高手能不能key 一段代碼~我真的弄不出來~
解决方案 »
- 数组组合问题
- PHP开发中MySQL数据库索引的经验
- php调用soap的时候报错
- 怎么样获取当前目录路径
- 请知道的朋友帮忙,关于横竖循环的问题
- Warning: date(): Windows does not support dates prior to midnight (00:00:00), January 1, 1970
- ┄┄┄┄┄┄┄ 仍然是编码问题```` 简单问题```` 鬼魅问题````
- unable to load oracle.dll...etc
- submit后以指定宽度、有垂直滚动条打开新窗口显示结果?
- 新手问题:提示没有定义变量
- 如何进行验证?
- 为什么使用Adodb插入到Ms sql里面的中文都变样子了??
拆分:
$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數據庫是空的,每提交一次都提交成功,但是提交后紀錄是空的