- json_decode: documentation ( source)
- end: documentation ( source)
- json_encode: documentation ( source)
- header: documentation ( source)
<?php
include_once 'dbconfig.php';
$method = $_SERVER['REQUEST_METHOD'];
switch($method) {
case 'POST':
$data = json_decode($_POST['params']);
$name = $data['name'];
$sql_query = "INSERT INTO person(name) VALUES('$name')";
$result = mysqli_query($link, $sql_query);
break;
case 'GET':
$uriParts = spliti ("/", $_SERVER['REQUEST_URI']);
$id = end($uriParts);
$sql_query="SELECT * FROM person WHERE id=".$id;
$result_set=mysqli_query($link, $sql_query);
$rows = array();
while($r = mysqli_fetch_assoc($result_set)) {
$rows[] = $r;
}
break;
}
header('Content-type: application/json');
echo json_encode($rows);