01.<?PHP
02.include('include/function.php');
03.?>
04.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
05.<?php $id = $_GET['id'];
06. $objConnect = mysql_connect("localhost","plan","Plan@5255") or die("Error Connect to Database");
07. $objDB = mysql_select_db("work",$objConnect);
08. mysql_query("SET character_set_results=utf8");
09. mysql_query("SET character_set_client=utf8");
10. mysql_query("SET character_set_connection=utf8");
11.
12.
13. $strSQL = "SELECT * FROM album WHERE AlbumID = '".$_GET["AlbumID"]."' ";
14. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
15. $objResult = mysql_fetch_array($objQuery);
16.
17.
18.
19.
20.
21. $strSQL = " DELETE FROM album ";
22. $strSQL .=" WHERE AlbumID = '".$_GET["AlbumID"]."' ";
23. $objQuery = mysql_query($strSQL);
24.
25.
26.
27. $strSQL2 = "SELECT * FROM gallery WHERE AlbumID = '".$_GET["AlbumID"]."' ORDER BY GalleryID ASC ";
28. $objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL2."]");
29. while($objResult2 = mysql_fetch_array($objQuery2))
30. {
31.
32.
33.
34.
35.
36. $strSQL = " DELETE FROM gallery ";
37. $strSQL .=" WHERE AlbumID = '".$_GET["AlbumID"]."' ";
38. $objQuery = mysql_query($strSQL);
39.
40. if($objQuery){
41. echo "<script>alert('เพิ่มอัลบั้มรูปภาพเรียบร้อย');window.location=\"system_index_details_building.php?id=$_POST[id]\";</script>";
42. } else {
43. echo 'ไม่สามารถเพิ่มไฟล์ข้อมูลได้!!!!!!!';
44. }
45. }
46.?>
Load balance : Server 05
