Hi! Could we please enable some services and cookies to improve your experience and our website?

PHPize Online / SQLize Online  /  SQLtest Online

A A A
Login    Share code      Blog   FAQ

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Copy Format Clear
CREATE TABLE menu (`mid` int, `parent` varchar(4), `org` int, `item` varchar(8), `price` varchar(3)) ; INSERT INTO menu (`mid`, `parent`, `org`, `item`, `price`) VALUES (1, NULL, 1, 'Category', '1'), (2, '1', 1, 'Item 1', '$10'), (3, '1', 1, 'Item 2', '$12'), (4, NULL, 1, 'Category', '2'), (5, '4', 1, 'Item 3', '$12'), (6, '4', 1, 'Item 4', '$90') ;

Stuck with a problem? Got Error? Ask AI support!

Copy Clear
Copy Format Clear
<?php $item = "Item' OR '1' = '1"; $result = mysqli_query($mysqli, "SELECT * FROM menu WHERE item = '$item'"); $rows = $result->fetch_all(MYSQLI_ASSOC); echo json_encode($rows, JSON_NUMERIC_CHECK);
Copy Clear