<?php
// $query = "create table users (
// id INT AUTO_INCREMENT PRIMARY KEY,
// name varchar(100),
// phone varchar(20),
// created_at TIMESTAMP
// )";
// get DB version using PDO
// $stmt = $pdo->prepare($query);
// $stmt->execute();
// foreach ($pdo->query("SHOW TABLES") as $row) {
// print_r( $row );
// }
// $table = 'users';
// $stmt = $pdo->prepare("describe $table");
// $stmt->execute();
// $columns = $stmt->fetchAll(PDO::FETCH_ASSOC);
// print_r($columns);
// $name = "Jeong";
// $phone = "080";
// $table = 'users';
// $stmt = $pdo->prepare("insert into $table (name, phone) values (? ,?) ");
// $stmt->execute([$name, $phone]);
// echo "done";
//////////////////
$stmt = $pdo->prepare("create table products (
id INT AUTO_INCREMENT PRIMARY KEY,
name varchar(100),
price int,
quantity int,
created_at TIMESTAMP
)");
$stmt->execute();
echo "done create";
//////////////////////
$datas = [
["apple", 200, 10],
["orange", 150, 20],
["banana", 100, 5]
];
$stmt = $pdo->prepare("insert into products (name, price, quantity) values (?,?,?)");
foreach ($datas as $data) {
$stmt->execute($data);
}
echo "insert done";