loadResult()
Query: "SELECT first_name FROM formula1_drivers WHERE id = 1"
Returns:Max
loadColumn()
Query: "SELECT first_name FROM formula1_drivers WHERE id <= 3"
Returns:Array ( [0] => Max [1] => Sergio [2] => Charles )
loadRowList()
Query: "SELECT * FROM formula1_drivers WHERE id <= 3"
Returns:Array ( [0] => Array ( [0] => 1 [1] => 2022-06-15 21:33:18 [2] => Max [3] => Verstappen [4] => 24 [5] => Dutch [6] => Max Verstappen [7] => 9 [8] => 4 [9] => 149 [10] => 1 [11] => 25 [12] => 66 [13] => 1707.5 [14] => 14 [15] => 18 [16] => 2005 ) [1] => Array ( [0] => 2 [1] => 2022-06-15 21:38:34 [2] => Sergio [3] => Perez [4] => 32 [5] => Mexican [6] => Sergio Perez [7] => 9 [8] => 4 [9] => 225 [10] => 0 [11] => 3 [12] => 20 [13] => 1025 [14] => 1 [15] => 8 [16] => 2005 ) [2] => Array ( [0] => 3 [1] => 2022-06-15 21:39:13 [2] => Charles [3] => Leclerc [4] => 24 [5] => Monegasque [6] => Charles Leclerc [7] => 5 [8] => 2 [9] => 89 [10] => 0 [11] => 4 [12] => 17 [13] => 676 [14] => 15 [15] => 7 [16] => 1950 ) )
loadAssocList()
Query: "SELECT * FROM formula1_drivers WHERE id <= 3"
Returns:Array ( [0] => Array ( [id] => 1 [date_time] => 2022-06-15 21:33:18 [first_name] => Max [last_name] => Verstappen [age] => 24 [nationality] => Dutch [full_name] => Max Verstappen [team_id] => 9 [team_principal] => 4 [races] => 149 [championships] => 1 [wins] => 25 [podiums] => 66 [career_points] => 1707.5 [pole_positions] => 14 [fastest_laps] => 18 [calc_php] => 2005 ) [1] => Array ( [id] => 2 [date_time] => 2022-06-15 21:38:34 [first_name] => Sergio [last_name] => Perez [age] => 32 [nationality] => Mexican [full_name] => Sergio Perez [team_id] => 9 [team_principal] => 4 [races] => 225 [championships] => 0 [wins] => 3 [podiums] => 20 [career_points] => 1025 [pole_positions] => 1 [fastest_laps] => 8 [calc_php] => 2005 ) [2] => Array ( [id] => 3 [date_time] => 2022-06-15 21:39:13 [first_name] => Charles [last_name] => Leclerc [age] => 24 [nationality] => Monegasque [full_name] => Charles Leclerc [team_id] => 5 [team_principal] => 2 [races] => 89 [championships] => 0 [wins] => 4 [podiums] => 17 [career_points] => 676 [pole_positions] => 15 [fastest_laps] => 7 [calc_php] => 1950 ) )
json_encode: [{"id":1,"date_time":"2022-06-15 21:33:18","first_name":"Max","last_name":"Verstappen","age":"24","nationality":"Dutch","full_name":"Max Verstappen","team_id":9,"team_principal":4,"races":149,"championships":"1","wins":25,"podiums":"66","career_points":"1707.5","pole_positions":"14","fastest_laps":"18","calc_php":"2005"},{"id":2,"date_time":"2022-06-15 21:38:34","first_name":"Sergio","last_name":"Perez","age":"32","nationality":"Mexican","full_name":"Sergio Perez","team_id":9,"team_principal":4,"races":225,"championships":"0","wins":3,"podiums":"20","career_points":"1025","pole_positions":"1","fastest_laps":"8","calc_php":"2005"},{"id":3,"date_time":"2022-06-15 21:39:13","first_name":"Charles","last_name":"Leclerc","age":"24","nationality":"Monegasque","full_name":"Charles Leclerc","team_id":5,"team_principal":2,"races":89,"championships":"0","wins":4,"podiums":"17","career_points":"676","pole_positions":"15","fastest_laps":"7","calc_php":"1950"}]
loadObjectList()
Query: "SELECT * FROM formula1_drivers WHERE id <= 3"
Returns:Array ( [0] => stdClass Object ( [id] => 1 [date_time] => 2022-06-15 21:33:18 [first_name] => Max [last_name] => Verstappen [age] => 24 [nationality] => Dutch [full_name] => Max Verstappen [team_id] => 9 [team_principal] => 4 [races] => 149 [championships] => 1 [wins] => 25 [podiums] => 66 [career_points] => 1707.5 [pole_positions] => 14 [fastest_laps] => 18 [calc_php] => 2005 ) [1] => stdClass Object ( [id] => 2 [date_time] => 2022-06-15 21:38:34 [first_name] => Sergio [last_name] => Perez [age] => 32 [nationality] => Mexican [full_name] => Sergio Perez [team_id] => 9 [team_principal] => 4 [races] => 225 [championships] => 0 [wins] => 3 [podiums] => 20 [career_points] => 1025 [pole_positions] => 1 [fastest_laps] => 8 [calc_php] => 2005 ) [2] => stdClass Object ( [id] => 3 [date_time] => 2022-06-15 21:39:13 [first_name] => Charles [last_name] => Leclerc [age] => 24 [nationality] => Monegasque [full_name] => Charles Leclerc [team_id] => 5 [team_principal] => 2 [races] => 89 [championships] => 0 [wins] => 4 [podiums] => 17 [career_points] => 676 [pole_positions] => 15 [fastest_laps] => 7 [calc_php] => 1950 ) )