<?php
include_once "inc/class/db.php";
$db = new Db();
function getPrimary($db,$table_name,$field_name){
$sql = "select max($field_name) from ".$table_name;
$str = $db->fetchOne($sql);
if(!isset($str))
{
$str = date("Ymd");
$newid = $str."0001";
}
else
$newid = $str+1;
return $newid;
}
$id = getPrimary($db,"order_1","id");
$sql = "INSERT INTO order_1 VALUES('$id',NOW())";
$stmt = $db->query($sql);
if($stmt)
{
echo "操作成功";
}
?>