Problème de lien entre BDD MySQL et PHP
rskas
-
lucas06150 Messages postés 147 Date d'inscription Statut Membre Dernière intervention -
lucas06150 Messages postés 147 Date d'inscription Statut Membre Dernière intervention -
Bonjour, je suis en train de faire un code en php, et je tombe sur un os : les modifications faites sur la page via un code php ne sont pas enregistrées sur la base de données, j'ai tout vérifier et il ne me semble pas avoir d'erreur, j'ai tout vérifier est aucun message d'erreur apparaît.
Voici le code source :
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="fr" xml:lang="fr">
<head>
<link rel="shortcut icon" href="images/ico.png"/>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" media="screen" type="text/css" title="style" href="http://*****.com/***********/***/******.css" />
<title>Administration</title>
</head>
<body>
<body>
<script>
var max = 100;
var min = 0;
var opacite=min;
up=true;
var IsIE=!!document.all;
var ThePic=document.getElementById("spaffySpecial");
function fadePic(){
if (opacite<max && up){opacite+=5;}
IsIE?ThePic.filters[0].opacity=opacite:document.getElementById("spaffySpecial").style.opacity=opacite/100;
document.getElementById('result').value=opacite+"%"
}
setInterval(function(){fadePic();},100)
</script>
<?php
include ('sql/1.php');
$actus_index = $_POST['actus_index'];
$menu_1 = $_POST['menu_1'];
$menu_2 = $_POST['menu_2'];
$menu_3 = $_POST['menu_3'];
$menu_4 = $_POST['menu_4'];
$menu_5 = $_POST['menu_5'];
$menu_6 = $_POST['menu_6'];
$menu_7 = $_POST['menu_7'];
$post = $_POST['post'];
$bandeau = $_POST['bandeau'];
$index = $_POST['index'];
mysql_query("UPDATE actus_index SET contenu=$actus_index' 'WHERE id='1'");
mysql_query("UPDATE contenu SET contenu='$menu_1' 'WHERE page='menu_1'");
mysql_query("UPDATE contenu SET contenu='$menu_2' 'WHERE page='menu_2'");
mysql_query("UPDATE contenu SET contenu='$menu_3' 'WHERE page='menu_3'");
mysql_query("UPDATE contenu SET contenu='$menu_4' 'WHERE page='menu_4'");
mysql_query("UPDATE contenu SET contenu='$menu_5' 'WHERE page='menu_5'");
mysql_query("UPDATE contenu SET contenu='$menu_6' 'WHERE page='menu_6'");
mysql_query("UPDATE contenu SET contenu='$menu_7' 'WHERE page='menu_7'");
mysql_query("UPDATE contenu SET contenu='$post' 'WHERE page='post'");
mysql_query("UPDATE contenu SET contenu='$bandeau' 'WHERE page ='bandeau'");
mysql_query("UPDATE contenu SET contenu='$index' 'WHERE page='index.php'");
?>
<html>
<h1>Accueil</h1>
<div id="head">
<form action="index.php" method="post">
<textarea name="actus_index" rows="1" cols="100"><?php echo $donnees['contenu']; ?></textarea>
</div>
<div id="menu">
<?
include ('sql/1.php');$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_1'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_1" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_2'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_2" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_3'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_3" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_4'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_4" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_5'");
while ($donnees = mysql_fetch_array($retour))
{
?><textarea name="menu_5" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_6'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_6" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_7'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_7" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
</ul>
</div>
</head>
<body>
<div id="bandeau2">
<textarea name="post" rows="18" cols="23"></textarea>
</div>
<div id="bandeau">
<textarea name="bandeau" rows="19" cols="24"></textarea>
</div>
<div id="spaffySpecial">
<div id="corps">
<table>
<textarea name="index" rows="50" cols="100"></textarea></table>
</div>
</div>
<input type="submit" value="Sauvegarder les modification" /><a decoration="none" href="" target=""><input type="button" value="Annuler"></a>
</body>
</html>
Voici le code source :
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="fr" xml:lang="fr">
<head>
<link rel="shortcut icon" href="images/ico.png"/>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" media="screen" type="text/css" title="style" href="http://*****.com/***********/***/******.css" />
<title>Administration</title>
</head>
<body>
<body>
<script>
var max = 100;
var min = 0;
var opacite=min;
up=true;
var IsIE=!!document.all;
var ThePic=document.getElementById("spaffySpecial");
function fadePic(){
if (opacite<max && up){opacite+=5;}
IsIE?ThePic.filters[0].opacity=opacite:document.getElementById("spaffySpecial").style.opacity=opacite/100;
document.getElementById('result').value=opacite+"%"
}
setInterval(function(){fadePic();},100)
</script>
<?php
include ('sql/1.php');
$actus_index = $_POST['actus_index'];
$menu_1 = $_POST['menu_1'];
$menu_2 = $_POST['menu_2'];
$menu_3 = $_POST['menu_3'];
$menu_4 = $_POST['menu_4'];
$menu_5 = $_POST['menu_5'];
$menu_6 = $_POST['menu_6'];
$menu_7 = $_POST['menu_7'];
$post = $_POST['post'];
$bandeau = $_POST['bandeau'];
$index = $_POST['index'];
mysql_query("UPDATE actus_index SET contenu=$actus_index' 'WHERE id='1'");
mysql_query("UPDATE contenu SET contenu='$menu_1' 'WHERE page='menu_1'");
mysql_query("UPDATE contenu SET contenu='$menu_2' 'WHERE page='menu_2'");
mysql_query("UPDATE contenu SET contenu='$menu_3' 'WHERE page='menu_3'");
mysql_query("UPDATE contenu SET contenu='$menu_4' 'WHERE page='menu_4'");
mysql_query("UPDATE contenu SET contenu='$menu_5' 'WHERE page='menu_5'");
mysql_query("UPDATE contenu SET contenu='$menu_6' 'WHERE page='menu_6'");
mysql_query("UPDATE contenu SET contenu='$menu_7' 'WHERE page='menu_7'");
mysql_query("UPDATE contenu SET contenu='$post' 'WHERE page='post'");
mysql_query("UPDATE contenu SET contenu='$bandeau' 'WHERE page ='bandeau'");
mysql_query("UPDATE contenu SET contenu='$index' 'WHERE page='index.php'");
?>
<html>
<h1>Accueil</h1>
<div id="head">
<form action="index.php" method="post">
<textarea name="actus_index" rows="1" cols="100"><?php echo $donnees['contenu']; ?></textarea>
</div>
<div id="menu">
<?
include ('sql/1.php');$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_1'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_1" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_2'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_2" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_3'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_3" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_4'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_4" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_5'");
while ($donnees = mysql_fetch_array($retour))
{
?><textarea name="menu_5" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_6'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_6" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
<?$retour = mysql_query("SELECT 'contenu' FROM 'contenu' WHERE page='menu_7'");
while ($donnees = mysql_fetch_array($retour))
{
?>
<textarea name="menu_7" rows="1" cols="20"><?php echo $donnees['contenu']; ?></textarea>
<?php
}
?>
</ul>
</div>
</head>
<body>
<div id="bandeau2">
<textarea name="post" rows="18" cols="23"></textarea>
</div>
<div id="bandeau">
<textarea name="bandeau" rows="19" cols="24"></textarea>
</div>
<div id="spaffySpecial">
<div id="corps">
<table>
<textarea name="index" rows="50" cols="100"></textarea></table>
</div>
</div>
<input type="submit" value="Sauvegarder les modification" /><a decoration="none" href="" target=""><input type="button" value="Annuler"></a>
</body>
</html>
