php 添加用户简单的php入门教程
CREATE TABLE IF NOT EXISTS `leo_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` char(30) NOT NULL, `birthday` date NOT NULL, `email` char(60) NOT NULL, `sex` enum('M','F','-') NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- 导出表中的数据 `leo_user` -- INSERT INTO `leo_user` (`id`, `name`, `birthday`, `email`, `sex`) VALUES (1, '张三', '1980-01-01', 'zhangshan@email.com', 'M'), (2, '李四', '1998-01-25', 'lisi@test.com', 'M'), (3, '王五', '1985-12-24', 'wangwu@leophp.cn', '-'), (4, '赵六', '1978-05-05', 'zhaoliu@test.com', 'F');
<?php function db_exec($sql) { $resource = mysql教程_connect(DB_HOST, DB_USER, DB_PASSWORD); //连接数据库教程 mysql_query("SET NAMES '" . DB_CHARSET . "' ;"); //设置字体集 $connect = mysql_select_db(DB_NAME, $resource); //选择数据库 return mysql_query($sql, $resource); //执行SQL } if($_POST['op'] == 'add') { $sql = " INSERT INTO " . TABLE_PREFIX . "user ( name, birthday, email, sex ) VALUES ( '" . $_POST['name'] . "', '" . $_POST['birthday'] . "', '" . $_POST['email'] . "', '" . $_POST['sex'] . "' )"; if(db_exec($sql)) { $notice = array( 'msg' => '添加成功', 'alt' => '列表用户', 'url' => '?op=index' ); require_once './_notice.phtml'; } else { $notice = array( 'msg' => '添加失败', 'alt' => '添加用户', 'url' => '?op=add' ); require_once './_notice.phtml'; } } else { require_once 'view/add.phtml'; }
//add.phtml模板页面
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>用户添加</title> </head> <body> <h3>用户添加</h3> <form action="?op=add" method="post" enctype="application/x-www-form-urlencoded"> 姓名:<input type="text" name="name" size="15" /><br /> 生日:<input type="text" name="birthday" size="10" /> (YYYY-MM-DD)www.111cn.net<br /> 邮箱:<input type="text" name="email" size="30" /><br /> 性别:<input type="radio" name="sex" value="3" />保密 <input type="radio" name="sex" value="1" />男 <input type="radio" name="sex" value="2" />女<br /> <input type="hidden" name="op" value="add" /><br /> <input type="submit" name="submit" value="添加用户" /> </form> <?php require_once 'view/_foot.phtml'; ?> </body> </html>
文章链接:http://www.phprm.com/code/7cf9306dcacfbd4fabf8a8dd1d801335.html
随便收藏,请保留本文地址!