ติดปันหา show db แล้ว error ช่วยดูหั้ยทีคับ + มันไม่โชว์หัวข้อคับ
Code (PHP) <?php
include 'mysql_connect.php';
$member = $_COOKIE['id_name'];
//echo $member;
$strSQL = "select daily_report.id_daily_report,member.nickname,department.department,subject_type.subject,daily_report.daily_report,daily_report.period,daily_report.date_new
from member,subject_type,daily_report,department
where member.id_member = daily_report.id_member
and subject_type.id_subject = daily_report.id_subject
and department.id_department = member.id_department
and member.id_member = '$member' ORDER BY id_daily_report ASC";
$objQuery = mysql_query($strSQL);
if (!$objQuery) {
echo("เอ็กซิคิวต์คำสั่ง SQL ไม่ได้ " . mysql_error() );
exit();
}
?>
<form name="frmMain" method="post" action="<?=$_SERVER["PHP_SELF"];?>">
<p>
<input type="hidden" name="hdnCmd" value="">
</p>
<p><table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="5" bgcolor="#61A500"><div align="right"><a href="logout.php">Logout</a></div></td>
</tr>
<tr>
<td colspan="5" bgcolor="#61A500"><p align="right" class="style1"> </p> </td>
</tr>
<tr>
<td>
<div class="green">
<div id="slatenav">
<ul>
<li><a href="login_employee.php" target="_blank" title="css menus" > Home </a></li>
<li><a href="edit.php" title="css menus" class="current">Manage content </a></li>
</ul>
</div>
</div></td>
</tr>
<tr>
<td colspan="5"><p align="right"><br>
<table width="500" border="1" align="center" cellpadding="5" cellspacing="0" id="tblfix">
<tr class="tr1">
<td width="10"><center>ID</center></td>
<td width="30"><center>nickname</center></td>
<td width="30"><center>subject</center></td>
<td width="30"><center>department</center></td>
<td width="300"><center>Daily report</center></td>
<td width="30"><center>period</center></td>
<td width="30"><center>date</center></td>
</tr>
<?
$showno = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$showno++;
$sessiondate_new = $objResult['date_new'];
//echo $sessiondate_new.'<br>';
?>
<tr>
<td><center><?=$showno?></center></td>
<td><?=$objResult["nickname"];?></td>
<td><?=$objResult["subject"];?></td>
<td><?=$objResult["department"];?></td>
<td><?=$objResult["daily_report"];?></td>
<td><?=$objResult["period"];?></td>
<td><?=$objResult["echo date('Y-m-d',strtotime($sessiondate_new))"];?></td>
</tr>
<?
}
?>
</table>
</tr>
</table>
</form>
Tag PHP, MySQL
Date :
2010-08-09 12:02:53By :
roof-ziiView :
900Reply :
7
Code <td><?=$objResult["echo date('Y-m-d',strtotime($sessiondate_new))"];?></td>
Code <td><?=date('Y-m-d',strtotime($objResult['date_new']));?></td>
Date :
2010-08-09 12:16:42By :
webmaster
Date :
2010-08-09 12:21:38By :
roof-zii
งงคับ echo ออกมาไม่ตรงกะ db ด้วยอะคับ - - "
Date :
2010-08-09 12:31:00By :
roof-zii
ทำได้แล้วคับ
Date :
2010-08-09 14:53:35By :
roof-zii
Code (PHP) <?php
include 'session_login_admin.php';
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<?php
include 'mysql_connect.php';
$strSQL = "select daily_report.id_daily_report,member.nickname,department.department,subject_type.subject,daily_report.daily_report,daily_report.period,daily_report.date_new
from member,subject_type,daily_report,department
where member.id_member = daily_report.id_member
and subject_type.id_subject = daily_report.id_subject
and department.id_department = member.id_department
ORDER BY id_daily_report ASC";
$objQuery = mysql_query($strSQL);
if (!$objQuery) {
echo("เอ็กซิคิวต์คำสั่ง SQL ไม่ได้ " . mysql_error() );
exit();
}
?>
<form name="frmMain" method="post" action="<?=$_SERVER["PHP_SELF"];?>">
<p>
<input type="hidden" name="hdnCmd" value="">
</p>
<p><table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="5" bgcolor="#708090"><div align="right"><a href="logout.php" title="ออกจากระบบ">Logout</a></div></td>
</tr>
<tr>
<td colspan="5" bgcolor="#708090"><p align="right" class="style1"> </p> </td>
</tr>
<tr>
<td>
<div class="#b8860b">
<div id="slatenav">
<ul>
<li><a href="login_employee.php" title="หน้าแรก"> Home </a></li>
<li><a href="register.php" title="สมัครสมาชิก" class="current"> Add register </a></li>
<li><a href="add_department.php" title="เพิ่มแผนก"> Add department </a></li>
<br>
<select id="depart" name="department" style="width:110px">
<option value="">- department -</option>
<?
include ("mysql_connect.php");
$strSQL1 = "SELECT * FROM department ORDER BY id_department ASC ";
$objQuery1 = mysql_query($strSQL1) or die ("Error Query [".$strSQL1."]");
while($objResult1 = mysql_fetch_array($objQuery1))
{
?>
<option value="<?=$objResult1["id_department"];?>"><?=$objResult1["department"];?></option>
<?
}
?>
</select>
<input type="submit" name="send" value="submit"/>
</ul>
</div>
</div></td>
</tr>
<tr>
<td colspan="5"><p align="right"><br></p>
<table width="1000" border="1" align="center" cellpadding="5" cellspacing="0" id="tblfix">
<tr class="tr1">
<td width="10"><center>ลำดับ</center></td>
<td width="50"><center>ชื่อเล่น</center></td>
<td width="80"><center>หัวข้องาน</center></td>
<td width="120"><center>แผนก</center></td>
<td width="500"><center>บันทึกประจำวัน</center></td>
<td width="50"><center>ระยะเวลา</center></td>
<td width="80"><center>วัน/เดือน/ปี</center></td>
</tr>
<?
$showno = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$showno++;
$sessiondate_new = $objResult['date_new'];
//echo $sessiondate_new.'<br>';
//echo date('d-F-Y',($objResult['date_new'])).'<br>';
//echo date('d-F-Y',strtotime($objResult['date_new']));
?>
<tr>
<td><center><?=$showno?></center></td>
<td><center><?=$objResult["nickname"];?></center></td>
<td><center><?=$objResult["subject"];?></center></td>
<td><center><?=$objResult["department"];?></center></td>
<td><?=$objResult["daily_report"];?></td>
<td><center><?=$objResult["period"];?></center></td>
<td><center><?=date('d-F-Y',($objResult['date_new']));?></center></td>
</tr>
<?
}
?>
</table>
</tr>
</table>
</form>
</body>
</html>
Date :
2010-08-09 16:09:41By :
roof-zii
select daily_report.id_daily_report,member.nickname,subject_type.subject,department.department,daily_report.daily_report,daily_report.period,daily_report.date_new
Date :
2010-08-09 17:21:15By :
roof-zii
รบกวนทีจ้า เช็คไม่ถูกว่าจะอยู่ตรงไหนครับผม
Date :
2010-08-10 11:05:36By :
roof-zii
Server 04
Load balance : Server 04
