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 »

CodeIgniter join query: Inner – Left – Right – Outer – Left Outer – Right Outer Join with example

CodeIgniter join query

CodeIgniter join query using query builder class in active record pattern. article includes CodeIgniter table join example for Inner Join, Left Join, Right Join, Normal Join, Conditional Join, Outer Join, Left Outer Join and Right Outer Join.

  Read More »

PDO IN clause bindparam for where condition mysql

PDO IN clause bindparam for where condition mysql

PDO IN clause bindparam not available, with minor trick we able to prepare mysql IN query bindparam. Using simple loop we can bindparam for PDO IN query.

  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 validate comma separated ids string

How to convert multi-dimention array key to string type

Use of regexp for validate comma separated ids string. Given regexp check and validate comma separated ids string.

  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 »

Codeigniter select query types

Codeigniter select query types

Here is three select query types for select one row, select one field value and select multiple rows using Codeigniter Active Record.

  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 »