* 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; }