* (c) 2006, D.E. Silvia, All rights reserved.
* This code is available for use for non-commercial purposes.
* Free to distribute as long as this copyright information remains intact.
* No modification is authorized. Please, refer bugs/enhancements to
* [email protected]
* Function to return enum values from a MySQL database in a PHP array.
* Values can then be easily displayed for user choices, i.e., in an
* HTML form.
* $host: database host, e.g., 'localhost'
* $user: database user
* $password: database password for the user
* $db: database to connect
* $table: database table to access
* $field: name of the field (column) containing the enum
* $sorted: boolean for sorting. default: return the array sorted
function getEnumVals ( $host , $user , $password , $db , $table , $field , $sorted = true )
$rp = mysql_connect ( $host , $user , $password );
$dbConnect = mysql_select_db ( $db );
$result = mysql_query ( 'show columns from ' . $table . ';' );
while( $tuple = mysql_fetch_assoc ( $result ))
if( $tuple [ 'Field' ] == $field )
$types = $tuple [ 'Type' ];
$beginStr = strpos ( $types , "(" )+ 1 ;
$endStr = strpos ( $types , ")" );
$types = substr ( $types , $beginStr , $endStr - $beginStr );
$types = str_replace ( "'" , "" , $types );
$types = split ( ',' , $types );
if( $sorted )
sort ( $types );
mysql_close ( $rp );
return( $types );
Simple conversion functions to change MySQL dates to arrays, arrays to MySQL dates.
Categories : PHP, Arrays, Date Time, Databases, MySQL bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases This functions makes it easy to use session-variables known from ASP. With one Cookie the array "session" will save and restore from a db-record. In this version MySQL is used but it's should very easy to change Categories : PHP, Arrays, Cookies, MySQL, Databases This simple function will take a few arguments and easily set a associative array for each column in a result from a MySQL query Categories : Databases, PHP, MySQL, Arrays This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases, MySQL, Complete Programs, PHP, Databases Finds the median in an array of numbers - Can be used with a MySql database column read into an array Categories : PHP, Arrays, Databases, MySQL dynamic table columns Categories : PHP, HTML and PHP, Arrays, Databases, MySQL Sort the results from a SELECT query (any number of columns) into an array automatically. Categories : PHP, PHP Classes, Arrays, Databases, MySQL create a grid out of <INPUT TYPE=TEXT> then saving to a database. Uses
a 'multi-dimension array', but not really as the array is just one big array
with the index of "[$i][$j]". Have a look at the code and you'll see what I
mean. Categories : PHP, MySQL, Arrays, Databases How to load a query result into a PHP Array Categories : PHP, Databases, Arrays, MySQL phpAds, a complete banner and ad management system with detailled tracking and stats. Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases Point and Click Interface ala MS Access for creating SQL statements. Categories : MySQL, Complete Programs, General SQL, PHP, Databases Count how many weeks in the month have a specified day, such as Mon, Tue, etc. Var avail - number of days - first day name of the month, occurrences of Sun, occurrences of Mon, etc. Allows you to calculate number of working hours exclude Holidays. Categories : Calendar, Date Time, PHP, Databases, MySQL Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs. Categories : Databases, PHP, MySQL, Complete Programs Link Manager for Link Exchangers Categories : PHP, PHP Classes, Databases, MySQL, CURL