getMessage(); } // SQL statement for creating new tables $statement1 = 'CREATE TABLE customers( ID INT NOT NULL, first_name VARCHAR(100) NOT NULL, middle_name VARCHAR(50), last_name VARCHAR(100), PRIMARY KEY(ID) );'; // execute SQL statements $pdo->exec($statement1); echo "

" . $statement1 . "

"; echo "

"; // SQL statement for inserting data $statement2 = 'INSERT INTO customers(ID, first_name, middle_name, last_name) VALUES (1, "Calvin", "R2", "D2");'; // execute SQL statements $pdo->exec($statement2); echo "

" . $statement2. "

"; // SQL statement for inserting data $statement3 = 'INSERT INTO customers(ID, first_name, middle_name, last_name) VALUES (2, "The", "Strongest", "Jedi");'; // execute SQL statements $pdo->exec($statement3); echo "

" . $statement3 . "

"; echo "

"; $statement4 = 'SELECT * FROM customers'; $query = $pdo->prepare($statement4); $query->execute(); $result = $query->fetchall(); echo "

" . $statement4 . "

"; // var_dump($result); echo "" ; foreach($result as $row) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; echo "

ID	First Name	Middle Name	Last Name
" . $row['ID'] . "	" . $row['first_name'] . "	" . $row['middle_name'] . "	" . $row['last_name'] . "

SQL Query - CREATE TABLE & INSERT INTO