CREATE TABLE `open_aclass` (
`acid` tinyint(3) unsigned NOT NULL auto_increment,
`parid` tinyint(3) unsigned NOT NULL default '0',
`acorder` tinyint(3) NOT NULL default '0',
`acname` varchar(255) NOT NULL default '',
`acinfo` text NOT NULL,
PRIMARY KEY (`acid`,`parid`)
)
`acid` tinyint(3) unsigned NOT NULL auto_increment,
`parid` tinyint(3) unsigned NOT NULL default '0',
`acorder` tinyint(3) NOT NULL default '0',
`acname` varchar(255) NOT NULL default '',
`acinfo` text NOT NULL,
PRIMARY KEY (`acid`,`parid`)
)
mysql_query("CREATE TABLE guest(name char(16),sex char(4),email char(36),oicq char(15),time char(36),ip char (30),words text)"); echo "创建表guest成功!!!<BR>";
`acid` tinyint(3) unsigned NOT NULL auto_increment,
`parid` tinyint(3) unsigned NOT NULL default '0',
`acorder` tinyint(3) NOT NULL default '0',
`acname` varchar(255) NOT NULL default '',
`acinfo` text NOT NULL,
PRIMARY KEY (`acid`,`parid`)
)
",$db);
<html>
<body bgcolor="#F5F5F5">
<font size=4>数据库测试过程:</font><br><p>
<?php
$count=0;
$count++;
echo $count.'.';
$lj=mysql_connect('localhost','tideway','tjs');
//连接参数为本地主机,用户名为tideway,密码为tjs
if(!$lj)//如果变量lj为假
die('服务器连接失败');
else
echo('服务器连接成功');?>
<br><p><?php
$count++;
echo $count.'.';
$db=mysql_select_db('phptest');//选择数据库phptest
if(!$db)
die('选择数据库失败');
else
echo('选择数据库成功');
$a='insert into tb1 values("提交内容","'.$_POST[t1].'"," ")';
if($_POST[t1]!='')
{
mysql_query($a);
}
?><br><p>
<?php
$count++;
echo $count.'.';
echo '读取数据表:<br><br>';
$result=mysql_query('select * from tb1');//读取数据库phptest中的表tb1
while($row=mysql_fetch_row($result))
{echo '名称:'.$row[0];
echo ' 字段2:'.$row[1];
echo ' 字段3:'.$row[2];
echo '<br>';
}
echo '<br><p>';
mysql_close();//关闭mysql数据库
$count++;
echo $count.'.';
$db=mysql_select_db('phptest');
if(!$db)
echo('关闭服务选择数据库失败');
else
echo('关闭服务选择数据库成功');
?>
<form method='post' action='index.php'>
<textarea name='t1' cols='50' rows=3>
</textarea>
<input type='submit' value='提交'>
</form>
<br>
显示提交内容:
<?php
echo $_POST[t1];
?>
</body>
</html>