TA貢獻1798條經驗 獲得超3個贊
您可以使用PDOid=1通過以下方式獲取分配的任務
?$id = 1;
$sql = "SELECT task FROM your_db_table WHERE `id` = :id ";
$sql ->execute([ 'id' => $id]);
?$task= $sql;
如果你使用的是mysqli
$id = 1;
$stmt = $dbConnection->prepare('SELECT task FROM your_db_table WHERE id =?');
$stmt->bind_param('i', $id); // 'i' specifies the variable type => 'integer'
$stmt->execute();
$result = $stmt->get_result();
$text= $result->fetch_assoc();
TA貢獻1883條經驗 獲得超3個贊
試試這個
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli_connect = mysqli_connect("localhost", "root", "", "hexll");
$sqlquery= mysqli_query($mysqli_connect,"select text from mytable where id='1' ");
$row= mysqli_fetch_array($sqlquery, MYSQLI_ASSOC);
echo $row['text'];
舉報