public function verify_column_synchro($ctx = "") { unset($ctx['table_list']); if (isset($ctx) && $ctx != '' && $ctx != ' ') { if (is_array($ctx)) { $ctx_object = new stdClass(); foreach ($ctx as $key => $values) { $ctx_object->{$key} = $values; } } $compteur = 0; foreach ($ctx_object as $row) { $req_list_champs = 'SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME="' . $row . '"'; $res_list_champs = $this->other_query($req_list_champs); $created_on_create = false; $modified_on_create = false; foreach ($res_list_champs as $row_champs) { if (isset($row_champs->COLUMN_NAME)) { if ($row_champs->COLUMN_NAME == "created_on") { $created_on_create = true; } if ($row_champs->COLUMN_NAME == "modified_on") { $modified_on_create = true; } } } $date_now = date('Y-m-d H:i:s'); if ($created_on_create == false) { $this->add_new_column($row, 'created_on', $type = "DATETIME NOT NULL"); $req_sql = 'UPDATE ' . $row . ' SET created_on = "' . $date_now . '"'; parent::query($req_sql); $compteur++; } if ($modified_on_create == false) { $this->add_new_column($row, 'modified_on', $type = "DATETIME NOT NULL"); $req_sql = 'UPDATE ' . $row . ' SET modified_on = "' . $date_now . '"'; parent::query($req_sql); $compteur++; } if ($created_on_create == "0000-00-00 00:00:00") { $req_sql = 'UPDATE ' . $row . ' SET created_on = "' . $date_now . '"'; parent::query($req_sql); $compteur++; } if ($modified_on_create == "0000-00-00 00:00:00") { $req_sql = 'UPDATE ' . $row . ' SET created_on = "' . $date_now . '"'; parent::query($req_sql); $compteur++; } } } else { return 'erreur survenue dans la fonction verify_column_synchro par rapport aux données reçues'; } return 'Votre insertion et synchronisation + add des colonne pour la synchro se sont bien déroulée : Nobmre de modification : ' . $compteur; }
public function delete_row($table, $where) { $req_sql = "DELETE FROM " . $table . " WHERE " . $where; parent::query($req_sql); }