Blog

Archive for the MySQL Category


MySQL Queries Cheat Sheet
Posted on December 31, 2017 in MySQL by Matt Jennings

Knowledge gained from Learn SQL and MySQL in 3 Hours by Umang Shah (Udemy class).

Starting Database and
Read more…


Post to a MySQL Database Using a jQuery AJAX Form with CodeIgniter
Posted on July 10, 2015 in AJAX, CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model Example

Controller Example

jQuery AJAX to Read from and Insert into a MySQL Database

View that Shows PHP and HTML for the
Read more…


MySQL LEFT JOIN and WHERE Example
Posted on July 7, 2015 in MySQL by Matt Jennings

Consider a user_quotes MySQL database with the three tables below:

users
quotes
favorites (one to many relationship with the users and quotes tables)

The
Read more…


MySQL Subquery Example
Posted on July 7, 2015 in MySQL by Matt Jennings

Consider a user_quotes MySQL database with the three tables below:

users
quotes
favorites (one to many relationship with the users and quotes tables)

The
Read more…


Delete a Database Row using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

Controller

View

To Top ↑