更新时间：2022-03-12 14:09:44
来源：网络转载

PHP和MySQL; 如果带有查询变量的语句不起作用

I have been having some problem getting the header() to initialize with this code. It seems that the if statement doesn't work with query variables?

In init.php the function $user_data is defined. $url is the $_GET code in the url-bar of the browser (in this case a 6 digit random code). The variables seem to work, since I tried to output them already. The problem seems to be the if statement though. I do not get an error message. The header() just does not initiate, even though I am not logged in and the url is set to public === 0 in MySQL. Where am I going wrong?

include 'core/init.php';
include 'includes/head.php';
$url = $_SERVER['QUERY_STRING'];
$url = sanitize($url);

$public_arr = mysql_query("SELECT `public` FROM `uploads` WHERE `url` = '$url' AND `active` = 1") or die(mysql_error());
$public_arr = mysql_fetch_assoc($public_arr);
$public = $public_arr['public'];

$owner_arr = mysql_query("SELECT `owner` FROM `uploads` WHERE `url` = '$url' AND `active` = 1") or die(mysql_error());
$owner_arr = mysql_fetch_assoc($owner_arr);
$owner = $owner_arr['owner'];

global $user_data;
if ($public === 0 AND $owner !== $user_data['username'] || logged_in() === false) {
    header('Location: mainpage.php');
    exit();
}

$name_arr = mysql_query("SELECT `name` FROM `uploads` WHERE `url` = '$url' AND `active` = 1") or die(mysql_error());
$name_arr = mysql_fetch_assoc($name_arr);
$name = $name_arr['name'];

我在使用此代码初始化 header（） code>时遇到了一些问题。 似乎 if code>语句不适用于查询变量？ p>

在 init.php code>中函数 $ user_data code>已定义。 $ url code>是浏览器url-bar中的 $ _ GET code>代码（在本例中为6位随机代码）。 变量似乎有效，因为我已经尝试输出它们。 问题似乎是 if code>语句。 我没有收到错误消息。 即使我没有登录并且在MySQL中将url设置为 public === 0 code>， header（） code>也不会启动。 我哪里错了？ p> 

  include'core / init.php'; 
include'include / head.php'; 
 $ url = $ _SERVER ['QUERY_STRING'  ]; 
 $ url = sanitize（$ url）; 
 
 $ public_arr = mysql_query（“SELECT`public` FROM`uploads` WHERE`url` ='$ url'和`active` = 1”）或死 （mysql_error（））; 
 $ public_arr = mysql_fetch_assoc（$ public_arr）; 
 $ public = $ public_arr ['public']; 
 
 $ owner_arr = mysql_query（“SELECT` owner` FROM`uploads` WHERE`  url` ='$ url'和`active` = 1“）或死（mysql_error（））; 
 $ owner_arr = mysql_fetch_assoc（$ owner_arr）; 
 $ owner = $ owner_arr ['owner']; 
 \  nglobal $ user_data; 
if（$ public === 0 AND $ owner！== $ user_data ['username'] || logged_in（）=== false）{
 header（'Location：mainpage.php'）;  
 exit（）; 
} 
 
 $ name_arr = mysql_query（“SELECT`name` FROM`uploads` WHERE`url` ='$ url'和`active` = 1”）或死（mysql_error（）  ）; 
 $ name_arr = mysql_fetch_assoc（$ name_arr）; 
 $ name = $ name_arr ['name']; 
  code>  pre> 
  div>


 2 条回答

网友1解答：

  • Assuming the variable values are as you say they are, try checking these vlaues are equal to and not identical, some times the types can vary (integers like 0 may be strings like "0").

    if ($public == 0 AND $owner != $user_data['username'] || logged_in() === false) {
    header('Location: mainpage.php');
    exit();
}

    As @jay-blanchard says, you should be using MySQLi functions instead of mysql_* for many reasons - the main that they're not supported as standard in PHP any more!

网友2解答：

  • if ($public === 0 AND $owner !== $user_data['username'] || logged_in() === false)

    should be

    if (($public === 0 && $owner !== $user_data['username']) || logged_in() === false)
mysql
php