Skip to main content
Being Idea Innovations
All Articles
Category

MySql

7 articles in this category

AllApacheCodeIgniterGen AIHTMLJavascriptMySqlPHPWordPress
MySQL JOINs Explained: INNER, LEFT, RIGHT, CROSS and the Missing FULL OUTER
FeaturedMySql

MySQL JOINs Explained: INNER, LEFT, RIGHT, CROSS and the Missing FULL OUTER

Every MySQL join type with worked examples — plus how to emulate FULL OUTER JOIN, which MySQL does not support, the WHERE clause that silently turns a LEFT JOIN into an INNER JOIN, and anti-joins for finding unmatched rows.

5 November 20187 min readRead more
Export MySQL Data to CSV or Excel in PHP (The Correct Way)
MySql

Export MySQL Data to CSV or Excel in PHP (The Correct Way)

Stream MySQL query results to CSV or a real Excel file in PHP using fputcsv — with the UTF-8 BOM Excel needs, protection against CSV formula injection, and memory-safe exports for large tables.

12 May 20185 min read
Load More / Infinite Scroll with PHP and MySQL: Why OFFSET Is the Wrong Tool
MySql

Load More / Infinite Scroll with PHP and MySQL: Why OFFSET Is the Wrong Tool

Build a Load More button with the Fetch API and PHP — plus keyset pagination, which stays fast at page 5,000 where LIMIT/OFFSET collapses, and the duplicate-row bug OFFSET causes on live data.

11 May 20186 min read
Import Excel or CSV Data into MySQL with PHP (Safely, at Scale)
MySql

Import Excel or CSV Data into MySQL with PHP (Safely, at Scale)

A production-ready CSV and XLSX import for PHP — prepared statements, batched inserts, streaming for large files, upload handling that is not a security hole, and per-row error reporting instead of silent failures.

15 April 20187 min read
Build a Like / Dislike Voting System with PHP and MySQL
MySql

Build a Like / Dislike Voting System with PHP and MySQL

A YouTube-style rating system done properly — one atomic upsert instead of six queries, a unique constraint that makes double-voting impossible, optimistic UI with fetch, and why identifying voters by IP address does not work.

14 March 20186 min read
Dependent Country / State / City Dropdowns with PHP and Fetch
MySql

Dependent Country / State / City Dropdowns with PHP and Fetch

Build cascading select menus backed by MySQL — returning JSON instead of HTML, cancelling stale requests so slow responses cannot overwrite fresh ones, and a schema that will not break at 127 countries.

11 February 20186 min read
Alphabetical A–Z Listings from MySQL in PHP (Without 27 Queries)
MySql

Alphabetical A–Z Listings from MySQL in PHP (Without 27 Queries)

Build an A–Z index page from MySQL with a single query instead of one per letter — plus collation choices that decide how accents and case sort, natural ordering for names with numbers, and the index that keeps it fast.

16 January 20185 min read

Want to talk tech?

Join 500+ engineering leaders who get our monthly insights on building great software.

Subscribe to NewsletterBook a callStart a Project
No long-term contracts
Senior engineers only
US · AU · NZ timezone coverage
14-day trial on retainers