query("SELECT * FROM `cricrdvl_db`.`WII_users` WHERE `username` LIKE '".$uname."' AND `password` LIKE '".$password."';");
$user = [];
//error_log( "SELECT * FROM `cricrdvl_db`.`WII_users` WHERE `username` LIKE '".$uname."';");
if($user = $usr->fetch(PDO::FETCH_NUM)){
$userid = $user[0];
//echo "found " .$_POST["name"].": ".$userid;
}else{
$insert_statement = "INSERT INTO `cricrdvl_db`.`WII_users` (`username`,`password`,`email`) VALUES ( '".$uname."', '".$password."', '".$email."');";
$usr_insert = $pdo->query($insert_statement);
//echo $insert_statement;
$usr = $pdo->query("SELECT * FROM `cricrdvl_db`.`WII_users` WHERE `username` LIKE '".$uname."';");
$user = $usr->fetch(PDO::FETCH_NUM);
$userid = $user[0];
}
}
function finduser($uname){
global $pdo;
$usr = $pdo->query("SELECT * FROM `cricrdvl_db`.`WII_users` WHERE `username` LIKE '".$uname."';");
//error_log( "SELECT * FROM `cricrdvl_db`.`WII_users` WHERE `username` LIKE '".$uname."';");
if($user = $usr->fetch(PDO::FETCH_NUM)){
$userid = $user[0];
//echo "found " .$_POST["name"].": ".$userid;
}else{
$insert_statement = "INSERT INTO `cricrdvl_db`.`WII_users` (`username`) VALUES ( '".$uname."');";
$usr_insert = $pdo->query($insert_statement);
//echo $insert_statement;
$usr = $pdo->query("SELECT * FROM `cricrdvl_db`.`WII_users` WHERE `username` LIKE '".$uname."';");
$user = $usr->fetch(PDO::FETCH_NUM);
$userid = $user[0];
}
return $userid;
}
?>
![]()
echo '
';
//echo "
GPS Coordinates: ".$obsdetails[2]."
";
?>
