Categories
Tags → Mysql Query Tutorial

Creating an object oriented MySQL abstraction class

In this tutorial I will show you how you can create an object oriented database abstraction class for MySQL database. Besides the basic functions this manager class can summarize total time spent with db connection and query execution and counts how ...
DETAILS

Dynamic (2 level) navigation list

The creation of a dynamic nested unordered list without using any JavaScript code is sometimes a problem because the script needs to &"remember&" the values, sub values and also the query string from previous clicked links. In this ...
DETAILS

PHP Commander

This small free script allows you to type php commands/scripts inside a text area and execute them from one single page. You can use it for: Learning PHP interactively; Testing and debugging your PHP scripts interactively; Running programs and system...
DETAILS

Formatting Date/Time value in SQL query

Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal.
DETAILS

SQL Database Function Wrappers

When interacting with a database, functions are called that are common to every transaction; functions to establish a connection, execute the query and then close the connection. This article shows how to create functions that will eliminate this red...
DETAILS

MySQL Table Joins

One of the great characteristics of SQL (Structured Query Language) is the fact that one can develop access and modify data across various tables. There are several benefits to this, including greater ease of manipulation, increased speed of access, ...
DETAILS
©2003-2019 jCay.com