主页 / 问题 / 575559
Accepted
Стас
Asked:2020-10-09 19:40:54 +0000 UTC2020-10-09 19:40:54 +0000 UTC

如何在php中编写从数据库中选择的条件？

  • 772

通过 GET 有 2 个变量：来一个或另一个。因此，您需要将此传入值替换为变量以进行采样。这是一个示例代码，但它不起作用：

$stname = mysql_escape_string($_GET['stname']);
$serv = mysql_escape_string($_GET['serv']);
if (($serv == "") || ($serv == "all") && ($stname == "") || ($stname == "all")) {
  $znvc = '1';
} else { 
  $znvc = 'serv="'.$serv.'"' OR 'stname="'.$stname.'"';
}
  $query = 'SELECT id, data, time_n, time_k, time_kk, dmin, serv, stname, team1, team2 FROM igry WHERE '.$znvc.' ORDER BY data, time_n'; 


$res = mysql_query( $query );
php

1 个回答

  1. Best Answer
    $stname = mysql_escape_string($_GET['stname']);
$serv = mysql_escape_string($_GET['serv']);

if ($serv && $serv != 'all') { 
    $znvc = 'WHERE serv="' . $serv . '"';
}

if ($stname && $stname != 'all') { 
    $znvc = 'WHERE stname="' . $stname . '"';
}

$query = 'SELECT id, data, time_n, time_k, time_kk, dmin, serv, stname, team1, team2 FROM igry ' . $znvc . ' ORDER BY data, time_n';
    • 0

相关问题