basic php/sql registration not working... (blank page after inputting data and not entering database)

Question

I'm trying to make a basic registration form on WAMP, I've tried with tutorials and a book.

I seem to be having a problem after I submit the data on the webpage.

I have created the database and tables and can be seen here... http://oi57.tinypic.com/2j47hux.jpg

Here is the code I have on my html page:

    <table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#536977">
<tr>
<form method="post" action="register.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#536977">
<tr>
<td colspan="3"><strong>Register: </strong></td>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><input type="text" id="username"></td>
</tr>

<tr>
<td width="78">First Name</td>
<td width="6">:</td>
<td width="294"><input type="text" id="firstname"></td>
</tr>
<tr>
<td width="78">Last Name</td>
<td width="6">:</td>
<td width="294"><input type="text" id="lastname"></td>
</tr>

<tr>
<td width="78">Age</td>
<td width="6">:</td>
<td width="294"><input type="text" id="age"></td>
</tr>

<tr>
<td>Email</td>
<td>:</td>
<td><input type="text" id="email"></td>
</tr>

<tr>
<td>Password</td>
<td>:</td>
<td><input type="text" id="password"></td>
</tr>


<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" value="Login"></td>
</tr>
</table>
</td
</form>
</tr>
</table>

The php I'm linking to is..

<?php
$con = mysqli_connect("localhost","root","","membersapp");
if (!$con)
  {
  die('Could not connect: ' . mysqli_error($con));
  }

$sql="INSERT INTO memberstable (username, firstname, lastname, age, email, password)
VALUES
('$_POST[username]','$_POST[firstname]','$_POST[lastname]','$_POST[age]','$_POST[email]','$_POST[password]' )";

if (!mysqli_query($con,$sql))
  {
  die('Error: ' . mysqli_error($con));
  }
echo "$_POST[firstname] $_POST[lastname] has been added";

mysqli_close($con);
?> 

I have ran a small php script to see if php connecting to database and it's connected.

Any ideas what is wrong?

Ok code edited..

    <?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

$con = mysqli_connect("localhost","root","","membersapp");
if (!$con)
  {
  die('Could not connect: ' . mysqli_error($con));
  }

$sql="INSERT INTO memberstable (username, firstname, lastname, age, email, password)
VALUES
('$_POST[username]','$_POST[firstname]','$_POST[lastname]','$_POST[age]','$_POST[email]','$_POST[password]' )";

if (!mysqli_query($con,$sql))
  {
  die('Error: ' . mysqli_error($con));
  }
echo "$_POST[firstname] $_POST[lastname] has been added";

mysqli_close($con);
?> 

and

    <form method="post" action="register.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#536977">
<tr>
<td colspan="3"><strong>Register: </strong></td>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><input type="text" id="username" name="username"></td>
</tr>

<tr>
<td width="78">First Name</td>
<td width="6">:</td>
<td width="294"><input type="text" id="firstname" name="firstname"></td>
</tr>
<tr>
<td width="78">Last Name</td>
<td width="6">:</td>
<td width="294"><input type="text" id="lastname" name="lastname"></td>
</tr>

<tr>
<td width="78">Age</td>
<td width="6">:</td>
<td width="294"><input type="text" id="age" name="age"></td>
</tr>

<tr>
<td>Email</td>
<td>:</td>
<td><input type="text" id="email" name="email"></td>
</tr>

<tr>
<td>Password</td>
<td>:</td>
<td><input type="password" id="password" name="password"></td>
</tr>


<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" value="Login"></td>
</tr>
</table>
</td>
</form>

Answer 1

There are a few things wrong with your code, so please read it to the end of my answer.

---

All of your inputs have no name attributes. You cannot rely on an id attribute alone.

Change

<input type="text" id="username">

to (minus all of the ^ characters of course) and to match $_POST[username]

<input type="text" id="username" name="username">
                                 ^^^^^^^^^^^^^^^

• and follow the same convention for the others.

Edit:
Also, your column is called Age and not age, but I doubt that will make a difference. Try changing it to match in letter-case.

However, doing it this way leaves you open to SQL injection. Use prepared statements, or PDO with prepared statements.

Add error reporting to the top of your file(s) which will help find errors.

<?php 
error_reporting(E_ALL);
ini_set('display_errors', 1);

// rest of your code

which would have caught the errors.

Sidenote: Error reporting should only be done in staging, and never production.

---

Passwords

I also noticed that you may be storing passwords in plain text. This is not recommended.

Use one of the following:

• CRYPT_BLOWFISH
• crypt()
• bcrypt()
• scrypt()
• On OPENWALL
• PBKDF2
• PBKDF2 on PHP.net
• PHP 5.5's password_hash() function.
• Compatibility pack (if PHP < 5.5) https://github.com/ircmaxell/password_compat/

Other links:

• PBKDF2 For PHP

---

Sidenote:

Password inputs should use the password type instead of text

<input type="password" id="password" name="password">

otherwise, passwords will show up in a readable format while being typed in.

---

Something else is missing

• You are also missing a > in </td which may affect your table, so change it to </td>