19 $this->pdoObject = new \PDO(
22 $config[
"user"], $config[
"password"]);
23 $this->pdoObject->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
24 $this->pdoObject->exec(
"SET CHARACTER SET utf8");
26 }
catch (\PDOException $e) {
27 print
"Error!: " . $e->getMessage() .
"<br/>";
34 $query = $this->pdoObject->query($sql);
35 return $query->fetchAll(\PDO::FETCH_COLUMN);
40 $recordset = $this->pdoObject->query(
"SHOW COLUMNS FROM `{$tableName}`");
41 $fields = $recordset->fetchAll(\PDO::FETCH_ASSOC);
42 foreach ($fields as $field) {
43 $fieldsInfos[$field[
'Field']] = [
"Type"=>$field[
'Type'],
"Nullable"=>$field[
"Null"]];
50 $recordset = $this->pdoObject->query(
"SHOW KEYS FROM `{$tableName}` WHERE Key_name = 'PRIMARY'");
51 $keys = $recordset->fetchAll(\PDO::FETCH_ASSOC);
52 foreach ($keys as $key) {
53 $fieldkeys[] = $key[
'Column_name'];
59 $recordset = $this->pdoObject->query(
"SELECT * 61 information_schema.KEY_COLUMN_USAGE 63 REFERENCED_TABLE_NAME = '".$tableName.
"' 64 AND REFERENCED_COLUMN_NAME = '".$pkName.
"' 65 AND TABLE_SCHEMA = '".$this->config[
"dbName"].
"';");
66 return $recordset->fetchAll(\PDO::FETCH_ASSOC);
getFieldsInfos($tableName)
getPrimaryKeys($tableName)
getForeignKeys($tableName, $pkName)
connect($config)
Réalise la connexion à la base de données.