Welcome Guest, Not a member yet? Register   Sign In
updating data in database using forms


I am student and new to CodeIgniter and even PHP.
I do have an assignment on updating the books in the database(phpmyadmin).

and not sure what I am doing wrong.
I am attaching the files with this email.
Can anyone help me with this?

Part Five [Create/ Read / Update / Delete]
Apply the concepts were learned in the previous parts of the assignment to complete the following:
1.) Add “Edit/Delete” links next the records rendered in “book_view.php”
a. The link should take the user to an “Edit/Delete” form
i. Make use of anchor_popup() method to open the form
ii. Make use of the book record’s primary key to retrieve correct record to edit
2.) Create an “Edit/Delete” book form that allows users to edit, update and delete book information
a. Make use of the CI validation library
b. * Review primary key/foreign key database concepts
3.) Create a “Book Category” form that allows users to add book categories to the application
4.) Create a “Book Category” form that allows users to update and delete book categories from the application
5.) Modify “add_book_form_view.php” so that it makes use of book categories retrieved from the “bookCategories” table
a. Add code to existing controllers, views, and model as needed

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Dashboard extends CI_Controller{
        public function index(){
        public function get_add_books_form(){  
public function edit_books_form_view(){  
public function save_books(){
  $this->form_validation->set_rules('author', 'Author', 'required');
        $this->form_validation->set_rules('bookTitle', 'Book Title', 'required');
        $this->form_validation->set_rules('description', 'Description', 'required');
  if($this->form_validation->run() == FALSE){
  } else {
   $this->session->set_flashdata('message' , 'Book Saved');
public function get_books(){
  $data['bookinformation'] = $this->BooksModel->get_books();
  $this->load->view("books_view", $data);
public function get_edit_books_form( $bookID="" ) {
  if (empty( $bookID )) {
  $bookID = $this->uri->segment(3, 0);
  $data['bookinformation'] = $this->BooksModel->get_book( $bookID );
  $this->load->view("edit_books_form_view", $data);
public function update_books() {
    $this->BooksModel->update_books( $_POST );
    $this->session->set_flashdata('message', 'Books data updated.');
    redirect("dashboard/get_edit_books_form/" . $_POST['bookID']);

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class BooksModel extends CI_Model {
public function save_books($formData){
$this->db->insert("bookinformation", $formData);}
public function get_books(){
return $this->db->get('bookinformation');}
public function get_book( $bookID ){
return $this->db->get('bookinformation', $bookID);}

$popupAttributes = array(
'width' => '800',
'height' => '600');
foreach( $bookinformation->result() as $bookinformation ) {
echo "<p>" . $bookinformation->bookID . "</p>";
echo "<p>" . $bookinformation->bookTitle . "</p>";
echo "<p>" . $bookinformation->author . "</p>";
echo "<p>" .  $bookinformation->description . "</p>";
echo "<p>" .  $bookinformation->isbn . "</p>";
echo anchor_popup('dashboard/get_edit_form_view'.$bookinformation->bookID, 'Edit/Delete', $popupAttributes );}?&gt;

echo $this->session->flashdata('message');
echo validation_errors();
$id = array('id' => 'BookForm');
echo form_open('dashboard/update_books', $id);
$bookinformation = $bookinformation->row();  
&lt;?php echo "EDIT/UPDATE" ?&gt;
<br />
<br />
&lt;input name="bookID" type="hidden" value="&lt;?php echo $bookinformation-&gt;bookID; ?&gt;" /&gt;
<label for="bookTitle">Book Title</label><br />
&lt;input name="bookTitle" id="bookTitle" type="text" value="&lt;?php echo $bookinformation-&gt;bookTitle; ?&gt;" /&gt;&lt;br />
   <label for="author">Author:  </label><br />
&lt;input name='author' id="author" value="&lt;?php echo $bookinformation-&gt;author; ?&gt;" /&gt;&lt;br />
<label for="ISBN">ISBN </label> <br />
&lt;input name='ISBN' id="ISBN" type='text' value="&lt;?php echo $bookinformation-&gt;isbn; ?&gt;" /&gt;&lt;br />
<label for="description">Description:<label><br />
&lt;textarea rows="10" cols="30" id="description" name="description" value="&lt;?php echo $bookinformation-&gt;description; ?&gt;"&gt;&lt;/textarea><br /><br />
<label for="categoryID">Categories: </label> <br />
<select name="categoryID" id="categoryID">
<option value="1">1. Arts & Photography</option>
<option value="2">2. Children's Books</option>
<option value="3">3. Computers & Technology</option>
<option value="4">4. Science & Math</option>
&lt;input id="submit" type="submit" value="Submit" /&gt;
&lt;?php echo "<strong>Book ID</strong>: " . $bookinformation->bookID . "<br />"; ?&gt;
&lt;?php echo "<strong>Book Author</strong>: " . $bookinformation->author . "<br />"; ?&gt;
&lt;?php echo "<strong>Book Title</strong>: " . $bookinformation->bookTitle . "<br />"; ?&gt;
&lt;?php echo "<strong>Book ISBN</strong>: " . $bookinformation->isbn . "<br />"; ?&gt;
&lt;?php echo "<strong>Book Description</strong>: " . $bookinformation->description . "<br />"; ?&gt;
&lt;?php echo "<strong>Book Category</strong>: " . $bookinformation->categoryID . "<br />"; ?&gt;
?php// echo "DELETE" ?&gt;
  &lt;?php //echo anchor("dashboard/delete_books/$bookinformation->bookID", "Delete"); ?&gt;

You will not be able to edit/delete using the anchor_popup like that!


Etend your controllers from this MY_Controller.
class MY_Controller extends CI_Controller {

public function __construct()

  $this->load->model('booksmodel', 'books');

  $tmpl = array (
   'table_open'   => '<table border="0" cellpadding="4" cellspacing="0">',

   'thead_open'   => '<thead>',
   'thead_close'   => '</thead>',

   'heading_row_start'  => '<tr>',
   'heading_row_end'  => '</tr>',
   'heading_cell_start' => '<th>',
   'heading_cell_end'  => '</th>',

   'tbody_open'   => '<tbody>',
   'tbody_close'   => '</tbody>',

   'row_start'    => '<tr>',
   'row_end'    => '</tr>',
   'cell_start'   => '<td>',
   'cell_end'    => '</td>',

   'row_alt_start'   => '<tr class="alt">',
   'row_alt_end'   => '</tr>',
   'cell_alt_start'  => '<td>',
   'cell_alt_end'   => '</td>',

   'table_close'   => '</table>'



Create a manage methon/function something like this to setup yuour edit/delete form.
// -----------------------------------------------------------------------

  * manage()
  * Description:
  * @access public
  * @return void
public function manage()
  // Get an array of users from the database
  $data = $this->books->get_books();

  // Set headings for the table
  $this->table->set_heading('ID', 'Author', 'Title', 'ISBN', 'Description', 'Category', 'Actions');

  foreach ($data as $value => $key)
   // Build action links
   $actions =  anchor("dashboard/edit/".$key['BookID']."/", "Edit");

   // Add the row to table
   $this->table->add_row($key['BookID'], $key['author'], $key['bookTitle'], $key['isbn'], $key['description'], $key['categoryID'], $actions);

  // Load the view

In your view to generate the table ad this:
&lt;?php echo $this->table->generate(); ?&gt;


CodeIgniter Users Guide - HTML Table Class

In your controller add the following functions and point them to your model:

Theme © iAndrew 2016 - Forum software by © MyBB