foreach($dbh->query ('SELECT a.tovar = '$users_input',
( select sum(b.kusy) from jednotypredaj as b where b.tovar=a.tovar and b.co="prijem" ) as prijem_ks,
( select sum(c.kusy) from jednotypredaj as c where c.tovar=a.tovar and c.co="predaj" ) as predaj_ks
FROM jednotypredaj as a GROUP BY a.tovar ORDER by predaj_ks DESC') as $row)
我找不到为什么'SELECT a.tovar = '$users_input'
,不适用于我的搜索引擎。
谢谢但是不知道如何真正使用它,我的整个代码看起来像这样'
$hostname="localhost";
$username="kintrogorgo";
$password="password";
$db = "jednoty";
$dbh = new PDO("mysql:host=$hostname;dbname=$db", $username, $password);
foreach($dbh->query ('SELECT a.tovar ,
( select sum(b.kusy) from jednotypredaj as b where b.tovar=a.tovar and b.co="prijem" ) as prijem_ks,
( select sum(c.kusy) from jednotypredaj as c where c.tovar=a.tovar and c.co="predaj" ) as predaj_ks
FROM jednotypredaj as a GROUP BY a.tovar ORDER by predaj_ks DESC') as $row)
{
echo "<tr>";
echo "<td>" . $row['tovar'] . "</td>";
echo "<td>" . $row['prijem_ks']. "</td>"; //Tu by mali bit predane kusy
echo "<td>" . $row['predaj_ks'] . "</td>";
echo "<td>" . ($row['predaj_ks']-$row['prijem_ks'] . "</td>");
echo '<td><a href="3edit.php?tovar=' . $row['tovar'] . '">Zobraziť</a></td>';
echo "</tr>";
}
?> `
我想在这里添加搜索引擎,以便能够在任何行中进行搜索。谢谢你