mysql 表不能查询数据库_无法查询mysql数据库，究竟哪里错了，在线等

session_start();

$id1=$_SESSION['num_xfs'];

$id2=$_SESSION['num_myl'];

$id3=$_SESSION['num_fz'];

$id4=$_SESSION['num_mm'];

$id5=$_SESSION['num_fbm'];

$id6=$_SESSION['num_bg'];

$id7=$_SESSION['num_bhc'];

$id8=$_SESSION['num_lc'];

$id9=$_SESSION['num_nc'];

$link=new MySQLi('localhost','root','','dinggou');

$select_spn="SELECT shangpinname FROM shangpin WHERE id = i ";

$select_pri="SELECT `price` FROM `shangpin` WHERE `id` = i ";

if(!$link){

echo '无法连接数据库';

exit;}

echo '

商品

单价

数量

小计

for($i=1;$i<=9;$i++){

$j='id'.$i;

if($$j>0){

$get_spn =mysqli_query($link,$select_spn);

$get_pri =mysqli_query($link,$select_pri);

if(!$get_spn){echo 'error';}

if(!$get_pri){echo 'error';}

echo '

'.$get_spn.''.$get_pri.''.$$j.''.$get_pri*$$j.'';

}

}

?>

展开