Categories
-
Category Archives: MySQL Tutorials
Using the MySQL LIMIT Clause for Paging with PHP
One of the first questions that comes up when someone starts using PHP and the very powerful MySQL database is: How do I page through the results of a query like I see with search results on many web sites? … Continue reading
MySQL One Liners
We have been using PHP and MySQL for web development almost exclusively for several years. During this time, our team has come up with a list of simple, yet powerful one line SQL statements that make MySQL easier to use. … Continue reading
Creating a States Table in MySQL
It is common to add a drop-down select box that is populated with USA states or Canadian provinces to PHP applications. There are basically three ways to do this. You can hard-code all of the Select box selections into your … Continue reading
Using a MySQL Full-Text Search
A full-text search allows a search of multiple text columns. If you are setting up a search of a series of articles or a site with lots of product-related content, a MySQL FULLTEXT search can make it very easy to … Continue reading
Using MySQL Data Types
Sometimes it is not easy to determine which MySQL data type is the proper one to use. This tutorial should help to clarify that issue. Continue reading
MySQL Cheatsheet by Example
MySQL is a very robust database that can take some time to learn. We offer this free cheatsheet to help the newbies to learn faster and to be a handy reference for seasoned professionals. Continue reading
Preventing SQL Injection with MySQL and PHP
SQL vulnerabilities can allow a malicious user to list the content of a database table or delete data. learn how to prevent SQL injection attacks using tools built into PHP. Continue reading
