Не получается вывести значение поля из таблицы

Рейтинг: -2Ответов: 1Опубликовано: 01.04.2015

Вопрос, конечно, кому-то покажется легким, но у меня никак не получается удалить запись из таблицы не вводя id записи, по идее при нажатии delete record, должно возвращать id т.е. указывает на запись которую собираюсь удалить. Вот код:

<?php
require_once 'inc/init.inc.php';
if (isset($_REQUEST['Submit'])) {
try
{   
    $BookID=$_POST['BookID'];
    $book->deleterecord($BookID);

    $result =$book->allbook();
    $count=count($result);
    if ($count>0)
    {
     $edit=true;

     displaybook($result, $edit);
    }
     else exit ("<br>There are no books to view!");
}
catch (PDOException $e)
{

   echo 'Error: ' . $e->getMessage().'</p>';
}
}
else {
$BookID = $_GET['BookID'];
try
 {

    $book = $book->onebook($BookID);
    $BookID= $book['BookID'];
    $Category = $book['Category'];
    $Title= $book['Title'];
    $Author=$book['Author'];
    $Publisher=$book['Publisher'];
    $Synopsis=$book['Synopsis'];
    $PageNum=$book['PageNum'];
    $PubDate=$book['PubDate'];
    $ReleaseDate=$book['ReleaseDate'];
    $Price=$book['Price'];
 }
 catch (PDOException $e)
 {
   echo '<br>PDO Exception Caught.';
   echo 'Error with the database: <br>';
   echo 'SQL Query: ', $sql;
   echo 'Error: ' . $e->getMessage().'</p>';
 }
?>
</p>


<form action = "" method = "post" id = "bookentry" class="form-horizontal">
    <fieldset><legend>Delete a Book Record</legend>
       <div class ="form-group">
       <label for="BookID" class="col-sm-2 control-label">BookID</label>
       <div class="col-sm-10">
        <input type="text" name="BookID" id="BookID"  class="form-control"  maxlength="9" readonly value = "<?php echo $BookID ?>">
       </div>
     </div>

         <div class ="form-group">
       <label for="Category" class="col-sm-2 control-label">Category</label>
       <div class="col-sm-10">
        <input type="text" name="Category" id="Category"   class="form-control"  value = "<?php echo $Category; ?>">
       </div>
     </div>

     <div class ="form-group">
       <label for="Title" class="col-sm-2 control-label">Title</label>
       <div class="col-sm-10">
        <input type="text" name="Title" id="Title"  class="form-control"    readonly value = "<?php echo $Title; ?>">
       </div>
     </div>


     <div class ="form-group">
       <label for="Author" class="col-sm-2 control-label">Author</label>
       <div class="col-sm-10">
        <input type="text" name="Author" id="Author"   class="form-control"   readonly value = "<?php echo $Author; ?>">
       </div>
     </div>


         <div class ="form-group">
          <label for="pub" class="col-sm-2 control-label">Publisher</label>
          <div class="col-sm-10">
          <select name = "pub" id="pub" disabled = "disabled"class="form-control" >

        <?php
        foreach($publishers as $publisher)
        {
          if ($pub==$publisher)
          {
           echo"<option selected = 'selected' value ='$pub'>" . "$pub</option>\n";
          }
           else {
             echo"<option value = '$publisher'>$publisher</option>\n";
          }
        }
        ?>
        </select>
        </div></div>

     <div class ="form-group">
       <label for="Synopsis" class="col-sm-2 control-label">Synopsis</label>
       <div class="col-sm-10">
        <input type="text" name="Synopsis" id="Synopsis" class="form-control" readonly value = "<?php echo $Synopsis; ?>">
       </div>
     </div>

     <div class ="form-group">
       <label for="PageNum" class="col-sm-2 control-label">PageNum</label>
       <div class="col-sm-10">
        <input type="text" name="PageNum" id="PageNum"  class="form-control" readonly value = "<?php echo $PageNum;?>">
       </div>
     </div>

     <div class ="form-group">
       <label for="PubDate" class="col-sm-2 control-label">PubDate</label>
       <div class="col-sm-10">
        <input type="text" name="PubDate" id="PubDate" class="form-control"  readonly value = "<?php echo $PubDate; ?>">
       </div>
     </div>

     <div class ="form-group">
       <label for="ReleaseDate" class="col-sm-2 control-label">ReleaseDate</label>
       <div class="col-sm-10">
        <input type="text" name="ReleaseDate" id="ReleaseDate"   class="form-control" readonly value = "<?php echo $ReleaseDate; ?>">
       </div>
     </div>

     <div class ="form-group">
       <label for="Price" class="col-sm-2 control-label">Price</label></td>
       <div class="col-sm-10">
         <input type="text" name="Price" id="Price" class="form-control"  readonly value = "<?php echo $Price; ?>">
       </div></div>



<div class="buttonarea">
            <input type="submit" value="Delete Book  Record" name = "Submit">
            <input type="button" value="Cancel" >

         </div>
    </fieldset>
    </form>
    <?php
}?>
</section>
</div>
</body>
</html>

Ответы

Ответов пока нет.