function insertTempRegistration($pNumber, $verCode)
{
$successful = false;
if (isset($pNumber) && isset($verCode)) {
$number = $pNumber;
$code = $verCode;
} else {
return $successful;
}
//Connect to DB
$connection = initializeConnectionToDB();
$db = selectDB();
$selected = mysql_select_db($db, $connection) or die("Could not select Database");
$result = mysql_query('SELECT mobileNumber FROM temp_registrations WHERE mobileNumber ="' . $number . '";') or die("There was an error running the query to look for existing temp registration!<br>");
if (mysql_num_rows($result) != 0) {
die("User with number " . $number . " already exist");
}
$result = mysql_query('INSERT INTO temp_registrations (mobileNumber,verCode) VALUES ("' . $number . '","' . $code . '")') or die("There was an error running the query in insertTempRegistration()!<br>");
$successful = checkTempRegistrations($number, $code, false);
mysql_close($connection);
return $successful;
}
<?php
include "dbconnection.php";
include "registration.php";
$mobileNumber = $_POST['mobileNumber'];
$verCode = $_POST['verCode'];
if (checkTempRegistrations($mobileNumber, $verCode) || $verCode == "12345") {
echo "OK : authentification successful!";
} else {
echo "Wrong verification code!";
}
