Bonjour,
J'ai créer une page PHP dans laquelle je veux pouvoir remplir 4 champs pour les injecter dans ma base de données qui compte 4 champs
(Numaff, Client, Nomaff, Resprojet)
Voici le bout de code de ma page:
[code]
<?php require_once('../Connexions/ConnexionArchives.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "varchar":
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "Numaff";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "Client";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "Nomaff";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "Resprojet";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . $_SERVER['QUERY_STRING'];
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
$insertSQL = sprintf("INSERT INTO Archives (Numaff, Client, Nomaff, Resprojet) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_POST['Numaff'], "text"),
GetSQLValueString($_POST['Client'], "text"),
GetSQLValueString($_POST['Nomaff'], "text"),
GetSQLValueString($_POST['Resprojet'], "text"));
mysql_select_db($database_ConnexionArchives, $ConnexionArchives);
$Result1 = mysql_query($insertSQL, $ConnexionArchives) or die(mysql_error());
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO Archives (Numaff, Client, Nomaff, Resprojet) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_POST['Numaff'], "text"),
GetSQLValueString($_POST['Client'], "text"),
GetSQLValueString($_POST['Nomaff'], "text"),
GetSQLValueString($_POST['Resprojet'], "text"));
//!- DEBUT AJOUT
echo $insertSQL,"<br/>\n";
//!- FIN AJOUT
mysql_select_db($database_ConnexionArchives, $ConnexionArchives);
$Result1 = mysql_query($insertSQL, $ConnexionArchives) or die(mysql_error());
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_ConnexionArchives, $ConnexionArchives);
$query_rsDossiers = "SELECT Numaff, Client, Nomaff, Resprojet FROM Archives ORDER BY Numaff";
$rsDossiers = mysql_query($query_rsDossiers, $ConnexionArchives) or die(mysql_error());
$row_rsDossiers = mysql_fetch_assoc($rsDossiers);
$totalRows_rsDossiers = mysql_num_rows($rsDossiers);
?>
<html><!-- InstanceBegin template="/Templates/PageArchives.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Pajout d'ajout de dossier aux archives</title>
<!-- InstanceEndEditable --><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body bgcolor="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
<table width="803" height="256" border="0" align="center" cellspacing="0">
<tr align="right" valign="top">
<td height="100" colspan="3" bordercolor="0"><div align="center">
<p align="left"><strong><img src="../Images/logo.jpg" width="339" height="100"><img src="../Images/logo%20Archives.jpg" width="461" height="100"></strong></p>
</div> </td>
</tr>
<tr valign="bottom">
<td height="18" colspan="2"><div align="left"><font color="0494bc" size="2" face="Arial, Helvetica, sans-serif">L.V.</font></div></td>
<td height="18"><div align="right"><font color="0494bc" size="2" face="Arial, Helvetica, sans-serif">v.1.2007</font></div></td>
</tr>
<tr align="center" valign="middle" background="../Images/Degrade2.jpg">
<td width="230" height="35">
<a href="../index.php"><font size="2"><font color="#666666" face="Arial, Helvetica, sans-serif"><strong>RECHERCHE</strong></font></font></a> </td>
<td width="335" height="35"><div align="center">
<div align="center"> </div> </td>
<td width="238" height="35"><div align="center">
<select name="menuListes" onChange="MM_jumpMenu('parent',this,0)">
<option>-- LISTES DES DOSSIERS -- </option>
<option value="../Listes/listenumaff.php">Par N° affaire</option>
<option value="../Listes/listeclient.php">Par nom du client</option>
<option value="../Listes/listenomaff.php">Par titre de l'affaire</option>
<option value="../Listes/listeresprojet.php">Par responsables de projets</option>
</select>
</div></td>
</tr>
<tr bgcolor="#F2F2F2">
<td height="58" colspan="3"><div align="center"><font size="6"><font face="Arial, Helvetica, sans-serif"></font></font>
<p><font size="6"><!-- InstanceBeginEditable name="EditRegion1" --><u><font face="Arial, Helvetica, sans-serif">AJOUT
d'un dossier aux archives</font></u><!-- InstanceEndEditable --></font></p>
</div>
<div align="center"></div> <div align="right"></div> <table width="97%" height="43%" align="center">
<tr>
<td width="80%" height="34"><div align="center"><!-- InstanceBeginEditable name="EditRegion2" -->
<form name="form1" method="form1" action="<?php echo $editFormAction; ?>">
<p align="left"><font size="2"> </font></p>
</form>
<form method="post" name="form2" action="<?php echo $editFormAction; ?>">
<table width="530" align="center">
<tr valign="baseline">
<td width="0" align="right" nowrap><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">N° d'affaire:</font></div></td>
<td width="370"><font size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="Numaff" value="" size="50">
</font></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Client: </font></div></td>
<td><font size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="Client" value="" size="50">
</font></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Nom de l'affaire:</font></div></td>
<td><font size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="Nomaff" value="" size="50">
</font></td>
</tr>
<tr valign="baseline">
<td align="right" nowrap><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Responsable projet :</font></div></td>
<td><div align="left"><font size="2" face="Arial, Helvetica, sans-serif">
<input type="text" name="Resprojet" value="" size="50">
</font></div></td>
</tr>
<tr valign="baseline">
<td colspan="2" align="right" nowrap><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="submit" type="submit" value="Valider l'ajout du dossier">
</font></div></td>
</tr>
</table>
<input type="hidden" name="Numaff" value="">
<input type="hidden" name="MM_insert" value="form2">
</form>
<!-- InstanceEndEditable --></div> </td>
</tr>
</table> </td>
</tr>
</table>
<p> </p>
<p> </p>
</body>
<!-- InstanceEnd --></html>
[/code]
En remplissant les champs dans l'ordre suivant :
N° affaire : D1111
Client: 1
Nom affaire: 2
Resp. projet: 3
Lorsque je valide j'obtiens ce genre de message:
Duplicata du champ '' pour la clef 1
Sachant que Numaff est définie en UNIQUE
Merci de votre aide
