[Help] User Registration System

ParadoxInTheVoid · 2015-09-09 21:24:48

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 · 2015-09-09 21:26:45

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

ParadoxInTheVoid · 2015-09-09 21:45:13

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 · 2015-09-09 21:56:49

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.

Zumza · 2015-09-10 10:37:04

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

ewoke · 2015-09-10 11:18:47

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

shadowda · 2015-09-10 11:39:25

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

AlphaJon · 2015-09-10 11:39:50

ewoke wrote:

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:

Mylo wrote:

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

hummerz5 · 2015-09-10 22:53:52

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.

Cyral

Official Everybody Edits Forums

#1 2015-09-09 21:24:48

[Help] User Registration System

#2 2015-09-09 21:26:45

Re: [Help] User Registration System

#3 2015-09-09 21:45:13

Re: [Help] User Registration System

#4 2015-09-09 21:56:49

Re: [Help] User Registration System

#5 2015-09-10 10:37:04, last edited by Zumza (2015-09-10 10:42:19)

Re: [Help] User Registration System

#6 2015-09-10 11:18:47

Re: [Help] User Registration System

#7 2015-09-10 11:39:25, last edited by shadowda (2015-09-10 11:50:22)

Re: [Help] User Registration System

#8 2015-09-10 11:39:50

Re: [Help] User Registration System

#9 2015-09-10 22:53:52

Re: [Help] User Registration System

Board footer