用户登录问题? 各位,请问: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条件,如果能查询到结果就允许登录,反之不允许。 如何判读PHP页面第一次加载 php 通过什么样的方法可以实现发送传真!!! discuz 和 ucenter 的用户密码 请问各位php高人,我用php写的后台如何支持苹果的浏览器啊? 有没有好的操作excel的类 php5.1.6情况下,出现RECURSION。求破!!! $db->query_first的简单问题,紧急求助!!!!多谢各位大侠!! php通过com链接access数据库的问题!? 各位老大,高分求解~PHP+SQL server2k的问题~ 关于PHP的DEBUG类?? 这种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,试着写的。获取数据库链接的写在另外的文件了。