Файловый менеджер

Файловый менеджер - Редактировать - /home/meharicl/www/rec/saisie/copy_tmp.php

Назад
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Sans Titre</title> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> <meta name="generator" content="HAPedit 3.1"> </head> <body bgcolor="#FFFFFF"> <? $id_tmp= $_GET['id']; $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql_temp="SELECT * FROM `rec_mehari_tmp` WHERE `id` = ".$id_tmp; $result_tmp=$link->query($sql_temp); while($resultat_tmp=$result_tmp->fetch_assoc()) { fait_new(); $id=get_last(); //mehari_an $sql="UPDATE `rec_mehari` SET `mehari_an` = '".$resultat_tmp['mehari_an']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_type $sql="UPDATE `rec_mehari` SET `mehari_type` = '".$resultat_tmp['mehari_type']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_numero_serie $sql="UPDATE `rec_mehari` SET `mehari_numero_serie` = '".$resultat_tmp['mehari_numero_serie']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_enac $sql="UPDATE `rec_mehari` SET `mehari_enac` = '".$resultat_tmp['mehari_enac']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_immatriculation $sql="UPDATE `rec_mehari` SET `mehari_immatriculation` = '".$resultat_tmp['mehari_immatriculation']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_date_circulation $sql="UPDATE `rec_mehari` SET `mehari_date_circulation` = '".$resultat_tmp['mehari_date_circulation']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //modele_id $sql="UPDATE `rec_mehari` SET `modele_id` = '".$resultat_tmp['modele_id']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_couleur $sql="UPDATE `rec_mehari` SET `mehari_couleur` = '".$resultat_tmp['mehari_couleur']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //pseudo $sql="UPDATE `rec_mehari` SET `mehari_pseudo_ok` = 1 WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); $sql="UPDATE `rec_mehari` SET `mehari_pseudo_forum` = '".$resultat_tmp['mehari_pseudo_forum']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_place $sql="UPDATE `rec_mehari` SET `mehari_place` = '".$resultat_tmp['mehari_place']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //recensement_note $resultat_tmp['recensement_note']=str_replace("'","\'",$resultat_tmp['recensement_note']); $sql="UPDATE `rec_mehari` SET `recensement_note` = '".$resultat_tmp['recensement_note']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //post forum $sql="UPDATE `rec_mehari` SET `mehari_post_forum` = '".$resultat_tmp['mehari_post_forum']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //recensement_qui $sql="UPDATE `rec_mehari` SET `recensement_qui` = '".$resultat_tmp['recensement_qui']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); ///recensement_email $sql="UPDATE `rec_mehari` SET `recensement_email` = '".$resultat_tmp['recensement_email']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //departement_id $sql="UPDATE `rec_mehari` SET `departement_id` = '".$resultat_tmp['departement_id']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_numero_serie_id $sql="UPDATE `rec_mehari` SET `mehari_numero_serie_id` = '".$resultat_tmp['mehari_numero_serie_id']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //update $sql="UPDATE `rec_mehari` SET `last_update` = '".date("Y-m-d")."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //suppression tmp $sql="DELETE FROM `rec_mehari_tmp` WHERE `rec_mehari_tmp`.`id` = ".$id_tmp; echo($sql); $result=$link->query($sql); } //*************************** function get_last() { $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql="SELECT * FROM `rec_mehari` ORDER BY `rec_mehari`.`id` DESC LIMIT 1"; $result=$link->query($sql); $num_id=$result->fetch_assoc(); return($num_id['id']); } function fait_new() { $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql="SELECT * FROM `rec_mehari` ORDER BY `rec_mehari`.`mehari_id` DESC"; $result=$link->query($sql); $l_id=$result->fetch_assoc(); $mehari_id=$l_id['mehari_id']+1; $sql="INSERT INTO `rec_mehari` (`id`, `mehari_id`, `saisie`, `mehari_an`, `mehari_type`, `mehari_numero_serie`, `mehari_date_circulation`, `mehari_modele`, `departement_id`, `recensement_adherent`, `recensement_qui`, `recensement_email`, `mehari_enac`, `mehari_immatriculation`, `recensement_note`, `last_update`, `mehari_couleur`, `mehari_place`, `modele_id`, `mehari_pseudo_forum`, `mehari_pseudo_ok`, `recensement_actif`, `mehari_post_forum`, `mehari_numero_serie_id`) VALUES (NULL, '".$mehari_id."', CURRENT_DATE(), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CURRENT_DATE(), NULL, NULL, '0', NULL, '0', '1', NULL, '0');"; $result=$link->query($sql); } ?> </body> </html>

| ver. 1.4 | Github | . | PHP 7.4.33 | Генерация страницы: 0 | proxy | phpinfo | Настройка