getMessage(); } echo "

SQL Query

"; // SQL statement for creating new tables $statement1 = ' CREATE TABLE EMPLOYEES( ID INT NOT NULL, first_name VARCHAR(100) NOT NULL, last_name VARCHAR(100), age INT NOT NULL, job VARCHAR(50) NOT NULL, salary DECIMAL(6,2) NOT NULL, PRIMARY KEY(ID) );'; // execute SQL statements $pdo->exec($statement1); echo "

Create table

"; echo "

" . $statement1 . "

"; echo "

"; // SQL statement for inserting data $statement2 = " INSERT INTO EMPLOYEES(ID, first_name, last_name, age, job, salary) VALUES (1, 'TONY', 'STARK', 45, 'SOFTWARE ENGINEER', 7902), (2, 'TIM', 'ADOLF', 34, 'SALESMAN', 7698), (3, 'KIM', 'JARVIS', 23, 'MANAGER', 7839), (4, 'SAM', 'MILES', 17, 'SALESMAN', 7698), (5, 'KEVIN', 'HILL', 21, 'MANAGER', 7840), (6, 'CONNIE', 'SMITH', 17, 'ANALYST', 7566), (7, 'ALFRED', 'KINSLEY', 50, 'PRESIDENT', 7566), (8, 'PAUL', 'TIMOTHY', 16, 'SALESMAN', 7698), (9, 'JOHN', 'ASGHAR', 14, 'SOFTWARE ENGINEER', 7788), (10, 'ROSE', 'SUMMERS', 25, 'TECHNICAL LEAD', 7698), (11, 'ANDREW', 'FAULKNER', 16, 'ANAYLYST', 7566), (12, 'KAREN', 'MATTHEWS', 20, 'SOFTWARE ENGINEER', 7782), (13, 'WENDY', 'SHAWN', 23, 'SALESMAN', 7698), (14, 'BELLA', 'SWAN', 38, 'MANAGER', 7860), (15, 'MADII', 'HIMBURY', 15, 'ANALYST', 7850), (16, 'ATHENA', 'WILSON', 16, 'ANALYST', 7910), (17, 'JENNIFER', 'HUETTE', 18, 'ANALYST', 7800);"; // execute SQL statements $pdo->query($statement2); echo "

Insert data

"; echo "

" . $statement2. "

"; echo "

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

Show all data

"; echo "

" . $statement4 . "

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

ID	First Name	Last Name	Age	Job	Salary
" . $row['ID'] . "	" . $row['first_name'] . "	" . $row['last_name'] . "	" . $row['age'] . "	" . $row['job'] . "	" . $row['salary'] . "

"; echo "

"; $statement5 = ' SELECT ID, salary FROM EMPLOYEES WHERE salary BETWEEN 7800 AND 7900; '; $query1 = $pdo->query($statement5); // $query1 = $pdo->prepare($statement5); // $query1->execute(); $result1 = $query1->fetchall(); echo "

Show ID and salary where their salary is between 7800 to 7900

"; echo "

" . $statement5 . "

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

ID	Salary
" . $row['ID'] . "	" . $row['salary'] . "

"; echo "

"; //////////// $statement5 = ' SELECT * FROM EMPLOYEES WHERE age >= 18; '; $query1 = $pdo->query($statement5); // $query1 = $pdo->prepare($statement5); // $query1->execute(); $result1 = $query1->fetchall(); echo "

Show employees' age above or equal to 18

"; echo "

" . $statement5 . "

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

ID	First Name	Last Name	Age	Job	Salary
" . $row['ID'] . "	" . $row['first_name'] . "	" . $row['last_name'] . "	" . $row['age'] . "	" . $row['job'] . "	" . $row['salary'] . "

";

SQL query