mysql中插入 年 月 日 +数字 递增的订单号

 <?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 "操作成功";
}
?>