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

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

Назад
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Recensement</title> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> <meta name="generator" content="HAPedit 3.1"> </head> <body bgcolor="#FFFFFF"> <? include('../choix_xx.inc'); //nouvelle fiche??? if($_GET['id']==0){fait_new();$id=get_last();} else{$id=$_GET['id'];} //echo("id=".$id."<br>"); $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); //mehari_an $sql="UPDATE `rec_mehari` SET `mehari_an` = '".$_GET['mehari_an']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_type $sql="UPDATE `rec_mehari` SET `mehari_type` = '".$_GET['mehari_type']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_numero_serie $sql="UPDATE `rec_mehari` SET `mehari_numero_serie` = '".$_GET['mehari_numero_serie']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_enac $sql="UPDATE `rec_mehari` SET `mehari_enac` = '".$_GET['mehari_enac']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_immatriculation $sql="UPDATE `rec_mehari` SET `mehari_immatriculation` = '".$_GET['mehari_immatriculation']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_date_circulation $sql="UPDATE `rec_mehari` SET `mehari_date_circulation` = '".$_GET['mehari_date_circulation']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //echo($sql."<br>"); //modele_id $sql="UPDATE `rec_mehari` SET `modele_id` = '".$_GET['modele_id']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_couleur $sql="UPDATE `rec_mehari` SET `mehari_couleur` = '".$_GET['mehari_couleur']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_place $sql="UPDATE `rec_mehari` SET `mehari_place` = '".$_GET['mehari_place']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //recensement_note echo($_GET['recensement_note']); $_GET['recensement_note']=str_replace("'","\'",$_GET['recensement_note']); //$_GET['recensement_note']=str_replace('"','',$_GET['recensement_note']); //echo($_GET['recensement_note']); $sql="UPDATE `rec_mehari` SET `recensement_note` = '".$_GET['recensement_note']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //post forum $sql="UPDATE `rec_mehari` SET `mehari_post_forum` = '".$_GET['mehari_post_forum']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //recensement_qui $sql="UPDATE `rec_mehari` SET `recensement_qui` = '".$_GET['recensement_qui']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //recensement_email $sql="UPDATE `rec_mehari` SET `recensement_email` = '".$_GET['recensement_email']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_pseudo_forum $sql="UPDATE `rec_mehari` SET `mehari_pseudo_forum` = '".$_GET['mehari_pseudo_forum']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //departement_id $sql="UPDATE `rec_mehari` SET `departement_id` = '".$_GET['departement_id']."' WHERE `rec_mehari`.`id` = ".$id; $result=$link->query($sql); //mehari_numero_serie_id $sql="UPDATE `rec_mehari` SET `mehari_numero_serie_id` = '".$_GET['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); //Pseudo OK if($_GET['mehari_pseudo_forum']) { $sql="UPDATE `rec_mehari` SET `mehari_pseudo_ok` = ".is_pseudo($_GET['mehari_pseudo_forum'])." WHERE `rec_mehari`.`id` = ".$id; } else { $sql="UPDATE `rec_mehari` SET `mehari_pseudo_ok` = ".'0'." WHERE `rec_mehari`.`id` = ".$id; } $result=$link->query($sql); //header('Location:http://www.mehariclubdefrance.com/rec/saisie/saisie.php'); //*********************Graphe //******************************** function fait_Region() { global $Nom_Region,$Nb_Region; $Nom_Region="categories: ["; $Nb_Region="data: ["; $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql = 'SELECT rec_regions.region_nom, Count( rec_mehari.mehari_id ) AS CompteDemehari_id FROM rec_mehari INNER JOIN ( ( rec_regions INNER JOIN rec_pays ON rec_regions.pays_id = rec_pays.pays_id ) INNER JOIN rec_departements ON rec_regions.region_id = rec_departements.region_id ) ON rec_mehari.departement_id = rec_departements.departement_id WHERE(rec_pays.pays_id=1) GROUP BY rec_regions.region_nom ORDER BY `CompteDemehari_id` DESC LIMIT 0, 300'; $result=$link->query($sql); while($region=$result->fetch_assoc()) { $nom=$region['region_nom']; $nom=str_replace("'","\'",$nom); $Nom_Region=$Nom_Region."'".$nom."',"; $Nb_Region=$Nb_Region.$region['CompteDemehari_id'].","; } $Nom_Region=$Nom_Region."],"; $Nb_Region=$Nb_Region."]"; $Nom_Region=str_replace(",]","]",$Nom_Region); $Nb_Region=str_replace(",]","]",$Nb_Region); } //** function fait_Dept() { global $Nom_Dept,$Nb_Dept; $Nom_Dept="categories: ["; $Nb_Dept="data: ["; $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql = 'SELECT departement_id, COUNT() FROM `rec_mehari` GROUP BY `departement_id` ORDER BY `COUNT()` DESC'; $result=$link->query($sql); while($dept=$result->fetch_assoc()) { //en France ? if(france($dept['departement_id'])==1) { $nom=nom_dept($dept['departement_id']); $nom=str_replace("'","\'",$nom); $Nom_Dept=$Nom_Dept."'".$nom."',"; $Nb_Dept=$Nb_Dept.$dept['COUNT()'].","; } } $Nom_Dept=$Nom_Dept."],"; $Nb_Dept=$Nb_Dept."]"; $Nom_Dept=str_replace(",]","]",$Nom_Dept); $Nb_Dept=str_replace(",]","]",$Nb_Dept); } //* function fait_Pays() { global $Nom_Pays,$Nb_Pays; $Nom_Pays="categories: ["; $Nb_Pays="data: ["; $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql = 'SELECT rec_pays.pays_nom, Count( rec_mehari.mehari_id ) AS CompteDemehari_id FROM rec_mehari INNER JOIN ( ( rec_regions INNER JOIN rec_pays ON rec_regions.pays_id = rec_pays.pays_id ) INNER JOIN rec_departements ON rec_regions.region_id = rec_departements.region_id ) ON rec_mehari.departement_id = rec_departements.departement_id GROUP BY rec_pays.pays_nom ORDER BY `CompteDemehari_id` DESC LIMIT 0, 30'; $result=$link->query($sql); while($pays=$result->fetch_assoc()) { $Nom_Pays=$Nom_Pays."'".$pays['pays_nom']."',"; $Nb_Pays=$Nb_Pays.$pays['CompteDemehari_id'].","; } $Nom_Pays=$Nom_Pays."],"; $Nb_Pays=$Nb_Pays."]"; $Nom_Pays=str_replace(",]","]",$Nom_Pays); $Nb_Pays=str_replace(",]","]",$Nb_Pays); } //*** function fait_Type() { global $Nom_Type,$Nb_Type; $Nom_Type="categories: ["; $Nb_Type="data: ["; $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql = 'SELECT rec_modele.modele_desc, Count( rec_mehari.mehari_id ) AS CompteDemehari_id FROM rec_mehari INNER JOIN rec_modele ON rec_mehari.modele_id = rec_modele.modele_id GROUP BY rec_modele.modele_id, rec_modele.modele_desc ORDER BY `CompteDemehari_id` DESC'; $result=$link->query($sql); while($type=$result->fetch_assoc()) { $Nom_Type=$Nom_Type."'".$type['modele_desc']."',"; $Nb_Type=$Nb_Type.$type['CompteDemehari_id'].","; }; $Nom_Type=$Nom_Type."],"; $Nb_Type=$Nb_Type."]"; $Nom_Type=str_replace(",]","]",$Nom_Type); $Nb_Type=str_replace(",]","]",$Nb_Type); } 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); } /function is_pseudo($pseudo) { $pseudo=strtolower($pseudo); $pseudo=utf8_decode($pseudo); $link = mysqli_connect("mehariclclobale.mysql.db", "mehariclclobale", "Pva131254", "mehariclclobale"); $sql="SELECT COUNT() FROM `phpbb_3users` WHERE `username_clean` LIKE '".$pseudo."'"; $result=$link->query($sql); $liste=$result->fetch_assoc(); return($liste['COUNT()']); } / ?> <script> window.location.assign("saisie.php"); </script> </body> </html>

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