File: fwphp/01mater/fw_popel/B1_cre_upd.php

Recommend this page to a friend!
  Classes of Slavko Srakocic  >  B12 PHP FW  >  fwphp/01mater/fw_popel/B1_cre_upd.php  >  Download  
File: fwphp/01mater/fw_popel/B1_cre_upd.php
Role: Example script
Content type: text/plain
Description: Example script
Class: B12 PHP FW
Manage database records with a PDO CRUD interface
Author: By
Last change:
Date: 1 month ago
Size: 3,040 bytes
 

Contents

Class file image Download
<?php
// J:\awww\apl\dev1\z30GB\04knjige\02popel\ch7books_in_out\B1_cre_upd.php
/**
* Page to add or edit an Block1 record
*/
include('common.inc.php');

// See if we have the author ID passed in the request
if (isset($_REQUEST['author'])) $id = (int)$_REQUEST['author'];
else
$id = '';
if(
$id) {
 
// U P D A T E
  // We have the ID, get the author details from the table
 
$q = $conn->query("SELECT * FROM authors WHERE id=$id");
 
$author = $q->fetch(PDO::FETCH_ASSOC);
 
$q->closeCursor();
 
$q = null;
}
else {
 
// C R E A T E
 
$author = array();
}
// See if the form was submitted
$warnings = array();
if(isset(
$_POST['submit']) and $_POST['submit'])
{
 
// Validate every field
 
$warnings = array();
 
// First name should be non-empty
 
if(!$_POST['firstName']) {
 
$warnings[] = 'Please enter first name';
  }
 
// Last name should be non-empty
 
if(!$_POST['lastName']) {
 
$warnings[] = 'Please enter last name';
  }
 
// Bio should be non-empty
 
if(!$_POST['bio']) {
   
$warnings[] = 'Please enter bio';
  }
 
// If there are no errors, we can update the database
  // If there was book ID passed, update that book
 
if(count($warnings) == 0) {
    if(@
$author['id']) {
   
$sql = "UPDATE authors SET firstName=" .
   
$conn->quote($_POST['firstName']) .
   
', lastName=' . $conn->quote($_POST['lastName']) .
   
', bio=' . $conn->quote($_POST['bio']) .
   
" WHERE id=$author[id]";
    }
    else {
   
$sql = "INSERT INTO authors(firstName, lastName, bio) VALUES(" .
   
$conn->quote($_POST['firstName']) .
   
', ' . $conn->quote($_POST['lastName']) .
   
', ' . $conn->quote($_POST['bio']) .
   
')';
    }
   
$conn->query($sql);
   
//header("Location: B1_tbl.php");
   
header("Location: index.php?p=b1_tbl");
    exit;
  }
}
else {
 
// Form was not submitted.
  // Populate the $_POST array with the author's details
 
$_POST = $author;
}
//
showHdr('Edit Author');
// If we have any w arnings, display them now
if(count($warnings)) {
  echo
"<b>Please correct these errors:</b><br>";
  foreach(
$warnings as $w) {
     echo
"- ", htmlspecialchars($w), "<br>";
  }
}
// Display f o r m
?>
<form action="B1_cre_upd.php" method="post">
  <table border="1" cellpadding="3">
    <tr>
    <td>First name</td>
    <td>
    <input type="text" name="firstName"
    value="<?=(isset($_POST['firstName']))?htmlspecialchars($_POST['firstName']):''?>">
    </td>
    </tr>
    <tr>
    <td>Last name</td>
    <td>
    <input type="text" name="lastName"
    value="<?=(isset($_POST['lastName']))?htmlspecialchars($_POST['lastName']):''?>">
    </td>
    </tr>
    <tr>
    <td>Bio</td>
    <td>
    <textarea name="bio"><?=(isset($_POST['bio']))?htmlspecialchars($_POST['bio']):''?>
</textarea>
    </td>
    </tr>
    <tr>
    <td colspan="2" align="center">
    <input type="submit" name="submit" value="Save">
    </td>
    </tr>
  </table>
  <?php if(@$author['id']) { ?>
<input type="hidden" name="author" value="<?=$author['id']?>">
  <?php } ?>
</form>
<?php
// Display footer
showFtr(__FILE__);






For more information send a message to info at phpclasses dot org.