[SOLVED] What's wrong with my code, I can't run it.

[ubuntu]

Dear all,

 

Below is my code, I couldn't find any error, what's wrong with my coding. Thanks for your kind attention Regards.

 

<?php
include('info.config');
//check for required fields
error_reporting( E_ALL );

$error = NULL;

if (!$_POST['fullname']) {
     $error .= "Full name is required.<br>";
}
if (!$_POST['ic_no']) {
     $error .= "NRIC no. is required.<br>";
}
if (!$_POST['gender']) {
     $error .= "Gender is required.<br>";
}
if (!$_POST['address']) {
     $error .= "Address is required.<br>";
}
if (!$_POST['city']) {
     $error .= "City is required.<br>";
}
if (!$_POST['state']) {
     $error .= "State is required.<br>";
}
if (!$_POST['contact_no']) {
     $error .= "Contact Tel No. is required.<br>";
}
if (!$_POST['hp_no']) {
     $error .= "Handphone no. is required.<br>";
}
if (!$_POST['email']) {
     $error .= "Email is required.<br>";
}
if (!$_POST['username']) {
     $error .= "Username is required.<br>";
}
if (!$_POST['password']) {
     $error .= "Password is required.<br>";
}
if (!$_POST['confirmpassword']) {
     $error .= "Confirm password is required.<br>";
}

if (!is_null($error)) {
    die($error);
}

//connect to server and select database
$connection = mysql_connect("$host", "$user", "$password")
     or die(mysql_error());
$db = mysql_select_db($database, $connection) or die(mysql_error());

//build and issue query
$sql = "SELECT * FROM pendaftaran WHERE
username = '" . $_POST['username'] . "'";

$result = mysql_query($sql) or die (mysql_error());

//get the number of rows in the result set
$num = mysql_num_rows($result);

//if username already exists, print the message
if ($num != 0) {
     die("The Username " . $_POST['username'] . " already exists, please select another username.");

}
?>

[btherl]

Can you tell us what you expect your code to do and what it actually does?  We are not mind-readers

[ubuntu]

I want to test if the user had enter the same username that exists in database, then it will notify user.

[StormTheGates]

And its not printing out any errors or anything?

 

Also your script is insecure, you never want to use a direct user input in an SQL query unless youve checked it for SQL injection.

 

Although I dont see any definitions for the variables for the db connector. So maybe its not connecting?

[btherl]

We need you to tell us the error message you get.  What do you see when you run this script?

[ubuntu]

It only display the message Address is required.

[btherl]

Is your form supplying the address to your script?  Check your form for something like

 

<input name="address" type="text">

[ubuntu]

Thank you btherl, yes, it's my mistake there. Appreciated.