Security is a measured challenge while creating an application in PHP. The raw SQL query in PHP can be injected through a malicious function. This may affect your entire functionality. Even you can lose your database or particular table and even any record. Due to the SQL injection, the vulnerable code or script can be injected into your SQL query. It is the most important thing to prevent SQL injection in your PHP application. I already shared a brief post on SQL Injection and Prevention Techniques in PHP. The PHP frameworks like Laravel, CodeIgniter, etc are secured from the SQL injection. We can overcome the possibility of SQL injection using prepared statement. The PHP prepared statement query will generate a placeholder. It will prepare a SQL statement and later will bind the values to the placeholder. In this post, I will create a CRUD app using prepared statement.
Contents
- 1 Prerequisites
- 2 Create a Project Folder Structure
- 3 Create Database and Table
- 4 Database Connection For PHP Prepared Statement
- 5 Create Master Layouts in PHP
- 6 Create Index File For Displaying Data
- 7 CRUD in PHP Using Prepared Statement
- 8 Create Post
- 9 Show Post
- 10 Update Post
- 11 Delete Post
- 12 Conclusion
- 12.1 Share this:
- 12.2 Like this:
- 12.3 Related
Prerequisites
For creating this CRUD app in php using prepared statement, you must have the below configuration.
- Apache/Nginx Server
- PHP >=7
- MySQL >=5
- VS Code (Optional)
Create a Project Folder Structure
Firstly, go to the htdocs directory if you are a windows user and installed xampp/wampp. If you are a Linux user then go to the var/www/html and create a new folder there. In my case, the folder name is crud. Inside this folder, I have created these two subfolders named assets and master.
Let me explain the file
#php #crud app #php 8 crud #php crud
