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


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-2020 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer