随便写了几行,参考:<table>
<form name=form1 action=deal.php method=post>
<tr>
<td>
<input name=title>
</td>
</tr>
<tr>
<td>
<input name=submit type=submit>
</td>
</tr>
</form>deal.php
<?
$database="database_name";
$conn=mysql_connect("localhost","root","");
mysql_select_db($database,$conn);
$title=$_POST['title'];
$sql=$Sql=sprintf("INSERT INTO table_name(title) VALUES(\"%s\")",$title);
mysql_query($sql);
mysql_close();
?></table>
<form name=form1 action=deal.php method=post>
<tr>
<td>
<input name=title>
</td>
</tr>
<tr>
<td>
<input name=submit type=submit>
</td>
</tr>
</form>deal.php
<?
$database="database_name";
$conn=mysql_connect("localhost","root","");
mysql_select_db($database,$conn);
$title=$_POST['title'];
$sql=$Sql=sprintf("INSERT INTO table_name(title) VALUES(\"%s\")",$title);
mysql_query($sql);
mysql_close();
?></table>
<?php
$sql = mysql_connect("localhost:3306", "root","")or die ('Not connected : ' . mysql_error()); $database_cc=mysql_select_db('cc', $sql) or die ('Can\'t use foo : ' . mysql_error());
$database_an=mysql_select_db('an', $sql) or die ('Can\'t use foo : ' . mysql_error());
?>
<?
$result_cc=mysql_query("SELECT id, name FROM cc");
while ($row_cc = mysql_fetch_array($result_cc, MYSQL_ASSOC))
{
echo "学号:".$row_cc[id]." 姓名:".$row_cc[name]."<br>";
}//此为显示table1
/*$result_an=mysql_query("SELECT id, name FROM an");//发送一条SQL语句
while ($row_an = mysql_fetch_array($result_an, MYSQL_ASSOC)) //查询结果生成数组
{
echo "学号:".$row_an[id]." 姓名:".$row_an[name]."<br>";
}
mysql_close();*/
?> //显示table2
CREATE TABLE `cc` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
INSERT INTO `cc` VALUES (1, '1212');
INSERT INTO `cc` VALUES (2, 'dfad');
INSERT INTO `cc` VALUES (3, 'sdf');<?php
$database="an";
$conn=mysql_connect("localhost","root","");
mysql_select_db($database,$conn);$result_cc=mysql_query("SELECT id, name FROM cc");
while ($row_cc = mysql_fetch_array($result_cc, MYSQL_ASSOC))
{
echo "学号:".$row_cc[id]." 姓名:".$row_cc[name]."<br>";
}?>