您尚未登入。
我已在data 加了 count 一欄，但不懂得如何在「用家」登入後把count + 1...
<?php require_once('Connections/libcn.php'); ?>
<?php
// *** Validate request to login to this site.
session_start();
$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($accesscheck)) {
$GLOBALS['PrevUrl'] = $accesscheck;
session_register('PrevUrl');
}
if (isset($_POST['login'])) {
$loginUsername=$_POST['login'];
$password=$_POST['password'];
$MM_fldUserAuthorization = "level";
$MM_redirectLoginSuccess = "main.php";
$MM_redirectLoginFailed = "accessdenied.php";
$MM_redirecttoReferrer = false;
mysql_select_db($database_libcn, $libcn);
$LoginRS__query=sprintf("SELECT logid, password, level, count FROM data WHERE logid='%s' AND password='%s'",
get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password));
$LoginRS = mysql_query($LoginRS__query, $libcn) or die(mysql_error());
$loginFoundUser = mysql_num_rows($LoginRS);
if ($loginFoundUser) {
$loginStrGroup = mysql_result($LoginRS,0,'level');
$count = $count+1;
//declare two session variables and assign them
$GLOBALS['MM_Username'] = $loginUsername;
$GLOBALS['MM_UserGroup'] = $loginStrGroup;
//register the session variables
session_register("MM_Username");
session_register("MM_UserGroup");
if (isset($_SESSION['PrevUrl']) && false) {
$MM_redirectLoginSuccess = $_SESSION['PrevUrl'];
}
header("Location: " . $MM_redirectLoginSuccess );
}
else {
header("Location: ". $MM_redirectLoginFailed );
}
}
?>
離線
其實e段碼好煩, 比我唔會咁寫...
其實方法係係容戶成功登入後,
//首先連接sql
mysql_connect("localhost","root","") or die("連接失敗");
mysql_select_db("db");
//取得count值
$sql="select count db where username='$username'";
$result=mysql_query($sql);
//輸出資料
list($count)=mysql_fetch_row($result);
//count+1
$count = $count+1;
//使用update 語法更新值
$sql="UPDATE db SET count='$count' where username='$username'";
mysql_query($sql);
離線