March 2006
Beginner to intermediate
448 pages
13h 33m
English
Content preview from Head Rush Ajax
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,
Start your free trial
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.headrstlabs.com”,
“secret”, “really-secret”);
if (!$conn)
die(“Error connecting to MySQL: “ . mysql_error());
if (!mysql_select_db(“headrst”, $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 prot
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 ...