Tag: MySQL

PHP SQL Joins Tutorial

PHP MySQLi

Content: Inroduction of PHP SQL JOINs, SQL Left Join, SQL Right Join, SQL Full Join. MySQLi JOIN clause is used to combine rows from two or more tables, based on a related column between tow or more tables.

  Read More »

MySQL speed up slow query large table with millions rows

MySQL speed up slow query large table with millions rows

Improve slow query large table with millions of rows. Its common issue – slow query in large table. Here are cases for performance optimization.

  Read More »

WordPress get category list order by custom category id order

WordPress – Category list order, Rearrange category display order in WordPress, Wordpress order categories, Wordpress change the order of a list of categories.

  Read More »

PHP prevent sql injection tips

PHP prevent sql injection tips

Tips list for prevent sql injection in PHP: Avoid $_GET, $_POST and $_REQUEST direct use in SQL query Check variable value and format before use Avoid use of $_REQUEST Use PDO process Limited Privileges to DB user Set…

  Read More »

How to get data from two tables in MySQL

How to get data from two tables in MySQL

Here is example for your queries: how to get data from two tables in MySQL, get data from multiple tables in MySQL, MySQL left join multiple tables, how to get data from two tables in MySQL using php,…

  Read More »

How to save 1000 or more sql by storing data in file

PHP MySQL

Storing Data with PHP, Save mysql query or sql, Reduce MySQL load, Improve page loading speed, php store data without database, How do I store an array in a file, Save array to PHP file, php – Print…

  Read More »

Delete multiple rows – PHP – Mysql

Delete multiple rows - PHP - Mysql

Delete multiple rows from php mysql with checkbox, Delete multiple rows by selecting checkboxes using PHP, php – How to delete multiple rows from mysql with checkbox, Delete multiple rows using PHP, Delete multiple rows in mysql with…

  Read More »

MySQL How to speed up sorting query

How to get data from two tables in MySQL

Optimizing SELECT statements, performance – MySQL How to speed up sorting query, MySQL tips to increase sorting query, MySQL – How to speed up sorting queries on a large record list, MySQL sort by ID field instead of…

  Read More »

MySQL query for finding values in a comma separated string

How to get data from two tables in MySQL

MySQL query for finding values in a comma separated string. Use REGEXP feature in your MySQL query for finding value in comma separate string. Given example query can use for find given value/values in comma separated string.

  Read More »

MySQL get comma separated values in result

How to get data from two tables in MySQL

Get id or field value in comma separate string. Use GROUP_CONCAT for getting result in comma separate string. Function useful when you want to use id or field value in comma separate or with other character separate string.

  Read More »