<?php
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: *');
header('Access-Control-Allow-Headers: *');
header("Content-Type: application/json; charset=UTF-8");
header("Access-Control-Max-Age: 3600");
include "conn.php";
$method=$_SERVER['REQUEST_METHOD'];
$json = file_get_contents("php://input");
$obj= json_decode($json,true);
switch ($method) {
case 'GET' :
$result=mysqli_query($conn,"Select * from feedback ORDER BY FID DESC");
if (mysqli_num_rows($result) > 0) {
while($row[] = mysqli_fetch_assoc($result)) {
$data=json_encode($row);
}
echo $data;
}
else
{
echo json_encode("result not found.");
}
break;
case 'POST':
$nAME=$obj["NAME"];
$mNUMBER=$obj["MNUMBER"];
$cOMMENT=$obj["COMMENT"];
$gENDER=$obj["GENDER"];
$fLAG=$obj["FLAG"];
$result=mysqli_query($conn,"INSERT INTO `feedback`( `NAME`, `MNUMBER`, `COMMENT`, `GENDER`, `FLAG`) VALUES ('$nAME','$mNUMBER','$cOMMENT','$gENDER','$fLAG')");
if($result)
{
echo json_encode("Data Inserted successfully.");
}
else
{
echo json_encode("Something went wrong.");
}
break;
case 'PUT':
$fID=$obj["FID"];
$nAME=$obj["NAME"];
$mNUMBER=$obj["MNUMBER"];
$cOMMENT=$obj["COMMENT"];
$gENDER=$obj["GENDER"];
$result=mysqli_query($conn,"UPDATE `feedback` SET `NAME`='$nAME',`MNUMBER`='$mNUMBER',`COMMENT`='$cOMMENT',`GENDER`='$gENDER' WHERE `FID`='$fID'");
if($result)
{
echo json_encode("Data Inserted successfully.");
}
else
{
echo json_encode("Something went wrong.");
}
break;
case 'DELETE':
$fID=$obj["FID"];
$result=mysqli_query($conn,"DELETE FROM `feedback` WHERE `FID`='$fID'");
if($result)
{
echo json_encode("Data Inserted successfully.");
}
else
{
echo json_encode("Something went wrong.");
}
break;
default:
echo 'Something went wrong.';
break;
}
mysqli_close($conn);
?>
