1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
|
<?php
include('db.php');
if(isset($_REQUEST['actionfunction']) && $_REQUEST['actionfunction']!=''){
$actionfunction = $_REQUEST['actionfunction'];
call_user_func($actionfunction,$_REQUEST,$con);
}
// Fonction Save DATA
function saveData($data,$con){
$fname = $con->real_escape_string($data['fname']);
$lname = $con->real_escape_string($data['lname']);
$domain = $con->real_escape_string($data['domain']);
$email = $con->real_escape_string($data['email']);
$sql = "insert into ajaxtable(firstname,lastname,domain,email) values('$fname','$lname','$domain','$email')";
if($con->query($sql)){
showData($data,$con);
} else {
echo "error";
}
}
// Fonction Show DATA
function showData($data,$con){
$sql = "select * from ajaxtable order by id asc";
$data = $con->query($sql);
$str='<tr class="head"><td>Firstname</td><td>Lastname</td><td>Domain</td><td>Email</td><td></td></tr>';
//if($data->num_rows>0) if (($firstname_tri) != "") {
if($data->num_rows>0) if (($firstname_tri) == "") {
while( $row = $data->fetch_array(MYSQLI_ASSOC)){
$str.="<tr id='".$row['id']."'><td>".$row['firstname']."</td><td>".$row['lastname']."</td><td>".$row['domain']."</td><td>".$row['email']."</td><td><input type='button' class='ajaxedit' value='Edit'/> <input type='button' class='ajaxdelete' value='Delete'></td></tr>";
}
} else {
$str .= "<td colspan='5'>No Data Available</td>";
}
echo $str;
}
function updateData($data,$con){
$fname = $con->real_escape_string($data['fname']);
$lname = $con->real_escape_string($data['lname']);
$domain = $con->real_escape_string($data['domain']);
$email = $con->real_escape_string($data['email']);
$editid = $con->real_escape_string($data['editid']);
$sql = "update ajaxtable set firstname='$fname',lastname='$lname',domain='$domain',email='$email' where id=$editid";
if($con->query($sql)){
showData($data,$con);
}
else{
echo "error";
}
}
function deleteData($data,$con){
$delid = $con->real_escape_string($data['deleteid']);
$sql = "delete from ajaxtable where id=$delid";
if($con->query($sql)){
showData($data,$con);
}
else{
echo "error";
}
}
?> |
Partager