Demonstrate reading rows from a table (Students)
Array
(
[0] => 1
[StudentID] => 1
[1] => Fred
[FirstName] => Fred
[2] => Bloggs
[Surname] => Bloggs
[3] => 2008-08-15 14:03:01
[DoB] => 2008-08-15 14:03:01
)
Array
(
[0] => 2
[StudentID] => 2
[1] => Tom
[FirstName] => Tom
[2] => Dickens
[Surname] => Dickens
[3] => 2009-09-09 14:02:01
[DoB] => 2009-09-09 14:02:01
)
Array
(
[0] => 3
[StudentID] => 3
[1] => Harry
[FirstName] => Harry
[2] => Krishna
[Surname] => Krishna
[3] => 2006-03-12 14:02:16
[DoB] => 2006-03-12 14:02:16
)
Array
(
[0] => 4
[StudentID] => 4
[1] => Sally
[FirstName] => Sally
[2] => Cinnamon
[Surname] => Cinnamon
[3] => 2010-12-25 14:02:32
[DoB] => 2010-12-25 14:02:32
)
Showing renaming of $conn to $db and wrapping results in table
| Student ID | Name | Surname | Date of Birth |
|---|
| 1 | Fred | Bloggs | 2008-08-15 14:03:01 |
| 2 | Tom | Dickens | 2009-09-09 14:02:01 |
| 3 | Harry | Krishna | 2006-03-12 14:02:16 |
| 4 | Sally | Cinnamon | 2010-12-25 14:02:32 |