ours70 Profil : Membre | J'ai un probleme : J'aimerais ajouter des cd dans une BDD mais il me dit qu'il y a unez erreur , je ne la voit pas pouvez vous m'aider ??
Merci Voici le code !!
Page add_cd Code :
- <?php
- require_once ("_protect.php" );
- if(isset($_SESSION['pseudo']) AND isset($_SESSION['motpass']))
- {
- ?>
- <form method="POST" action="confirm_cd.php">
- <?php
- include ("htpacces.php" );
- mysql_connect("$ftp", "$login", "$pass" );
- mysql_select_db("$bd" );
- if(isset($_GET['modif_cd']))
- {
- $val=mysql_query('Select * From cd Where id_cd=\''.$_GET['modif_cd'].'\'');
- $val_rang=mysql_fetch_array($val);
- $id_cd=stripslashes($val_rang['id_cd']);
- $Nom_album=stripslashes($val_rang['Nom_album']);
- $Nom_artiste=stripslashes($val_rang['Nom_artiste']);
- $Date_Sortie=stripslashes($val_rang['Date_Sortie']);
- $Style_artiste=stripslashes($val_rang['Style_artiste']);
- $Synopsis_Artiste=stripslashes($val_rang['Synopsis_Artiste']);
- $Prix_Achat=stripslashes($val_rang['Prix_Achat']);
- $Marge=stripslashes($val_rang['Marge']);
- $Prix_Vente=stripslashes($val_rang['Prix_Vente']);
- $Stock=stripslashes($val_rang['Stock']);
- $Top_Ventes=stripslashes($val_rang['Top_Ventes']);
- $bouton="Modifier";
- echo '<title> Administration | Modifier un cd</title>';
- }
- else
- {
- $id_cd='';
- $Nom_album='';
- $Nom_artiste='';
- $Date_Sortie='';
- $Style_artiste='';
- $Synopsis_Artiste='';
- $Prix_Achat='';
- $Marge='';
- $Prix_Vente='';
- $Stock='';
- $Top_Ventes='';
- $bouton="Ajouter";
- echo '<title>Administration | Ajouter un cd</title>';
- }
- ?>
- <CENTER><TABLE>
- <TR> AJOUT D'UN CD
- <TD>Nom du CD : <input type='text' size="50" maxlength="60" name="Nom_album" value='<?php echo $Nom_album; ?>'><BR><BR>
- </TD>
- </TR>
- <TR>
- <TD>Nom artiste: <input type="text" size="50" maxlength="60" name='Nom_artiste' value='<?php echo $Nom_artiste; ?>'><BR><BR>
- </TD>
- </TR>
- <TR>
- <TD>Date Sortie: <input type="text" size="50" maxlength="60" name='Date_Sortie' value='<?php echo $Date_Sortie; ?>'><BR><BR>
- </TD>
- </TR>
- <TR>
- <TR>
- <TD>Style artiste: <input type="text" size="50" maxlength="60" name='Style_artiste' value='<?php echo $Style_artiste; ?>'><BR><BR>
- </TD>
- </TR>
- <TR>
- <TD>Synopsis Artiste: <input type="text" size="50" maxlength="60" name='Synopsis_Artiste' value='<?php echo $Synopsis_Artiste; ?>'><BR><BR>
- </TD>
- </TR>
- <TR>
- <TD>Prix achat: <input type="text" size="50" maxlength="60" name='Prix_Achat' value='<?php echo $Prix_Achat; ?>'><BR><BR>
- </TD>
- </TR>
- <TR>
- <TD>Marge: <input type="text" size="50" maxlength="60" name='Marge' value='<?php echo $Marge; ?>'><BR><BR>
- </TD>
- </TR>
- <TR>
- <TD>Prix Vente: <input type="text" size="50" maxlength="60" name='Prix_Vente' value='<?php echo $Prix_Vente; ?>'><BR><BR>
- </TD>
- </TR>
- <TR>
- <TD>Stock: <input type="text" size="50" maxlength="60" name='Stock' value='<?php echo $Stock; ?>'><BR><BR>
- </TD>
- </TR>
- <TR>
- <TD>Top Vente: <input type="text" size="50" maxlength="60" name='Top_Ventes' value='<?php echo $Top_Ventes; ?>'><BR><BR>
- </TD>
- </TR>
- </TABLE><BR>
- <input type="submit" value="<?php echo $bouton; ?>">
- </CENTER></form>
- <?php
- }
- ?>
|
page :comfirm_cd
Code :
- <?php
- require_once ("_protect.php" );
- if(isset($_SESSION['pseudo']) AND isset($_SESSION['motpass']))
- {
- ?>
- <?php
- require_once ("htpacces.php" );
- mysql_connect($ftp, $login, $pass);
- mysql_select_db($bd);
- if(isset($_GET['delete_CD']))
- {
- echo '<title>Administration | Suppression d\'un CD</title>';
- echo '<META http-equiv="refresh" content="1; URL=admin.php">';
- $_GET['delete_CD']=addslashes($_GET['delete_CD']);
- mysql_query('DELETE FROM CD WHERE id_cd=\''.$_GET['delete_CD'].'\'');
- echo '<center> Le CD a été bien supprimé !! </center>';
- }
- else
- {
- if(isset($val_rang['id_cd']) AND isset($val_rang['nom_album']) AND isset($val_rang['Nom_Artiste']) AND isset($val_rang['Date_Sortie']) AND isset($val_rang['Style_artiste']) AND isset($val_rang['Synopsis_Artiste']) AND isset($val_rang['Prix_Achat']) AND isset($val_rang['Marge']) AND isset($val_rang['Prix_Vente']) AND isset($val_rang['Stock']) AND isset($val_rang['Top_Ventes']))
- {
- $id_cd=stripslashes($val_rang['id_cd']);
- $Nom_album=stripslashes($val_rang['Nom_album']);
- $Nom_artiste=stripslashes($val_rang['Nom_artiste']);
- $Date_Sortie=stripslashes($val_rang['Date_Sortie']);
- $Style_artiste=stripslashes($val_rang['Style_artiste']);
- $Synopsis_Artiste=stripslashes($val_rang['Synopsis_Artiste']);
- $Prix_Achat=stripslashes($val_rang['Prix_Achat']);
- $Marge=stripslashes($val_rang['Marge']);
- $Prix_Vente=stripslashes($val_rang['Prix_Vente']);
- $Stock=stripslashes($val_rang['Stock']);
- $Top_Ventes=stripslashes($val_rang['Top_Ventes']);
- if($_POST['id_user']==1)
- {
- echo '<title>Administration | Confirmation d\'un ajout de CD</title>';
- mysql_query("INSERT INTO CD VALUES('$id_cd', '$Nom_album', '$Nom_artiste', '$Date_Sortie', '$Style_artiste', '$Synopsis_Artiste', '$Prix_Achat', '$Marge', '$Prix_Vente', '$Stock', '$Top_Ventes')" ) OR die('Erreur SQL!<br>'.mysql_error());
- echo '<center> Votre CD a été créé et enregistré !! </center>';
- echo '<META http-equiv="refresh" content="1; URL=all_CD.php">';
- }
- else
- {
- echo '<title>Administration | Confirmation d\'une modification d\'un CD</title>';
- $id_user=addslashes($_POST['id_user']);
- mysql_query("UPDATE CD SET id_cd='id_cd', Nom_Album='$Nom_album', Nom_artiste='$Nom_artiste', Date_Sortie='$Date_Sortie', Style_artiste='$Style_artiste', Synopsis_Artiste='$Synopsis_Artiste', Prix_Achat='$Prix_Achat', Marge='$Marge', Prix_Vente='$Prix_Vente', Stock='$Stock', Top_Ventes='$Top_Ventes' WHERE Nom_album='$id_cd'" ) OR die('Erreur SQL!<br>'.mysql_error());
- echo '<center> Votre CD a été modifié !! </center>';
- echo '<META http-equiv="refresh" content="1; URL=all_CD.php">';
- }
- }
- else
- {
- echo 'Vous n\'avez pas remplit tout les champs comportant <B>*</B>';
- echo '<META http-equiv="refresh" content="1; URL=add_cd.php">';
- }
- }
- ?>
- <?php
- }
- ?>
|
Message édité par ours70 le 16-05-2008 à 19:59:23
|