slt,
je veut faire une modification,mais tjs il me dit qu'il y a une erreurs ds la ligne 14.
voila le script si vous trouver une solution.
sa urge pour mon PFE
<html>
<head>
<STYLE type=text/css>
textarea {
BACKGROUND-COLOR: #Fbcccc; COLOR: #cc0033; FONT-FAMILY: arial; FONT-SIZE: 14px
}
INPUT{
BACKGROUND-COLOR: #Fbcccc; COLOR: #cc0033; FONT-FAMILY: arial; FONT-SIZE: 12px
}
</STYLE>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body bgcolor="#CCCCCC">
<?php
----> (ligne14) if(isset($action['modifier']))
{
$con= mysql_connect("localhost","root","");
$db = mysql_select_db("solar_base",$con);
$sql="UPDATE sonnerie SET `nom_sonnerie`='$nom_sonnerie',`type_sonnerie`='$type_sonnerie',`date_insertion`='$date'";
mysql_query($sql);
$sql1="UPDATE theme SET `nom_theme`='$nom_theme' WHERE categorie_theme='sonnerie'";
mysql_query($sql1);
$sql2="UPDATE portable SET `marque_du_portable`='$marque_du_portable',`modele_du_portable`='$modele_du_portable'";
mysql_query($sql2);
mysql_close($con);
include "ok.php" ;
}
else
{
$con= mysql_connect("localhost","root","");
$db = mysql_select_db("solar_base",$con);
$date=strftime("%Y-%m-%d %H:%M:%S");
$res = mysql_query("select * from sonnerie",$con);
$num = mysql_num_rows ($res);
$i=0;
$res1 = mysql_query("select nom_theme from theme where categorie_theme='sonnerie'",$con);
$num1 = mysql_num_rows ($res1);
$res2 = mysql_query("select marque_du_portable,modele_du_portable from portable",$con);
$num2 = mysql_num_rows ($res2);
while (($i<$num)&&($i<$num1)&&($i<$num2))
{
$id_sonnerie = mysql_result ($res,$i,"id_sonnerie");
$nom_sonnerie = mysql_result ($res,$i,"nom_sonnerie");
$type_sonnerie = mysql_result ($res,$i,"type_sonnerie");
$date_insertion = mysql_result ($res,$i,"date_insertion");
$nom_theme = mysql_result ($res1,$i,"nom_theme");
$marque_du_portable = mysql_result ($res2,$i,"marque_du_portable");
$modele_du_portable = mysql_result ($res2,$i,"modele_du_portable");
list($year, $month, $day) = explode("-", $date_insertion);
$date2 = "$day-$month-$year";
}
echo"<table border = 1 cellspacing=1>";
echo"<form action = update.php method = post>";
echo"<input type = hidden name = action value = modifier >";
echo"<tr><td><font face =tahoma size =2><b>Nom de la sonnerie : </b></font></td><td> <input type = text name = nom_sonnerie size=30 value = '$nom_sonnerie'></td></tr>";
echo"<tr><td><font face =tahoma size =2><b>Type de sonnerie : </b></font> </td><td><select name= type_sonnerie size=1 value = '$type_sonnerie' ><option selected>------Choisissez le type-------</option>
<option>POLYPHONIQUE</option>
<option>MONOPHONIQUE</option>
<option>SON REEL</option>
<option>VOIX REELLES</option>
</select></td></tr>";
echo"<tr><td><font face =tahoma size =2><b>Nom du thème :</b></font> </td><td><input type = text name = nom_theme size=30 value = '$nom_theme'></td></tr>";
echo"<tr><td><font face =tahoma size =2><b>Marque du portable :</b></font> </td><td><select name=marque_du_portable size=1 value='$marque_du_portable'>
<option selected>-------Choisissez Marque------</option>
<option>ALcatel</option>
<option>BenQ</option>
<option>Bosch</option>
<option>DBtel</option>
<option>Handspring</option>
<option>LG</option>
<option>Maxon</option>
<option>Mitsubichi</option>
<option>Motorola</option>
<option>MyWay</option>
<option>NEC</option>
<option>NOKIA</option>
<option>Panasonic</option>
<option>Philips</option>
<option>Qtek</option>
<option>Sagem</option>
<option>Samsung</option>
<option>Sendo</option>
<option>Sharp</option>
<option>Simens</option>
<option>Sony Ericson</option>
<option>SPV</option>
<option>Telital</option>
<option>Tochiba</option>
<option>Trium</option>
<option>Wonu</option>
</select></td></tr>";
echo"<tr><td><font face =tahoma size =2><b>Modèle du portable :</b></font> </td><td><input type = text name =modele_du_portable size=30 value = '$modele_du_portable'></td></tr>";
echo"<tr><td colspan = 2 align = center><input type = submit value = modifier></td></tr>";
echo"<input type = hidden name = id_sonnerie value = '$id_sonnerie'>";
echo"</form>";
echo"</table>";
mysql_close($con);
}
?>
<?
$host = "localhost";
$login = "root";
$pass = "";
$base = "solar_base";
$identification= MYSQL_CONNECT($host,$login,$pass);
mysql_select_db($base);
$query = "SELECT * FROM sonnerie WHERE id_sonnerie='$id_sonnerie'";
$result = @mysql_query($query,$identification);
$date=strftime("%Y-%m-%d %H:%M:%S");
$query = "SELECT * FROM sonnerie WHERE id_sonnerie='$id_sonnerie'";
$result = @mysql_query($query);
$query1 = "SELECT nom_theme FROM theme WHERE categorie_theme='sonnerie'";
$result1 = @mysql_query($query1);
$query2 = "SELECT marque_du_portable,modele_du_portable FROM portable";
$result2 = @mysql_query($query2);
while (($row = @mysql_fetch_array($result))&&($row1 = @mysql_fetch_array($result1))&&($row2 = @mysql_fetch_array($result2)))/* récupération des valeurs dans un tableau */
{
$nom_sonnerie = $row["nom_sonnerie"];
$type_sonnerie = $row["type_sonnerie"];
$nom_theme = $row1["nom_theme"];
$marque_du_portable = $row2["marque_du_portable"];
$modele_du_portable = $row2["modele_du_portable"];
?>
<form action="" method="">
<table width="60%" border="2" align="left" cellpadding="3" cellspacing="0">
<tr valign="top">
<td width="22%" height="19" bgcolor="#999999"> <p><strong><font size="2" face="Arial, Helvetica, sans-serif">Nom
de la sonnerie :</font></strong></p></td>
<td width="78%" bgcolor="fbcccc"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="nom_sonnerie" type="text" value="<? echo"$nom_sonnerie"; ?>" size="30">
</font></td>
</tr>
<tr valign="top">
<td height="29" bgcolor="#999999"><strong><font size="2" face="Arial, Helvetica, sans-serif">Type de sonnerie :</font></strong></td>
<td bgcolor="fbcccc"><font size="2" face="Arial, Helvetica, sans-serif">
<select name="type_sonnerie" size="1" value= "<? echo"$type_sonnerie"; ?>"> </selected>
</font></td>
</tr>
<tr valign="top">
<td height="19" bgcolor="#999999"><strong><font size="2" face="Arial, Helvetica, sans-serif">Nom du thème
: </font></strong></td>
<td bgcolor="fbcccc"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="nom_theme" type="text" value= "<? echo"$nom_theme"; ?>" size="30" >
</font></td>
</tr>
<tr valign="top">
<td height="19" bgcolor="#999999"><strong><font size="2" face="Arial, Helvetica, sans-serif">Marque du portable
: </font></strong></td>
<td bgcolor="fbcccc"><font size="2" face="Arial, Helvetica, sans-serif">
<select name="marque_du_portable" size=1 value= "<? echo"$marque_du_portable"; ?>"></selected>
</font></td>
</tr>
<tr valign="top">
<td height="19" bgcolor="#999999"><strong><font size="2" face="Arial, Helvetica, sans-serif">Modèle du portable
: </font></strong></td>
<td bgcolor="fbcccc"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="modele_du_portable" type="text" value= "<? echo"$modele_du_portable"; ?>" size="30" >
</font></td>
</tr>
</table>
</form>
<?
}
?>
</body>
</html>
