<!-- FORM --> <p><img src="<?php echo $site_url; ?>/assets/modules/dbedit/images/db.gif" align="absmiddle" alt="dBedit" title="" width='32' height='32' /> Here you can add a new configuration to manage a database table. The database table must already exists and be accessible by ModX. </p> <br /> <form name="mutate" id="form_mutate" method="POST" action="index.php?a=112&dba=<?php echo $dba==107?'109':'110'; ?>&id=<?php echo $module_id; ?>"> <input type="hidden" name="json_data" id="json_data" value="" /> <input type="hidden" name="db" id="prop_dbid" value="" /> <?php //* debug */ print __LINE__.': <pre>'.print_r($dbConfig,true) .'</pre><br />'; ?> <table border='0' cellspacing='0' cellpadding='3'> <tr><td colspan="2"><div class='split'></div></td></tr> <tr> <td scope="row">Table Name</td> <td><div id="wait-for-me"><span>Select a the table to expose it's properties below.</span></div> <?php if( $dba==107 ){ //new table $names = listTables(); if($names){ $tags = '<select name="fld_tableName" id="prop_tablename" onchange="ajaxLoadConfig(this)"> <option value=""></option>'; foreach($names as $table) $tags .= '<option value="'.$table.'">'.$table.'</option>'; $tags .= '</select>'; } }else $tags = '<input type="text" name="fld_tableName" id="prop_tablename" size="30" onchange="ajaxLoadConfig(this)" value="" />'; ?> <?php echo $tags; ?> <input type="button" name="btRefresh" value="refresh" accesskey="r" onclick="ajaxLoadConfig($('prop_tablename'))" /> <span class='comment'>(refresh will reset all property fields)</span></td> <td></td> </tr>
function dropTable() { global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $queryStr, $errMsg; $queryStr = "DROP TABLE {$tablename}"; mysql_select_db($dbname, $mysqlHandle); mysql_query($queryStr, $mysqlHandle); $errMsg = mysql_error(); listTables(); }