php+mysql+获取多行_php – 从MySQL表中获取多个行值

查看sql

SUM()聚合函数和

IN比较运算符：

SELECT SUM(`number`) FROM `table` WHERE `id` IN (1,2,4);

UPDv1：

// hostname, username, password and database should be replaced with actual values.

$dbms = mysqli_connect('hostname', 'username', 'password', 'database');

if($dbms->connect_errno)die('MySQL connection error: ' . $dbms->connect_error);

// table should be replaced with actual table name.

$result = $dbms->query('SELECT SUM(`number`) as `amount` FROM `table` WHERE `id` IN (1,2,4)');

if($dbms->errno)die('MySQL error: ' . $dbms->error);

$row = $result->fetch_assoc();

echo $row['amount'];

?>

另外,检查MySQLi驱动程序的PHP是installed.