fabu.php代码如下<html>
<body align=center stlye="wdith:800px;"><form action="savefabu.php" method="post">
<table style="width:800px; height:600px;">
<tr>
<td width=100>catid:</td> <td><input type="text" name="catid" /> </td></tr>
<tr><td>typeid:</td> <td><input type="text" name="typeid" value="0"/> </td></tr>
<tr><td>areaid:</td> <td><input type="text" name="areaid" /> </td></tr>
<tr><td>title: </td><td><input type="text" name="title" /> </td></tr>
<tr><td>posids: </td><td><input type="text" name="posids" value="0"/> </td></tr>
<tr><td>url:</td> <td><input type="text" name="url" value="url"/> </td></tr>
<tr><td>listorder:</td><td><input type="text" name="listorder" value="0"/> </td> </tr>
<tr><td>status:</td><td><input type="text" name="status" value="99"/> </td></tr>
<tr><td>userid:</td><td><input type="text" name="userid" value="1"/> </td></tr>
<tr><td>username:</td><td><input type="text" name="username" value="lovelover"/> </td></tr>
<tr><td>inputtime:</td><td><input type="text" name="inputtime" value="1282286912"/> </td></tr>
<tr><td>updatetime:</td><td><input type="text" name="updatetime" value="1282286912"/> </td> </tr><tr><td>islink:</td><td><input type="text" name="islink" value="0"/></td>
</tr>
<tr><td>template:</td><td><input type="text" name="template" value="show_info"/> </td> </tr><tr><td>content:</td><td><input type="text" name="template" /> </td> </tr><tr><td>endtime:</td><td><input type="text" name="endtime" value="2010-12-01"/> </td> </tr>
<tr><td>telephone:</td><td><input type="text" name="telephone" /> </td> </tr><tr><td>email :</td><td><input type="text" name="email" /> </td> </tr>
<tr><td>address :</td><td><input type="text" name="address" /> </td> </tr><tr><td>groupids_view :</td><td><input type="text" name="groupids_view" value="0" /> </td> </tr><tr><td>readpoint :</td><td><input type="text" name="readpoint" value="0"/> </td> </tr></table><input type="submit" />
</form></body>
</html>
savefabu.php 代码如下:<?php
$con = mysql_connect("localhost","admin","admin");
mysql_query("SET NAMES UTF8");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("lucy1015", $con);$sql="INSERT INTO phpcms_content (catid, typeid, areaid, title, posids, url, listorder, status, userid, username, inputtime, updatetime, islink)VALUES ('$_POST[catid]','$_POST[typeid]','$_POST[areaid]','$_POST[title]','$_POST[posids]','$_POST[url]','$_POST[listorder]','$_POST[status]','$_POST[userid]','$_POST[username]','$_POST[inputtime]','$_POST[updatetime]','$_POST[islink]')";
$sql2="INSERT INTO phpcms_c_info (contentid, template, content, endtime, telephone, email, address, groupids_view, readpoint)VALUES ('mysql_insert_id()','$_POST[template]','$_POST[content]','$_POST[endtime]','$_POST[telephone]','$_POST[email]','$_POST[address]','$_POST[groupids_view]','$_POST[readpoint]')"; if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "成功添加!";mysql_close($con)
?> 就是同时表单的数据插入第一个表 和第二个表 第二个数据表的字段 contentid 能够自动获取到第一个表的生成的contentid
第二个表的插入语句我些了 不行
请PHP高手给看看
<body align=center stlye="wdith:800px;"><form action="savefabu.php" method="post">
<table style="width:800px; height:600px;">
<tr>
<td width=100>catid:</td> <td><input type="text" name="catid" /> </td></tr>
<tr><td>typeid:</td> <td><input type="text" name="typeid" value="0"/> </td></tr>
<tr><td>areaid:</td> <td><input type="text" name="areaid" /> </td></tr>
<tr><td>title: </td><td><input type="text" name="title" /> </td></tr>
<tr><td>posids: </td><td><input type="text" name="posids" value="0"/> </td></tr>
<tr><td>url:</td> <td><input type="text" name="url" value="url"/> </td></tr>
<tr><td>listorder:</td><td><input type="text" name="listorder" value="0"/> </td> </tr>
<tr><td>status:</td><td><input type="text" name="status" value="99"/> </td></tr>
<tr><td>userid:</td><td><input type="text" name="userid" value="1"/> </td></tr>
<tr><td>username:</td><td><input type="text" name="username" value="lovelover"/> </td></tr>
<tr><td>inputtime:</td><td><input type="text" name="inputtime" value="1282286912"/> </td></tr>
<tr><td>updatetime:</td><td><input type="text" name="updatetime" value="1282286912"/> </td> </tr><tr><td>islink:</td><td><input type="text" name="islink" value="0"/></td>
</tr>
<tr><td>template:</td><td><input type="text" name="template" value="show_info"/> </td> </tr><tr><td>content:</td><td><input type="text" name="template" /> </td> </tr><tr><td>endtime:</td><td><input type="text" name="endtime" value="2010-12-01"/> </td> </tr>
<tr><td>telephone:</td><td><input type="text" name="telephone" /> </td> </tr><tr><td>email :</td><td><input type="text" name="email" /> </td> </tr>
<tr><td>address :</td><td><input type="text" name="address" /> </td> </tr><tr><td>groupids_view :</td><td><input type="text" name="groupids_view" value="0" /> </td> </tr><tr><td>readpoint :</td><td><input type="text" name="readpoint" value="0"/> </td> </tr></table><input type="submit" />
</form></body>
</html>
savefabu.php 代码如下:<?php
$con = mysql_connect("localhost","admin","admin");
mysql_query("SET NAMES UTF8");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("lucy1015", $con);$sql="INSERT INTO phpcms_content (catid, typeid, areaid, title, posids, url, listorder, status, userid, username, inputtime, updatetime, islink)VALUES ('$_POST[catid]','$_POST[typeid]','$_POST[areaid]','$_POST[title]','$_POST[posids]','$_POST[url]','$_POST[listorder]','$_POST[status]','$_POST[userid]','$_POST[username]','$_POST[inputtime]','$_POST[updatetime]','$_POST[islink]')";
$sql2="INSERT INTO phpcms_c_info (contentid, template, content, endtime, telephone, email, address, groupids_view, readpoint)VALUES ('mysql_insert_id()','$_POST[template]','$_POST[content]','$_POST[endtime]','$_POST[telephone]','$_POST[email]','$_POST[address]','$_POST[groupids_view]','$_POST[readpoint]')"; if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "成功添加!";mysql_close($con)
?> 就是同时表单的数据插入第一个表 和第二个表 第二个数据表的字段 contentid 能够自动获取到第一个表的生成的contentid
第二个表的插入语句我些了 不行
请PHP高手给看看
if (!mysql_query($sql,$con)){
die('Error: ' . mysql_error());
}
$sql2 = "*************('".mysql_insert_id()."',****";
mysql_query($sql2,$con)
echo "成功添加!";
mysql_close($con);
mysql_query($sql2,$con);
$con = mysql_connect("localhost","admin","admin");
mysql_query("SET NAMES UTF8");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("lucy1015", $con);$sql="INSERT INTO phpcms_content (catid, typeid, areaid, title, posids, url, listorder, status, userid, username, inputtime, updatetime, islink)VALUES ('$_POST[catid]','$_POST[typeid]','$_POST[areaid]','$_POST[title]','$_POST[posids]','$_POST[url]','$_POST[listorder]','$_POST[status]','$_POST[userid]','$_POST[username]','$_POST[inputtime]','$_POST[updatetime]','$_POST[islink]')";if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
$sql2="INSERT INTO phpcms_c_info (contentid, template, content, endtime, telephone, email, address, groupids_view, readpoint)VALUES (".mysql_insert_id().",'$_POST[template]','$_POST[content]','$_POST[endtime]','$_POST[telephone]','$_POST[email]','$_POST[address]','$_POST[groupids_view]','$_POST[readpoint]')";mysql_query($sql2,$con); echo "成功添加!";mysql_close($con)
?>
2 if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
if (!mysql_query($sql2,$con))
{
die('Error: ' . mysql_error());
}
echo "成功添加!";mysql_close($con)
$content = $_POST["content"];
$sql1 = "insert into table1...";
$sql2 = "insert into table2...";
mysql_query($sql1);
mysql_query($sql2);