* (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 );
bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases Sort the results from a SELECT query (any number of columns) into an array automatically. Categories : PHP, PHP Classes, Arrays, Databases, MySQL 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 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 dynamic table columns Categories : PHP, HTML and PHP, Arrays, Databases, MySQL How to load a query result into a PHP Array Categories : PHP, Databases, Arrays, MySQL 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 Simple conversion functions to change MySQL dates to arrays, arrays to MySQL dates.
Categories : PHP, Arrays, Date Time, Databases, MySQL Tropicalm Genetree Family (MySQL based family tree) Categories : PHP, Interfaces, Databases, MySQL, Complete Programs Storing / Retrieving pictures from database This can be used for banner / ads exchange. very useful for people developing big portal with ads in the site........ Categories : PHP, MySQL, Databases, HTML and PHP Email a user with out exposing email address Categories : PHP, Databases, MySQL, Email This class splits the results of the query into multiple pages like what the search engine does. Categories : PHP Classes, PHP, MySQL, Databases Invision Forums Latest Threads list Categories : PHP, Miscellaneous, Databases, MySQL