用户登录问题? 各位,请问:PHP中怎样将已经从表单获取到得用户信息传入数据库,与其进行匹配? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 没明白LZ什么意思建议LZ找个PHP&MySQL注册代码看看 require_once dirname(__FILE__).'/'.'../common/db/connect_db.php'; $compID = $_POST['compID']; $userID = $_POST['userID']; $userPsw = $_POST['userPsw']; if($compID == '' || $userID == '' || $userPsw == ''){ echo "<script language='javascript' type='text/javascript'>"; echo "window.location = '../login.html'"; echo "</script>"; } $con = getConnection(); $sql = "SELECT * FROM USER_MST UM LEFT JOIN COMP_MST CM ON UM.COMP_ID = CM.COMP_ID AND CM.DEL_FLG = 0 WHERE UM.COMP_ID='%s' AND UM.USER_ID='%s' AND UM.DEL_FLG=0"; $sql = sprintf($sql, mysql_real_escape_string($compID), mysql_real_escape_string($userID)); //echo $sql."<br/>"; //SQL execute mysql_query('SET NAMES UTF8'); $result = mysql_query($sql,$con); if(!$result){ echo "sql query error"; exit; } //data num $numrows = mysql_numrows($result); //get data $data = mysql_fetch_array($result); //check psw if($userPsw != $data["USER_PSW"] || $numrows != 1){ echo "failed:The id or password is wrong."; } else{ session_start(); $_SESSION['comp_id'] = $compID; $_SESSION['comp_name'] = $data['COMP_NAME']; echo "success"; } mysql_close($con);我刚学php,试着写的。获取数据库链接的写在另外的文件了。 数据不是传入数据库 而是根据表单的数据 去select 如果找到就转入success页面 否则error页面 就是把提交的数据作为SQL查询的WHERE条件,如果能查询到结果就允许登录,反之不允许。 preg_match低级问题,请高手赐教 php页面静态化如何做,不是伪静态....哪些方法比较好,大家用过的 XOOPS中的smarty表单显示问题 能把Javascript的数组传递到PHP中么 asp与php冲突问题 请教大家一个关于投票数显示的问题 这是问题 网络时代,我应选择什么,asp??php??jsp?? 经过md5加密的密码如何返回到原来的密码? 用fgets()读取txt文件每一行,怎么能够把每行中<>内部的字符串读出来啊? 这种json如何读取 跳转问题
require_once dirname(__FILE__).'/'.'../common/db/connect_db.php'; $compID = $_POST['compID'];
$userID = $_POST['userID'];
$userPsw = $_POST['userPsw']; if($compID == '' || $userID == '' || $userPsw == ''){
echo "<script language='javascript' type='text/javascript'>";
echo "window.location = '../login.html'";
echo "</script>";
} $con = getConnection(); $sql = "SELECT *
FROM USER_MST UM
LEFT JOIN COMP_MST CM
ON UM.COMP_ID = CM.COMP_ID
AND CM.DEL_FLG = 0
WHERE UM.COMP_ID='%s'
AND UM.USER_ID='%s'
AND UM.DEL_FLG=0"; $sql = sprintf($sql, mysql_real_escape_string($compID), mysql_real_escape_string($userID));
//echo $sql."<br/>"; //SQL execute
mysql_query('SET NAMES UTF8');
$result = mysql_query($sql,$con);
if(!$result){
echo "sql query error";
exit;
} //data num
$numrows = mysql_numrows($result); //get data
$data = mysql_fetch_array($result); //check psw
if($userPsw != $data["USER_PSW"] || $numrows != 1){
echo "failed:The id or password is wrong.";
}
else{
session_start(); $_SESSION['comp_id'] = $compID;
$_SESSION['comp_name'] = $data['COMP_NAME'];
echo "success";
} mysql_close($con);我刚学php,试着写的。获取数据库链接的写在另外的文件了。