*************

SQL code: Upload dump Copy Format Clear

CREATE TABLE Orders ( OrderID INT PRIMARY KEY, CustomerID INT, OrderDate DATE, ShipDate DATE, OrderStatus VARCHAR(50) ); INSERT INTO Orders (OrderID, CustomerID, OrderDate, ShipDate, OrderStatus) VALUES (1, 101, '2024-01-05', '2024-01-08', 'Shipped'), (2, 102, '2024-01-10', '2024-01-15', 'Shipped'), (3, 103, '2024-02-02', '2024-02-05', 'Shipped'), (4, 104, '2024-02-10', '2024-02-12', 'Shipped');

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php function createRecord($table, $data) { $columns = implode(", ", array_keys($data)); $values = implode("', '", $data); // PDO or prepared statements are safer for production $sql = "INSERT INTO $table ($columns) VALUES ('$values')"; $result = $mysqli->query($sql); if ($result) { return $mysqli->insert_id; // Return newly created ID } else { return false; } } function readRecords($table, $conditions = "") { $sql = "SELECT * FROM $table"; if ($conditions) { $sql .= " WHERE $conditions"; } $result = $mysqli->query($sql); if ($result->num_rows > 0) { return $result->fetch_all(MYSQLI_ASSOC); } else { return false; } } function updateRecord($table, $data, $id) { $columns = array_keys($data); $values = array_map(fn($value) => "'$value'", $data); // PDO or prepared statements for safety $set = array_map(fn($column, $value) => "$column = $value", $columns, $values); $set = implode(", ", $set); $sql = "UPDATE $table SET $set WHERE id = $id"; $result = $mysqli->query($sql); return $result; } function deleteRecord($table, $id) { $sql = "DELETE FROM $table WHERE id = $id"; $result = $mysqli->query($sql); return $result; } echo readRecords("Orders") ?>

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online