PHP MYSQL HTML
(quick guide & example)
order_id name email qty
INTEGER PRIMARY KEY VARCHAR VARCHAR INTEGER
<form method="post" target="_self"> <input type="text" name="name"> <input type="email" name="email"> <input type="number" name="qty""> <input type="submit" value="GO!"> </form>
CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8mb4", USER, PASSWORD);
SAVE INTO DATABASE $stmt = $pdo->prepare("INSERT INTO `orders` (`name`, `email`, `qty`) VALUES (?,?,?)"); $stmt->execute([$_POST["name"], $_POST["email"], $_POST["qty"]]);