PHP MySQL simple registration form

Let's start with easy PHP sample,
simple registration page

first you need to create a registration form page.
let's name it "registrationForm.php"


<form method="POST" action="register.php">

<table>
<tr><td>Username:</td><td><input type="text" name="username"></td></tr>

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

<tr><td colspan="2"><input type="submit" name="register" value="register"></td></tr>

</table>

</form>


Now create a database table name "member"


mysql_query("CREATE TABLE IF NOT EXISTS `member`
(`id` int(11) unsigned NOT NULL auto_increment,

`username` varchar(255) NOT NULL default '',

`password` varchar(255) NOT NULL default '',

PRIMARY KEY (`id`)

) ENGINE=MyISAM");

Let's create a new page and we'll name it "register.php"
let's make it simple add to database

<?php
// I prefer using constant define instead of variables so...

define("HOST","your_database_host");

define("USER","your_database_username");

define("PASS","your_database_password");

define("DB","your_database_name");

// I suggest writing always mysql_error()

// connect to database

mysql_connect(HOST,USER,PASS) or die(mysql_error());

// select the database

mysql_select_db(DB) or die(mysql_error());

// let's insert the form value to mysql data

if(isset($_POST['register']) {

mysql_query("INSERT INTO user(username, password) VALUES('".$_POST['username']." ', '".$_POST['password']."')") or die(mysql_error());

}

?>


There you go, now check your database and you should see a new record now..