SitePoint Sponsor

User Tag List

Results 1 to 11 of 11

Threaded View

  1. #1
    SitePoint Member
    Join Date
    Nov 2012
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Chapter 7 Novice to Ninja

    Hello, Im building teh database in novice to Ninja and am getting stcuk. Im at the authours management part, i have the pages set up, its cycles through and goes back to the original page, it just doesnt want to add or edit an author, only delete works. Any ideas, ive ripped the code from the book and wrote it out myself. What can I be missing that wont edit or added to the daatabse? but it will delete.

    Thanks

    PHP Code:
    <?php
    include_once $_SERVER['DOCUMENT_ROOT'] .
        
    '/paranoiddb/includes/magicquotes.inc.php';

    if (isset(
    $_GET['add']))
    {
      
    $pageTitle 'New Band';
      
    $action 'addform';
      
    $name '';
      
    $email '';
      
    $id '';
      
    $button 'Add Band';

      include 
    'form.html.php';
      exit();
    }

    if (isset(
    $_GET['addform']))
    {
      include 
    $_SERVER['DOCUMENT_ROOT'] . '/paranoiddb/includes/db.inc.php';

      try
      {
        
    $sql 'INSERT INTO band SET
            name = :name,
            email = :email'
    ;
        
    $s $pdo->prepare($sql);
        
    $s->bindValue(':name'$_POST['name']);
        
    $s->bindValue(':email'$_POST['email']);
        
    $s->execute();
      }
      catch (
    PDOException $e)
      {
        
    $error 'Error adding submitted author.';
        include 
    'error.html.php';
        exit();
      }

      
    header('Location:.');
      exit();
    }

    if (isset(
    $_POST['action']) and $_POST['action'] == 'Edit')
    {
      include 
    $_SERVER['DOCUMENT_ROOT'] . '/paranoiddb/includes/db.inc.php';

      try
      {
        
    $sql 'SELECT id, name, email FROM band WHERE id = :id';
        
    $s $pdo->prepare($sql);
        
    $s->bindValue(':id'$_POST['id']);
        
    $s->execute();
      }
      catch (
    PDOException $e)
      {
        
    $error 'Error fetching author details.';
        include 
    'error.html.php';
        exit();
      }

      
    $row $s->fetch();

      
    $pageTitle 'Edit Band';
      
    $action 'editform';
      
    $name $row['name'];
      
    $email $row['email'];
      
    $id $row['id'];
      
    $button 'Update band';

      include 
    'form.html.php';
      exit();
    }

    if (isset(
    $_GET['editform']))
    {
      include 
    $_SERVER['DOCUMENT_ROOT'] .'/paranoiddb/includes/db.inc.php';

      try
      {
        
    $sql 'UPDATE band SET
            name = :name,
            email = :email
            WHERE id = :id'
    ;
        
    $s $pdo->prepare($sql);
        
    $s->bindValue(':id'$_POST['id']);
        
    $s->bindValue(':name'$_POST['name']);
        
    $s->bindValue(':email'$_POST['email']);
        
    $s->execute();
      }
      catch (
    PDOException $e)
      {
        
    $error 'Error updating submitted author.';
        include 
    'error.html.php';
        exit();
      }

      
    header('Location: .');
      exit();
    }

    if (isset(
    $_POST['action']) and $_POST['action'] == 'Delete')
    {
      include 
    $_SERVER['DOCUMENT_ROOT'] . '/paranoiddb/includes/db.inc.php';

      
    // Get jokes belonging to author
      
    try
      {
        
    $sql 'SELECT id FROM video WHERE bandid = :id';
        
    $s $pdo->prepare($sql);
        
    $s->bindValue(':id'$_POST['id']);
        
    $s->execute();
      }
      catch (
    PDOException $e)
      {
        
    $error 'Error getting list of jokes to delete.';
        include 
    'error.html.php';
        exit();
      }

      
    $result $s->fetchAll();

      
    // Delete joke category entries
      
    try
      {
        
    $sql 'DELETE FROM videocategory WHERE videoid = :id';
        
    $s $pdo->prepare($sql);

        
    // For each joke
        
    foreach ($result as $row)
        {
          
    $videoId $row['id'];
          
    $s->bindValue(':id'$videoId);
          
    $s->execute();
        }
      }
      catch (
    PDOException $e)
      {
        
    $error 'Error deleting category entries for joke.';
        include 
    'error.html.php';
        exit();
      }

      
    // Delete jokes belonging to author
      
    try
      {
        
    $sql 'DELETE FROM video WHERE bandid = :id';
        
    $s $pdo->prepare($sql);
        
    $s->bindValue(':id'$_POST['id']);
        
    $s->execute();
      }
      catch (
    PDOException $e)
      {
        
    $error 'Error deleting jokes for author.';
        include 
    'error.html.php';
        exit();
      }

      
    // Delete the author
      
    try
      {
        
    $sql 'DELETE FROM band WHERE id = :id';
        
    $s $pdo->prepare($sql);
        
    $s->bindValue(':id'$_POST['id']);
        
    $s->execute();
      }
      catch (
    PDOException $e)
      {
        
    $error 'Error deleting author.';
        include 
    'error.html.php';
        exit();
      }

      
    header('Location: .');
      exit();
    }

    // Display author list
    include $_SERVER['DOCUMENT_ROOT'] . '/paranoiddb/includes/db.inc.php';

    try
    {
      
    $result $pdo->query('SELECT id, name FROM band ');
    }
    catch (
    PDOException $e)
    {
      
    $error 'Error fetching authors from the database!';
      include 
    'error.html.php';
      exit();
    }

    foreach (
    $result as $row)
    {
      
    $bands[] = array('id' => $row['id'], 'name' => $row['name']);
    }

    include 
    'bands.html.php';

    ?>
    Last edited by paul_wilkins; Nov 9, 2012 at 02:38. Reason: add [php] tags


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •