客服电话
APP下载
迪恩网络APP
随时随地掌握行业动态
官方微信
扫描二维码
关注迪恩网络微信公众号
|
$Host = "localhost";
$Database = "smsdb"; $DbaUser = "root"; $DbaPassword = ""; ////数据库的连接 $db = mysql_pconnect($Host, $DbaUser,$DbaPassword); if(!$db) { echo "Error: Could not connect to database.Please try again."; exit; } //选择数据库 mysql_select_db($Database,$db); ///数据库的断开 mysql_close($db); ///数据库的操作 //查询 $query = "SELECT * FROM user WHERE "; //插入 $query = "INSERT INTO employees VALUES (2,'John','Roberts','45 There St , Townville','Telephonist');" //删除 $query = "DELETE FROM employees WHERE age IS NULL"; //修改 $query = "UPDATE employees SET FROM WHERE"; Townville','Telephonist');" //结果 $result = mysql_query($query); if(!$result) { echo "Error!"; exit ; } $num_reslutlt = mysql_num_rows($result); //获取当前系统时间 $AddTime = date("YmdHms"); ///////////////////////////1. enroll.php 用户注册 $Host = "localhost"; $Database = "smsdb"; $DbaUser = "root"; $DbaPassword = ""; //验证用户填写数据的合理性 trim($UserMb); trim($UserPwd); trim($PwdConfirm); if(!$UserMb || !$UserPwd || !$PwdConfirm) { echo "Your have not enter your detail message"; exit; } if($UserPwd != $PwdConfirm) { echo "Confirm Password not correct to passworld" ; exit; } ////数据库的连接 $db = mysql_pconnect($Host, $DbaUser,$DbaPassword); if(!$db) { echo "Error: Could not connect to database.Please try again."; exit; } //选择数据库 mysql_select_db($Database,$db); //获取当前系统时间 $AddTime = date("YmdHms"); //插入 $query = "INSERT INTO user VALUES ('','".$UserMb."','".$UserPwd."','".$AddTime."');" //结果 $result = mysql_query($query); if($result) { ///以下为成功后的相关操作 echo "Enroll Success!"; } else { echo "Error!"; exit ; } ///数据库的断开 mysql_close($db); ////////////////////////////////////////////用户验证代码示例 //判断用户名是否设置 if(!isset($PHP_AUTH_USER)) { header("WWW-Authenticate:Basic realm="身份验证功能""); header("HTTP/1.0 401 Unauthorized"); echo "身份验证失败，您无权共享网络资源!"; exit(); } /*连接数据库*/ $db=mysql_connect("localhost","root",""); //选择数据库 mysql_select_db("XinXiKu",$db); //查询用户是否存在 $result=mysql_query("SELECT * FROM user WHERE name='$PHP_AUTH_USER' AND password='$PHP_AUTH_PW'",$db); if ($myrow = mysql_fetch_row($result)) { //以下为身份验证成功后的相关操作 } else { //身份验证不成功，提示用户重新输入 header("WWW-Authenticate:Basic realm="身份验证功能""); header("HTTP/1.0 401 Unauthorized"); echo "身份验证失败，您无权共享网络资源!"; exit(); } ///////////////////////2 login.php 用户登陆 $Host = "localhost"; $Database = "smsdb"; $DbaUser = "root"; $DbaPassword = ""; //验证用户填写数据的合理性 trim($UserMb); trim($UserPwd); if(!$UserMb || !$UserPwd ) { echo "Your have not enter your detail message"; exit; } ////数据库的连接 $db = mysql_pconnect($Host, $DbaUser,$DbaPassword); if(!$db) { echo "Error: Could not connect to database.Please try again."; exit; } //选择数据库 mysql_select_db($Database,$db); //查询用户是否存在 $query = "SELECT * FROM user WHERE name='$UserMb' AND password='$UserPwd'"; $result=mysql_query($query); if ($myrow = mysql_fetch_row($result)) { //以下为身份验证成功后的相关操作 } else { //身份验证不成功，提示用户重新输入 header("WWW-Authenticate:Basic realm="身份验证功能""); header("HTTP/1.0 401 Unauthorized"); echo "身份验证失败，您无权共享网络资源!"; exit(); } ///数据库的断开 mysql_close($db); ////////////////// 3. 管理员登录 $Host = "localhost"; $Database = "smsdb"; $DbaUser = "root"; $DbaPassword = ""; //验证用户填写数据的合理性 trim($SysUser); trim($SysUserPwd); if(!$SysUser || !$SysUserPwd ) { echo "Your have not enter your detail message"; exit; } ////数据库的连接 $db = mysql_pconnect($Host, $DbaUser,$DbaPassword); if(!$db) { echo "Error: Could not connect to database.Please try again."; exit; } //选择数据库 mysql_select_db($Database,$db); //查询用户是否存在 $query = "SELECT * FROM sysuser WHERE SysUser='$SysUser' AND SysUserPwd='$SysUserPwd'"; $result=mysql_query($query); if ($myrow = mysql_fetch_row($result)) { //以下为身份验证成功后的相关操作 } else { //身份验证不成功，提示用户重新输入 header("WWW-Authenticate:Basic realm="身份验证功能""); header("HTTP/1.0 401 Unauthorized"); echo "身份验证失败，您无权共享网络资源!"; exit(); } ///数据库的断开 mysql_close($db); /////////////////////// 4. 文字短信管理 /**********显示短信********************/ $Host = "localhost"; $Database = "smsdb"; $DbaUser = "root"; $DbaPassword = ""; ////数据库的连接 $db = mysql_pconnect($Host, $DbaUser,$DbaPassword); if(!$db) { echo "Error: Could not connect to database.Please try again."; exit; } //选择数据库 mysql_select_db($Database,$db); //查询文字短信 $query = "SELECT * FROM sms WHERE SmsType='$SmsType'; $result=mysql_query($query); if ($myrow = mysql_fetch_row($result)) { //以下为提取成功后的相关操作 } else { echo "无记录!"; exit(); } ///数据库的断开 mysql_close($db); /*************添加短信*****************************/ $Host = "localhost"; $Database = "smsdb"; $DbaUser = "root"; $DbaPassword = ""; ////数据库的连接 $db = mysql_pconnect($Host, $DbaUser,$DbaPassword); if(!$db) { echo "Error: Could not connect to database.Please try again."; exit; } //选择数据库 mysql_select_db($Database,$db); //获取当前系统时间 $AddTime = date("YmdHms"); //添加 $query = "INSERT INTO sms VALUES ('',$SmsType,$SmsContent,$AddTime)"; $result=mysql_query($query); if ($myrow = mysql_fetch_row($result)) { //以下为添加成功后的相关操作 } else { echo "Add fail!"; exit(); } ///数据库的断开 mysql_close($db); /*************删除*********************************/ $Host = "localhost"; $Database = "smsdb"; $DbaUser = "root"; $DbaPassword = ""; ////数据库的连接 $db = mysql_pconnect($Host, $DbaUser,$DbaPassword); if(!$db) { echo "Error: Could not connect to database.Please try again."; exit; } //选择数据库 mysql_select_db($Database,$db); //删除 $query = "DELETE FROM sms WHERE SmsId = $SmsId"; $result=mysql_query($query); if ($myrow = mysql_fetch_row($result)) { //以下为删除成功后的相关操作 } else { echo "Delete fail!"; exit(); } ///数据库的断开 mysql_close($db);
|
2022-07-18
2022-08-30
2022-08-17
2022-11-06
2022-08-17
librespeed/speedtest: Self-hosted Speedtest for HTML5 and more. Easy setup, exam
avehtari/BDA_m_demos: Bayesian Data Analysis demos for Matlab/Octave
女人怀孕后，为了有一个健康聪明的宝宝，经历各种体检、筛查。其实这些体检和筛查中的
A vulnerability was found in Itech Movie Portal Script 7.36. It has been declare
medfreeman/markdown-it-toc-and-anchor: markdown-it plugin to add a toc and ancho
万里平台石家庄会场，领略大美石家庄，用诗歌赞美我可爱的家乡石家庄。 我可爱的家乡
sydney0zq/covid-19-detection: The implementation of A Weakly-supervised Framewor
Matlab，批量，绘图，文件读取
离中国最远的国家是阿根廷。从太平洋直线计算，即往东线走，北京到阿根廷的布宜诺斯艾
INI文件操作 （1）INI文件的结构： ;这是关于INI文件的注释部分 关键字=值 ...
请发表评论