Installation guide & download for Display and Edit record script

There are three folders inside the zip file.
display-edit is for displaying records and editing single column data of a record.
display-edit2 is for displaying records and editing all the columns data of a record. display-edit3 Using JQuery, PHP, MySQLi drivers and MySQL database.

It is recommended to start with single column data edit and then move to all column data edit script.
There are two different tutorials explaining on the record edit. First one is editing single column of a record. Second one is editing all the columns of a record.

Here are the files

sql_dump.php : Use this SQL file to create student table. It has sample data which can be used.
config.php : Enter your database login details like database name, user id, password & localhost.
display.php : This is the main file which display the records and give the option to user to edit. This is the first file to be opened.
display-ajax.php : The backend file which receives the data from display.php through Ajax and checks the data. It update the record in our student table and returns the data with message.
ajax.js JavaScript file connected to display.php. Contains Ajax code to communicate between display.php and display-ajax.php file

Pre conditions to run this script.

You must have PHP 5 or above installed and running in your server. ( How to check PHP version ? )
PDO enabled in your PHP installation and same can be checked by php info. How to Check PDO
OR MySQLi support to run the JQuery version of this script ( display-edit3 )
MySQL database server with PhpMyAdmin running on your localhost to setup the database.

Running the script

After installation of tables and filling all database details in config.php file, try to open display.php file. If you are using single column data edit script then your URL at your browser address bar should be.

https://127.0.0.1/t/pdo/display-edit/display.php

In place of 127.0.0.1 you can use localhost if you are testing the script in your local computer. For the script with all columns edit option your URL should be like this ( with localhost )

https://localhost/t/pdo/display-edit2/display.php

For JQuery version with MySQLI support

https://localhost/t/pdo/display-edit3/display.php

Let us know if you have any suggestions to improve or facing any problem in installation. download script

Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com




    steve gaisan

    15-08-2014

    Thank you I m working on school exam mark management and this is so helpful. Keep it up. Will return again for to get more script from you.
    Dnyaneshwar

    22-11-2014

    Nice Tutorial , thanks for sharing
    JohnB

    02-05-2015

    Thanks - I think I got a grip on this this time - very well explained very helpful

    Post your comments , suggestion , error , requirements etc here .




    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2021 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer