<!DOCTYPE html>
<html>
<head>
<title>JavaScript [Demo]</title>
<script type="text/javascript" src="js/jquery-2.2.1.js"></script>
<style type="text/css">
*{
font-size: 14px;
font-family: arial;
}
.red{
background-color: red;
padding: 5px;
}
.blue{
background-color: blue;
padding: 5px;
}
</style>
</head>
<body>
<p>Username: <input type="text" id="txtusername" name="txtusername"/></p>
<p>Password: <input type="text" id="txtpassword" name="txtpassword"/></p>
<button id="btnSave">Send Page.</button>
<hr/>
<button id="btnResult">Result</button>
<div class="student_info">
</div>
<script type="text/javascript">
$(function(){
$('#btnSave').on('click',function(){
var formData = {
'username':$('#txtusername').val(),
'password':$('#txtpassword').val()
};
$.post("mi_test.php", formData).done(function( data ) {
debugger;
});
});
$('#btnResult').on('click',function(){
var stdInfo = '';
$.getJSON("result.php", function( json ) {
for(i=0;i<json.dataResult.length;i++){
stdInfo+='<p class="hidebtn">';
stdInfo+=json.dataResult[i].id;
stdInfo+=' ';
stdInfo+=json.dataResult[i].username;
stdInfo+=' ';
stdInfo+=json.dataResult[i].password;
stdInfo+=" ";
stdInfo+="<button class='delid' data-getid='"+json.dataResult[i].id+"'>Delete</button>";
stdInfo+='</p>';
}
$('.student_info').html(stdInfo);
});
});//btnResult
$('.student_info').on('click','p .delid',function(e){
var getid = $(this).data('getid'),con_status,formData;
con_status = confirm('Ara You Sure Delete');
if(con_status){
$(this).parents('p').hide();
formData = {
'post_id':getid
};
$.post("mi_delete.php", formData).done(function( data ) {
debugger;
});
}
});
});
</script>
</body>
</html>
--------------------------------------------------
result.php
<?php
$db = mysql_connect('localhost','root','');
mysql_select_db('db_utility',$db);
$sql = mysql_query('select * from user_json',$db);
$arr=array();
while($row = mysql_fetch_array($sql)){
$arr[] = $row;
}
echo json_encode(array('dataResult'=>$arr));
?>
mi_test.php
<?php
$db = mysql_connect('localhost','root','');
mysql_select_db('db_utility',$db);
// $sql = mysql_query('select * from emp',$db);
// $arr=array();
// while($row = mysql_fetch_array($sql)){
// $arr[] = $row;
// }
// echo json_encode(array('dataResult'=>$arr));
$getUser = $_POST['username'];
$getPass = $_POST['password'];
$sql = mysql_query("insert into user_json (username,password) values ('$getUser','$getPass')",$db);
$arrMsg = array();
$arrMsg['result'] = 'some parameter is missing.';
if($sql){
$arrMsg['result'] = 'Data has been inserted.';
}
echo json_encode(array('result'=>$arrMsg));
?>
mi_delete.php
<?php
$db = mysql_connect('localhost','root','');
mysql_select_db('db_utility',$db);
$getId = $_POST['post_id'];
$sql = 'delete from user_json where id = '.$getId;
$sql = mysql_query($sql,$db);
$arr = array();
if($sql){
$arr['msg']='data deleted success';
}
echo json_encode(array('dataResult'=>$arr));
?>
------------------------------
user_json.sql
CREATE TABLE IF NOT EXISTS `user_json` (
`id` int(11) NOT NULL,
`username` varchar(25) NOT NULL,
`password` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
0 comments:
Post a Comment