f (substr($maxPr01,3,2)==date("m")) { $maxPr01++; } else { $maxPr01=substr($maxPr01,0,1).date("y").date("m")."001"; } 胡亂胡亂路亂
你最好用一个字段标识插入的日期 每次插入前先选择出本月插入的个数,再在个数上加1插入你的个数位只有3位,不足可以补0,但超了怎么处理? 以下只考虑3位不足补0的部分 select @total:=count(*) from tbl where month(now()) = month(datefield); insert into tbl set pro1= concat('A',date_format(now(), '%y%m'),right(concat('00',(@total+1)),3));
<?php //connect to the mysql $db=mysql_connect("172.16.10.7","basys","123654"); //select db mysql_select_db("apply",$db);$sql = "select count(*) as total from Prg_Req where month(now()) = month(datefield)";$res = mysql_query( $sql ); $arr = mysql_fetch_array( $res ); $PR01= "A" . date("ym") . str_pad( $arr["total"], 3, "0", STR_PAD_LEFT ); ?><input type="text" name="PR01" readonly="ture" value="<?php echo $PR01; ?>">看我的代碼是這個樣子的,但是還是不行啊~這個是出錯代碼 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\myweb\testfile\manager.php on line 10 錯誤代碼是這一行:$arr = mysql_fetch_array( $res );
拆分:
$result=Array("A", "04", "12", "001");
获取当前日期:
$now= Array("A","04","12");
判断年份月份是否相同,
相同,那么只要
$now[3]=$result[3]+1;
否则,那么更新年份(有可能的话),更新月份,然后:
$now[3]="000";
将$now数据的数据存入数据库
亂了。不會弄阿~
{
$maxPr01++;
} else {
$maxPr01=substr($maxPr01,0,1).date("y").date("m")."001";
}
胡亂胡亂路亂
每次插入前先选择出本月插入的个数,再在个数上加1插入你的个数位只有3位,不足可以补0,但超了怎么处理?
以下只考虑3位不足补0的部分
select @total:=count(*) from tbl where month(now()) = month(datefield);
insert into tbl set pro1= concat('A',date_format(now(), '%y%m'),right(concat('00',(@total+1)),3));
如果要在一個input裏面呢??把這段信息放入input裏面(也就是說在input裏面顯示我所說的條件)然後input設置為 readonly='ture'具體該怎麼弄呢?
請高手詳細點解一下啊!
A A0412
B 自动编号
你先把本月的总个数算出
$sql = "select count(*) as total from tbl where month(now()) = month(datefield)";$res = mysql_query( $sql );
$arr = mysql_fetch_array( $res );
$pro1= "A" . date("ym") . str_pad( $arr["total"], 3, "0", STR_PAD_LEFT );
生成下一个的pro1
<input type="text" readonly="readonly" value="<?php echo $pro1; ?>"/>
$sql = "select count(*) as total from Prg_Req where month(now()) = month(datefield)";$res = mysql_query( $sql );
$arr = mysql_fetch_array( $res );
$PR01= "A" . date("ym") . str_pad( $arr["total"], 3, "0", STR_PAD_LEFT );
?><input type="text" name="PR01" readonly="ture" value="<?php echo $PR01; ?>">行不通阿~寻梦的稻草人我这个人笨的可以
$lp = mysql_connect("localhost", "user", "password" );
mysql_selected_db( "dbname", $lp );
然后再 mysql_query(....);
//connect to the mysql
$db=mysql_connect("172.16.10.7","basys","123654");
//select db
mysql_select_db("apply",$db);$sql = "select count(*) as total from Prg_Req where month(now()) = month(datefield)";$res = mysql_query( $sql );
$arr = mysql_fetch_array( $res );
$PR01= "A" . date("ym") . str_pad( $arr["total"], 3, "0", STR_PAD_LEFT );
?><input type="text" name="PR01" readonly="ture" value="<?php echo $PR01; ?>">看我的代碼是這個樣子的,但是還是不行啊~這個是出錯代碼
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\myweb\testfile\manager.php on line 10
錯誤代碼是這一行:$arr = mysql_fetch_array( $res );
你应该替换成你的日期字段名
//1.php
<?php
$db=mysql_connect("172.16.10.7","basys","123654");
mysql_select_db("longwell",$db);$sql = "select count(PR01) as total from Prg_Req where month(now()) = month(PR01)";$res = mysql_query( $sql );
$arr = mysql_fetch_array( $res );
$PR01= "A" . date("ym") . str_pad( $arr["total"], 3, "0", STR_PAD_LEFT );
?>
<form name="form1" method="post" action="2.php">
<input type="text" name="PR01" readonly="ture" value="<?php echo $PR01; ?>">
<input type="submit" name="Submit" value="送出">
</form>
//2.php<?php
$db=mysql_connect("172.16.10.7","basys","123654");mysql_select_db("longwell",$db); $sql = "INSERT INTO Prg_Req (PR01) VALUES ('$PR01')";
$result = mysql_query($sql);
if ($result){
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
</head>
<body>
<script language="javascript">
alert('更新成功!');
location.href="1.php";
</script>
</body>
</html>
<?
}
else{
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
</head>
<body>
<script language="javascript">
alert('更新失敗,請再重試一次!');
history.go(-1);
</script>
</body>
</html>
<?
}?>
跳轉到1.php后顯示的還是A0412000數據庫是空的,每提交一次都提交成功,但是提交后紀錄是空的