How to create a REST API using PHP code example
Example 1: rest api example php
CREATE TABLE `Transaction` (
`id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
`comment` text,
`price` float,
`quantity` float,
`reason` enum('New Stock','Usable Return','Unusable Return'),
`createdAt` datetime NOT NULL,
`updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`productid` int(11) NOT NULL
);
Example 2: rest api php mysql
<?php include_once('config.php'); $task = isset($_GET['task']) ? mysqli_real_escape_string($conn, $_GET['task']) : ""; $sql = "SELECT * FROM `my_to_do_db`.`my_to_do_tb` WHERE task='{$task}';"; $get_data_query = mysqli_query($conn, $sql) or die(mysqli_error($conn)); if(mysqli_num_rows($get_data_query)!=0){ $result = array(); while($r = mysqli_fetch_array($get_data_query)){ extract($r); $result[] = array("Task" => $task, "Date" => $date, 'Priority' => $priority); } $json = array("status" => 1, "info" => $result); } else{ $json = array("status" => 0, "error" => "To-Do not found!"); }@mysqli_close($conn);