build an api with php code example
Example: 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
);