嘿伙計們，我發(fā)現(xiàn)了我的問題，現(xiàn)在我需要幫助如何解決它。我通過 rand 從數(shù)據(jù)庫中獲取一個人，單擊“喜歡”按鈕后，它應(yīng)該喜歡它顯示的當前數(shù)字，但事實并非如此。它喜歡單擊按鈕后顯示的下一個數(shù)字，我不知道如何更好地顯示它。這是我的代碼<?phpinclude_once 'session.php';include_once 'dbh.php'; ?><!doctype html><html><head> <meta charset="utf-8"> <title>The HTML5 Herald</title> <meta name="description" content="The HTML5 Herald"> <meta name="author" content="SitePoint"> <link rel="stylesheet" href="cs.css"></head><body></body></html><?php$sql = "SELECT * FROM users ORDER BY RAND () LIMIT 1 ; ";$result = mysqli_query($conn, $sql);$resultCheck = mysqli_num_rows($result); if ($resultCheck> 0){ $row = mysqli_fetch_assoc($result); $ide = $row['idUsers']; echo $ide; if(isset($_POST['like'])){ $sql1= "INSERT INTO likes (id, likes) VALUES ('1', '$ide')"; if ($conn->query($sql1) === TRUE) { echo "New record created successfully"; } else { echo "Error: ".$sql1."<br>". $conn->error; } $conn->close(); }}?><form action ="" method="post"><button value = "like" name="like">like</button></form>
1 回答
ITMISS
TA貢獻1871條經(jīng)驗 獲得超8個贊
您需要將用戶 ID 放入表單中，并在插入時使用。
此外，表格需要在里面<body>，而不是在它之后。
<?php
include_once 'session.php';
include_once 'dbh.php';
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>The HTML5 Herald</title>
<meta name="description" content="The HTML5 Herald">
<meta name="author" content="SitePoint">
<link rel="stylesheet" href="cs.css">
</head>
<body>
<?php
$sql = "SELECT * FROM users ORDER BY RAND () LIMIT 1 ; ";
$result = mysqli_query($conn, $sql);
$resultCheck = mysqli_num_rows($result);
if ($resultCheck> 0){
$row = mysqli_fetch_assoc($result);
$ide = $row['idUsers'];
?>
<form action ="" method="post">
<button value = "<?php echo $ide; ?>" name="like">like</button>
</form>
<?php
}
- 1 回答
- 0 關(guān)注
- 104 瀏覽
添加回答
舉報
0/150
提交
取消