Axiso a dit:
<?php include '../include/connexion_db.php';
$query = "SELECT ADMIN_ID FROM administration WHERE ADMIN_USER = '".mysql_real_escape_string($_POST["username"])."' AND ADMIN_MDP = '".mysql_real_escape_string($_POST["password"])."'";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
$id = $row[0];
if ($id == '0')
{
echo "<script language='javascript' type='text/javascript'>\n
window.location.replace('home.php');\n
</script>";
$_SESSION['login'] = "ok";
}
else
{
echo "<script language='javascript' type='text/javascript'>\n
window.location.replace('index.php?msg=1');\n
</script>";
}
include '../include/deconnexion_db.php';
?><?php
include '../include/connexion_db.php';
include 'valid_login.php';
if ( isset( $_POST['fdp'] )) $fdp = mysql_real_escape_string($_POST['fdp']);
if ( isset( $_POST['fdp_gratuit'] )) $fdp_gratuit = mysql_real_escape_string($_POST['fdp_gratuit']);
$query = "UPDATE fdp SET FDP_PRIX = '$fdp', FDP_GRATUIT = '$fdp_gratuit' WHERE FDP_ID = '0'";
$result = mysql_query($query);
echo "<script language='javascript' type='text/javascript'>\n
window.location.replace('fdp.php?modif_info=ok');\n
</script>";
include '../include/deconnexion_db.php';
?><?php
include '../include/connexion_db.php';
$dest_dossier = '../upload_shop/';
$isOk = 0;
/***********************************************************************************************************************
TRAITEMENT DE LA PHOTO 1
***********************************************************************************************************************/
if(isset($_FILES['file']))
{
// formatage nom fichier : enlever les accents, remplacer les caracteres autres que lettres, chiffres et point par _
$timestamp=date("U"); //SECONDES ECOULEES DEPUIS LE 1ER JANVIER 1970
$dest_fichier = basename($_FILES['file']['name']);
$dest_fichier = strtr($dest_fichier, '¿¡¬√ƒ≈«»… ÀÃÕŒœ“”‘’÷Ÿ⁄€‹›‡·‚„‰ÂÁËÈÍÎÏÌÓÔÚÛÙıˆ˘˙˚¸˝ˇ', 'AAAAAACEEEEIIIIOOOOOUUUUYaaaaaaceeeeiiiioooooouuuuyy');
$dest_fichier = preg_replace('/([^.a-z0-9]+)/i', '_', $dest_fichier);
if ($dest_fichier != '')
{
// copie du fichier
$dest_fichier=$timestamp.'_'.$dest_fichier;
move_uploaded_file($_FILES['file']['tmp_name'], $dest_dossier . $dest_fichier);
}
else
$dest_fichier = '';
$queryFree = "SELECT UIS_1, UIS_2, UIS_3, UIS_4, UIS_5 FROM uploadimagesshop WHERE UIS_ID = '0'";
$resultFree = mysql_query($queryFree);
$rowFree = mysql_fetch_row($resultFree);
$image_1 = $rowFree[0];
$image_2 = $rowFree[1];
$image_3 = $rowFree[2];
$image_4 = $rowFree[3];
$image_5 = $rowFree[4];
if (($image_1 == "NA") && ($isOk == 0))
{
$query = "UPDATE uploadimagesshop SET UIS_1 = '$dest_fichier' WHERE UIS_ID = '0'";
$result = mysql_query($query);
$isOk = 1;
}
if (($image_2 == "NA") && ($isOk == 0))
{
$query = "UPDATE uploadimagesshop SET UIS_2 = '$dest_fichier' WHERE UIS_ID = '0'";
$result = mysql_query($query);
$isOk = 1;
}
if (($image_3 == "NA") && ($isOk == 0))
{
$query = "UPDATE uploadimagesshop SET UIS_3 = '$dest_fichier' WHERE UIS_ID = '0'";
$result = mysql_query($query);
$isOk = 1;
}
if (($image_4 == "NA") && ($isOk == 0))
{
$query = "UPDATE uploadimagesshop SET UIS_4 = '$dest_fichier' WHERE UIS_ID = '0'";
$result = mysql_query($query);
$isOk = 1;
}
if (($image_5 == "NA") && ($isOk == 0))
{
$query = "UPDATE uploadimagesshop SET UIS_5 = '$dest_fichier' WHERE UIS_ID = '0'";
$result = mysql_query($query);
$isOk = 1;
}
}
echo "<script language='javascript' type='text/javascript'>\n
window.location.replace('uploadImages.php');\n
</script>";
include '../include/deconnexion_db.php'; ?><?PHP
function dumpMySQL($serveur, $login, $password, $base, $mode)
{
$connexion = mysql_connect($serveur, $login, $password);
mysql_select_db($base, $connexion);
$entete = "-- ----------------------\n";
$entete .= "-- dump de la base ".$base." au ".date("d-M-Y")."\n";
$entete .= "-- ----------------------\n\n\n";
$creations = "";
$insertions = "\n\n";
$listeTables = mysql_query("show tables", $connexion);
while($table = mysql_fetch_array($listeTables))
{
// si l'utilisateur a demandé la structure ou la totale
if($mode == 1 || $mode == 3)
{
$creations .= "-- -----------------------------\n";
$creations .= "-- creation de la table ".$table[0]."\n";
$creations .= "-- -----------------------------\n";
$listeCreationsTables = mysql_query("show create table ".$table[0], $connexion);
while($creationTable = mysql_fetch_array($listeCreationsTables))
{
$creations .= $creationTable[1].";\n\n";
}
}
// si l'utilisateur a demandé les données ou la totale
if($mode > 1)
{
$donnees = mysql_query("SELECT * FROM ".$table[0]);
$insertions .= "-- -----------------------------\n";
$insertions .= "-- insertions dans la table ".$table[0]."\n";
$insertions .= "-- -----------------------------\n";
while($nuplet = mysql_fetch_array($donnees))
{
$insertions .= "INSERT INTO ".$table[0]." VALUES(";
for($i=0; $i < mysql_num_fields($donnees); $i++)
{
if($i != 0)
$insertions .= ", ";
if(mysql_field_type($donnees, $i) == "string" || mysql_field_type($donnees, $i) == "blob")
$insertions .= "'";
$insertions .= addslashes($nuplet[$i]);
if(mysql_field_type($donnees, $i) == "string" || mysql_field_type($donnees, $i) == "blob")
$insertions .= "'";
}
$insertions .= ");\n";
}
$insertions .= "\n";
}
}
mysql_close($connexion);
$timestamp=date("Y-m-d");
$fichierDump = fopen("backupMySql/".$timestamp.".sql", "wb");
fwrite($fichierDump, $entete);
fwrite($fichierDump, $creations);
fwrite($fichierDump, $insertions);
fclose($fichierDump);
echo "Sauvegarde réalisée avec succès !!";
}
include '../include/connexion_db.php';
dumpMySQL($db_host, $db_user, $db_pass, $db_name, 3);
?>➡️ Offre MyRankingMetrics ⬅️
pré-audit SEO gratuit avec RM Tech (+ avis d'expert)
coaching offert aux clients (avec Olivier Duffez ou Fabien Faceries)
Voir les détails ici
