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
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';
?>