login cookie ดู code ติดปันหาคะ อยากจะเก็บเป็นรหัสเพื่อใช้ในการบันทึกข้อมูล
อยากจะเก็บ cookie เป็น id_member ได้มั้ยคะ<?php
@mysql_connect("localhost", "root", "") or die ("error connect to database");
@mysql_select_db("report") or die ("error select db");
mysql_query("SET NAMES 'tis620' ");
?>
<?php
ob_start();
session_start();
include ("mysql_connect.php");
$user = $_POST["username"];
$pass = $_POST["password"];
$depart = $_POST["depart1"];
if(empty($user)){
echo "<script>alert('Please input your username');window.location = 'main.php';</script>";
exit();
}
if(empty($pass)){
echo "<script>alert('Please input your password');window.location = 'main.php';</script>";
exit();
}
if(empty($depart)){
echo "<script>alert('Please input your choose department');window.location = 'main.php';</script>";
exit();
}
$sql = "SELECT * FROM member WHERE username='$user' and password='$pass' and id_department='$depart' and status_user ='1'";
$result = mysql_query($sql) or die ("SQL ERROR!!");
$row = mysql_fetch_array($result);
$num = mysql_num_rows($result);
$sql1 = "SELECT * FROM member WHERE username ='$user' and password='$pass' and id_department='$depart' and status_user ='0'";
$result1 = mysql_query($sql1) or die ("SQL1 ERROR!!");
$row1 = mysql_fetch_array($result1);
$num1 = mysql_num_rows($result1);
if($num >=1){
setcookie ( "username_admin", $user,time()+60 );
setcookie ( "password_admin", $pass,time()+60 );
echo"<script>alert('ยินดีต้อนรับ $user');
window.location = 'admin.php';</script>";
}else if($num1 >=1){
setcookie ( "id_name", 'id_member',time()+60 );
setcookie ( "username", $user,time()+60 );
setcookie ( "password", $pass,time()+60 );
header("location: login_employee.php");
}else{
echo "<script>alert('Please try again.');window.location = 'main.php';</script>";
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<?php
session_start ();
if(!isset($_COOKIE["id_name"]) && !isset($_COOKIE["username"]) && !isset($_COOKIE["password"])){
header("location:main.php");
exit();
}else {
echo "ยินดีตอนรับ " .$_COOKIE['username'] . $_COOKIE['id_name']; >> โชว์เป็น nickname ได้มั้ยคะ
}
?>
<center><br>
<h3><a href="add_report.php">Add daily report</a><br><br>
<a href="previous_report.php">Previous report</a><br><br>
<a href="edit_report.php">Edit information</a><br><br>
<a href="add_type.php">Add type</a><br><br><br>
<a href="logout.php">Logout</a></h3>
</center>
</body>
</html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<?php
session_start ();
if(!isset($_COOKIE["username"]) && !isset($_COOKIE["password"])){
header("location:main.php");
exit();
}
?>
<form id="form5" name="fomr5" method="post" action="check_add_report.php">
<center><h2>Daily report</h2></center>
<center>
<textarea name="report" cols ="70" rows="15"</textarea><br><p>
<select id="period" name="period" style="width:90px">
<option value="">- Period -</option>
<option value="30">30 min</option>
<option value="60">1 hour</option>
<option value="90">1 hour 30 min</option>
<option value="120">2 hour</option>
<option value="150">2 hour 30 min</option>
<option value="180">3 hour</option>
<option value="210">3 hour 30 min</option>
<option value="240">4 hour</option>
<option value="270">4 hour 30 min</option>
<option value="300">5 hour</option>
<option value="330">5 hour 30 min</option>
<option value="360">6 hour</option>
<option value="390">6 hour 30 min</option>
<option value="420">7 hour</option>
<option value="450">7 hour 30 min</option>
<option value="480">8 hour</option>
</select>
<select id="subject" name="subject" style="width:90px">
<option value="">- Subject -</option>
<?
include ("mysql_connect.php");
$strSQL = "SELECT * FROM subject_type ORDER BY id_subject ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
while($objResult = mysql_fetch_array($objQuery))
{
?>
<option value="<?=$objResult["id_subject"];?>"><?=$objResult["subject"];?></option>
<?
}
?>
</select>
<br><p>
<input type="submit" name="send" value="send"/>
<input type="reset" name="reset" value="cancel"/><br>
<?
echo '<center><h3><a href="login_employee.php">Home</a><h3></center>';
?>
</center>
</form>
</body>
</html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<?php
session_start ();
if(!isset($_COOKIE["username"]) && !isset($_COOKIE["password"])){
header("location:main.php");
exit();
}
?>
<?php
session_start();
include ("mysql_connect.php");
$daily_report = $_POST["report"];
$period = $_POST["period"];
$subject = $_POST["subject"];
if(empty($daily_report)){
echo "<script>alert('Please input your daily report');window.location = 'add_report.php';</script>";
exit();
}
if(empty($period)){
echo "<script>alert('Please input your period');window.location = 'add_report.php';</script>";
exit();
}
$t = time();
$sql = "INSERT INTO daily_report (id_subject,daily_report,period,date_new) values ('$subject' , '$daily_report' , '$period' , '$t')";
$dbQuery = mysql_query($sql) or die ("SQL ERROR!!");
if($dbQuery){
echo "<center><h3>Save Done</h3></center>";
echo '<center><h3><a href="login_employee.php">Home</a><h3></center>';
}else{
echo "<h3>Error Save</h3>".$sql;
}
?>
</body>
</html>
Tag PHP
Date :
2010-08-05 11:06:15By :
kookziView :
1816Reply :
6
>> อยากหั้ยมันเก็บเป็น id_member คนนี้ เพื่อทีจะ เอาไปบันทึกหน้า daily report จะได้รู้ว่าใคร add เพิ่มคะCode (PHP) $sql = "INSERT INTO daily_report (id_subject,daily_report,period,date_new) values ('$subject' , '$daily_report' , '$period' , '$t')";
อ่านดูน่ะครับ
ประวัติการแก้ไข
Date :
2010-08-05 13:44:43By :
iieszz
check_login.php if($num >=1){
$sessionnickname = $row['nickname'];
setcookie ( "username_admin", $user,time()+120 );
setcookie ( "password_admin", $pass,time()+120 );
setcookie ( "nickname", $$sessionnickname,time()+120 );
echo"<script>alert('ยินดีต้อนรับ $nickname');
window.location = 'admin.php';</script>";
}else if($num1 >=1){
$sessionID = $row1['id_member'];
$sessionnickname = $row1['nickname'];
setcookie ( "id_name", $sessionID,time()+120 );
setcookie ( "username", $user,time()+120 );
setcookie ( "password", $pass,time()+120 );
setcookie ( "nickname", $sessionnickname,time()+120 );
header("location: login_employee.php");
<?php
session_start ();
if(!isset($_COOKIE["id_name"]) && !isset($_COOKIE["username"]) && !isset($_COOKIE["password"]) && !isset($_COOKIE["nickname"])){
header("location:main.php");
exit();
}
include ("mysql_connect.php");
$daily_report = $_POST["report"];
$period = $_POST["period"];
$subject = $_POST["subject"];
$id_name = $_COOKIE["id_name"];
if(empty($daily_report)){
echo "<script>alert('Please input your daily report');window.location = 'add_report.php';</script>";
exit();
}
if(empty($period)){
echo "<script>alert('Please input your period');window.location = 'add_report.php';</script>";
exit();
}
$t = time();
$sql = "INSERT INTO daily_report (id_member,id_subject,daily_report,period,date_new) values ('$id_name' , '$subject' , '$daily_report' , '$period' , '$t')";
$dbQuery = mysql_query($sql) or die ("SQL ERROR!!");
if($dbQuery){
echo "<center><h3>Save Done</h3></center>";
echo '<center><h3><a href="login_employee.php">Home</a><h3></center>';
}else{
echo "<h3>Error Save</h3>".$sql;
}
?>
Date :
2010-08-05 13:51:30By :
kookzi
Date :
2010-08-05 14:35:05By :
iieszz
พี่คะ ยกตัวอย่าง การโชว์ข้อมูลหั้ยดูเปนแนวหน่อยคะ
Date :
2010-08-05 14:42:44By :
kookzi
อยากให้เวลาโชว์ข้อมูลเป็นชื่อแต่เวลาเก็บใน data base อยากให้เก็บเป็ยรหัส รบกวนใครรู้ช่วยตอบทีนะค่ะ
Date :
2010-09-14 11:50:47By :
cs2
ภาษาวิบัท
Date :
2011-03-13 09:28:30By :
kkk
Server 03
Load balance : Server 03
แน่นอนจริงๆ
