Official Everybody Edits Forums

ParadoxInTheVoid

Member

From: ̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺

Joined: 2015-02-18

Posts: 341

[Help] User Registration System

I'm trying to use phpMyAdmin to make an account registration system, and I can't seem to find the right resources. So if someone with some PHP skill could assist me that'd be great.

---

Mylo

Master Developer

From: Drama

Joined: 2015-02-15

Posts: 829

Re: [Help] User Registration System

What do you need? I could help you - if you make your question more specific.

---

https://m-k.io

ParadoxInTheVoid

Member

From: ̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺̺

Joined: 2015-02-18

Posts: 341

Re: [Help] User Registration System

Yea, okay, I'm trying to make a database where I can store users and I want them to register through a C# application (Which obviously I will be making) and even the website that I will have. What is need:
Username, Password, Email (for verification), Rank, ID if thats not too much (something like XXXX-XXXX (number and letters))

---

hummerz5

Member

From: wait I'm not a secret mod huh

Joined: 2015-08-10

Posts: 5,853

Re: [Help] User Registration System

probably should make sure to encrypt that **** at least
and if you're using the password for auth, then hash et rite
if you're just holding on to the password, that's a bummer

also, don't write the sql credentials into the client side... that's just stupid
someone's done that before, though, so don't feel too bad.

---

thanks HG, HG, HG, HG! anatoly, zumza! zoey!

Zumza

Member

From: root

Joined: 2015-02-17

Posts: 4,656

Re: [Help] User Registration System

I have experience with php, mysql and phpmyadmin.
If you need help pm me with the issue.

To make an registration system you will need:
1. a database
2. a users table in that db (with columns: id, name, password, email, rank)
3. adding a row if that user doesn't exist
4. for security reasons you may hash some data like passwords

With php basically you execute an sql command and wait for its feedback

---

Everybody edits, but some edit more than others

ewoke

Member

Joined: 2015-02-20

Posts: 412

Re: [Help] User Registration System

nbot 2.0 amazing

$host = '';
$user = "root";
$pass = "";
$database="";

<?php
$con = mysqli_connect("localhost",$user,$pass,$database);

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
?>

check w3 schools for moar

---

if you can read this....good for you

shadowda

Member

From: somewhere probably.

Joined: 2015-02-19

Posts: 1,015

Re: [Help] User Registration System

well what i did what when a user says .register it puts their name into the first available space in my chart.

---

color = #1E1E1E       

AlphaJon

Member

From: Who knows

Joined: 2015-07-21

Posts: 1,297

Re: [Help] User Registration System

nbot 2.0 amazing

$host = '';
$user = "root";
$pass = "";
$database="";

<?php
$con = mysqli_connect("localhost",$user,$pass,$database);

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
?>

check w3 schools for moar

I think what he's asking is the SQL for his tables rather than the PHP script to connect to the database (I may be wrong).
However, I can't really help either because:

What do you need? I could help you - if you make your question more specific.

hummerz5

Member

From: wait I'm not a secret mod huh

Joined: 2015-08-10

Posts: 5,853

Re: [Help] User Registration System

Same. There's just not enough
and paradox hasn't been around to enlighten us. Maybe this is being resolved via PM. no idea.

As far as "if that's not too much", you're probably not going to reach the limits of SQL. Not with simple text fields. When you start deciding to save entire worlds to the database, I'd refer you to a file system or something. I still want to stress that any passwords need to be hashed out. Consider making user ID the primary auto increment key. Numbers and letters, however, is overkill. Truly. A-Z + 0-9 (36) ^ 10 = 3656158440062976. You aren't going to hit that number of users. Shoot, 36^3 is 46,656. Decimals are more realistic.

If you're going to run e-mail for verification, consider another field (or some strange way) to determine what stage the e-mail is in. Is it verified? Is there a code to send in? How do you store that code? Is another table in order for the verification fields to save space? Matching user ID to code?

Sessions - how do you keep users logged in? Are you going to hash that as well? Is your site safe from those nasty xss attacks?

just things to think about, with plenty more out there.

---

thanks HG, HG, HG, HG! anatoly, zumza! zoey!