连接数据库 $conn=@mysql_connect("localhost","root","") or die(mysql_error()); @mysql_select_db('demo',$conn) or die(mysql_error());
localhost 是服务器ip,本机用localhost root是数据库用户名 密码为空。
db结构
CREATE TABLE `test` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(100) NOT NULL, `age` tinyint(4) unsigned NOT NULL, `addtime` datetime NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
db.php 用于显示记录
<?php //打开数据库 function opendb(){ $conn=@mysql_connect("localhost","root","") or die(mysql_error()); @mysql_select_db('demo',$conn) or die(mysql_error()); } //关闭数据库 function closedb(){ @mysql_close() or die("?????出?!"); } opendb(); echo ''; $sqlstr = "select * from test order by addtime desc"; $query = mysql_query($sqlstr) or die(mysql_error()); while($thread=mysql_fetch_assoc($query)){ $result[] = $thread; } if($result){ foreach($result as $val){ echo $val['id'].' '.$val['name'].' '.$val['age'].' '.$val['addtime'].' '; } }?>
add.php 用于新增记录
<?php//打开数据库function opendb(){ $conn=@mysql_connect("localhost","root","") or die(mysql_error()); @mysql_select_db('demo',$conn) or die(mysql_error()); }//关闭数据库function closedb(){ @mysql_close() or die("?????出?!");}opendb();$send = isset($_POST['send'])? $_POST['send'] : '';if($send=='true'){ // submit $name = isset($_POST['name'])? $_POST['name'] : ''; $age = isset($_POST['age'])? $_POST['age'] : ''; $addtime = date('Y-m-d H:i:s'); if($name=='' || $age==''){ exit('name or age is empty'); } $sqlstr = "insert into test(name,age,addtime) values('{$name}','{$age}','{$addtime}')"; mysql_query($sqlstr) or die(mysql_error()); echo 'insert success';}else{?> New Document
连接数据库 $conn=@mysql_connect("localhost","root","") or die(mysql_error()); @mysql_select_db('demo',$conn) or die(mysql_error());
localhost 是服务器ip,本机用localhost root是数据库用户名 密码为空。
db结构
CREATE TABLE `test` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(100) NOT NULL, `age` tinyint(4) unsigned NOT NULL, `addtime` datetime NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
db.php 用于显示记录
<?php //打开数据库 function opendb(){ $conn=@mysql_connect("localhost","root","") or die(mysql_error()); @mysql_select_db('demo',$conn) or die(mysql_error()); } //关闭数据库 function closedb(){ @mysql_close() or die("?????出?!"); } opendb(); echo ''; $sqlstr = "select * from test order by addtime desc"; $query = mysql_query($sqlstr) or die(mysql_error()); while($thread=mysql_fetch_assoc($query)){ $result[] = $thread; } if($result){ foreach($result as $val){ echo $val['id'].' '.$val['name'].' '.$val['age'].' '.$val['addtime'].' '; } }?>
add.php 用于新增记录
<?php//打开数据库function opendb(){ $conn=@mysql_connect("localhost","root","") or die(mysql_error()); @mysql_select_db('demo',$conn) or die(mysql_error()); }//关闭数据库function closedb(){ @mysql_close() or die("?????出?!");}opendb();$send = isset($_POST['send'])? $_POST['send'] : '';if($send=='true'){ // submit $name = isset($_POST['name'])? $_POST['name'] : ''; $age = isset($_POST['age'])? $_POST['age'] : ''; $addtime = date('Y-m-d H:i:s'); if($name=='' || $age==''){ exit('name or age is empty'); } $sqlstr = "insert into test(name,age,addtime) values('{$name}','{$age}','{$addtime}')"; mysql_query($sqlstr) or die(mysql_error()); echo 'insert success';}else{?> New Document