Commit | Line | Data |
---|---|---|
6855525e JL |
1 | <?php |
2 | /* | |
3 | * Copyright (C) 2003-2004 Polytechnique.org | |
4 | * http://opensource.polytechnique.org/ | |
5 | * | |
6 | * This program is free software; you can redistribute it and/or modify | |
7 | * it under the terms of the GNU General Public License as published by | |
8 | * the Free Software Foundation; either version 2 of the License, or | |
9 | * (at your option) any later version. | |
10 | * | |
11 | * This program is distributed in the hope that it will be useful, | |
12 | * but WITHOUT ANY WARRANTY; without even the implied warranty of | |
13 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | |
14 | * GNU General Public License for more details. | |
15 | * | |
16 | * You should have received a copy of the GNU General Public License | |
17 | * along with this program; if not, write to the Free Software | |
18 | * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA | |
19 | */ | |
20 | ||
21 | ||
22 | /** Class for handling operations on MySQL database tables. Upon construction, the class | |
23 | * probes the table to read its structure. | |
24 | * | |
25 | * @see DiogenesDatabase, DiogenesTableEditor | |
26 | */ | |
27 | class DiogenesDatabaseTable { | |
28 | /** Handle to the database */ | |
29 | var $dbh; | |
30 | /** Name of the table */ | |
31 | var $table; | |
32 | /** The table's columns */ | |
33 | var $vars = array(); | |
34 | ||
35 | /** The constructor. It reads the table structure from database. | |
36 | * | |
37 | * @param dbh the handle to the database | |
38 | * @param table the name of the table | |
39 | */ | |
40 | function DiogenesDatabaseTable(&$dbh,$table) | |
41 | { | |
42 | $this->dbh =& $dbh; | |
43 | $this->table = $table; | |
44 | ||
45 | $res = $this->dbh->query("show columns from $table"); | |
46 | while (list($name,$ftype,,$key,$value,$extra) = mysql_fetch_row($res)) | |
47 | { | |
48 | if (!preg_match("/^([a-z]+)(\(([^\)]*)\))?( [a-z]+)?$/",$ftype,$matches)) | |
49 | die("could not parse $ftype"); | |
50 | ||
51 | $dtype = $matches[1]; | |
52 | switch($dtype) { | |
53 | case "set": case "enum": | |
54 | $type = "set"; | |
55 | break; | |
56 | case "timestamp": | |
57 | case "datetime": | |
58 | $type = "timestamp"; | |
59 | break; | |
60 | default: | |
61 | $type="text"; | |
62 | } | |
63 | $this->vars[$name] = array("table" => $this->table, "field" => $name, | |
64 | "type" => $type, "value" => $value, "desc" => $name, "sum" => false, | |
65 | "key" => $key, "extra" => $extra, "edit" => true, "show" => true); | |
66 | } | |
67 | } | |
68 | ||
69 | } | |
70 | ||
71 | ?> |