Task 10: MySQL PDO
Check/Create database: Failed.
Connection to Database Successfull.
Check/Create tblTask10: Successfull with 16 rows.
FetchAll Method: All records returned.
--------------------------------------------------------------------------
ID: 1, GENDER: M, AGE: 37, EMPLOYED: YES
ID: 2, GENDER: M, AGE: 63, EMPLOYED: YES
ID: 3, GENDER: F, AGE: 22, EMPLOYED: YES
ID: 4, GENDER: F, AGE: 22, EMPLOYED: NO
ID: 5, GENDER: M, AGE: 34, EMPLOYED: YES
ID: 6, GENDER: F, AGE: 21, EMPLOYED: NO
ID: 7, GENDER: F, AGE: 25, EMPLOYED: YES
ID: 8, GENDER: F, AGE: 42, EMPLOYED: NO
ID: 9, GENDER: M, AGE: 33, EMPLOYED: NO
ID: 10, GENDER: M, AGE: 27, EMPLOYED: YES
ID: 11, GENDER: F, AGE: 24, EMPLOYED: YES
ID: 12, GENDER: M, AGE: 39, EMPLOYED: NO
ID: 13, GENDER: M, AGE: 31, EMPLOYED: YES
ID: 14, GENDER: M, AGE: 28, EMPLOYED: YES
ID: 15, GENDER: F, AGE: 52, EMPLOYED: YES
ID: 16, GENDER: F, AGE: 55, EMPLOYED: NO
16 Rows printed.
--------------------------------------------------------------------------
Named Select: where Minimum age is 35 and Gender is M
--------------------------------------------------------------------------
ID: 1, GENDER: M, AGE: 37, EMPLOYED: YES
ID: 2, GENDER: M, AGE: 63, EMPLOYED: YES
ID: 12, GENDER: M, AGE: 39, EMPLOYED: NO
3 Rows printed.
--------------------------------------------------------------------------
Question Mark Select: where Minimum age is 30 and Gender is F
------------------------------------------------------------------------------------
ID: 8, GENDER: F, AGE: 42, EMPLOYED: NO
ID: 15, GENDER: F, AGE: 52, EMPLOYED: YES
ID: 16, GENDER: F, AGE: 55, EMPLOYED: NO
3 Rows printed.
------------------------------------------------------------------------------------