|
 |
| |
สอบถามปัญหาคำสั่ง SQL เรื่อง syntax ต้องแก้ไขอย่างไร ช่วยด้วยครับ |
| |
 |
|
|
 |
 |
|
Code (PHP)
<?
include "sessionuser.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<script language="javascript" src="../include/time.js">
</script>
<script language="javascript" src="../include/1.js">
</script>
<script language="Javascript" type="text/javascript" src="tooltip.js"></script>
<script language="Javascript" type="text/javascript" src="ajax.js"></script>
<title>ระบบหนังสือเวียน</title>
<style type="text/css">
/* พื้นที่ tooltip */
#lyrtooltip {
position:absolute;
border:1px solid #FFA500;
background-color: white;
padding:3px;
text-align:left;
}
</style>
<link rel="stylesheet" type="text/css" href="menu_user.css">
<style type="text/css">
<!--
A:link {COLOR: #000000; TEXT-DECORATION: none}
A:visited {COLOR: #000000; TEXT-DECORATION: none}
A:hover {COLOR: red; TEXT-DECORATION: underline}
.style4 {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #FFFFFF;
}
.style12 {
font-size: 13px
}
.style15 {color: #ECE9D8}
.style16 {color: #ECE9D8; font-size: 13px; }
.style24 {
color: #0000FF;
font-size: 14px;
}
-->
</style>
</head>
<body bgcolor="#999999" leftmargin="0" topmargin="0" >
<table width="799" height="822" border="0" align="center" CELLPADDING=0 cellspacing="0" bgcolor="#FFFFFF" > <!-- start table 1 -->
<tr>
<td width="799" height="200" background="../images/head_02.jpg"></td>
</tr>
<tr>
<td width="799" height="26" ><? include "menu_user.php"?></td>
<tr bgcolor="#DBDBDB">
<td width="799" height="413" align="center">
<table width="794" height="412" border="0" cellpadding="0" cellspacing="0"><!-- start table 2 -->
<tr>
<th width="18" bgcolor="#DBDBDB" scope="col"> </th>
<th width="175" align="center" valign="top" bgcolor="#DBDBDB" scope="col">
<table width="175" border="0">
<tr align="left">
<td height="28" colspan="2"> </td>
</tr>
<tr align="left">
<td height="35" colspan="2"><span class="style24">Main Menu</span><br>
<hr></td>
</tr>
<tr>
<td width="34" height="25" align="right"><img src="../images/5_06.GIF" /></td>
<td width="156" align="left"><a href="user_book_in.php">หนังสือเวียนเข้า</a></td>
</tr>
<tr>
<td height="24" align="right"><img src="../images/5_06.GIF" /></td>
<td align="left"> <a href="user_book_out.php">หนังสือเวียนออก</a></td>
</tr>
<tr>
<td height="26" align="right"><img src="../images/5_06.GIF" /></td>
<td align="left"> <a href="user_send.php">ส่งหนังสือเวียน</a></td>
</tr>
<tr>
<td height="26" align="right"><img src="../images/5_06.GIF" /></td>
<td align="left"> <a href="user_search_book.php">ค้นหาหนังสือเวียน</a></td>
</tr>
<tr>
<td height="26" align="right"><img src="../images/5_06.GIF" /></td>
<td align="left"> <a href="user_check_approve.php">ตรวจสอบสถานะ</a></td>
</tr>
<tr>
<td height="46" colspan="2" align="left" valign="top"><p class="style22">.</p> </td>
</tr>
<tr>
<td height="42" colspan="2" align="left" valign="top"><span class="style24">Hello User</span><br>
<hr></td>
</tr>
<tr>
<td height="33" colspan="2" align="center" valign="top">
<?
include "connect.php";
$sql = "select * from user , position where user.user_id='$sess_id' and user.position_id = position.position_id ";
mysql_query("set names tis620");
$result = mysql_query($sql);
$data = mysql_fetch_array($result);
echo "<B> $sess_fname $sess_surname <br><br> $data[position_detail]";
?> </td>
</tr>
<tr>
<td height="135" colspan="2" align="center" valign="middle"><img src="../pic/<?=$data[user_pic]?>" width="100" height="100" border="2" bordercolor="#FFFFFF" /></td>
</tr>
<tr>
<td height="25" colspan="2" align="center" valign="middle"> <a href="../logout.php" class="style23 style12"><font color="#FF0000" >ออกจากระบบ </font> </a></td>
</tr>
<tr>
<td height="25" colspan="2" align="center" valign="middle"> </td>
</tr>
</table> </th>
<th width="23" scope="col"> </th>
<td width="578" align="center" valign="top" bgcolor="#FFFFFF" scope="col">
<br >
<form name="frmMain" action="user_delete_book_in.php" method="post" OnSubmit="return onDelete();">
<table width="542" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="center">
<td colspan="5"> </td>
</tr>
<tr align="center" bgcolor="#0099FF">
<td width="52" height="51" align="center"><span class="style15"></span></td>
<td width="139" bgcolor="#0099FF"><span class="style16">ผู้ส่ง</span></td>
<td width="118" ><span class="style16">เรื่อง</span></td>
<td width="109"><span class="style16">วันที่ส่ง</span></td>
<td width="66"><span class="style16">ไฟล์ลับ</span><span class="style15"></span></td>
</tr>
<?
include "../include/connect.php";
(!isset($_REQUEST[”page”])) ? $page = 1 : $page=$_REQUEST[”page”];
$a = $sess_id;
$sql="select * from send , book , send_detail , user , typebook where send_detail.user_id = $a and send_detail.send_id = send.send_id and send.book_id = book.book_id and send.user_id = user.user_id and book.typebook_id = typebook.typebook_id;";
$result =mysql_query("set names tis620");
$result=mysql_query($sql);
$totalrecord = mysql_num_rows($result);
$pagesize = 15;
$totalpage = (int) ($totalrecord / $pagesize);
if (($totalrecord % $pagesize) != 0) {
$totalpage += 1;
}
if (isset($pageid)) {
$start = $pagesize * ($pageid - 1);
}
else {
$pageid = 1;
$start = 0;
}
$sql="select * from book , send ,send_detail , user , typebook where send_detail.user_id = $a and send_detail.send_id = send.send_id and send.book_id = book.book_id and send.user_id = user.user_id and book.typebook_id = typebook.typebook_id order by send.send_id DESC LIMIT $start, $pagesize;";
$result=mysql_query($sql);
mysql_query("set names tis620");
$i = 0;
while($data=mysql_fetch_array($result)) {
if($i%2 == 0){
?>
<tr bgcolor="#99FFFF">
<?
}else{
?>
<tr bgcolor="#D7FBFB">
<?
}
if ($data[open]==0){
?>
<td height="35" align=center>
<img src="../images/littel.png" width=27 height=23 /></td>
<?
}else{
?>
<td height="35" align=center>
<img src="../images/open.png" width=33 height=23 /></td>
<?
}
?>
<td align=left> <a onmouseover="loadtooltip(this,<?=$data[user_id]?>)" onmouseout="hidetooltip()" onclick="hidetooltip()" ><?=$data[user_fname].' '.$data[user_surname] ?></a></td>
<td align=left><A HREF="user_show_book_in.php?send_id=<?=$data[send_id]?>"><font color="#CC0000" ><?=$data[subject] ?> </font></A> </td>
<td align="left"> <?=$data[send_date] ?></td>
<?
$name_book=$data[book_name];
?>
<td width="58" align="left">
<?
if($data[vision]==1){
echo "มีไฟล์ลับ";
}
?></td>
<?
$i++;
}
?>
<tr >
<td width="52" align="center"> </td>
<td width="139" align="left"></td>
<td width="118" align="left" ></td>
<td width="109" align="left"></td>
<td width="66" align="left"></td>
</tr>
<tr >
<td width="52" align="center"> </td>
<td width="139" align="left"></td>
<td width="118" align="left" ></td>
<td width="109" align="left"> </td>
<td width="66" align="left"><?
echo "หน้าที่ ";
for ($i=1; $i<=$totalpage; $i++) {
if ($i == $pageid) {
echo $i . " ";
}
else {
echo "[<a href=\"user_book_in.php?pageid=$i\">$i</a>] ";
}
}
?></td>
</tr>
</table>
</form>
<!-- END table 3 -->
<br >
<!-- END fieldset 3 -->
<br ><br > </td>
</tr>
</table><!-- END table 2 --> </tr>
<tr>
<td width="799" height="100" background="../images/head_05.jpg" >
<div align="right">
<p> </p>
<? include "footer.php"?>
</div> </td>
</tr>
</table>
</body>
</html>
Tag : PHP, MySQL, HTML/CSS, JavaScript, Ajax, jQuery
|
|
|
 |
 |
 |
 |
| Date :
2016-05-08 18:29:49 |
By :
settachai |
View :
909 |
Reply :
9 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
คาดว่า $a ไม่มีค่าอะไรเลย กำหนดค่าไว้ยังไงครับ
|
| |
|
|
| |
| Date :
2016-05-08 19:25:41 |
By :
Chaidhanan |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ก็ต้องไล่ต่อไปอีกว่า $sess_id เอามาจากไหน กำหนดค่าตอนไหนครับ ค่อยๆ ไล่ไปที่ละเสต็ป เด๊่ยวก็เจอว่า ค่ามันหายไปตอนไหน หรือควรจะกำหนดค่าตอนไหน
|
| |
|
|
| |
| Date :
2016-05-08 21:44:21 |
By :
Chaidhanan |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ถูกไหมครับ
|
| |
|
|
| |
| Date :
2016-05-09 00:09:19 |
By :
settachai |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ลอง print_r( $_SESSION) ออกมาดูครับว่ามีค่าไหม
ถ้ามี เวลาเรียกใช้ ก็ใช้การอ้างอิงเต็มรูป อย่าหวังพี่งตัวแปรชนิด global แปลงค่าเป็นตัวแปรธรรมดา
เพราะแต่ละ server ไม่ได้กำหนด สภาพแวดล้อมแบบเดียวกัน
Code (PHP)
$a=$sess_id;
//แก้เป็น
$a = $_SESSION['sess_id'];
|
| |
|
|
| |
| Date :
2016-05-09 06:43:14 |
By :
Chaidhanan |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
path รูปไม่ถูกต้องครับ ลองกดดูว่าถูกหรือเปล่า?
|
| |
|
|
| |
| Date :
2016-05-10 11:27:34 |
By :
ALTELMA |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ได้ล่ะครับขอบคุณครับ
|
| |
|
|
| |
| Date :
2016-05-10 11:40:54 |
By :
settachai |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 05
|
