JavaScript - jQuery - Handling JSON Data: Client, Meet Server(PHP,db_connection funcion, database(MySQL))

Head First jQuery
(O'Reilly Media)
Ryan Benedetti(著), Ronan Cranley(著)

開発環境

• OS X Yosemite - Apple (OS)
• Safari, Firefox, Google Chrome(Webプラウザ)
• Emacs (CUI)、BBEdit - Bare Bones Software, Inc.(GUI) (Text Editor)
• JavaScript (プログラミング言語)

Head First jQuery(Ryan Benedetti(著)、Ronan Cranley(著)、O'Reilly Media)のChapter 9(Handling JSON Data: Client, Meet Server)、PHP CODE MAGNETS(No. 4735)を解いてみる。

その他参考書籍

• Head First HTML and CSS
• Head First JavaScript Programming

PHP CODE MAGNETS(No. 4735)

SQL(BBEdit, Emacs)

<?php
$query = "SELECT first_name, last_name, gender, finish_time FROM runners ORDER BY finish_time ASC";
$result = db_connection($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  print_r($result);
}

function db_connection() {
  mysql_connect("127.0.0.1", "runner_db_user", "runner_db_password")
    OR die ("Could not connect to to database.");
  mysql_select_db('hfjq_race_info');  
  return mysql_query($query);
}
?>