Login Script - With MySql - Register - PHP Development

Hello I Was Wondering If Anyone Could Help Me With This I Have Followed The Tutorial At http://www.phpeasyst...om/phptu/6.html and I was wondering if there was any way i could make a script to register new users with this system Here Is The Code:

//main_login.php


<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">

<tr>

<form name="form1" method="post" action="checklogin.php">

<td>

<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">

<tr>

<td colspan="3"><strong>Member Login </strong></td>

</tr>

<tr>

<td width="78">Username</td>

<td width="6">:</td>

<td width="294"><input name="myusername" type="text" id="myusername"></td>

</tr>

<tr>

<td>Password</td>

<td>:</td>

<td><input name="mypassword" type="text" id="mypassword"></td>

</tr>

<tr>

<td> </td>

<td> </td>

<td><input type="submit" name="Submit" value="Login"></td>

</tr>

</table>

</td>

</form>

</tr>

</table>

//checklogin.php


<?php

ob_start();

$host="localhost"; // Host name 

$username=""; // Mysql username 

$password=""; // Mysql password 

$db_name="test"; // Database name 

$tbl_name="members"; // Table name 


// Connect to server and select databse.

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 

mysql_select_db("$db_name")or die("cannot select DB");


// Define $myusername and $mypassword 

$myusername=$_POST['myusername']; 

$mypassword=$_POST['mypassword']; 


// To protect MySQL injection (more detail about MySQL injection)

$myusername = stripslashes($myusername);

$mypassword = stripslashes($mypassword);

$myusername = mysql_real_escape_string($myusername);

$mypassword = mysql_real_escape_string($mypassword);


$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";

$result=mysql_query($sql);


// Mysql_num_row is counting table row

$count=mysql_num_rows($result);

// If result matched $myusername and $mypassword, table row must be 1 row


if($count==1){

// Register $myusername, $mypassword and redirect to file "login_success.php"

session_register("myusername");

session_register("mypassword"); 

header("location:login_success.php");

}

else {

echo "Wrong Username or Password";

}


ob_end_flush();

?>

//login_success.php


<? 

session_start();

if(!session_is_registered(myusername)){

header("location:main_login.php");

}

?>


<html>

<body>

Login Successful

</body>

</html>

//logout.php


<? 

session_start();

session_destroy();

?>

//MySQL Query


CREATE TABLE `members` (

`id` int(4) NOT NULL auto_increment,

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

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

PRIMARY KEY (`id`)

) TYPE=MyISAM AUTO_INCREMENT=2 ;


-- 

-- Dumping data for table `members`

-- 


INSERT INTO `members` VALUES (1, 'john', '1234');

If Anyone Could Help Me Make A PHP Script To Add Users To The SQL Database I Would Dearly Appreciate It. :):lol:
Thanks. Jack

$add_member = mysql_query("INSERT INTO members(username,password)VALUES('".mysql_real_escape_string($_POST['username'])."', '".mysql_real_escape_string($_POST['password'])."') ")or die("Couldn't create account for memberMysql Error:".mysql_error()."");