Skip to main content

MVC Database

By Testing
MVC database Edit/update/delete 


Controllers/EditDelete

<?php



class EditDelete extends CI_Controller {

    public function index() {

        $data = array(
            "header" => "Result set of Users",
            "data" => $this->db->get('users')->result()
        );
        $this->load->view('EditDeleteView', $data);
    }

    public function edit($id = "") {
        $this->load->library('form_validation');
        $data = array(
            "header" => "Result set of User Edit",
            "data" => $this->db->get_where('users', array('idu' => $id))
        );
        $this->load->view('EditView', $data);
    }

    public function update() {

   /*     $id = $this->input->post('id');
        $data = array(
            "username" => $this->input->post('username'),
            "email" => $this->input->post('email')
        );

        $this->db->update('users', $data, array('idu' => $id));
*/
     
            $this->load->library('form_validation');
     
        $FormRules = array(
            array(
                'field' => 'username',
                'label' => 'Username',
                'rules' => 'required'
        ));


        $this->form_validation->set_rules($FormRules);

        if ($this->form_validation->run() == TRUE) {
            echo "Success";
        } else {
            echo validation_errors();
        }
     
     
    }

}

Views/EditDeleteView


<table border="1">
    <caption>
        <th colspan="5"> <?php echo $header; ?></th>
    </caption>
    <tr>
       
        <th>No</th>
        <th>Username</th>
        <th>Password</th>
        <th>Email</th>       
        <th>Operation</th>
    </tr>
    <?php
    $i = 1;
    foreach ($data as $res) {
        ?>

        <tr>
            <td><?php echo $i++; ?></td>
            <td><?php echo $res->username; ?></td>
            <td><?php echo $res->password; ?></td>
            <td><?php echo $res->email; ?></td>
            <td><a href="<?php echo base_url('index.php/editdelete/edit/'.$res->idu); ?>">Edit</a> | Delete</td>
        </tr>
        <?php
    }
    ?>
</table>

View/EditView

<html><head><script src="http://localhost/js/jquery.min.js" type="text/javascript"></script>
<script>

$(document).ready(function(){
    $('form.jsForm').on('submit',function(form){
        form.preventDefault();
        $.post('editdelete/update',$('form.jsForm').serialize(),function(data){
                console.log(data);
                $('div.jsError').html(data);
            });
    });
});

</script>
    </head>
    <body>
<?php echo form_open('editdelete/update/', array('class' => 'jsForm')); ?>

<div class="jsError"></div>
<table border="0">



    <?php
    if ($data->num_rows() != 0) {
        $row = $data->row();
        ?>

        <tr>
            <td>Username</td>
        <input type="hidden" name="id" value="<?php echo $row->idu; ?>" >
        <td><input type="text" value="<?php echo $row->username; ?>" name="username"></td>
    </tr>
    <tr>
        <td>Password</td>
        <td><!-- input type="text" value="<?php echo $row->password; ?>" name="password" --><?php echo $row->password; ?></td>
    </tr>
    <tr>
        <td>Email</td>
        <td><input type="text" value="<?php echo $row->email; ?>" name="email"></td>
    </tr>

    <tr>
        <td colspan="2"><input type="submit" value="Save"></td>
    </tr>
    </tr>

<?php } ?>

</table>

<?php echo form_close(); ?>


    </body>
</html>


Labels:

Comments

Post a Comment

Popular posts from this blog

Ministry of Higher Education Project : SLIATE (live project)

By
ABOUT SLIATE Our Mission  "Creating Excellent Higher National and National Diplomates with Modern Technology for Sustainable Development" Our Vision "To Become the Centre of Excellence in Technological Education" As per the recommendations of the Committee appointed by Prof. Wiswa Waranapala, Deputy Minister of Higher Education in 1994, the Sri Lanka Institute of Advanced Technical Education (SLIATE) was formed in 1995, under the Sri Lanka Institute of Advanced Technical Education Act No. 29 of 1995, In 2001 the name of the institution was amended as Sri Lanka Institute of Advanced Technological Education, (SLIATE). It functions as an autonomous Institute for the management of Higher National and National Diploma courses. The main purposes of establishing SLIATE were to reform and restructure the entire technical and vocational education system in relation to the changing needs of economic development, to meet manpower requirements of natio...
Post a Comment
Read more

Micro Loan Banking Management System

By Testing
Post a Comment
Read more

Android SQLite Database 1

By Testing
Using Android Studio Crating a Database (SQLite) 1. NEW PROJECT 2.CREATE  A CLASS NAME CALL (DB.class) 3.import SQLiteDatabase    import SQLiteOpenHelper SCREEN SHOT OF CODE (IMAGE) CODE (TEXT) Bellow package com.example.rimzan.j2program ; import android.content.Context ; import android.database.sqlite.SQLiteDatabase ; import android.database.sqlite.SQLiteOpenHelper ; public class DB extends SQLiteOpenHelper { public static final String DATABASE_NAME = "Student.db" ; public static final String TABLE_NAME = "Student_Table" , COL_1 = "ID" , COL_2 = "NAME" , COL_3 = "SURENAME" , COL_4 = "MARKS" ; public DB(Context context) { super (context , DATABASE_NAME ,null, 1 ) ; SQLiteDatabase db=getWritableDatabase() ; } @Override public void onCreate (SQLiteDatabase db) { db.execSQL( "CREATE TABLE " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AU...
Post a Comment
Read more