I am a new comer to php and am creating a simple login system. When someone really wants to register, they're going to join up.html code, then place.php. The code below should add the information in the form towards the table but is does not show up inside it. I suspect it's most likely the road: $sql=Place INTO... The only real factor showing up may be the echo statement at the end from the code I understand there most likely is a straightforward response to this, however i still aren't able to find it. Thanks, any assistance is really appreciated!

The code for place.php

<?php
$email=$_POST['email'];
$name=$_POST['name'];
$password=$_POST['password'];
$con = mysql_connect("localhost","user","p@ssword");
mysql_select_db("database", $con);
$sql="INSERT INTO table_name (email, name, password)
VALUES ('$email', '$name', '$password')";  
echo"Thank you, you are now registered and can login on our homepage";
mysql_close($con);
?>

Many thanks!

You established the bond and eager the query, however, you did not really carry it out! You have to call mysql_query(), passing within the SQL and also the connection handle, to teach the database to do the statement.

<?php
$email=$_POST['email'];
$name=$_POST['name'];
$password=$_POST['password'];
$con = mysql_connect("localhost","user","p@ssword");
mysql_select_db("database", $con);
$sql="INSERT INTO table_name (email, name, password)
VALUES ('$email', '$name', '$password')";
mysql_query( $sql, $con ) or trigger_error( mysql_error( $con ), E_USER_ERROR );
echo"Thank you, you are now registered and can login on our homepage";
mysql_close($con);
?>

Because you say you are a new comer to PHP (and most likely database rise in general?), allow me to also point you in direction of the PHP tutorial on SQL injection, which describes what it's and why you ought to guard against it - your example code, for example, is vulnerable.

Why this code does not work is you don't have the phone call to mysql_query that really helps make the query:

mysql_query($sql);

However a larger problem is your application is presently highly insecure, because you aren't checking the validity of $email, $name or $password, so a malicious user could easily do nasty stuff for your database. At the very least, use [cde] to flee them ideally, make use of a library for example PDO to assist make sure the security of the site.