SQL/PHP PDO选择随机行 [英] SQL / PHP PDO Select random row

问题描述

我是PDO的新手.我希望能够随机选择一个没有面对考试的学生('N')，然后回显姓名和科目.我该如何实现?

I'm new to PDO. I want to be able to select a STUDENT randomly who has not FACED the exam ('N') and echo the name and subject. How can I achieve this?

$query = $db->prepare('SELECT name FROM exams WHERE faced = ?');
$array = array('N');
$query->execute($array);

推荐答案

您可以使用类似以下内容的

You can use something like:

$query = $db->prepare('SELECT name, subject
          FROM exams WHERE faced = ?
          ORDER BY RAND() LIMIT 1');
$array = array('N');
$query->execute($array);

$result = $query->fetchAll(PDO::FETCH_COLUMN, 0);

var_dump($result);

这篇关于SQL/PHP PDO选择随机行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！