Why won't this send the user to user.php if the ID don't exist in the table?
<?php
include 'db_connect.php';
$id_exists = false;
$url_id = mysql_real_escape_string($_GET['id']);
$sql = "SELECT id FROM members WHERE id='$url_id'";
$result = mysql_query($sql);
if ($result == $url_id)
{
$id_exists = true;
}
else if ($result != $url_id)
{
$id_exists = false;
header("location:user.php");
exit();
}
?>
$url_id = mysql_real_escape_string($_GET['id']);
$sql = "SELECT id FROM members WHERE id='$url_id'";
$result = mysql_query($sql);
if(mysql_num_rows($result) >0){
//found
}else{
//not found
}
Try something like this :). http://php.net/manual/en/function.mysql-num-rows.php
Please, read the docs for mysql_query
. You have to fetch the result after making the query. That said, you should probably use PDO instead of mysql_*
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With