function insert_data($con, $val) { echo $fname = nullcheck($val['fname']); echo "</br>"; echo $lname = nullcheck($val['lname']); echo "</br>"; echo $email = nullcheck($val['email']); echo "</br>"; echo $pwd = md5(nullcheck($val['pass'])); echo "</br>"; echo $number = nullcheck($val['phone']); echo "</br>"; echo $address = nullcheck($val['address']); echo "</br>"; echo $fbook = nullcheck($val['facebook']); echo "</br>"; echo $twitter = nullcheck($val['twitter']); echo "</br>"; echo $gplus = nullcheck($val['gplus']); echo "</br>"; echo $date = date("Y-m-d H:i:s"); mysqli_query($con, "INSERT INTO user_tbl (FirstName,LastName,email,upassword,phone_number,address,twitter,facebook,googleplus,date) \r\nVALUES ('{$fname}','{$lname}','{$email}','{$pwd}','{$number}','{$address}','{$twitter}','{$fbook}','{$gplus}','{$date}')"); mysqli_close($con); }
$ncsecques = protect($_POST['secques']); $ncsecans = protect($_POST['secans']); $nerror = 0; function nullcheck($string, $item) { global $nerror; if (empty($string)) { echo 'No ' . $item . '.<br />'; $nerror++; } } nullcheck($ncfname, 'First Name'); nullcheck($ncsname, 'Surname'); nullcheck($ncemail, 'Email'); nullcheck($ncsecques, 'Security Question'); nullcheck($ncsecans, 'Security Question Answer'); if ($nerror === 0) { //echo 'Stage Two of client creation:<br/>'; $emailck = "SELECT COUNT(*) as count\n\t\t\t\t\t\t\t\t\t\tFROM tbl_clients\n\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\temail = '{$ncemail}'\n\t\t\t\t\t\t\t\t\t\t"; $emailckqry = mysql_query($emailck); $emailckres = mysql_fetch_assoc($emailckqry); //echo 'Number of the same email addresses: ' . $emailckres; if ($emailckres['count'] == 0) { //echo 'Stage There of client creation:'; $pass = hashword('password321', $hash); $createqry = "INSERT INTO tbl_clients (\n\t\t\t\t\t\t\t\t\t\t\t\tfirstname,\n\t\t\t\t\t\t\t\t\t\t\t\tsurname,\n\t\t\t\t\t\t\t\t\t\t\t\temail,\n\t\t\t\t\t\t\t\t\t\t\t\tmob,\n\t\t\t\t\t\t\t\t\t\t\t\ttel,\n\t\t\t\t\t\t\t\t\t\t\t\tpassword,\n\t\t\t\t\t\t\t\t\t\t\t\tsecques,\n\t\t\t\t\t\t\t\t\t\t\t\tsecans,\n\t\t\t\t\t\t\t\t\t\t\t\tday,\n\t\t\t\t\t\t\t\t\t\t\t\tmonth,\n\t\t\t\t\t\t\t\t\t\t\t\tyear,\n\t\t\t\t\t\t\t\t\t\t\t\tbanned,\n\t\t\t\t\t\t\t\t\t\t\t\tempty\n\t\t\t\t\t\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t\t\t\t\t\t'{$ncfname}',\n\t\t\t\t\t\t\t\t\t\t\t\t'{$ncsname}',\n\t\t\t\t\t\t\t\t\t\t\t\t'{$ncemail}',\n\t\t\t\t\t\t\t\t\t\t\t\t'{$ncmob}',\n\t\t\t\t\t\t\t\t\t\t\t\t'0',\n\t\t\t\t\t\t\t\t\t\t\t\t'{$pass}',\n\t\t\t\t\t\t\t\t\t\t\t\t'{$ncsecques}',\n\t\t\t\t\t\t\t\t\t\t\t\t'{$ncsecans}',\n\t\t\t\t\t\t\t\t\t\t\t\t'0',\n\t\t\t\t\t\t\t\t\t\t\t\t'0',\n\t\t\t\t\t\t\t\t\t\t\t\t'0',\n\t\t\t\t\t\t\t\t\t\t\t\t'0',\n\t\t\t\t\t\t\t\t\t\t\t\t'0'\n\t\t\t\t\t\t\t\t\t\t\t)"; $createsql = mysql_query($createqry); if ($createsql) { echo 'A New Client Created.<br />'; $clicheckqry = "SELECT *\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM tbl_clients\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\t\t\t\temail = '{$ncemail}'\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tsecans = '{$ncsecans}'\n\t\t\t\t\t\t\t\t\t\t\t\t\tLIMIT 1"; $clichecksql = mysql_query($clicheckqry);