* Time: 12:00 PM
*/
$server = "localhost";
$db_user = "******";
$db_pass = "******";
$db_name = "testsite";
$name = $_POST['name'];
$email = $_POST['email'];
$password = $_POST['password'];
$cpassword = $_POST['cpassword'];
if ($name && $email && $password && $cpassword) {
if (strlen($password > 3)) {
if ($password == $cpassword) {
mysqli_connect($server, $db_user, $db_pass) or die("Could not connect to server!");
mysqli_select_db($db_name) or die("Could not connect to database!");
$username = mysqlii_query("SELECT name FROM users WHERE name='{$name}'");
$count = mysqli_num_rows($username);
$remail = mysqli_query("SELECT email FROM users WHERE email='{$email}'");
$checkmail = mysqli_num_rows($remail);
if ($checkmail != 0) {
echo "Email is not Available!";
} else {
if ($count != 0) {
echo "This User has already been registerd!";
} else {
mysqli_query("INSERT INTO users(name,email,password) VALUES ('{$name}','{$email}','{$password}')");
//$registered = mysqli_affected_rows();
echo "Successfully Registered";
}
}
} else {
function mysqlii_list_fields($global_mysqlibw_dbname, $table_name, $global_mysqlibw_db)
{
global $global_mysqlibw_db;
$returnarray = null;
$result = mysqlii_query("SHOW COLUMNS FROM " . $table_name);
if (!$result) {
return null;
} elseif (mysqlii_num_rows($result) > 0) {
$i = 0;
while ($row = mysqlii_fetch_array($result)) {
$arrayfields = null;
$returnarray[$i][0] = trim($row['Field']);
list($ftype, $fsize) = explode("(", $row['Type']);
$fsize = str_replace(")", "", $fsize);
$returnarray[$i][1] = $ftype;
if ($returnarray[$i][1] == "varchar") {
$returnarray[$i][1] = "string";
}
if ($returnarray[$i][1] == "text") {
$returnarray[$i][1] = "blob";
}
$returnarray[$i][2] = $fsize;
if (!$fsize > 0) {
$fsize = 1;
}
$i++;
}
}
return $returnarray;
}
