Learning PHP and MySQL

Monday, September 25, 2006

Example 12-12 Displaying the authors in a list

<?php require_once('db_login.php'); require_once('DB.php');
$connection  =  DB::connect("mysql://$db_username:$db_password@$db_host/$db_database");
if  (DB::isError($connection)){
die  ("Could  not  connect  to  the  database:  <br  />".  DB::errorMessage($connection));
}
//  Display  the  table
$query  =  "SELECT  *  FROM  `books`";
$result  =  $connection->query($query);
if  (DB::isError($result)){
die("Could  not  query  the  database:  <br  />".$query."  ".DB::errorMessage($result));
}
echo  '<table  border="1">';
echo  "<tr><th>Title</th><th>Pages</th><th>Authors</th></tr>"; while  ($result_row  =  $result->fetchRow(DB_FETCHMODE_ASSOC))  { echo  "<tr><td>";
echo  htmlentities($result_row["title"])  .  '</td><td>';
echo  htmlentities($result_row["pages"])  .  '</td><td>';
$author_query  =  "SELECT  *  FROM  `authors`  WHERE  `title_id`=".$result_row["title_id"];
$author_result  =  $connection->query($author_query);
if  (DB::isError($author_result)){
die("Could  not  query  the  database:  <br  />".$author_query."
".DB::errorMessage($author_result));
}
$author_count  =  $author_result->numRows();
if  (0  ==  $author_count)  {
echo  'none';
}
$counter  =  0;
while  ($author_result_row  =  $author_result->fetchRow(DB_FETCHMODE_ASSOC))  {
$counter++;
echo  htmlentities($author_result_row["author"]);
if  ($counter  !=  $author_count)  {
echo  ',  ';
}
}
echo  '</td></tr>';
}
echo  '</table>';
$connection->disconnect();
?>

Posted by krautgrrl on 09/25 at 11:19 AM
Chapter 12 Code • (5) Comments • (319) Trackbacks • Permalink

Example 12-2 Dropping the purchases table in drop.php

<?php require_once('db_login.php'); require_once('DB.php');
$connection  =  DB::connect("mysql://$db_username:$db_password@$db_host/$db_database");
if  (DB::isError($connection)){
die  ("Could  not  connect  to  the  database:  <br  />".  DB::errorMessage($connection));
}
$query  =  "DROP  TABLE  `purchases`";
$result  =  $connection->query($query);
if  (DB::isError($result)){
die("Could  not  query  the  database:  <br  />".  $query."  ".DB::errorMessage($result));
}
echo  "Table  dropped  successfully!";
$connection->disconnect();
?>

Example 12-2 returns:

Table dropped successfully!

Posted by krautgrrl on 09/25 at 10:51 AM
Chapter 12 Code • (0) Comments • (2754) Trackbacks • Permalink

Example 12-3 Using a predefined INSERT statement in insert.php

<?php require_once('db_login.php'); require_once('DB.php');
$connection  =  DB::connect("mysql://$db_username:$db_password@$db_host/$db_database");
if  (DB::isError($connection)){
die  ("Could  not  connect  to  the  database:  <br  />".  DB::errorMessage($connection));
}
$query  =  "INSERT  INTO  `purchases`  VALUES  (NULL,'mdavis',2,NULL)";
$result  =  $connection->query($query);
if  (DB::isError($result)){
die("Could  not  query  the  database:  <br  />".  $query."  ".DB::errorMessage($result));
}
echo  "Inserted  successfully!";
$connection->disconnect();
?>

When you call up insert.php, in your browser, you get:

Inserted successfully!

Posted by krautgrrl on 09/25 at 10:53 AM
Chapter 12 Code • (2) Comments • (179) Trackbacks • Permalink

Example 12-4 Using embedded links to provide a purchase button in pear_purchase_example.php

<?php require_once('db_login.php'); require_once('DB.php');
$connection  =  DB::connect("mysql://$db_username:$db_password@$db_host/$db_database");
if  (DB::isError($connection)){
die  ("Could  not  connect  to  the  database:  <br  />".  DB::errorMessage($connection));
}
$query  =  "SELECT  *  FROM  `books`";
$result  =  $connection->query($query);
if  (DB::isError($result)){
die("Could  not  query  the  database:  <br  />".  $query."  ".DB::errorMessage($result));
}
echo  '<table  border="1">';
echo  "<tr><th>Title</th><th>Pages</th><th>Buy</th></tr>";
while  ($result_row  =  $result->fetchRow(DB_FETCHMODE_ASSOC))  {
echo  "<tr><td>";
echo  $result_row["title"]  .  '</td><td>';
echo  $result_row["pages"]  .  '</td><td>';
echo  '<a  href="purchase.php?title_id='.$result_row["title_id"].'">Click to  purchase</a></td></tr>';
}
echo  "</table>";
$connection->disconnect();
?>

Posted by krautgrrl on 09/25 at 10:54 AM
Chapter 12 Code • (0) Comments • (0) Trackbacks • Permalink

Example 12-5 The file purchase.php processes the user action based on the title_id parameter

<?php
require_once('db_login.php');
require_once('DB.php');
$connection  =  DB::connect("mysql://$db_username:$db_password@$db_host/$db_database");
if  (DB::isError($connection)){
die  ("Could  not  connect  to  the  database:  <br  />".  DB::errorMessage($connection));
}
$title_id  =  $_GET["title_id"];
$user_id  =  'mdavis';
$query  =  "INSERT  INTO  `purchases`  VALUES  (NULL,'$user_id',$title_id,NULL)";
$result  =  $connection->query($query);
if  (DB::isError($result)){
die("Could  not  query  the  database:  <br  />".  $query."  ".DB::errorMessage($result));
}
?>
<html>
<head>
<title>Thanks  for  your  purchase!</title>
<meta  http-equiv="refresh"  content="4;  url=pear_purchase_example.php">
</head>
<body>
Thanks  for  your  purchase!<br  />
<?php

$query  =  "SELECT  *  FROM  purchases  NATURAL  JOIN  books  NATURAL  JOIN  authors";
$result  =  $connection->query($query);
if  (DB::isError($result)){
die("Could  not  query  the  database:  <br  />".  $query."  ".DB::errorMessage($result));
}
echo  '<table  border="1">';
echo  "<tr><th>User</th><th>Title</th><th>Pages</th>";
echo  "<th>Author</th><th>Purchased</th></tr>";
while  ($result_row  =  $result->fetchRow(DB_FETCHMODE_ASSOC))  {
echo  "<tr><td>";
echo  $result_row["user_id"]  .  '</td><td>';
echo  $result_row["title"]  .  '</td><td>';
echo  $result_row["pages"]  .  '</td><td>';
echo  $result_row["author"]  .  "</td><td>";
echo  $result_row["purchased"]  .  "</td></tr>";
}
echo  "</table>";

$connection->disconnect();
?>
</body>
</html>

Posted by krautgrrl on 09/25 at 10:56 AM
Chapter 12 Code • (2) Comments • (3) Trackbacks • Permalink

Example 12-6 Using input from a form to add a title

<?php
//  Define  a  function  to  perform  the  database  insert  and  display  the  titles function  insert_db($title,  $pages){
require_once('db_login.php');
require_once('DB.php');
$connection  =  DB::connect("mysql://$db_username:$db_password@$db_host/$db_database");
if  (DB::isError($connection)){
die  ("Could  not  connect  to  the  database:  <br  />".  DB::errorMessage($connection));
}
//  The  query  includes  the  form  sumbission  values  that  were  passed  to  the  function
$query  =  "INSERT  INTO  `books`  VALUES  (NULL,'$title','$pages')";
$result  =  $connection->query($query);
if  (DB::isError($result)){
die("Could  not  query  the  database:  <br  />".  $query."  ".DB::errorMessage($result));
}
echo  "Inserted  OK.<br  />";
//  Display  the  table
$query  =  "SELECT  *  FROM  `books`";
$result  =  $connection->query($query);
if  (DB::isError($result)){
die("Could  not  query  the  database:  <br  />".  $query."  ".DB::errorMessage($result));
}
echo  '<table  border="1">';
echo  "<tr><th>Title</th><th>Pages</th></tr>";
while  ($result_row  =  $result->fetchRow(DB_FETCHMODE_ASSOC))  {
echo  "<tr><td>";
echo  $result_row["title"]  .  '</td><td>';
echo  $result_row["pages"]  .  '</td></tr>';
}
echo  "</table>";
$connection->disconnect();
}

?>
<html>
<head>
<title>Inserting  From  a  Form</title>
</head>
<body>
<?php
//  Retrieve  the  variable  from  the  form  submission
$title  =  $_GET["title"];
$pages  =  $_GET["pages"];
if  (($title  !=  NULL  )  &&  ($pages  !=  NULL)){
insert_db($title,$pages);
}
else  {
//  Display  the  form echo  '
<h1>Enter  a  new  title:</h1>
<form  action="'.$_SERVER["PHP_SELF"].'"  method="GET">
<label> Title:
<input  type="text"  name="title"  id="title"  />
</label>
<label> Pages:
<input  type="text"  name="pages"  id="pages"  />
</label>
<input  type="submit"  value="Go!"  />
</form>';
}
?>
</body>
</html>

Posted by krautgrrl on 09/25 at 11:07 AM
Chapter 12 Code • (15) Comments • (0) Trackbacks • Permalink

Example 12-7 Checking for magic quotes

<?php
if  (get_magic_quotes_gpc())  {
echo  "Magic  quotes  are  enabled.";
}  else  {
echo  "Magic  quotes  are  disabled.";
}
?>

The script should return:

Magic quotes are enabled.

Posted by krautgrrl on 09/25 at 11:10 AM
Chapter 12 Code • (0) Comments • (233) Trackbacks • Permalink

Example 12-8 Updating a field

<?php require_once('db_login.php'); require_once('DB.php');
$connection  =  DB::connect("mysql://$db_username:$db_password@$db_host/$db_database");
if  (DB::isError($connection)){
die  ("Could  not  connect  to  the  database:  <br  />".  DB::errorMessage($connection));
}
$query  =  "UPDATE  `books`  SET  `pages`=558  WHERE  `title_id`=2";
$result  =  $connection->query($query);
if  (DB::isError($result)){
die("Could  not  query  the  database:  <br  />".$query."  ".DB::errorMessage($result));
}
echo  "Updated  successfully!";
$connection->disconnect();
?>

Posted by krautgrrl on 09/25 at 11:16 AM
Chapter 12 Code • (0) Comments • (0) Trackbacks • Permalink

Example 12-9 Providing a link to delete a purchase in deletion_link.php

<?php require_once('db_login.php'); require_once('DB.php');
$connection  =  DB::connect("mysql://$db_username:$db_password@$db_host/$db_database");
if  (DB::isError($connection)){
die  ("Could  not  connect  to  the  database:  <br  />".  DB::errorMessage($connection));
}
$query  =  "SELECT  *  FROM  `purchases`  NATURAL  JOIN  `books`";
$result  =  $connection->query($query);
if  (DB::isError($result)){
die("Could  not  query  the  database:  <br  />".$query."  ".DB::errorMessage($result));
}
echo  '<table  border="1">';
echo  "<tr><th>User</th><th>Title</th><th>Purchased</th><th>Remove</th></tr>";
while  ($result_row  =  $result->fetchRow(DB_FETCHMODE_ASSOC))  {
echo  "<tr><td>";
echo  $result_row["user_id"]  .  '</td><td>';
echo  $result_row["title"]  .  '</td><td>';
echo  $result_row["purchased"]  .  '</td><td>';
echo  '<a  href="delete.php?purchase_id='.$result_row["purchase_id"].'">Click  to remove  from  purchases</a></td></tr>';
}
echo  '</table>';
$connection->disconnect();
?>

Posted by krautgrrl on 09/25 at 11:17 AM
Chapter 12 Code • (0) Comments • (0) Trackbacks • Permalink

Example 13-1 Creating a cookie

<?php
//remember  that  setcookie  must  come  before  any  other  line  that  generates  output setcookie("username","michele");
echo  'Cookie  created.';
?>

Posted by krautgrrl on 09/25 at 11:20 AM
Chapter 13 Code • (0) Comments • (3) Trackbacks • Permalink

Example 13-10 Simply starting a session

<?php session_start();
?>

Posted by krautgrrl on 09/25 at 11:32 AM
Chapter 13 Code • (0) Comments • (258) Trackbacks • Permalink

Example 13-11 Registering a variable with session_register

<?php
//DON'T  USE  THIS  APPROACH session_start(); session_register("hello");
$hello  =  "Hello  World";
?>

Modern PHP interpreters return a warning with this code:

Warning:  Unknown():  Your  script  possibly  relies  on  a  session  side-effect  which existed  until  PHP  4.2.3.  Please  be  advised  that  the  session  extension  does  not consider  global  variables  as  a  source  of  data,  unless  register_globals  is  enabled. You  can  disable  this  functionality  and  this  warning  by  setting
session.bug_compat_42  or  session.bug_compat_warn  to  off,  respectively.  in  Unknown on  line  0

Posted by krautgrrl on 09/25 at 11:33 AM
Chapter 13 Code • (0) Comments • (1) Trackbacks • Permalink

Example 13-12 Registering a variable by including it in $_SESSION

<?php session_start();
$_SESSION['hello']  =  'Hello  World';
echo  $_SESSION['hello'];
?>

Posted by krautgrrl on 09/25 at 11:35 AM
Chapter 13 Code • (0) Comments • (0) Trackbacks • Permalink

Example 13-13 Referencing a variable set on a prior page in the session

<?php session_start();
echo  $_SESSION['hello'];
?>

Posted by krautgrrl on 09/25 at 11:36 AM
Chapter 13 Code • (0) Comments • (0) Trackbacks • Permalink

Example 13-14 Checking to see whether a user is valid

<?php 
session_start();
require_once('db_login.php');
require_once('DB.php');
if  (empty($_SESSION['user_id']))  {
if  (!isset($_SERVER['PHP_AUTH_USER'])  ||  !isset($_SERVER['PHP_AUTH_PW']))  {
header('WWW-Authenticate:  Basic  realm="Member  Area"');
header("HTTP/1.0  401  Unauthorized");
echo  "You  must  enter  in  a  username  and  password  combination!";
exit;
}
$connection  =  DB::connect("mysql://$db_username:$db_password@$db_host/$db_database");
if  (DB::isError($connection)){
die  ("Could  not  connect  to  the  database:  <br  />".  DB::errorMessage($connection));
}
$username  =  mysql_real_escape_string($_SERVER['PHP_AUTH_USER']);
$password  =  mysql_real_escape_string($_SERVER['PHP_AUTH_PW']);
$query  =  "SELECT  `user_id`,  `username`  FROM  `users`  WHERE
`username`='".$username."'  AND  `password`=MD5('".$password."')  LIMIT  1";
$result  =  $connection->query($query);
if(!($row  =  $result->fetchRow(DB_FETCHMODE_ASSOC)))  { header('WWW-Authenticate:  Basic  realm="Member  Area"'); header("HTTP/1.0  401  Unauthorized");
echo  "Your  username  and  password  combination  was  incorrect!";
exit;
}
$_SESSION['user_id']  =  $row['user_id'];
$_SESSION['username']  =  $row['username'];
}
echo  "You  have  successfully  logged  in  as  ".$_SESSION["username"].".";
?>

Posted by krautgrrl on 09/25 at 11:43 AM
Chapter 13 Code • (26) Comments • (30) Trackbacks • Permalink

Page 11 of 15 pages « First < 9 10 11 12 13 > Last »

Statistics

This page has been viewed 375170 times
Page rendered in 0.2587 seconds
Total Entries: 224
Total Comments: 16
Total Trackbacks: 307338
Most Recent Entry: 09/27/2006 12:39 pm
Most Recent Comment on: 10/26/2007 10:00 am
Total Members: 2
Total Logged in members: 0
Total guests: 8
Total anonymous users: 0
Most Recent Visitor on: 02/10/2012 09:09 am
The most visitors ever was 1103 on 11/20/2007 12:50 pm

Referrers