 |
|
ช่วยแก้ให้ทีครับ
เมื่อคลิกเมนูผู้ดูแลระบบ มันดึงข้อมูลมาปกติ พอกด del edit เพิ่มข้อมูล มันไม่ยอมดึงข้อมูลมารีเฟช ช่วยดูให้ทีครับ งงมานานแล้วครับ
โพสต์ครั้งแรกผิดประการใด ขอโทษด้วยครับ
ไฟล์ได้แนบไปแล้วครับ ^^
config.php
<?php
$host = "localhost";
$us = "root";
$pw = "12345";
$db = "test";
$link = mysql_connect($host,$us,$pw)or die ("Could not connect to MySQL");
mysql_select_db($db)or die ("Could not connect to Database");
?>
Content.php
<div class="tag-all">
<p> In hac habitasse platea dictumst. Duis porttitor. Sed vulputate elementum nisl. Vivamus et mi at arcu mattis iaculis. Nullam posuere tristique tortor. In bibendum. Aenean ornare, nunc eget pretium porttitor, sem est pretium leo, non euismod nulla dui non diam. Pellentesque dictum faucibus leo. Vestibulum ac ante. Sed in est. Sed sodales nisl sit amet augue. Donec ultrices, augue ullamcorper posuere laoreet, turpis massa tristique justo, sed egestas metus magna sed purus. Fusce eleifend, dui ut posuere auctor, justo elit posuere sapien, at blandit enim quam fringilla mi.</p>
<p> In hac habitasse platea dictumst. Duis porttitor. Sed vulputate elementum nisl. Vivamus et mi at arcu mattis iaculis. Nullam posuere tristique tortor. In bibendum. Aenean ornare, nunc eget pretium porttitor, sem est pretium leo, non euismod nulla dui non diam. Pellentesque dictum faucibus leo. Vestibulum ac ante. Sed in est. Sed sodales nisl sit amet augue. Donec ultrices, augue ullamcorper posuere laoreet, turpis massa tristique justo, sed egestas metus magna sed purus. Fusce eleifend, dui ut posuere auctor, justo elit posuere sapien, at blandit enim quam fringilla mi.</p>
</div>
edit_del_member.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:'edit_del_sql.php',
data:datastring,
beforeSend: function(){
$("#show_id").html("Plese wait...");
},
success:function(data){
$("#show_id").html(data);
}
});
}
/*-----------------------EDIT----------------------*/
function edit_members(edit_id){
//alert(edit_id);
var str=Math.random();
var username = document.myform.username.value;
var password = document.myform.password.value;
var email = document.myform.email.value;
var datastring='str='+str + '&edit_id='+edit_id + '&username='+username+ '&password='+password + '&email='+email;
$.ajax({
type:'POST',
url:'edit_del_sql.php',
data:datastring,
beforeSend: function(){
$("#show_id").html("Plese wait...");
},
success:function(data){
window.location.reload("view_edit_del_memberdata.php");
}
});
}
/*-----------------------DEL----------------------*/
function del_members(del_id){
//alert(edit_id);
var str=Math.random();
var datastring='str='+str + '&del_id='+del_id;
$.ajax({
type:'POST',
url:'edit_del_sql.php',
data:datastring,
beforeSend: function(){
$("#show_id").html("Plese wait...");
},
success:function(data){
window.location.reload("view_edit_del_memberdata.php");
}
});
}
/*-----------------------INSERT----------------------*/
function insertsql(){
var str=Math.random();
var user = $("#user").val();
var password = $("#password").val();
var email = $("#email").val();
var datastring='str='+str + '&user='+user+ '&password='+password + '&email='+email;
//alert(datastring);
$.ajax({
type:'POST',
url:'edit_del_sql.php',
data:datastring,
beforeSend: function(){
$("#show_id").html("Plese wait...");
},
success:function(data){
window.location.reload("view_edit_del_memberdata.php");
}
});
}
edit_del_sql
<?php
include 'config.php';
/*-----------------SHOW MEMBERS FOR EDIT--------------*/
$show_id = $_POST['show_id'];
if($_POST['show_id']){
$sql = "select * from members where member_id = '$show_id' order by '$show_id'";
$result = mysql_query($sql);
$row= mysql_fetch_array($result);
$edit_id=$row['member_id'];
$username=$row['username'];
$password=$row['password'];
$email=$row['emailaddress'];
echo "<div id='edit_id'>";
echo "<form name=myform>";
echo "<div style='margin-left:22px;margin-bottom:8px;'>
Username:<input type='text' name='username' value='$username'size=25></div>";
echo "<div style='margin-left:25px;margin-bottom:8px;'>
Password:<input type='text' name='password' value='$password'size=25></div>";
echo "<div style='margin-bottom:8px;'>
Emailaddress:<input type='text' name='email' value='$email'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'];
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
if($_POST['edit_id']){
if($username =="" || $password =="" || $email ==""){
echo "error";
}
else{
$sql = "update members set
username = '$username',
password = '$password',
emailaddress = '$email'
where member_id = '$edit_id'";
mysql_query($sql);
echo "success";
}
}
/*--------------------DEL MEMBERS---------------------*/
$del_id = $_POST['del_id'];
if($_POST['del_id']){
$sql = "delete from members where member_id = '$del_id'";
$result = mysql_query($sql,$link);
}
/*--------------------INSERT MEMBERS---------------------*/
$user = $_POST['user'];
$password = $_POST['password'];
$email = $_POST['email'];
if($_POST['user']){
if($password == "" || $email == ""){
exit();
}
else{
$sql = "insert into members (username,password,emailaddress)values ('$user','$password','$email')";
mysql_query($sql,$link);
mysql_close();
}
}
?>
index.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>test</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/style.css" rel="stylesheet" type="text/css" />
<script language="JavaScript" src="js/admin.js"></script>
<script language="JavaScript" src="jquery.js"></script>
<script language="JavaScript" src="edit_del_members.js"></script>
</head>
<body>
<div id="outer-container">
<div id="header"></div>
<div class="clear"></div>
<div id="outer-content">
<div id="sidebar">
<table width="180" border="0">
<tr>
<td><a href=javascript:doCallAjax('content.php'); class="home">หน้าหลัก</a></td>
</tr>
<tr>
<td><a href=javascript:doCallAjax('view_edit_del_memberdata.php'); class="member">ผู้ดูแลระบบ</a></td>
</tr>
</table>
</div>
</div>
<div id="content"><? include('content.php'); ?></div>
<div class="clear"></div>
<div id="footer">Copyright © 2011</div>
</div>
</body>
</html>
view_edit_del_memberdata
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="edit_del_members.js"></script>
<link rel="stylesheet" type="text/css" href="style.css"/>
</head>
<body>
<center>
<div class="cleaner_h20"></div>
<div id="show_id"></div>
<div class="cleaner_h20"></div>
<table width="780" border="1">
<th>Id</th>
<th>Username</th>
<th>Password</th>
<th>email</th>
<th>Edit</th>
<th>Del</th>
<?php
include 'config.php';
/*---------------------------SHOWDATA----------------------------*/
$sql = "select * from members order by member_id";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$i=0;
while($i<$num){
$row = mysql_fetch_array($result);
$id = $row['member_id'];
$username = $row['username'];
$password = $row['password'];
$email = $row['emailaddress'];
echo "<tr>";
echo "<td>$id</td>";
echo "<td>$username</td>";
echo "<td>$password</td>";
echo "<td>$email</td>";
$show_id = $row['member_id']; //กำหนดตัวแปร edit_id ให้กับ link
echo "<td align='center'><span id='edit' onclick='show_members($show_id)'>edit</span></td>";
$del_id = $row['member_id'];//กำหนดตัวแปร del_id ให้กับ link
echo "<td align='center'><span id='del' onclick='del_members($del_id)'>del</span></td>";
echo "</tr>";
$i++;
}
?>
</table>
<div> </div>
<!----------------------FORM INSERT MEMBER---------------------->
<div>
<form name="form1" method="post">
INSERT USER:>> username:<input type="text" name="user" id="user"/>
password:<input type="password" name="password" id="password"/>
email:<input type="text" name="email" id="email"/>
<input type="button" value="submit" onClick="insertsql()"/>
</form>
</div>
</center>
</body>
</html>
admin.js
function doCallAjax(url) {
HttPRequest = false;
if (window.XMLHttpRequest) { // Mozilla, Safari,...
HttPRequest = new XMLHttpRequest();
if (HttPRequest.overrideMimeType) {
HttPRequest.overrideMimeType('text/html');
}
} else if (window.ActiveXObject) { // IE
try {
HttPRequest = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
HttPRequest = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e) {}
}
}
if (!HttPRequest) {
alert('Cannot create XMLHTTP instance');
return false;
}
var pmeters = "";
HttPRequest.open('POST',url,true);
HttPRequest.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
HttPRequest.setRequestHeader("Content-length", pmeters.length);
HttPRequest.setRequestHeader("Connection", "close");
HttPRequest.send(pmeters);
HttPRequest.onreadystatechange = function()
{
if(HttPRequest.readyState == 3) // Loading Request
{
document.getElementById("content").innerHTML = "Now is Loading...";
}
if(HttPRequest.readyState == 4) // Return Request
{
document.getElementById('content').innerHTML = HttPRequest.responseText;
}
}
}
style.css
@charset "utf-8";
/* CSS Document */
body {
font-size: 62.5%; /* Resets 1em to 10px */
font-family: Tahoma, 'Lucida Grande', Verdana, Arial, Sans-Serif;
background-color: #EEE;
color: #666;
margin: 0;
font-size: 12px;
}
/* outer-container */
#outer-container {
margin: 0px auto 0px auto;
width: 1000px;
padding: 0px 1px 0px 1px;
background: url(../img/background.jpg) repeat-y;
}
/* header */
#header {
width: 1000px;
height: 160px;
background-color: transparent;
background: url(../img/bck.png);
}
/* outer-content */
#outer-content{
width: auto;
}
/* content */
#content {
width: 790px;
margin-left: 5px;
margin-right: 5px;
padding: 5px 5px 5px 5px;
float: left;
font-size: 14px;
}
/* border content */
#tag-all {
width: 790px;
float: left;
}
/* sidebar */
#sidebar {
background-color:#f5fcfd;
width: 180px;
margin-top: 2px;
margin-left: 5px;
margin-right: 5px;
float: left;
}
#sidebar a.home{
-moz-border-radius:6px;
-webkit-border-radius:6px;
border-radius:6px;
background:#828282 url(../img/home.png) 5px 50% no-repeat;
border:1px solid #6D6D6D;
color:#FFF;
display:block;
padding:5px 5px 5px 30px;
text-decoration: none;
}
#sidebar .member{
border-radius:6px;
background:#eaf3fa url(../img/member.png) 10px 50% no-repeat;
color: #000;
display:block;
padding:5px 5px 5px 30px;
text-decoration: none;
margin-top:10px;
}
/* footer */
#footer{
width: 994px;
height: 20px;
font-size: 14px;
color: #FFFFCC;
padding: 10px 0px 3px 0px;
margin-left: 5px;
margin-right: 5px;
text-align:center;
background:url(../img/bgfooter.jpg) repeat-x;
}
/* clear */
.clear{
clear: both;
}
Tag : MySQL, HTML/CSS, JavaScript, Ajax, jQuery
|
|
|
 |
 |
 |
 |
| Date :
2011-09-02 09:31:16 |
By :
weaned |
View :
1038 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
