我有两个来自URL的变量。
即$_GET["pro_id"]
和$_GET["pro_page"]
以及
$_GET["pro_id"] = 1,2,3,4,
和$_GET["pro_page"] = 1,1,1,3,
我已经将这些变量分离为
$pro_id = $_GET["pro_id"];
$pro_id = explode(",", $pro_id);
foreach($pro_id as $key) {
echo $key.'<br/>';
}
$pro_page = $_GET["pro_page"];
$pro_page = explode(",", $pro_page);
foreach($pro_page as $key) {
echo $key.'<br/>';
}
pro_id的输出为1.2.3.4.对于pro_page1.1.1.3
并且我想要混合来自pro_id的第一个数字和来自pro_page的第一个数位。即
select * from db_table where row1=1 and row2=1
select * from db_table where row1=2 and row2=1
select * from db_table where row1=3 and row2=1
select * from db_table where row1=4 and row2=3
如何实现这一点。有什么解决办法吗。
为了更可靠,请使用foreach
foreach($propage as $key => $value)
{
$sql = "SELECT * FROM db_table WHERE row1 = '".$pro_id[$key]."' AND row2='".$propage[$key]."'";
}
这应该适用于您,尽管这些是一些奇怪的$_GET
参数。
$pro_id = $_GET["pro_id"];
$pro_id = explode(",", $pro_id);
$pro_page = $_GET["pro_page"];
$pro_page = explode(",", $pro_page);
foreach($pro_id as $idx => $value) {
$proid = $value;
$propage = $pro_page[$idx];
//QUERY HERE
echo $proid." ".$proage;
}