 |
|
|
 |
 |
|
Code (PHP)
<?
session_start();
mysql_connect("localhost","root","root");
mysql_select_db("mydatabase");
$strSQL = "SELECT * FROM member WHERE Username = '".mysql_real_escape_string($_POST['txtUsername'])."'
and Password = '".mysql_real_escape_string($_POST['txtPassword'])."'";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
if(!$objResult)
{
echo "Username and Password Incorrect!";
}
else
{
$_SESSION["UserID"] = $objResult["UserID"];
$_SESSION["Status"] = $objResult["Status"];
session_write_close();
if($objResult["Status"] == "ADMIN")
{
header("location:admin_page.php");
}
else
{
header("location:user_page.php");
}
}
mysql_close();
?>
ดูเป็นตัวอย่างคับ https://www.thaicreate.com/community/php-mysql-login-form-check-username-password.html
อยากให้ไปหน้าขึ้นอยุ่กับสถานะที่ตั้งคับในดาต้าเบสเช่น User จะวิ่งไปหน้า user_page.php ถ้า Admin ก็จะวิ่งไปหน้า admin_page.php
|
ประวัติการแก้ไข
2014-06-06 08:41:04
 |
 |
 |
 |
| Date :
2014-06-06 08:40:05 |
By :
woraman |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ก็ query index ของแต่ละ user มาใส่หลังลิงค์ที่ให้กดไงครับ 
กดแต่ละลิงค์ก็เป็นคนละ index
เอา index ไป query ข้อมูล user
|
| |
|
|
| |
| Date :
2014-06-06 11:49:36 |
By :
progamer2000 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
แปะ code ที่เขียนมาหน่อยจิครับ
|
| |
|
|
| |
| Date :
2014-06-06 13:12:52 |
By :
progamer2000 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
<?php
#### สคริ๊ปนี้ใช้ในการเช็ค ว่าล็อกอินหรือยัง ให้นำสคริ๊ปนี้ไปไว้ที่หน้าที่คุณต้องการให้เช็ค ####
session_start() ;
if (!isset($_SESSION['login_true'])) {
header("Location: index.php");
exit;
}
### จบการเช็ค ###
?>
<?php
include("config.inc.php") ;
mysql_select_db($db) ;
## Please Don't delete it. It will Error. You can tell me about bug of program this way ##
$echo = "Program by <a href='http://www.funwhan.com' target='_blank'>Ittiphol pudgrajang</a>
copy right©2003 <a href='mailto:[email protected]'>Contact us</a>" ;
$result = mysql_query("select * from member where user='$_SESSION[login_true]'") or die ("Err Can not to result") ;
$dbarr = mysql_fetch_array($result) ;
?>
<head>
<meta http-equiv='refresh' content='1500; url=post.php'>
<meta http-equiv="content-type" charset="windows-874">
<link rel="stylesheet" type="text/css" href="../css/table_style.css">
<link rel="stylesheet" type="text/css" href="../css/style.css">
<link rel="stylesheet" type="text/css" href="../css/player.css">
</head>
<?php
include("config.inc.php") ;
mysql_select_db($db) ;
$strSQL = "SELECT * FROM webboard order by QuestionID desc ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);
{
$Num_Pages =1;
}
?>
<!doctype html>
<html>
<head>
<link rel="stylesheet" type="text/css" href="../css/table_style.css">
<link rel="stylesheet" type="text/css" href="../css/style.css">
</head>
<body>
<table align="center" border="0">
<tr>
<td align="center" valign="top" width="700">
<div class="wrap">
<div class="comment-block">
<!--แถวบน-->
<table width="730" align="center">
<?
while($objResult = mysql_fetch_array($objQuery))
{
?>
<tr>
<td valign="middle">
<a href="Profile.php?user=<?=$objResult["user"];?> " target="_blank"><img class="circle1" src="<?=$objResult["Profile_pic"];?>" ></a> <span class="span"> <?=$objResult["Name"];?><a href=""> ## </a><?=$objResult["Dip1"];?> <a href=""> ## </a><?=$objResult["Question"];?> </span><br><br>
<br>
<table width="680" align="center">
<tr>
<td class="wrap3"><?=$objResult["Details"];?></td>
</tr>
</table>
<br>
<br>
<!--รูปภาพ-->
<img class="circle3" src="<?=$objResult["Icon"];?>"><br><br><br>
<!--รูปภาพ-->
<!--วันเวลา-->
<table width="730" align="center">
<tr>
<td width="230"align="left"><span class="span2">เมื่อเวลา:<?=$objResult["CreateDate"];?></span></td>
<td align="center" height="30"> <strong><span class="wrap2"><a href="comment.php?QuestionID=<?=$objResult["QuestionID"];?>" target="_blank"><img src="../img/comment.png"></a></span></strong> <strong><span class="wrap2"><a href="<?=$objResult["Link"];?>" target="_blank"><img src="../img/Promote.png"></a></span></strong></td>
</tr>
</table>
<hr class="hr">
<!--วันเวลา-->
<?
}
?>
</td>
</tr>
</table>
<!--แถวบน-->
</td>
</tr></table>
<!-- End Template Left -->
</body>
</html>
ตรงจุดที่ผมพิมแดง ไว้นนะครับ ผมต้องการ คลิกที่ ลิ้ง แล้ว กับไป หน้า Profile
|
| |
|
|
| |
| Date :
2014-06-06 14:01:21 |
By :
Thanet |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขอบคุณที่แนะนำผมนะครับ ทุกความเห็น ของทุกท่านผมจะนำเอาไปพัฒนา ตัวเองครับ ขอบคุณจริงๆ
|
| |
|
|
| |
| Date :
2014-06-06 14:03:01 |
By :
Thanet |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
แล้ว Profile.php รับค่ายังไงครับ สั่ง query ยังไง
|
| |
|
|
| |
| Date :
2014-06-06 14:03:23 |
By :
progamer2000 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
<?php
#### สคริ๊ปนี้ใช้ในการเช็ค ว่าล็อกอินหรือยัง ให้นำสคริ๊ปนี้ไปไว้ที่หน้าที่คุณต้องการให้เช็ค ####
session_start() ;
if (!isset($_SESSION['login_true'])) {
header("Location: index.php");
exit;
}
### จบการเช็ค ###
?>
<!doctype html>
<html>
<head>
<meta http-equiv="content-type" charset="windows-874">
<link rel="stylesheet" type="text/css" href="../css/table_style.css">
<link rel="stylesheet" type="text/css" href="../css/style.css">
<link rel="stylesheet" type="text/css" href="../css/player.css">
<style type="text/css">
.top-commenter-line {margin: 3px 0;}
.top-commenter-line .profile-name-link {padding-left:0;}
.top-commenter-avatar {vertical-align:middle;}
</style>
<script type="text/javascript">
//
// Top Commentators gadget with avatars, by MS-potilas 2012.
// Gets a list of top commentators from all comments, or specified number of days in the past.
// See http://yabtb.blogspot.com/2012/05/top-commenters-gadget-with-avatars.html
//
// CONFIG:
var maxTopCommenters = 5; // how big a list of top commentators
var minComments = 1; // how many comments must top commentator have at least
var numDays = 0; // from how many days (ex. 30), or 0 from "all the time"
var excludeMe = true; // true: exclude my own comments
var excludeUsers = ["Anonymous", "someotherusertoexclude"]; // exclude these usernames
var maxUserNameLength = 42; // 0: don't cut, >4: cut usernames
//
var txtTopLine = '<b>[#].</b> [image] [user] ([count])';
var txtNoTopCommenters = 'No top commentators at this time.';
var txtAnonymous = ''; // empty, or Anonymous user name localized if you want to localize
//
var sizeAvatar = 16;
var cropAvatar = true;
//
var urlNoAvatar = "http://lh4.googleusercontent.com/-069mnq7DV_g/TvgRrBI_JaI/AAAAAAAAAic/Iot55vywnYw/s"+sizeAvatar+"/avatar_blue_m_96.png"; // http://www.blogger.com/img/avatar_blue_m_96.png resizeable
var urlAnoAvatar = 'http://www.gravatar.com/avatar/00000000000000000000000000000000?d=mm&s=' + sizeAvatar;
var urlMyProfile = ''; // set if you have no profile gadget on page
var urlMyAvatar = ''; // can be empty (then it is fetched) or url to image
// config end
// for old IEs & IE modes:
if(!Array.indexOf) {
Array.prototype.indexOf=function(obj) {
for(var i=0;i<this.length;i++) if(this[i]==obj) return i;
return -1;
}}
function replaceTopCmtVars(text, item, position)
{
if(!item || !item.author) return text;
var author = item.author;
var authorUri = "";
if(author.uri && author.uri.$t != "")
authorUri = author.uri.$t;
var avaimg = urlAnoAvatar;
var bloggerprofile = "http://www.blogger.com/profile/";
if(author.gd$image && author.gd$image.src && authorUri.substr(0,bloggerprofile.length) == bloggerprofile)
avaimg = author.gd$image.src;
else {
var parseurl = document.createElement('a');
if(authorUri != "") {
parseurl.href = authorUri;
avaimg = 'http://www.google.com/s2/favicons?domain=' + parseurl.hostname;
}
}
if(urlMyProfile != "" && authorUri == urlMyProfile && urlMyAvatar != "")
avaimg = urlMyAvatar;
if(avaimg == "http://img2.blogblog.com/img/b16-rounded.gif" && urlNoAvatar != "")
avaimg = urlNoAvatar;
var newsize="s"+sizeAvatar;
avaimg = avaimg.replace(/\/s\d\d+-c\//, "/"+newsize+"-c/");
if(cropAvatar) newsize+="-c";
avaimg = avaimg.replace(/\/s\d\d+(-c){0,1}\//, "/"+newsize+"/");
var authorName = author.name.$t;
if(authorName == 'Anonymous' && txtAnonymous != '' && avaimg == urlAnoAvatar)
authorName = txtAnonymous;
var imgcode = '<img class="top-commenter-avatar" height="'+sizeAvatar+'" width="'+sizeAvatar+'" title="'+authorName+'" src="'+avaimg+'" />';
if(authorUri!="") imgcode = '<a href="'+authorUri+'">'+imgcode+'</a>';
if(maxUserNameLength > 3 && authorName.length > maxUserNameLength)
authorName = authorName.substr(0, maxUserNameLength-3) + "...";
var authorcode = authorName;
if(authorUri!="") authorcode = '<a class="profile-name-link" href="'+authorUri+'">'+authorcode+'</a>';
text = text.replace('[user]', authorcode);
text = text.replace('[image]', imgcode);
text = text.replace('[#]', position);
text = text.replace('[count]', item.count);
return text;
}
var topcommenters = {};
var ndxbase = 1;
function showTopCommenters(json) {
var one_day=1000*60*60*24;
var today = new Date();
if(urlMyProfile == "") {
var elements = document.getElementsByTagName("*");
var expr = /(^| )profile-link( |$)/;
for(var i=0 ; i<elements.length ; i++)
if(expr.test(elements[i].className)) {
urlMyProfile = elements[i].href;
break;
}
}
if(json && json.feed && json.feed.entry && json.feed.entry.length) for(var i = 0 ; i < json.feed.entry.length ; i++ ) {
var entry = json.feed.entry[i];
if(numDays > 0) {
var datePart = entry.published.$t.match(/\d+/g); // assume ISO 8601
var cmtDate = new Date(datePart[0],datePart[1]-1,datePart[2],datePart[3],datePart[4],datePart[5]);
//Calculate difference btw the two dates, and convert to days
var days = Math.ceil((today.getTime()-cmtDate.getTime())/(one_day));
if(days > numDays) break;
}
var authorUri = "";
if(entry.author[0].uri && entry.author[0].uri.$t != "")
authorUri = entry.author[0].uri.$t;
if(excludeMe && authorUri != "" && authorUri == urlMyProfile)
continue;
var authorName = entry.author[0].name.$t;
if(excludeUsers.indexOf(authorName) != -1)
continue;
var hash=entry.author[0].name.$t + "-" + authorUri;
if(topcommenters[hash])
topcommenters[hash].count++;
else {
var commenter = new Object();
commenter.author = entry.author[0];
commenter.count = 1;
topcommenters[hash] = commenter;
}
}
if(json && json.feed && json.feed.entry && json.feed.entry.length && json.feed.entry.length == 200) {
ndxbase += 200;
document.write('<script type="text/javascript" src="http://'+window.location.hostname+'/feeds/comments/default?redirect=false&max-results=200&start-index='+ndxbase+'&alt=json-in-script&callback=showTopCommenters"></'+'script>');
return;
}
// convert object to array of tuples
var tuplear = [];
for(var key in topcommenters) tuplear.push([key, topcommenters[key]]);
tuplear.sort(function(a, b) {
if(b[1].count-a[1].count)
return b[1].count-a[1].count;
return (a[1].author.name.$t.toLowerCase() < b[1].author.name.$t.toLowerCase()) ? -1 : 1;
});
// list top topcommenters:
var realcount = 0;
for(var i = 0; i < maxTopCommenters && i < tuplear.length ; i++) {
var item = tuplear[i][1];
if(item.count < minComments)
break;
document.write('<di'+'v class="top-commenter-line">');
document.write(replaceTopCmtVars(txtTopLine, item, realcount+1));
document.write('</d'+'iv>');
realcount++;
}
if(!realcount)
document.write(txtNoTopCommenters);
}
document.write('<script type="text/javascript" src="http://'+window.location.hostname+'/feeds/comments/default?redirect=false&max-results=200&alt=json-in-script&callback=showTopCommenters"></'+'script>');
</script>
<meta charset="utf-8">
<title><?php echo $dbarr['name'] ; ?></title>
<script type="text/javascript">
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>
<?php
include("config.inc.php") ;
mysql_select_db($db) ;
## Please Don't delete it. It will Error. You can tell me about bug of program this way ##
$echo = "Program by <a href='http://www.funwhan.com' target='_blank'>Ittiphol pudgrajang</a>
copy right©2003 <a href='mailto:[email protected]'>Contact us</a>" ;
$result = mysql_query("select * from member where user='$_SESSION[login_true]'") or die ("Err Can not to result") ;
$dbarr = mysql_fetch_array($result) ;
?>
</head>
<body>
<table class="menu" width="100%" align="center">
<tr>
<td align="left" width="20%" class="style10">  สวัสดีคุณ: <?php echo $dbarr['name'] ; ?> </td>
<td width="60%" align="center" class="style2">ฟังเพลงออนไลน์ <a href="Post_wall.php">โพสต์</a> ดูการ์ตูนออนไลน์ ดูหนังออนไลน์ ตลาดออนไลน์ ผู้สนับสนุน</td>
<td width="20%" align="center" class="style2">
<a href="logout.php">ออกจากระบบ</a> <a href="edit_profile.php">ตกแต่ง</a>
</td>
</tr>
</table>
<table width="100%" align="center" >
<tr>
<!-- รูปโปรไฟล์-->
<td height="256" align="left" valign="top">
<table class="tableProfile1" background="<?php echo $dbarr['pbanner'] ; ?>" align="left">
<tr>
<td align="left">
<img class="circle" src="<?php echo $dbarr['img'] ; ?>">
</td>
</tr>
</table>
<!-- รูปโปรไฟล์-->
<!-- Template ads -->
<!-- Template ads -->
<!-- Template right -->
<td class="tableProfile2" align="center" valign="middle">
<iframe id="youtube" width="400" height="250" src="http://www.youtube.com/embed/<?php echo $dbarr['youtube'] ; ?>?rel=0&autoplay=1" frameborder="0" allowfullscreen></iframe>
</td>
</tr>
</table>
<!-- End Template Left -->
<table>
<tr>
<td valign="top">
<div id="tableProfile4-1" align="center">
<iframe width="300" height="1103" src="about_me.php"align="middle" scrolling="no"\ frameborder="0"></iframe>
</div>
</td>
<td bgcolor="#FFFFFF" align="center" valign="top">
<div id="tableProfile4-2">
<iframe longdesc="" frameborder="0" width="740" height="1100" src="Post.php" >
</iframe>
</div>
</td>
<td id="tableProfile4-4" align="center"valign="top">
<a href=" <?php echo "$dbarr[LINK_FB]"; ?>" target="_blank"><img src="../img/Facebook_logo.png"></a><br>
<br>
<font face="tahoma" color="#00FF00" size="+2"> LINE ID : <?php echo $dbarr['LINE_ID'] ; ?></font>
<iframe width="300" height="960" frameborder="0" align="middle" src="chatbox.php"></iframe>
</td >
</tr>
</table>
</body>
</html>
นี่คือหน้า Profile.php ครับ
|
| |
|
|
| |
| Date :
2014-06-06 14:19:59 |
By :
Thanet |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
คิดว่าน่าจะตรงนี้นะ
เราก็ต้องรับค่า $_GET ที่ส่งมาก่อน
Code (PHP)
$user = $_GET['user'];
จากนั้นก็เอาค่า $user ไป Query
Code (PHP)
<?php
include("config.inc.php") ;
mysql_select_db($db) ;
$result = mysql_query("select * from member where user='$user'") or die ("Err Can not to result") ;
$dbarr = mysql_fetch_array($result) ;
?>
|
| |
|
|
| |
| Date :
2014-06-06 14:26:40 |
By :
arm8957 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ถ้าผมศึกษาตามหัวข้อในลิ้งนี้ จะตอบโจทย์ผมได้มั้ยครับ
http://html.net/tutorials/php/lesson20.php
|
| |
|
|
| |
| Date :
2014-06-06 14:27:03 |
By :
Thanet Boonlert |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
เดียวผมลองดูครับ
|
| |
|
|
| |
| Date :
2014-06-06 14:29:10 |
By :
Thanet Boonlert |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
นายA ขึ้นเครื่องจากกรุงเทพ ไป นิวยอร์ก เที่ยวบิน a href แต่ปรากฏว่านายA กลับมาโผล่ที่กรุงเทพเหมือนเดิม
เป็นไปได้ว่า สายการบินมีปัญหา a href มีปัญหาในการระบุปลายทาง
|
| |
|
|
| |
| Date :
2014-06-06 15:14:46 |
By :
meannerss |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
Load balance : Server 00
