jQuery Ajax PHP Delete Records Confirmation

jQuery Ajax PHP Delete Records Confirmation

Download

http://dl.dropbox.com/u/7106563/r-ednalan/Delete_Records_Confirmation.zip




Jquery Ajax

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.min.js"></script>

<script type="text/javascript">

$(function() {

$(".delbutton").click(function(){

var element = $(this);

//Find the id of the link that was clicked

var del_id = element.attr("id");

//Built a url to send

var info = 'id=' + del_id;

if(confirm("Sure you want to delete this update? There is NO undo!"))

{

	$.ajax({

	   type: "GET",

	   url: "delete.php",

	   data: info,

	   success: function(){

	   }

	});

 $(this).parents(".record").animate({ backgroundColor: "#fbc7c7" }, "fast")

	.animate({ opacity: "hide" }, "slow");

}

return false;

});

});

</script>

CSS Code

<style>

#rounded-corner

{

	font-family: "Lucida Sans Unicode", "Lucida Grande", Sans-Serif;

	font-size: 12px;

	margin: 45px;

	width: 480px;

	text-align: left;

	border-collapse: collapse;

}

#rounded-corner thead th.rounded-company

{

	background: #b9c9fe url('table-images/left.png') left -1px no-repeat;

}

#rounded-corner thead th.rounded-q4

{

	background: #b9c9fe url('table-images/right.png') right -1px no-repeat;

}

#rounded-corner th

{

	padding: 8px;

	font-weight: normal;

	font-size: 13px;

	color: #039;

	background: #b9c9fe;

}

#rounded-corner td

{

	padding: 8px;

	background: #e8edff;

	border-top: 1px solid #fff;

	color: #669;

}

#rounded-corner tfoot td.rounded-foot-left

{

	background: #e8edff url('table-images/botleft.png') left bottom no-repeat;

}

#rounded-corner tfoot td.rounded-foot-right

{

	background: #e8edff url('table-images/botright.png') right bottom no-repeat;

}

#rounded-corner tbody tr:hover td

{

	background: #d0dafd;

}

</style>

index.php

<table id="rounded-corner" border="0">

 <thead>

 	<tr>

     	<th scope="col" class="rounded-company">Company</th>

         <th scope="col" class="rounded-q1">Q1</th>

         <th scope="col" class="rounded-q2">Q2</th>

         <th scope="col" class="rounded-q3">Q3</th>

         <th scope="col" class="rounded-q3">Q4</th>

         <th scope="col" class="rounded-q4" width="15px;"></th>

     </tr>

 </thead>

     <tfoot>

 	<tr>

     	<td colspan="5" class="rounded-foot-left"><em></em></td>

     	<td class="rounded-foot-right"> </td>

     </tr>

 </tfoot>

 <tbody>

		<?php

			

		 include("dbconfig.php");

		 $query4="select * from table order by id desc";

			$result4 = mysql_query($query4);

			while($row=mysql_fetch_array($result4))

			{

			$message=stripslashes($row["company"]);			

		?>

 	<tr class="record">

     	<td><?php echo $message; ?></td>

         <td>20.3</td>

         <td>30.5</td>

         <td>23.5</td>

         <td>40.3</td>

         <td><a href="#" id="<?php echo $row["id"]; ?>" class="delbutton"><img src="publish_x.png"/></a></td>

     </tr>

		<?php

		}

		?>

 </tbody>

</table>

delete.php

<?php

include("dbconfig.php");

if($_GET['id'])

{

$id=$_GET['id'];

$sql = "delete from messages where id='$id'";

mysql_query( $sql);

}

?>

dbconfig.php

<?php

$mysql_hostname = "localhost";

$mysql_user = "root";

$mysql_password = "ednalan";

$mysql_database = "test";



$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");

mysql_select_db($mysql_database, $bd) or die("Could not select database");

?>