$goods = db_query("select * from car_goods where id = '$id'");
<input type="hidden" name="id" value="<?php echo $goods[0]['id']; ?>"> 查询和获取
$goods = db_query("select * from car_goods order by id desc");
<div class="am-list-news-bd">
<ul class="am-list">
<?php for ($i = 0, $count = count($goods); $i < $count; $i++) { ?>
<li class="am-g am-list-item-dated">
<a href="car_goods_mod.php?id=<?php echo $goods[$i]['id']; ?>" class="am-list-item-hd"><?php echo $goods[$i]['title']; ?></a>
<span class="am-list-date"><?php echo $goods[$i]['mtime']; ?></span>
</li>
<?php } ?>
</ul>
</div> 遍历ID查询展示
<?php
header("Content-type: application/json; charset=UTF-8");
include('../lib/core/tool.php');
$title = empty($_POST['title']) ? '' : $_POST['title'];
$content = empty($_POST['content']) ? '' : $_POST['content'];
$brand = empty($_POST['brand']) ? '' : $_POST['brand'];
$normalprice= empty($_POST['normalprice']) ? '' : $_POST['normalprice'];
$couponprice= empty($_POST['couponprice']) ? '' : $_POST['couponprice'];
$id = uniqid() . mt_rand(100, 999);//汽车商品ID
$dbArr = array(
'id' => $id,
'title' => $title,
'content' => $content,
'brand' => $brand,
'normalprice' => $normalprice,
'couponprice' => $couponprice,
'ctime' => date('Y-m-d H:i:s'),
'mtime' => date('Y-m-d H:i:s')
);
db_insert('car_goods', $dbArr);//汽车商品
echo '{"result" : "success"}';
?>插入数据库
<?php
header("Content-type: application/json; charset=UTF-8");
include('../lib/core/tool.php');
$id = empty($_POST['id']) ? '' : $_POST['id'];
$title = empty($_POST['title']) ? '' : $_POST['title'];
$content = empty($_POST['content']) ? '' : $_POST['content'];
$brand = empty($_POST['brand']) ? '' : $_POST['brand'];
$normalprice= empty($_POST['normalprice']) ? '' : $_POST['normalprice'];
$couponprice= empty($_POST['couponprice']) ? '' : $_POST['couponprice'];
//$id = uniqid() . mt_rand(100, 999);//汽车商品ID
$sql_con = '';
if (!empty($title)) {
$sql_con .= ", title = '$title' ";
}
if (!empty($content)) {
$sql_con .= ", content = '$content' ";
}
if (!empty($brand)) {
$sql_con .= ", brand = '$brand' ";
}
if (!empty($normalprice)) {
$sql_con .= ", normalprice = '$normalprice' ";
}
if (!empty($couponprice)) {
$sql_con .= ", couponprice = '$couponprice' ";
}
$sql = "update car_goods set mtime = now() $sql_con where id = '$id'";
mysql_query($sql);
echo '{"result" : "success"}';
?>更新数据库