|
 |
| |
สอบถามปัญหา Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource |
| |
 |
|
|
 |
 |
|
index.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="#ccffff">
<td width="799" height="413" align="center">
<table width="794" height="412" border="0" cellpadding="0" cellspacing="0"><!-- start table 2 -->
<tr>
<th width="10" bgcolor="#ccffff" scope="col"> </th>
<th width="175" align="center" valign="top" bgcolor="#ccffff" 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 "../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="10" scope="col" bgcolor="#00FFFF"> </th>
<td width="599" align="center" valign="top" bgcolor="#CCFFFF" 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 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;";
$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>
<p align="center"><span class="style6"><font color="#FFFFFF">
<BR>
<BR>
<BR><a href="http://www.neu.ac.th/home.php">
<font color="#FF0000" face="Times New Roman, Times, serif"> http://www.neu.ac.th/home.php </font>
</a></span></p> </td>
</tr>
</table>
</body>
</html>
Tag : PHP, MySQL, jQuery, CakePHP, Windows
|
ประวัติการแก้ไข
2016-05-03 14:27:56
2016-05-03 14:28:36
|
 |
 |
 |
 |
| Date :
2016-05-03 14:26:25 |
By :
settachai |
View :
768 |
Reply :
11 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
MySQL Error จากบรรทัดที่ 148 ไม่สามารถ query ได้ลองเอา SQL ไปรันดูว่าได้ข้อมูล หรือมี error อะไรหรือเปล่า?
|
| |
|
|
| |
| Date :
2016-05-03 14:39:39 |
By :
ALTELMA |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
สอบถามนิดหนึงครับ ไปเอาโปรเจ็คใครมาหรือเปล่าครับ?
ข้อมูลเพียบครับ ลองศึกษาเพิ่มเติมได้ที่นี่ครับ
|
ประวัติการแก้ไข
2016-05-03 16:57:20
2016-05-03 16:58:26
| |
|
|
| |
| Date :
2016-05-03 16:56:47 |
By :
ALTELMA |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
แก้ไขไฟล์ connect.php ครับ ลองดูตามลิงค์ที่ให้ไป
|
| |
|
|
| |
| Date :
2016-05-03 21:42:09 |
By :
ALTELMA |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ลองดูครับ file connect database ตอน include เข้ามาใช้
Code (PHP)
<?
function condb()
{
$con = mysql_connect("localhost","root","rhtd1234");
{
if(!$con)
{
die("! Cannot connect db because ".mysql_error());
}
mysql_select_db('ชื่อ data base',$con); //เลือก data base
mysql_query("SET NAMES UTF8",$con);
return $con;
}
}
?>
|
| |
|
|
| |
| Date :
2016-05-04 11:16:33 |
By :
_/\_ |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 03
|
