PDA

View Full Version : Updata Data In Database Without Refresh ((AJAX))!!


SmAsH_HaCkEr
12-24-2009, 05:26 AM
Hey Guyz,

I Have A PHP CODE Which Allows Me To Re-Order Categories In My PHP SCRIPT

Here's The Code

<?php
switch($_REQUEST[cat]){
case"up":
$order=intval($_GET[order]);
$id=intval($_GET[id]);
$orderup=$order-1;
$q=@mysql_query("select * from `categories` where `order`='$orderup'");
$down=@mysql_fetch_array($q);
$num_row=$down[id];
$query_up1=@mysql_query("update `categories` SET `order`='$order' where `id`='$num_row' ");
$query_up2=@mysql_query("update `categories` SET `order`='$orderup' where `id`='$id' ");
break;

case"down":
$order=intval($_GET[order]);
$id=intval($_GET[id]);
$orderdown=$order+1;
$q=@mysql_query("select * from `categories` where `order`='$orderdown'");
$down=@mysql_fetch_array($q);
$num_row=$down[id];
$query_up1 =@mysql_query("update `categories` SET `order`='$order' where `id`='$num_row' ");
$query_up2 =@mysql_query("update `categories` SET `order`='$orderdown' where `id`='$id' ");
break;
}

?>

AND Here Is The Display Page

<table border='1' cellspacing='1' cellpadding='0' align='center' dir='rtl'>
<tr>
<td>Category Title</td>
<td>Up</td>
<td>Down</td>
</tr>
<?
$up=0;
$query=@mysql_query("select * from `categories` order by `order` DESC LIMIT 1");
$num=@mysql_fetch_array($query);
$down=$num[order];
$query=@mysql_query("SELECT * FROM `categories` order by `order`");
while($row=@mysql_fetch_array($query)){
$up=$up+1;
echo"<tr><td>$row[name]</td>";
if($up==1){echo"<td>_</td>";}
else{echo"<td><a href='order.php'cat=up&order=$row[order]&id=$row[id]'>Up</a></td>";}
if($down==$row[order]){echo"<td>_</td>";}
else{echo"<td><a href='order.php?cat=down&order=$row[order]&id=$row[id]'>Dwon</a></td></tr>";}
}
?>
</table>

It Works Well But When I Click On The UP Or The DOWN Link I Must Refresh The Page To See The Categories After Re-Ordering

All I Want Is Ajax Code That Allows Me To Re-Order Categories Without Refreshing The Page

I Hope You Help Me SooN !!