数据基列是一个查询,用于在一个请求中选择多个结果。
global $wpdb;
$res = $wpdb->get_results( $wpdb->prepare(
"SELECT name, lastname
FROM datatable
WHERE userID in ( %d , %d)
AND
UserPass in ( %d, %d )",
array(
$val[1],
$val[2],
$val[3],
$val[4],
)
),
ARRAY_A
);其中$val1和$val2应该被用作userID,$val3和$val4 UserPass。我想我对占位符值的排序有问题,并且查询没有正确设置,可以使用一个提示词。
发布于 2015-09-04 11:35:49
试着用这个:
$querystr = "
SELECT name, lastname
FROM datatable
WHERE userID in ('your user ids implode with commas')
AND
UserPass in ('password string implode with commas ')
";
$result = $wpdb->get_results($querystr, OBJECT);发布于 2015-09-04 11:24:17
此查询返回与给定密码匹配的所有用户。
<?php
global $wpdb;
$res = $wpdb->get_results( $wpdb->prepare(
"SELECT name, lastname, UserPass
FROM datatable
WHERE userID in ( %d , %d)
HAVING UserPass in ( %d, %d )",
array(
$val[1],
$val[2],
$val[3],
$val[4],
)
),
ARRAY_A
);
?>也许这个能帮上忙?
https://stackoverflow.com/questions/32395671
复制相似问题