|
|
|
|
Bookmark this on Delicious
Share on Facebook
 Slashdot It!
Digg px_get_schema
Returns the database schema
(PECL paradox:1.0-1.4.1)
px_get_schema() returns the database schema. Parameters
Return Values
Returns the schema of a database file as an associated array. The key name
is equal to the field name. Each array element is itself an associated
array containing the two fields Code Examples / Notes » px_get_schemamr muddy
It's not especially pretty and there isn't any error trapping, so please don't use this on any sort of production data. This will display the schema of a paradox data source.... <? /* Paradox database schema display Tim Burt 27/07/07 */ //we're expecting a filename in the post vars if ($_POST['database_name'] != "") { //Set up anything we are likely to need $database_filename = "<path to your data file>".$_POST['database_name']; echo " <b>Schema for ".$_POST['database_name']."</b>\n"; if(!$pxdoc = px_new()) { DIE("Problem !"); } $fp = fopen($database_filename, "r"); if(!px_open_fp($pxdoc, $fp)) { DIE("Couldn't open database file"); } else { //output the database schema... $stock_schema = px_get_schema($pxdoc); if (is_array($stock_schema)) { foreach ($stock_schema as $key=>$value) { echo " <b>".$key."</b> - Type ".$value['type']; } } } px_close($pxdoc); px_delete($pxdoc); fclose($fp); } else { //show the form to get the filename echo "<form action=\"show_schema.php\" method=\"post\">\n"; echo " Data Source Name (include extension) : <input type=\"text\" size=\"10\" name=\"database_name\">\n"; echo " <input type=\"submit\" value=\"Show Schema !\">\n"; echo "</form>\n"; } ?> |
Change Language
px_close px_create_fp px_date2string px_delete_record px_delete px_get_field px_get_info px_get_parameter px_get_record px_get_schema px_get_value px_insert_record px_new px_numfields px_numrecords px_open_fp px_put_record px_retrieve_record px_set_blob_file px_set_parameter px_set_tablename px_set_targetencoding px_set_value px_timestamp2string px_update_record |
