If you are a PHP developer, you may have come across the mysql_* functions at some point in your career. These functions are used to interact with a MySQL database in PHP applications. However, you might have heard that using these functions is not recommended. In this blog post, we will discuss why you shouldn’t […]
Preventing SQL Injection in PHP: Best Practices and Examples
SQL injection is a common vulnerability in web applications, including those written in PHP. It occurs when an attacker manipulates user input to insert malicious SQL code into a query, allowing them to access or modify sensitive information in a database. In this article, we will discuss some best practices for preventing SQL injection in […]
How to Import data into MySQL database using MySQL Workbench?
This tutorial will help you understand the process of importing data into your MySQL database running on Windows and MacOS using MySQL Workbench. It will also work on Linux; However, on Linux I would like you to use Commands, as it is faster and easy way to handle the import operations. Open MySQL Workbench Open […]
Installing Configuring MySQL Workbench on Windows 10/11
1. Choosing a Setup Type: 2. Check Requirements 3. The warning 4. Installation 5. Product configuration 6. Type and Networking 7. Authentication Method 8. Accounts and Roles 9. Windows Service 10. Server File Permissions 11. Apply Configuration 12. Product Configuration 13. MySQL Router Configuraion 14. Product Configuration 15. Coneect to Server 16. Connect to Server […]
What is the difference between SQL Primary and Foreign key
This article will you detail understanding on what is primary and foreign key in SQL database and how to use them to manage relationship between two or multiple tables and also details the key difference between primary and foreign key
Change User Password by Validating Current Password in PHP MySQL
The perfect user of PHP password_hash and password_verify inbuilt functions, Learn how you can develop change login password feature along with all required validations.