 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
<?php /* variable initialization will initialize a global variable for every field in a given table reduces coding later if a table structure changes written by Victor M. Font Jr. Abba Consulting group http://abba.fontlife.com */ function initvar($varname, $value=null){ global $$varname; if(!isset($$varname)){ if ($value == null){ $$varname = ""; }else{ $$varname = $value; } } } $sServer = "localhost"; $sUser = "your_user_id"; $sPass = "your_password"; $Database = "your_database"; $db = mysql_connect($sServer, $sUser, $sPass); mysql_select_db($Database,$db); // populate this array with the tables for which you are initializing variables $sTableList = array("table1","table2","table3","table4","table5"); for ($n=0; $n<count($sTableList); $n++){ $id = @mysql_list_fields($Database, $table); $count = @mysql_num_fields($id); $results["num_fields"] = $count; for ($i=0; $i<$count; $i++) { $results[$i]["table"] = @mysql_field_table ($id, $i); $results[$i]["name"] = @mysql_field_name ($id, $i); $results[$i]["type"] = @mysql_field_type ($id, $i); $results[$i]["len"] = @mysql_field_len ($id, $i); $results[$i]["flags"] = @mysql_field_flags ($id, $i); $results["meta"][$results[$i]["name"]] = $i; } @mysql_free_result($id); for ($i=0; $i<$results["num_fields"]; $i++){ /* if you want to initialize variables for types other than strings and numbers, you'll have to add your own type in the switch statment below */ switch ($results[$i]["type"]){ case "string": initvar($results[$i]["name"]); break; case "int": initvar($results[$i]["name"],0); break; case "blob": initvar($results[$i]["name"]); break; } } } ?> | |||||
| Related Code Examples | |||||
