/** edit a field * @param $request * @return PDOStatement|string */ public function edit_field($request) { $controller = new Controller(); try { $str = "ALTER TABLE " . $request['name_db'] . "." . $request['table_name'] . " CHANGE "; $str = $str . $request['odl_field_name'] . " " . $request['new_field_name'] . " " . $request['new_type_field'] . "(" . $request['new_size_field'] . ")"; $str = $request['new_isNull_field'] == "NO" ? $str . " NOT NULL" : $str . " NULL"; if ($request['new_default_field'] == "NULL") { $str = $str . " DEFAULT NULL"; } else { if ($request['new_default_field'] == "CURRENT_TIMESTAMP") { $str = $str . " DEFAULT CURRENT_TIMESTAMP"; } else { if ($request['new_default_field'] == "Aucune") { $str = $str . ""; } else { $str . " DEFAULT '" . $request['new_default_field'] . "'"; } } } $controller->write_log_sql($str); $result = Connector::prepare($str, NULL); return $result; } catch (PDOException $e) { return $e->getMessage(); } unset($controller); }