public function select_simple($var, $from, $where = '', $order = '', $type_return = 'object', $limite = '') { if ($where != '') { $req_sql = "SELECT " . $var . " FROM " . $from . " WHERE " . $where . ""; } else { $req_sql = "SELECT " . $var . " FROM " . $from . ""; } if ($order != '') { $req_sql = $req_sql . " " . $order; } if ($limite != '') { $req_sql = $req_sql . ' LIMIT ' . $limite; } // $security = new security(); // instancie le fichier de securiter // $req_sql = $security->verif_req($req_sql); // return la requète sécurisée ! if ($type_return == 'object') { $i = 0; while ($row = parent::fetch_object($req_sql)) { $res_fx[$i] = $row; $i++; } } else { if ($type_return == 'array') { $i = 0; while ($row = parent::fetch_array($req_sql)) { $res_fx[$i] = $row; $i++; } } else { if ($type_return == 'assoc') { $i = 0; while ($row = parent::fetch_assoc($req_sql)) { $res_fx[$i] = $row; $i++; } } } } unset($req_sql); //vide le buffer de memoire $req_sql pour liberer de la place if (!isset($res_fx)) { return ''; } else { return $res_fx; } }
function info_table() { $_db_connect = new _db_connect(); $base_name = $_db_connect->get_name_base(); $req_sql = "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='" . $base_name . "'"; while ($row = $_db_connect->fetch_object($req_sql)) { unset($row->TABLE_CATALOG); unset($row->ENGINE); unset($row->VERSION); unset($row->AVG_ROW_LENGTH); unset($row->INDEX_LENGTH); unset($row->DATA_FREE); unset($row->CHECK_TIME); unset($row->CHECKSUM); unset($row->CREATE_OPTIONS); unset($row->TABLE_COMMENT); affiche_pre($row); } unset($row); unset($req_sql); }