 |
|
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in D:\AppServ\www\ROY\show_applicant.php on line 77
หมายความว่าอย่างไรค่ะ
<?
include("dbconnect.php");
// ไม่มี mysql_fetch_assoc(ตัวแปร); เพราะไม่ต้องการให้แสดงข้อมูล
if($delete==1)
{ // ส่งค่าตัวแปร/คำสั่งไปกับ url
$sql_deldata_applicant = "delete FROM applicant where ID='$ID' ";
$query_del_applicant = odbc_exec($sql_deldata_applicant, $connect_db) or die(mysql_error()); // ส่งคำสั่งไปในฐานข้อมูล
//@unlink($pic_del); // เป็นการลบรูป @ ถ้าไม่มีรูปจะได้ไม่ Error
echo "<script type=text/javascript>"; // เป็นการสร้างข้อความแจ้งเตือน
echo "alert('DELETE DONE ')"; /// ส่งข้อมูลไปยังฐานข้อมูล และแสดงข้อความแจ้ง
echo "</script>";
}
?>
<form id="form1" name="form1" method="post" action="show_applicants.php">
<table width="2246" height="113" border="1">
<tr>
<td colspan="14" background="BG/9.jpg"><h5 align="center" class="style5"> APPLICANTS FORM</h5></td>
</tr>
<tr>
<td width="115"><h5 align="center" class="style5">ID</h5></td>
<td width="161"><h5 align="center" class="style5">Titlename </h5></td>
<td width="161"><h5 align="center" class="style5">Firstname </h5></td>
<td width="161"><h5 align="center" class="style5">Lastname</h5></td>
<td width="161"><h5 align="center" class="style5">Birth</h5></td>
<td width="161"><h5 align="center" class="style5">Address</h5></td>
<td width="161"><h5 align="center" class="style5">E-mail</h5></td>
<td width="161"><h5 align="center" class="style5">ID Card</h5></td>
<td width="161"><h5 align="center" class="style5">Telephone</h5></td>
<td width="161"><h5 align="center" class="style5">username </h5></td>
<td width="184"><h5 align="center" class="style5">Course name </h5></td>
<td width="123"><h5 align="center" class="style5">Edit</h5></td>
<td width="178"><h5 align="center" class="style5">Delete</h5></td>
</tr>
<?php
$sql_applicant = " select
`applicant`.`ID` AS `ID`,
`applicant`.`titlename` AS `titlename`,
`applicant`.`firstname` AS `firstname`,
`applicant`.`lastname` AS `lastname`,
`applicant`.`birth` AS `birth`,
`applicant`.`address` AS `address`,
`applicant`.`email` AS `email`,
`applicant`.`IDcard` AS `IDcard`,
`applicant`.`phone` AS `phone`,
`applicant`.`username` AS `username`,
`course`.`coursename` AS `coursename`
from
(`course` join `applicant` on((`course`.`courseID` = `applicant`.`courseID`))) ";
$query_applicant = odbc_exec($sql_applicant, $connect_db) or die(mysql_error());
$row_applicant = odbc_fetch_row($query_applicant );
$Num_Rows = odbc_num_fields($query_applicant);
while ($row_applicant = odbc_fetch_row($query_applicant));
{
?>
<tr>
<td><div align="center"><? print $row_applicant[ID]; ?> </div></td>
<td><div align="center"><? print $row_applicant[titlename]; ?> </div></td>
<td><div align="center"><? print $row_applicant[firstname]; ?> </div></td>
<td><div align="center"><? print $row_applicant[lastname]; ?> </div></td>
<td><div align="center"><? print $row_applicant[birth]; ?> </div></td>
<td><div align="center"><? print $row_applicant[address]; ?> </div></td>
<td><div align="center"><? print $row_applicant[email];?></div></td>
<td><div align="center"><? print $row_applicant[IDcard]; ?> </div></td>
<td><div align="center"><? print $row_applicant[phone]; ?> </div></td>
<td><div align="center"><? print $row_applicant[username]; ?> </div></td>
<td><div align="center"><? print $row_applicant[coursename]; ?></div></td>
<td><div align="center"><a href="edit_applicants.php?ID=<? print $row_applicant[ID];?>"> Edit</a></div></td>
<td><div align="center">
<a href="show_applicant.php?delete=1&ID=<? print $row_applicant[ID]; ?>">Delete</a></div></td>
</tr>
<?
}
?>
</table>
</form>
</body>
</html>
|
 |
 |
 |
 |
| Date :
2009-08-22 01:42:15 |
By :
sa |
|
 |
 |
 |
 |
|
|
 |
Quote:
