I have Mysql running in localhost.
The name of my database is JONSOF and i have not configure my database settings yet, so everyone has the access!
I am trying some scripts for user authentication via Mysql with no success 🙁((
Here is my script
<h2 align=center>User Signup</h2>
<?php
$connect = mysql_connect("localhost");
mysql_select_db("JONSOF", $connect);
$sql = "SELECT * FROM users WHERE username =".$username;
$result = @mysql_query($sql) or die("No.");
$num = mysql_num_rows($result);
if(!$submit) {
echo "<form method=POST action=$PHP_SELF>
<center>
<table>
<tr>
<td>First Name:</td>
<td><input type=text name=fname size=20></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input type=text name=lname size=20></td>
</tr>
<tr>
<td>Username:</td>
<td><input type=text name=username size=20></td>
</tr>
<tr>
<td>Password:</td>
<td><input type=password name=password size=20></td>
</tr>
</table>
<p><input type=submit value=Submit name=submit></p>
</center>
</form>";
} else if($submit && empty($fname) && empty($lname) && empty($username) && empty($username)) {
echo "<center>You need to enter all the fields</center>";
} else if($num == "1") {
echo "<center>The username is already registered, please try another.</center>";
} else if($submit && !empty($fname) && !empty($lname) && !empty($username) && !empty($username) && $num == "0") {
$insert = "INSERT INTO users VALUES ('', '$fname', '$lname', '$username', '$password')";
$insert_res = @mysql_query($insert) or die("No.");
echo "<h2 align=center>You successfully added the username $username.</h2>";
}
mysql_close($connect);
?>
I also made a table like this
CREATE TABLE users (
id int(11) NOT NULL auto_increment,
fname varchar(20) default '',
lname varchar(20) default '',
username varchar(30) default '',
password varchar(30) default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
Could you Help me?
