w3docs logo
  1. Snippets
    2. ›
  2. MySQL

How-to articles, tricks, and solutions about MYSQL

How can I prevent SQL injection in PHP?

There are several ways to prevent SQL injection attacks in PHP.

php sql MySQL security sql-injection

How do I connect to a MySQL Database in Python?

To connect to a MySQL database in Python, you can use the mysql-connector-python library.

MySQL python

How do I count unique visitors to my site?

There are several ways to count unique visitors to a website using PHP, but one common method is to use cookies.

php MySQL counting visitor-statistic

How do I display a MySQL error in PHP for a long query that depends on the user input?

To display a MySQL error in PHP for a long query that depends on user input, you can use the mysqli_error() function.

php MySQL mysqli

How do I find out my MySQL URL, host, port and username?

To find out your MySQL connection details, you will need to look in your MySQL configuration files. The specific location of these files will depend on how you installed MySQL, but common locations include /etc/my.cnf,

java database MySQL database-connection jdbc

How to Check if a Record Exists in a MySQL Database

In this tutorial, we are going to represent to you two handy options of how to check if a record exists in the database with PHP.

php database MySQL

How to Convert MySQL Data to JSON with PHP

If you wonder how to find a proper way of converting MySQL data to JSON format using PHP, then you are in the right place. Read on and check the example.

php json MySQL json_encode

How to count and group by in yii2

In Yii2, you can use the count() and groupBy() methods in the query builder to count and group the results of a query, respectively.

php MySQL yii2

How to create a foreign key in phpmyadmin

To create a foreign key in PHPMyAdmin, follow these steps:

php database MySQL phpmyadmin

How to create virtual column using MySQL SELECT?

To create a virtual column using a MySQL SELECT statement, you can use the AS keyword to assign a name to an expression in the SELECT statement.

php select MySQL