PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table tblEmployee ( Employee_id int auto_increment primary key, Employee_first_name varchar(500) NOT null, Employee_last_name varchar(500) NOT null, Employee_Address varchar(1000), Employee_emailID varchar(500), Employee_department_ID int default 9, Employee_Joining_date date ); SHOW TABLES; INSERT INTO tblEmployee ( employee_first_name, employee_last_name ) values ('Nisarg', 'Upadhyay'), ('Test', 'T2'); select * from tblEmployee;
Copy Clear
Copy Format Clear
<?php printf("Current PHP version: %s \n", phpversion()); $query = "SELECT * FROM tblEmployee"; $stmt = $pdo->prepare($query); $stmt->execute(); $row = $stmt->fetchAll(PDO::FETCH_ASSOC); print_r($row);
Show:  
Copy Clear