|
 |
| |
PHP + Ajax การ delete ทำแบบ photo gallery ลบภาพใหญ่ออกแต่ภาพเล็กยังโชว์อยู๋ |
| |
 |
|
|
 |
 |
|
สืบเนื่องมาจากหนูได้ทำ photo gallery แบบ ajax ตามกระทู้นี้ https://www.thaicreate.com/tutorial/ajax-gallery.html
ตอนนี้หนูทำให้มันลบค่ะ ตรงรูปเล็กเมื่อกดลบภาพใหญ่ที่โชว์หายไปค่ะ ข้อมูลหายจากฐานข้อมูลค่ะแต่ภาพเล็กที่โชว์และเลือกไว้เปลี่ยนรูปไม่หายไป หนูอยากให้พอกดลบก็หายไปทั้งภาพเล็กภาพใหญ่เลยค่ะ
ขอคำปรึกษาด้วยนะคะ ขอบคุณมากๆค่ะสำหรับการช่วยเหลือ หนูไม่สันทัด ajax จริงๆ 5555
อันนี้โค้ดหน้าโชว์แล้วสามารถลบได้ค่ะ
Code (PHP)
<html>
<head>
<title>WTF</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" type="text/css" href="css/main.css">
<script type="text/javascript" src="script.js"></script>
<script type="text/javascript" src="jsjs.js"></script>
</head>
<body Onload="JavaScript:doCallAjax();">
<div id = "total">
<div class = "header">
<h1>Where’s The Food.</h1>
</div>
<div id="myDiv">
<button type="button" class = "mybt" onclick="myFunction()">New Menu</button>
<div class = "containner">
<h2>Choose me if you want.</h2>
<table width="680" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="168" valign="top">
<?
$objConnect = mysql_connect("localhost","","") or die("Error Connect to Database");
mysql_query("SET NAMES UTF8");
mysql_query("SET character_set_results=utf8");
$objDB = mysql_select_db("");
$strSQL = "SELECT * FROM files ORDER BY FilesID ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
<?
echo"<table border=\"0\" cellspacing=\"1\" cellpadding=\"1\"><tr>";
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
echo "<td>";
?>
<a href="JavaScript:doCallAjax('<?=$objResult["FilesID"];?>');">
<!--onMouseOver="JavaScript:doCallAjax('<?=$objResult["GalleryID"];?>');"-->
<img id ="dd" src="ViewImage.php?FilesID=<?=$objResult["FilesID"];?>" width="70" height="53" border="0"></a><br/>
<a href="JavaScript:doCallAjaxx('DELETE','<?php echo $objResult["FilesID"];?>');">X</a>
<?
echo"</td>";
if(($intRows)%3==0)
{
echo"</tr>";
}
else
{
echo "<td><br/>";
}
}
echo"</tr></table>";
?>
<?
mysql_close($objConnect);
?>
</td>
<td width="250" height = "250" valign="top"><span id="mySpan"></span></td>
</tr>
</table>
</div>
</div>
<div class= "footer" id="foot">
</div>
</div>
</body>
</html>
อันเป็น js ค่ะมีเยอะอยู่นะคะแต่ลบอยู่ด้านล่างค่ะ
Code (JavaScript)
var HttPRequest = false;
function loadXMLDoc(url,cfunc)
{
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=cfunc;
xmlhttp.open("GET",url,true);
xmlhttp.send();
}
function myFunction()
{
loadXMLDoc("PageUploadToMySQL1.php",function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("myDiv").innerHTML=xmlhttp.responseText;
}
});
}
function myFunction1()
{
loadXMLDoc("AjaxPHPGallery1.php",function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("total").innerHTML=xmlhttp.responseText;
}
});
}
function doCallAjax(ID) {
HttPRequest = false;
if (window.XMLHttpRequest) { // Mozilla, Safari,...
HttPRequest = new XMLHttpRequest();
if (HttPRequest.overrideMimeType) {
HttPRequest.overrideMimeType('text/html');
}
} else if (window.ActiveXObject) { // IE
try {
HttPRequest = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
HttPRequest = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e) {}
}
}
if (!HttPRequest) {
alert('Cannot create XMLHTTP instance');
return false;
}
var url = 'AjaxPHPGallery2.php';
var pmeters = "tID="+ID;
HttPRequest.open('POST',url,true);
HttPRequest.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
HttPRequest.setRequestHeader("Content-length", pmeters.length);
HttPRequest.setRequestHeader("Connection", "close");
HttPRequest.send(pmeters);
HttPRequest.onreadystatechange = function()
{
if(HttPRequest.readyState == 3) // Loading Request
{
document.getElementById("mySpan").innerHTML = "Now is Loading...";
}
if(HttPRequest.readyState == 4) // Return Request
{
document.getElementById('mySpan').innerHTML = HttPRequest.responseText;
}
}
}
var HttPRequest = false;
function doCallAjaxx(Mode,ID) {
if(confirm('คุณแน่ใจที่จะลบรูปภาพ ?')==false)
{
return false;
} ;
HttPRequest = false;
if (window.XMLHttpRequest) { // Mozilla, Safari,...
HttPRequest = new XMLHttpRequest();
if (HttPRequest.overrideMimeType) {
HttPRequest.overrideMimeType('text/html');
}
} else if (window.ActiveXObject) { // IE
try {
HttPRequest = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
HttPRequest = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e) {}
}
}
if (!HttPRequest) {
alert('Cannot create XMLHTTP instance');
return false;
}
var url = 'AjaxPHPDeleteRecord2.php';
var pmeters = "tMode=" + Mode +
"&tID=" + ID;
HttPRequest.open('POST',url,true);
HttPRequest.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
HttPRequest.setRequestHeader("Content-length", pmeters.length);
HttPRequest.setRequestHeader("Connection", "close");
HttPRequest.send(pmeters);
HttPRequest.onreadystatechange = function()
{
if(HttPRequest.readyState == 3) // Loading Request
{
document.getElementById("mySpan").innerHTML = "Now is Loading...";
}
if(HttPRequest.readyState == 4) // Return Request
{
document.getElementById("mySpan").innerHTML = HttPRequest.responseText;
}
}
}
function callLoad(url){
var xmlhttp = new XMLHttpRequest();
loadXMLDoc(xmlhttp, url, function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
document.getElementById("result").innerHTML += xmlhttp.responseText ;
}
});
}
function myFunction2(){
document.getElementById("result").innerHTML = "";
callLoad("PageUploadToMySQL2.php");
}
อันนี้เป็นส่วนของฐานข้อมูลค่ะ
Code (PHP)
<?php
/*** By Weerachai Nukitram ***/
/*** http://www.ThaiCreate.Com ***/
$strMode = $_POST["tMode"];
$strID = $_POST["tID"];
$objConnect = mysql_connect("localhost","","") or die("Error Connect to Database");
$objDB = mysql_select_db("");
if($strMode == "DELETE")
{
$strSQL = "DELETE FROM files ";
$strSQL .="WHERE FilesID = '".$strID."' ";
$objQuery = mysql_query($strSQL);
}
?>
Tag : PHP, Ajax
|
|
|
 |
 |
 |
 |
| Date :
2014-12-19 04:00:02 |
By :
munkminkgirl |
View :
1038 |
Reply :
5 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
คุณจะต้องอ่าน Path มันมาก่อนที่จะลบน่ะครับ
Code (ตัวอย่างการเขียนเพื่อลบ)
<?php
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("mydatabase");
//*** Select Old File (Album) ***//
$strSQL = "SELECT * FROM album WHERE AlbumID = '".$_GET["AlbumID"]."' ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysql_fetch_array($objQuery);
//*** Delete Files (Album) ***//
@unlink("myfile/".$objResult["AlbumShot"]);
//*** Delete Rows (Album)***//
$strSQL = " DELETE FROM album ";
$strSQL .=" WHERE AlbumID = '".$_GET["AlbumID"]."' ";
$objQuery = mysql_query($strSQL);
//*** Loop Delete Gallery ***//
$strSQL2 = "SELECT * FROM gallery WHERE AlbumID = '".$_GET["AlbumID"]."' ORDER BY GalleryID ASC ";
$objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL2."]");
while($objResult2 = mysql_fetch_array($objQuery2))
{
//*** Delete Files (Gallery) ***//
@unlink("myfile/".$objResult2["GalleryShot"]);
}
//*** Delete All Rows (Gallery)***//
$strSQL = " DELETE FROM gallery ";
$strSQL .=" WHERE AlbumID = '".$_GET["AlbumID"]."' ";
$objQuery = mysql_query($strSQL);
echo "Delete Complete<br>";
mysql_close($objConnect);
?>
|
| |
|
|
| |
| Date :
2014-12-19 09:24:02 |
By :
mr.win |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
อะไรอยู่ที่ไหน คุณก็ตามไปลบมัน ก็แค่นั้นแหละครับ 
|
| |
|
|
| |
| Date :
2014-12-19 14:35:32 |
By :
mr.win |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ยังไม่ได้เลยค่าาาาา พี่ๆคนไหนใจดีช่วยหนูหน่อยค่าาา ขอบคุณล่วงหน้าเลยค่าา
|
| |
|
|
| |
| Date :
2014-12-20 02:13:56 |
By :
munkminkgirl |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 00
|
