有PHP高手吗？ 100元求个完整数据库连接和查询代码

TyCoding · 发表于 2023-3-3 11:55:42

不对外，内部工作需要

婷姐 · 发表于 2023-3-3 11:55:55

<?php

$a = $_POST["aaa_3"]; //等10多个值，
$b = $_POST["bbb_3"]; //等10多个值，同理其他十个

$val = [0,1,2,3,4];
if (!in_array($a,$val)){
echo 'err value';
exit;
}
if (!in_array($b,$val)){
echo 'err value';
exit;
}
$dsn = 'mysql:dbname=mysqla;host:127.0.0.1';
try {
$dbh = new PDO($dsn, 'my_user', 'my_passwd');
} catch (PDOException $e) {
echo 'Connection filed:' . $e->getMessage();
exit;
}

$sql = 'select * from mysqla where zzzvalue in(0,1,2) order by rand() limit 5';

$res = $dbh->query($sql);

if ($res === false) {
$err = $dbh->errorInfo();
print_r($err);
exit;
}

$row = $res->fetchAll();

//要考虑row是否大于5行
$record1 = $row[0];
$record2 = $row[1];
$record3 = $row[2];
$record4 = $row[3];
$record5 = $row[4];