Phpmyadmin:
Phpmyadmin图像示例
if (mysql_query("SELECT setup FROM users") === 1) {
echo "One";
} else if (mysql_query("SELECT setup FROM users") === 0) {
echo "Zero";
}
已注册。定义如下：0。
若表中显示0，则回显"零"。否则，如果表显示ID 1，则返回"一"。
这是怎么做到的？
解决方案：
$setup = mysql_query("SELECT setup FROM users");
$row = mysql_fetch_assoc($setup);
if ($row['setup'] == 0) {
echo "Zero.";
} else {
echo "One!";
}
我想你需要这个
首先使用mysqli
//$connection = your mysqli connection. Dont use mysql
然后，如果您需要管理行，请正确编写查询
$query = "SELECT `setup` FROM `users` WHERE `user_id`=1 AND `username` = 'admin'";
然后执行查询
$result = mysqli_query($connection, $query);
然后搜索$setup-value
while($row = mysqli_fetch_assoc($result)){
$setup = $row['setup'];
}
然后回应你需要的
if ($setup == 1) {
echo "One";
} else if ($setup == 0) {
echo "Zero";
}
请参阅文档。"Example（MySQLi Procedureal）"示例与您想要的类似。
代码段：
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
}
} else {
echo "0 results";
}
mysqli_close($conn);
?>
更改
$sql = "SELECT id, firstname, lastname FROM MyGuests";
至
$sql = "SELECT setup FROM users";
然后
if (mysqli_num_rows($result) > 0) {
到您的各种if检查应该足够了。不是最干净的。看起来你可以打印出设置的值吗？祝你好运