้เขียนคำสั่ง Delete ข้อมูลในฐาน แล้ว ไม่ยอมหายไปครับ ไม่รู้ errorr ตรงไหน รบกวนช่วยดูทีครับ
Code (PHP) <?php
session_start();
?>
<html>
<head>
<script>
function confirmDelete(delUrl) {
if (confirm("คุณต้องการลบไฟล์ใช่หรือไม่")) {
document.location = delUrl;
}
}
</script>
</head>
<center>
<form name="frmSearch" method="get" action="list_files.php">
<table width="599" border="0">
<tr>
<th>Keyword
<input name="txtKeyword" type="text" id="txtKeyword">
<input type="submit" value="Search"></th>
</tr>
</table>
</form>
<br>
<br>
</center>
<?php
// Connect to the database
$dbLink = new mysqli('localhost', 'it55660293', 'xgabpyz1626', 'it55660293');
if(mysqli_connect_errno()) {
die("MySQL connection failed: ". mysqli_connect_error());
}
// Query for a list of all existing files
$sql = "SELECT `id`, `name`, `mime`, `size`, `created`,`count` FROM `file` WHERE UserID = '$_SESSION[UserID]'";
$result = $dbLink->query($sql);
// Check if it was successfull
if($result) {
if($_GET["txtKeyword"] != "")
{
$objConnect = mysql_connect("localhost","it55660293","xgabpyz1626") or die("Error Connect to Database");
$objDB = mysql_select_db("it55660293");
// Search By Name or Email
$strSQL = "SELECT * FROM file WHERE (name LIKE '%".$_GET["txtKeyword"]."%' and UserID = '$_SESSION[UserID]')";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
echo '<table width="80%" align="center">
<tr>
<td><b>Name</b></td>
<td><b>Mime</b></td>
<td><b>Size (bytes)</b></td>
<td><b>Created</b></td>
<td><b> </b></td>
<td><b>Sum Download</b></td>
<td><b>Delete File</b></td>
</tr>';
// Print each file
while($row = mysql_fetch_array($objQuery)) {
echo "
<tr>
<td align='center'>{$row['id']}</td>
<td>{$row['name']}</td>
<td>{$row['mime']}</td>
<td>{$row['size']}</td>
<td>{$row['created']}</td>
<td><a href='get_file.php?id={$row['id']}'>Download</a></td>
<td> {$row['count']}</td>
<td align='center'><a href = javascript:confirmDelete('list_files.php?action=delete&value={$row['id']}')><font color = 'red'>Delete</font></a></td>
</tr>";
}
// Close table
echo '</table>';
}
else
{
// Make sure there are some files in there
if($result->num_rows == 0) {
echo '<p>There are no files in the database</p>';
}
else {
// Print the top of a table
echo '<table width="80%" align="center">
<tr>
<td ><b>Name</b></td>
<td><b>Mime</b></td>
<td><b>Size (bytes)</b></td>
<td><b>Created</b></td>
<td><b> </b></td>
<td><b>Sum Download</b></td>
<td><b>Delete File</b></td>
</tr>';
// Print each file
while($row = $result->fetch_assoc()) {
echo "
<tr>
<td align='center'>{$row['id']}</td>
<td>{$row['name']}</td>
<td>{$row['mime']}</td>
<td>{$row['size']}</td>
<td>{$row['created']}</td>
<td><a href='get_file.php?id={$row['id']}'>Download</a></td>
<td> {$row['count']}</td>
<td align='center'><a href = javascript:confirmDelete('list_files.php?action=delete&value={$row['id']}')><font color = 'red'>Delete</font></a></td>
</tr>";
}
// Close table
echo '</table>';
}
}
// delete
function delete($id){
$sql15 = "DELETE FROM file WHERE id = '$id'";
mysql_query($dbLink,$sql15) or die("ERRPR MSG DELETE FILES : ".mysql_error());
echo "DELETE COMPLETE";
echo "<META HTTP-EQUIV='Refresh' CONTENT='0;URL=./list_files.php'>";
}
if($_GET['action'] == 'delete'){
delete($_GET['value']);
}
// Free the result
$result->free();
}
else
{
echo 'Error! SQL query failed:';
echo "<pre>{$dbLink->error}</pre>";
}
// Close the mysql connection
$dbLink->close();
?>
<body>
<table border="0" cellpadding="10" cellspacing="1" width="500" align="center">
<tr class="tableheader">
<td align="center"></td>
</tr>
<tr class="tablerow">
<td>
<center>
<a href="add_file.php">Back to Upload File</a>
<br>
<?php
if($_SESSION["Username"]) {
?>
Welcome <?php echo $_SESSION["Username"]; ?>. Click here to <a href="index.html" tite="Logout">Logout.
<br> Your user ID is <?php echo $_SESSION["UserID"]; ?>
</center>
<?php
}
?>
</td>
</tr>
</body>
</html>
Tag PHP, MySQL, HTML/CSS
ประวัติการแก้ไข
Date :
2014-12-01 19:35:52By :
xgabpyzView :
2813Reply :
10
พอถึง ฟังชั่น delete เหมือนมันเข้า or die("ERRPR MSG DELETE FILES : ".mysql_error()); อะครับ
Date :
2014-12-01 20:22:10By :
xgabpyz
ยังไม่ได้เหมือนเดิมครับ
Date :
2014-12-01 21:54:31By :
xgabpyz
มันขึ้นว่าไงเอ่ย
Date :
2014-12-01 22:14:50By :
k.voyza
Date :
2014-12-01 22:18:34By :
xgabpyz
เอาโค้ดมาจากไหนครับเนี่ย - -Code (PHP) <?php
// global scope
$a = 555;
function abc()
{
// function scope
echo $a; // error เพราะ $a อยู่ใน global scope
}
abc();
Code (PHP) <?php
// global scope
$a = 555;
function abc()
{
// function scope
global $a; // ดึง $a มาจาก global scope
echo $a; // ok
}
abc();
จะแก้ไขให้ทำงานถูกต้องได้อย่างไร? function delete($id){
$sql15 = "DELETE FROM file WHERE id = '$id'";
mysql_query($dbLink,$sql15) or die("ERRPR MSG DELETE FILES : ".mysql_error());
echo "DELETE COMPLETE";
echo "<META HTTP-EQUIV='Refresh' CONTENT='0;URL=./list_files.php'>";
}
Date :
2014-12-01 22:23:50By :
phpinfo()
Code (PHP) function delete($id){
$sql15 = "DELETE FROM file WHERE id = '$id'";
global $dbLink;
mysql_select_db("it55660293", $dbLink);
mysql_query($sql15, $dbLink) or die("ERRPR MSG DELETE FILES : ".mysql_error());
echo "DELETE COMPLETE";
echo "<META HTTP-EQUIV='Refresh' CONTENT='0;URL=./list_files.php'>";
}
if($_GET['action'] == 'delete'){
delete($_GET['value']);
}
Code (PHP) function delete($id){
global $sql;
$sql = "DELETE FROM file WHERE id = '$id'";
mysql_select_db("it55660293", $dbLink);
mysql_query($sql, $dbLink) or die("ERRPR MSG DELETE FILES : ".mysql_error());
echo "DELETE COMPLETE";
echo "<META HTTP-EQUIV='Refresh' CONTENT='0;URL=./list_files.php'>";
}
if($_GET['action'] == 'delete'){
delete($_GET['value']);
}
Code (PHP) function delete($id){
global $sql,$dbLink;
$sql = "DELETE FROM file WHERE id = '$id'";
mysql_select_db("it55660293", $dbLink);
mysql_query($sql, $dbLink) or die("ERRPR MSG DELETE FILES : ".mysql_error());
echo "DELETE COMPLETE";
echo "<META HTTP-EQUIV='Refresh' CONTENT='0;URL=./list_files.php'>";
}
if($_GET['action'] == 'delete'){
delete($_GET['value']);
}
ประวัติการแก้ไข
Date :
2014-12-01 22:27:03By :
xgabpyz
ลบไฟล์ได้แล้วครับ ขอบคุณมากนะครับ !!
ประวัติการแก้ไข
Date :
2014-12-02 00:24:33By :
xgabpyz
ตัวแปรใน function ที่ต้องทำ Global คือการประกาศตัวแปรแบบหนึ่ง Code (PHP) function delete($id){
// ตัวแปรที่ต้องปรเะกาศ เพราะไม่ได้ถูกประกาศไว้ ภายในฟังก์ชั่น
global $dbLink;
$sql15 = "DELETE FROM file WHERE id = '$id'";
mysql_query($dbLink,$sql15) or die("ERRPR MSG DELETE FILES : ".mysql_error());
echo "DELETE COMPLETE";
echo "<META HTTP-EQUIV='Refresh' CONTENT='0;URL=./list_files.php'>";
}
ประวัติการแก้ไข
Date :
2014-12-02 08:21:00By :
Chaidhanan
Server 04
Load balance : Server 04
