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 ...

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Tags
  • mysql manager,
  • php basic,
  • php database abstraction,
  • php database class,
  • php execution time,
  • php mysql query,
  • php mysql tutorial,
  • php tutorial,
  • query execution in php,
  • time in php
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • Freeware

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 ...

• Categories
  • PHP →
  • Tips and Tutorials →
  • Site Navigation
• Tags
  • html list,
  • javascript menu,
  • menu javascript,
  • menu script,
  • navigation menu,
  • navigation php,
  • php dynamic menu,
  • php menu,
  • php navigation,
  • script menu
• Platforms
  • Linux
• Licenses
  • Freeware

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...

• Categories
  • PHP →
  • Scripts and Programs →
  • Development Tools
• Tags
  • free mysql,
  • free php script,
  • free php scripts,
  • mysql commands,
  • mysql php,
  • php dice,
  • php mysql,
  • php mysql query,
  • php mysql tutorial,
  • php scripts
• Platforms
  • Linux
• Licenses
  • Freeware

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.

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Tags
  • function sql,
  • how to use mysql,
  • learn how to use mysql,
  • learn mysql,
  • learn sql,
  • mysql example,
  • mysql examples,
  • mysql tutorial,
  • sql examples,
  • sql query
• Platforms
  • Linux
• Licenses
  • Freeware

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...

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Tags
  • create database mysql,
  • create mysql database,
  • database mysql tutorial,
  • database tutorial mysql,
  • how to use mysql,
  • mysql create database,
  • mysql database tutorial,
  • mysql query,
  • mysql tutorial
• Platforms
  • Linux
• Licenses
  • Freeware

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, ...

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Tags
  • access sql,
  • access to mysql,
  • characteristics of sql,
  • mysql command,
  • mysql data types,
  • mysql tutorial,
  • sql command,
  • sql cross join,
  • sql join,
  • sql query
• Platforms
  • Linux
• Licenses
  • Freeware