| | |
| | | { |
| | | |
| | | global $conf; |
| | | $this->dbHost = $conf["mysql_server_host"]; |
| | | //$this->dbName = $conf["mysql_server_database"]; |
| | | $this->dbUser = $conf["mysql_server_admin_user"]; |
| | | $this->dbPass = $conf["mysql_server_admin_password"]; |
| | | $this->dbHost = $conf["mysql"]["host"]; |
| | | //$this->dbName = $conf["mysql"]["database"]; |
| | | $this->dbUser = $conf["mysql"]["admin_user"]; |
| | | $this->dbPass = $conf["mysql"]["admin_password"]; |
| | | //$this->connect(); |
| | | } |
| | | |
| | |
| | | return $this->query($sql); |
| | | } |
| | | |
| | | // gibt Array mit Tabellennamen zurück |
| | | // gibt Array mit Tabellennamen zur�ck |
| | | function getTables($database_name = '') { |
| | | |
| | | if($database_name == '') $database_name = $this->dbName; |
| | | $result = mysql_list_tables($database_name); |
| | | if($database_name == ''){ |
| | | $database_name = $this->dbName; |
| | | } |
| | | $result = mysql_query("SHOW TABLES FROM `$database_name`"); |
| | | $tb_names = array(); |
| | | for ($i = 0; $i < mysql_num_rows($result); $i++) { |
| | | $tb_names[$i] = mysql_tablename($result, $i); |
| | | } |
| | | return $tb_names; |
| | | } |
| | | |
| | | // gibt Feldinformationen zur Tabelle zurück |
| | | // gibt Feldinformationen zur Tabelle zur�ck |
| | | /* |
| | | $columns = array(action => add | alter | drop |
| | | name => Spaltenname |
| | |
| | | return 'char'; |
| | | break; |
| | | case 'varchar': |
| | | if($typeValue < 1) die("Datenbank Fehler: Für diesen Datentyp ist eine Längenangabe notwendig."); |
| | | if($typeValue < 1) die("Datenbank Fehler: F�r diesen Datentyp ist eine L�ngenangabe notwendig."); |
| | | return 'varchar('.$typeValue.')'; |
| | | break; |
| | | case 'text': |
| | |
| | | |
| | | } |
| | | |
| | | ?> |
| | | ?> |