code แก้ไขข้อมูลครับ
user.js
โค้ด: เลือกทั้งหมด
/*-----------------------SHOW----------------------*/
function show_members(show_id){
alert(show_id);
var str=Math.random();
var datastring='str='+str + '&show_id='+show_id ;
$.ajax({
type:'POST',
url:'user_process.php',
data:datastring,
beforeSend: function(){
$("#show_id").html('<img src="loading2.gif">');
},
success:function(data){
$("#show_id").html(data);
}
});
}
/*-----------------------EDIT----------------------*/
function edit_members(edit_id){
alert(edit_id);
var str=Math.random();
var agent = document.myform.agent.value;
var password = document.myform.password.value;
var datastring='str='+str + '&edit_id='+edit_id + '&agent='+agent
+ '&active='+active;
$.ajax({
type:'POST',
url:'user_process.php',
data:datastring,
beforeSend: function(){
$("#show_id").html('<img src="loading2.gif">');
},
success:function(data){
window.location.reload("user_process.php");
}
});
}
โค้ด: เลือกทั้งหมด
<?php
$sql = "select * from tb_member";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$i = 0;
while ($i < $num) {
$row = mysql_fetch_array($result);
$userid = $row['member_id'];
$email = $row['member_email'];
$name = $row['member_disname'];
$grant = $row['grant'];
$active = $row['active'];
echo "<tr>";
echo "<td>$userid</td>";
echo "<td>$email</td>";
echo "<td>$name</td>";
echo "<td>$grant</td>";
echo "<td>$active</td>";
$show_id = $row['member_id'];
echo "<td><span id='edit' OnClick='show_members($show_id)'>
<img border=0 src='images/icn_edit.png'/></span></td>";
$del_id = $row['member_id'];
echo "<td><span id='del' onclick='del_members($del_id)'>
<img border=0 src='images/icn_trash.png'></span></td>";
echo "</tr>";
$i++;
}
?>
โค้ด: เลือกทั้งหมด
/*-----------------SHOW MEMBERS FOR EDIT--------------*/
$show_id = $_POST['show_id'];
echo $show_id;
if($_POST['show_id']){
$sql = "select * from tb_member where member_id = '$show_id'";
$result = mysql_query($sql);
$row= mysql_fetch_array($result);
$edit_id = $row['member_id'];
$edit_grant = $row['grant'];
$edit_active = $row['active'];
echo "<div id = 'edit_id'>";
echo "<form name = myform>";
echo "<div>
grant:
<input type='text' name='grant' value='$edit_grant'size=25></div>";
echo "<div>
active:
<input type='text' name='active' value='$edit_active'size=25></div>";
echo "<div>
<input type='button' onclick='edit_members($edit_id)' value='Edit'></div>";
echo "</form>";
echo "</div>";
}
/*--------------------EDIT MEMBERS---------------------*/
$edit_id = $_POST['edit_id'];
$agent = $_POST['agent'];
$active = $_POST['active'];
$email = $_POST['email'];
if($_POST['edit_id']){
if($grant =="" || $active ==""){
echo "error";
}
else{
$sql = "update tb_members set
member_grant = '$grant',
member_active = '$active',
where member_id = '$edit_id'";
mysql_query($sql);
echo "success";
}
}