如何将表单里面数据写到数据库里面.docVIP

如何将表单里面的数据写到数据库里面 CREATE TABLE `liuyan`.`ll_phone` ( `id` INT NOT NULL AUTO_INCREMENT , `time` FLOAT NOT NULL , `tel` VARCHAR( 255 ) NOT NULL , `date` datetime NOT NULL , `ip` INT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM ; !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=/1999/xhtml head meta http-equiv=Content-Type content=text/html; charset=utf-8 / title无标题文档/title script src=SpryAssets/SpryValidationConfirm.js type=text/javascript/script link href=SpryAssets/SpryValidationConfirm.css rel=stylesheet type=text/css / /head body ?php include (conn.php); ? form action=llxinxi.php method=post 时间： input type=text name=time br/ 手机号： input type=text name=tel br/ input type=submit value=提交 /form /body /html 写入数据并且返回结果 llxinxi.php !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=/1999/xhtml head meta http-equiv=Content-Type content=text/html; charset=utf-8 / title无标题文档/title script src=SpryAssets/SpryValidationConfirm.js type=text/javascript/script link href=SpryAssets/SpryValidationConfirm.css rel=stylesheet type=text/css / /head body ?php include(conn.php); $id = mysql_insert_id(); $time=$_POST[time]; $tel=$_POST[tel]; mysql_query(SET NAMES UTF8); mysql_select_db(liuyan); $sql = insert into ll_phone (id,time,tel,date) values (null,$time,$tel,NOW()); $result = mysql_query($sql); $timesql = SELECT * FROM ll_phone ORDER BY time ASC LIMIT 0 ,10 ; $result1 = mysql_query($timesql); while($row = mysql_fetch_array($result1, MYSQL_NUM)) { $ID = $row[0]; $name = $row[1]; $tel = $row[2]; echo time:$name USERid:$ID Telphone: $tel br / ; } mysql_close(); ? /body /html Conn.php ?php /* * To change this template, choose Tools | Templates * and open the template in the editor. */ mysql_connect(localhost,root,root);//连接数据库 mysql_select_db(liuyan);//选择数据库 ? HYPERLINK 原创