查询和网页间值得传递 遍历及展示 数据的插入 数据库的更新

$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"}';
?>更新数据库