以下是php程序代码,但调用不出任何内容,也无报错信息
$pid = $_GET['pid'];
// pid不为空,则调用记录
if (!empty($pid)) {
$sql = "select pd.pid, pd.providerid, pd.item, pd.update, pd.price, pd.minOrder, pd.imglink, pv.ID, pv.company from price_db as pd ".
"inner join providers as pv ".
"on (pd.providerid = pv.ID) where pd.pid=$pid";
require_once('../../conn.php');
echo $sql;
$result = mysqli_query($conn,$sql) or die("$sql<br>" . mysql_error()); //SQL语句在这里执行
$row = mysqli_fetch_array($result);
$item = $row[item];
$update = $row[update];
$price = $row[price];
$minOrder = $row[minOrder];
$imglink = $row[imglink];以下是echo $sql的语句
select pd.pid, pd.providerid, pd.item, pd.update, pd.price, pd.minOrder, pd.imglink, pv.ID, pv.company from price_db as pd inner join providers as pv on (pd.providerid = pv.ID) where pd.pid=4
mysql_error()也无报错,已确定问题就在红色所示的sql内联语句中,请大家帮忙看看
$pid = $_GET['pid'];
// pid不为空,则调用记录
if (!empty($pid)) {
$sql = "select pd.pid, pd.providerid, pd.item, pd.update, pd.price, pd.minOrder, pd.imglink, pv.ID, pv.company from price_db as pd ".
"inner join providers as pv ".
"on (pd.providerid = pv.ID) where pd.pid=$pid";
require_once('../../conn.php');
echo $sql;
$result = mysqli_query($conn,$sql) or die("$sql<br>" . mysql_error()); //SQL语句在这里执行
$row = mysqli_fetch_array($result);
$item = $row[item];
$update = $row[update];
$price = $row[price];
$minOrder = $row[minOrder];
$imglink = $row[imglink];以下是echo $sql的语句
select pd.pid, pd.providerid, pd.item, pd.update, pd.price, pd.minOrder, pd.imglink, pv.ID, pv.company from price_db as pd inner join providers as pv on (pd.providerid = pv.ID) where pd.pid=4
mysql_error()也无报错,已确定问题就在红色所示的sql内联语句中,请大家帮忙看看
这儿你弄错了。
echo mysqli_error($conn);
有结果那就是后面的出错,无结果那就是空
去数据库里执行一下,看看是不是SQL拼写错误,如果有数据,则PHP的问题我测SQL没问题,看看是不是你where pd.pid=4 没有数据 所有返回空。
我测的SQL语句:select * from wwwadmin_ads_advertising as pd inner join wwwadmin_ads_image as pv on pd.Image_id = pv.Image_id where pd.Id=2