PHP Simple CRUD Application Script

PHP Simple CRUD Application Script Zip:

Download

What is CRUD?

CRUD refers to the four basic types of Database operations: Create, Read, Update, Delete. Most applications and projects perform some kind of CRUD functionality.

Once you learn about these CRUD operations, you can use them for many projects. For an example, if you learn how to create student table with multiple columns, you can use similar approach to create employee table or customers table.

About Simple CRUD Script:

We have created a Simple CRUD (Create/Read/Update/Delete) Application in PHP that is easy to understand. You can directly download all the code/database using the Download button.

This CRUD Script has the minimum number of functions required, so that anybody can easily understand the code. This script does not ensure security and data validation. So, if you want to use this script for your live project, please make sure to validation user data.

How to run CRUD Script:

You just need to run the given code files and database at your server. This script should run properly after database setup on most local server. But it may require few configuration changes on remote/live server.

  • Download CRUD Script Zip file and extract it.
  • Copy complete crud folder into your local server (in htdocs or www)
  • Create a new database “crud_db” (You can use PHPMyAdmin)
  • Import database.sql file from crud folder into database “crud_db”
  • Now run files from crud folder using your server/folder path (For example: http://localhost/crud/)
  • It should works properly. You can Add some user data. Then you can test Edit/Update/Delete-User functions as well

You can see code from all the files in this tutorial. You can find basic description in comments as well.

config.php file store information about the database host, username and password. Most of the local server works with given detail. You can change as per your host and database details.

database.sql is a database file. You can to create a database, after downloading the crud script. You can either run commands from above mysql file or simply import this ‘database.sql’ file into database (example using PHPMyAdmin).

index.php file is the main file which include configuration file for database connection. Then it display all users list using MySQL Select Query. However, you need to add some users first using ‘Add New User’ link.

add.php file is responsible to add new users. HTML Form is used to capture user data. After User data is submitted, MySQL INSERT Query is used to insert user data into database. You can “View User” after user added.

edit.php is used to edit/update user data once user click on’Edit’ link. It first fetch user’s current data in form. You can change user data and update it. It will redirect to homepage, after successful update.

delete.php file simply called when we click on ‘Delete’ link for any user. It will delete selected user. Delete/edit/update operations user particular user_id to identify users.

Common Mistakes while running CRUD Script

  • Make sure you properly downloaded and extracted all files
  • Make sure you have created database properly with the same as as mentioned in config.php
  • When running CRUD script, make sure folder name is right. Sometimes there are folder inside folders. Adjust your path or folder accordingly.
  • For any other problem, you can send your error screenshot to tutorialsclass.online@gmail.com or contact us at facebook page

We will update next version of the CRUD script with basic validation functions. See you back.

PHP Simple CRUD Application Script Zip Download:

Download