Tags → Mysql Query Example

Simple csv to MySQL tool

This code will take a csv file and create or, insert or update, the data into a MySQL database. It assumes the first line contains the field names and uses that to build the SQL query for the following data lines. There''s a download button fo...

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

Mysql Select Query

This simple script uses the DBI module in order to connect to a Mysql database, retrieves the results from a select query and display the results inside a while statement. There is a live example as a demo.

• Categories
  • CGI and Perl →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Other Free / Open Source License

PHP Multipurpose Forms with data binding and cross table

To administrate data has to be efficient and easy to handle. If you consider for example a publishers company with several authors who have written different books it makes no sense to present the data on different web pages. That''s not lucid. ...

• Categories
  • PHP →
  • Scripts and Programs →
  • Form Processors
• Platforms
  • Windows
• Licenses
  • Freeware

Cascade Select

This class is meant to generate two HTML form select type inputs making the currently selected value on the first input determine the option values that are made available on the second. It uses JavaScript to update the second input options when...

• Categories
  • PHP →
  • Scripts and Programs →
  • Development Tools
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Sun Solaris
• 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
• Platforms
  • Linux
• Licenses
  • Freeware

MP3SQL

MP3SQL is an product that generates and file with SQL commands. These commands are for adding the information that have been extracted out of your MP3 files. This archive also includes some scripts to easy add several CD-Roms containing MP3s. There i...

• Categories
  • PHP →
  • Scripts and Programs →
  • Music Libraries
• Platforms
  • Linux
• Licenses
  • Freeware