function DatabaseQuery($query)
{
stripslashes($query);
$conn = DatabaseConnect();
mysql_query($query) or die("couldn't run query " . mysql_error());
mysql_close($conn);
}
function DatabaseQueryReturn($query)
{
stripslashes($query);
$conn = DatabaseConnect();
$result = mysql_query($query) or die("Couldn't run mysql query " . mysql_error());
$data = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$data[] = $row;
}
mysql_close($conn);
return $data;
}
function alreadyExistsInRemoteDB($idCheck)
{
DatabaseConnect();
$query = "SELECT * FROM children where child_id='{$idCheck}';";
$result = pg_query($query) or die('Query failed: ' . pg_last_error());
if (pg_num_rows($result) == 1) {
return true;
} else {
return false;
}
}
<?php
include "common.php";
$link = DatabaseConnect();
$name = safe($_POST['name']);
$score = safe($_POST['score']);
$hash = safe($_POST['hash']);
$real_hash = md5($name . $score . $secretKey);
if ($real_hash == $hash) {
$query = "INSERT INTO {$DatabaseName} .`scores` (`id`, `name`, `score`) VALUES (NULL, '{$name}', '{$score}');";
$result = mysql_query($query);
$my_err = mysql_error();
if ($result === false || $my_err != '') {
echo "\n\t\t\t<pre>\n {$my_err} <br />\n {$query} <br />\n\t\t\t</pre>";
die;
}
echo "done";
}
function alreadyExistsInRemoteDB($usernameCheck, $firstnameCheck, $lastnameCheck)
{
DatabaseConnect();
$query = "SELECT * FROM users where username='******' and firstname='{$firstnameCheck}' and lastname='{$lastnameCheck}' ;";
$result = pg_query($query) or die('Query failed: ' . pg_last_error());
if (pg_num_rows($result) == 1) {
return true;
} else {
return false;
}
}
