I am the records file

“;

//SELECT ALL FIELDS FROM TABLE

#$sqlQuery = “SELECT * FROM robert1_dwarves where 1″;
#$sqlQuery = “SELECT *FROM robert1_dwarves where zid=3″;
$sqlQuery = “SELECT zid, name, concat(sha1(name),\”.doc\”) as uid, colour FROM robert1_dwarves where 1″;

echo “

Query is:
$sqlQuery

“;

//Assign result of the query to a variable
//this just indicates if it was valid or not
$result = mysql_query($sqlQuery);

if (!$result) {

}

$numRows = mysql_num_rows($result);

echo “

Number of records returned is: $numRows

“;

output_table_header();

while ( $record = mysql_fetch_assoc($result) ) {

output_row_start();
output_cell($record[’zid’]);
output_cell($record[’name’]);
output_cell($record[’colour’]);
output_cell($record[’uid’]);
output_row_end();
}

output_table_footer();
?>

if($link_id) {
 echo “<p>Successful Connection</p>”;
}
 else {
 echo “<p>Unsuccessful Connection!</p>”;
}
if ( mysql_select_db(DB_CLIENT_DATABASE,$link_id) ) {
 echo “<p>Successful Database Selection</p>”;

} else {
die( “<p>Successful Database Selection</p>” );

}

//echo “<p>” . $_SERVER[’HTTP_HOST’];

function getPages() {

return array(”main”,”conversations”,”");

}

if ($_SERVER[’HTTP_HOST’]==DB_CLIENT_HOST) {

$link_id=@mysql_connect(DB_CLIENT_SERVER,DB_CLIENT_USER,DB_CLIENT_PASSWORD);

if($link_id) {
//echo “Successful Connection”;
}

if(mysql_select_db(DB_CLIENT_DATABASE,$link_id)) {
//echo “<p>Connection to art site success”;
} else {

//echo “<p>Connection to art db not a success”;
}

}

dbconnect.inc.php

login.php
 include_once(”config.inc.php”)
 include_once(”dbconnect.inc.php”)
 include_once(”foos.inc.php”)
 session_start()
 
 $formName= generateFormname(FORM_LOGIN);
 
 if ( !isset($_POST[’formID’]) ||
      !isset($_POST[’fieldName’]) ||
      !isset($_POST[’fieldPassword’]) ||
     strlen(trim($_POST[’fieldName’]))==0 ||
     strlen(trim($_POST[’fieldPassword’]))==0 ||
     $_POST[’formID’] != $formName
    
    
    
     ) {
  echo display_login_form();
  exit;
 } else {
 
 $cleanName=htmlspecialchars($_POST[’fieldName’])
 $cleanPasword=htmlspecialchars($_POST[’fieldPassword’])
 
 
 
   if (   !boolValidateLogin($cleanName, $cleanPassword) ) {
     $_SESSION=array(); //clear any session variables
     session_destroy();
    echo display_login_form();
  
  
   } else {
  
  
    //echo “Logging in….”;
    $_SESSION[’loggedIn’]=1;
    header(”location: index.php”);
  
  
   } // else
 
 
 
 } // else valid fields posted
 
 
 
 
  fieldName
  fieldPassword
  login.php
  post
 
 
 
 
 
index.php
 session_start()
 define(”INDEX_PAGEx”,1);
 
 if(!isset($_SESSION[’loggedIn’]) {
 
 header(”location: login.php”);
 
 }
 
 echo “This is index.php”;
 echo “<a href=’logout.php’>Logout</a>”;
 
 
 
foos.inc.php
if(!defined(
INDEX_PAGE)) exit;
 function display_login_form() {
 
 $formName= generateFormname(FORM_LOGIN);
 
 
 <input type=’hidden’ name=’formID’ value=’$formName’ />
 
 
 }
 
 
 
 function generateFormname($formName) {
 
 
 
 
  return sha1($formName . date(”mdy”));
  
  
  
 
 
 }
 
 
 function trace($message) {
 
  if( DEBUG_ON) {
   echo “<p>$message</p>”;
  }
 
 }
 
 
 function boolValidateLogin($userName, $userPassword) {
 
 
 
 $sqlQuery = “SELECT * from ” . TABLE_USER .
            ” WHERE ” .
            FIELD_NAME .
            “=’$userName’ AND ” .
            FIELD_PASSWORD .
            “=’$userPassword’”;
 trace($sqlQuery);
 
 if (! $result = mysql_query($sqlQuery) ) {
 
  die(”Unable to execute query ” . mysql_error());
 
 } else {
 
  if (mysql_num_rows($result) == 1 {
  
  return 1;
  
  } else {
  
  return 0;
  
  }
 
 }
 
 exit;
 
 
 return 0;
 
 }
 
logout.php
 session_start();
 $_SESSION=array(); //clear any session variables
 session_destroy();
 header(”location: index.php”);
protected.php
 if (!defined(INDEX_PAGE))
  header(”location: index.php”);
  
  
  
  
cart
 Item 1 <a href=’addtocart.php?id=1′>Add to Cart</a>
 
 
 function countCartItems() {
 
 
 return sizeof($_SESSION[’cart’]);
 
 }
 
 
 echo “<p>Items in Cart: ” . countCartItems() . “</p>”;
 
 
 
 function initCart() {
 
 if (!isset($_SESSION[’cart’]))
  $_SESSION[’cart’]=array();
 
 
 
 }
 
 
 initCart();
 
 function add2Cart($id) {
 
 $_SESSION[’cart’][]=$id;
 
 
 
 
 }
 
 add2Cart($_GET[’id’]);
 header(”location: catalog.php”);
 
 
 function showCart() {
 
 $count = countCartItems();
 
 for($i=0; $i < $count; $i++) {
 
 echo “<p>” . $_SESSION[’cart’][$i] . “</p>”;
 
 
 }
 
 
 
 
 }
 
 
 
 
 function writeImage($filename) {
 
 
 
 echo “<img src=’../images/$filename’ />
 
 
 
 
 }

The date select box should be formatted in the form “Monday May 13th 2008″. It should show the next 30 days from the current date.

The  PerformanceTimes select box should show three performance times: 15:00, 20:00 and 21:00.

The Performance Times should be stored as an array and a foreach loop used to display.

The Header is a text input field and should allow for 50 characters. It will handle main title of the performance such as ” Joe Bloggs and his Merry Band”

The Body content is a longer description of the event.

The form is in a page called createevent.php

The form is processed by a page called processevent.php

The form is POSTED

No javascript validation is required

svnadmin create c:/repositories/testing

svn import c:\testfolder file:///c:/repositories/testrepos/testing

svn status -v
Lists changes in the system

update DB_TABLE set field2=’y’ WHERE date=’2008-04-28′;

update DB_TABLE set field1=’x’ WHERE name=’John’;

rm -r ??0208 // removes all directories and sub directories etc.

validateuser($cleanName, $cleanPassword);

function validateUser($fieldName, $fieldPassword) {

$sqlQuery = “SELECT * from TABLE_USERS WHERE username = $fieldName AND upassword = $fieldPassword”;

$result = mysql_query();

if(!$result) die(mysql_error());

if ( mysql_num_rows($result) == 1) return 1;

return 0;
}

Create a database with at least 10 users, each with a username and encrypted password.

A user must login in order to view the timetable. Failed logins redirect to the login page.

A logout link must be availalbe. When the user logs out, the program redirects back to the login page.

Date Handling and Theory

Timetable Exercise