Before I had posted an article to add, edit, delete, and display contents. I had also included sessions there. There was the facility to login and register users too.

But i got feedback that it was a bit complex for novice users of PHP (users who have just started PHPing). It was a kind of full-fledge system with PHP, MySQL and session.

So in this article, I have simplified the same functionality of the above tutorial. I have not used session in this case. If you want tutorial about session, login, and register then you can refer to my previous article (the link which is provided above).

Files included in this tutorial/code:

users.sql = This contains sql queries to make MySQL database and table

config.php = contains the database connection code (this file is included in all the php pages with the include() function)

index.php = contains the display part (displaying data from database)

add.html = contains form to add data

add.php = contains php code to add data

edit.php = contains php code to edit data

delete.php = contains php code to delete data

Download full source code: Create, read, update, delete in php and mysql

Cheers,