【php开源代码栏目提醒】:以下是网学会员为您推荐的php开源代码-creasset_add_ok.php,希望本篇文章对您学习有所帮助。
<body background="images/0021.gif" leftmargin="150">
<font face="标楷体">
<h2>固定数据建立</h2><br><br><br>
<?
$link=mysql_connect('localhost','root','123456');
mysql_select_db('fams');
$str="select max(asset_no) from creasset;";
$result=
mysql_query($str,$link);
while ($row=my
sql_fetch_array($result,MYSQL_NUM))
{
$one = substr(".$row[0]",1,1); //总长度不因此改变
$count = substr(".$row[0]",2);
$count=$count+1;
$zero="000000";
$sym="8"; //依前面所加代号可更改 此程式预设为加1个代号
$rest = "$sym$zero$count";
}
echo "资产编号:".$rest;
//新增数据
$str="insert into creasset values('".$rest."','".$category."','".$name."','".$amt."','".$unit."','".$owner."','" .$buyday."','".$nullday."','".$dep."','".$location."','".$asup_no."','".$invoice."','".$price."','".$tax."','".$assort."','".$status."','".$com."');";
$result=mysql_query($str,$link);
echo "<br>";
echo "<br>";
echo "资产类别:".$category;
echo "<br>";
echo "资产名称:".$name;
echo "<br>";
echo "数量:".$amt;
echo "<br>";
echo "保管人:".$owner;
echo "<br>";
echo "购买日期:".$buyday;
echo "<br>";
echo "成本中心:".$dep;
echo "<br>";
echo "所在位置:".$location;
echo "<br>";
echo "供应商编号:".$asup_no;
echo "<br>";
echo "发票号码:".$invoice;
echo "<br>";
echo "购入金额:".$price;
echo "<br>";
echo "税金:".$tax;
echo "<br>";
echo "财产分类:".$assort;
echo "<br>";
echo "财产指示码:".$status;
echo "<br>";
echo "备注:".$com;
echo "<br><br>";
?>
<a href="creasset_add.php">回上一页</a>
<p>
<INPUT onclick="document.execCommand('print','true','true')" type=button value=列印>