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);
