Skip to Main Content
Head Rush Ajax
book

Head Rush Ajax

by Brett McLaughlin
March 2006
Beginner to intermediate content levelBeginner to intermediate
448 pages
13h 33m
English
O'Reilly Media, Inc.
Content preview from Head Rush Ajax
20
Chapter 1
...at a glance
PHP
Here’s a quick look at the PHP that Katie’s using for her Boards app.
Remember, we’re not going to explain how this all works... but here’s what’s
going on when a request is made for updated board sales.
<?php
// Connect to database
$conn = @mysql_connect(“mysql.headrstlabs.com”,
“secret”, “really-secret”);
if (!$conn)
die(“Error connecting to MySQL: “ . mysql_error());
if (!mysql_select_db(“headrst”, $conn))
die(“Error selecting Head First database: “ . mysql_error());
$select = ‘SELECT boardsSold’;
$from = ‘ FROM boardsrus’;
$queryResult = @mysql_query($select . $from);
if (!$queryResult)
die(‘Error retrieving total boards sold from database.’);
while ($row = mysql_fetch_array($queryResult)) {
$totalSold = $row[‘boardsSold’];
}
$price = 249.95;
$cost = 84.22;
$cashPerBoard = $price - $cost;
$cash = $totalSold * $cashPerBoard;
mysql_close($conn);
?>
<html>
<head> <title>Boards ‘R’ Us</title>
<link rel=”stylesheet” type=”text/css” href=”boards.css” />
</head>
<body>
<h1>Boards ‘R’ Us :: Custom Boards Report</h1>
The rst part of the script
makes a connection to the
Boards ‘R’ Us database.
This part of the
script handles
getting the latest
sales totals from
the database.
The amount of prot
on each board is gured
out here.
If you wanted, you
could store these values
in the database, too.
Here comes all that
HTML we’ve been
talking about...
This is bonus credi ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Reinventing the Organization for GenAI and LLMs

Reinventing the Organization for GenAI and LLMs

Ethan Mollick
Head First Ajax

Head First Ajax

Rebecca M. Riordan

Publisher Resources

ISBN: 0596102259Errata PageSupplemental Content