Tags → Mysql Query Examples

myPageDisplay class

This class can perform several tasks and you decide how much you want from it. In its complete form it can generate an interactable paginated columnar listing from a MySQL database. If you want to use it in parts you can generate XHTML tables ...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows
• Licenses
  • GPL

Paging Results in PHP

Following examples teaches how to query a mySQL database and getting results in pages. Every page displays results maximum 10 results in a single page.

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • Freeware

datDatabase

datDatabase is used to simplify the most common mySQL query operations that are issued to a mySQL server. Instead of coding out complete mySQL queries to interact with the mySQL server, the programmer can simply pass several variables and the Class w...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • FreeBSD
• Licenses
  • Other Free / Open Source License

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
• Platforms
  • Linux
• Licenses
  • Freeware