(1)FIRST WRITE javascript CODE in <head> section </head> :
<html>
<head>
<script type="text/javascript">
function doDelete(id){
if(confirm("Do you want to delete the record?")){
$.ajax({
url:'delete.php',
type:'post',
data:'id='+id,
success:function(msg){
alert(msg);
window.location.href='pagination2.php';
}
});
}
}
</script>
</head>
<!---Second use following line where you want to call doDelete() method in <body> section </body>--->
<body>
<?php
include("connect.php");
$per_page = 8;
$pages_query = mysql_query("SELECT COUNT('id') FROM notes order by coursename,semester ASC");
$pages = ceil(mysql_result($pages_query, 0) / $per_page);
$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $per_page;
$query = mysql_query("SELECT * FROM notes LIMIT $start, $per_page");
while($row = mysql_fetch_assoc($query))
{
echo "record one";
?>
<a class="click-more" href="#" onClick="doDelete('<?php echo $row['id']; ?>');">read more</a>
<?php
$prev = $page - 1;
$next = $page + 1;
if(!($page<=1)){
echo "<a href='pagination1.php?page=$prev'><button>Prev</button></a> ";
}
if($pages>=1 && $page<=$pages){
for($x=1;$x<=$pages;$x++){
echo ($x == $page) ? '<strong><a href="?page='.$x.'"><button>'.$x.'</button></a></strong> ' : '<a href="?page='.$x.'"><button>'.$x.'</button></a> ';
}
}
if(!($page>=$pages)){
echo "<a href='pagination1.php?page=$next'><button>Next>></button></a>";
}
?>
</body>
</html>
(2)write code for delete.php file:
<?php
$id=$_POST['id'];
include("connect.php");
$sql="delete from notes where id='$id'";
mysql_query($sql) or die(mysql_error());
echo "Record deleted successfully";
echo '<br></br>';
echo '<a href="pagination1.php"><button>back to previous page</button></a>';
?>
No comments:
Post a Comment