PHPfrance

la communauté d'entraide francophone dédiée au PHP

insertion

4 messages   •   Page 1 sur 1
   Outils de sujet
Ozil
Invité n'ayant pas de compte PHPfrance

23 oct. 2014, 21:25

bonjours j'arrive pas a inserer dans la table "type_de_marche" de ma base de donnees.
cette erreur s'affiche tout l tmp et j n voi pa ou se situe l'erreur


voici mon code 
<?php require_once('Connections/connexion.php');?>
<?php $type_de_marche="";?>

<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) ){
mysql_select_db($database_connexion, $connexion);
$query_Recordset5 = "SELECT type_de_marche, count(id_finances) as nombretype ,sum(montant) as Montant  FROM finances group by type_de_marche" ;
$Recordset5 = mysql_query($query_Recordset5, $connexion) or die(mysql_error());
$row_recordset5 = mysql_fetch_assoc($Recordset5);
$total=mysql_num_rows($Recordset5);
  $insertSQL = sprintf("INSERT INTO finances (montant, date, type_de_marche) VALUES (%s, %s, %s)",
                   
					   GetSQLValueString($_POST['montant'], "text"),
					   GetSQLValueString($_POST['date'], "text"),
					   GetSQLValueString($_POST['type_de_marche'], "text"));

  mysql_select_db($database_connexion, $connexion);
  $Result1 = mysql_query($insertSQL, $connexion) or die(mysql_error());
}


mysql_select_db($database_connexion, $connexion);
$query_Recordset3 = "SELECT * FROM type_de_marche ";
$Recordset3 = mysql_query($query_Recordset3, $connexion) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);

?>

<?php
//initialize the session
if (!isset($_SESSION)) {
  session_start();
}

// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
  $logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
  //to fully log out a visitor we need to clear the session varialbles
  $_SESSION['MM_Username'] = NULL;
  $_SESSION['MM_UserGroup'] = NULL;
  $_SESSION['PrevUrl'] = NULL;
  unset($_SESSION['MM_Username']);
  unset($_SESSION['MM_UserGroup']);
  unset($_SESSION['PrevUrl']);
	
  $logoutGoTo = "index.php";
  if ($logoutGoTo) {
    header("Location: $logoutGoTo");
    exit;
  }
}
?>
<?php
if (!isset($_SESSION)) {
  session_start();
}
$MM_authorizedUsers = "administrateur";
$MM_donotCheckaccess = "false";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False; 

  // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays. 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && false) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}

$MM_restrictGoTo = "limite.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = $_SERVER['PHP_SELF'];
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0) 
  $MM_referrer .= "?" . $QUERY_STRING;
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>ACCUEIL </title>
<link href="/templates/ol_karinpi/favicon.ico" rel="shortcut icon" type="image/vnd.microsoft.icon" />
<style type="text/css">
<!--
.Style1 {
	font-size: 12px;
	font-style: italic;
	color: #666666;
}
a {
	text-decoration: none;
	color: #333333;
	display: block;
}
-->
</style>
</head>

<body>
<center><table width="1000" border="0" cellpadding="0" cellspacing="0" bgcolor="#999999">
  <!--DWLayoutTable-->
  <tr>
    <td width="12" height="7"></td>
    <td width="978"></td>
    <td width="10"></td>
  </tr>
  <tr>
    <td height="497"></td>
    <td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
      <!--DWLayoutTable-->
      <tr>
        <td width="9" height="6"></td>
            <td width="197"></td>
            <td width="115"></td>
            <td width="393"></td>
            <td width="30"></td>
            <td width="225"></td>
            <td width="9"></td>
          </tr>
      <tr>
        <td height="18"></td>
            <td colspan="5" valign="top"><?php include "entete.php";?></td>
            <td></td>
          </tr>
      <tr>
        <td height="13"></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
          </tr>
      <tr>
        <td height="19"></td>
        <td></td>
        <td></td>
        <td></td>
        <td colspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
          <!--DWLayoutTable-->
          <tr>
            <td width="255" height="19" align="right" valign="top"><a href="<?php echo $logoutAction ?>">D&eacute;connexion</a></td>
              </tr>
        </table></td>
        <td></td>
      </tr>
      <tr>
        <td height="20"></td>
        <td></td>
        <td></td>
        <td></td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td></td>
      </tr>
      
      
      <tr>
        <td height="34"></td>
            <td colspan="5" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#999999">
                <!--DWLayoutTable-->
                <tr>
                  <td width="1" height="3"></td>
                  <td width="141"></td>
                  <td width="10"></td>
                  <td width="159"></td>
                  <td width="9"></td>
                </tr>
                <tr>
                  <td height="28"></td>
                  <td align="center" valign="middle" bgcolor="#FFFFFF"><a href="accueil.php"><strong>ACCUEIL</strong></a></td>
                      <td width="8">&nbsp;</td>
				   <td width="148" align="center" valign="middle" bgcolor="#FFFFFF"><a href="type_de_marche.php"><strong>TYPE DE MARCHE</strong></a></td>
                    </tr>
                <tr>
                  <td height="3"></td>
                  <td></td>
                  <td></td>
                  <td></td>
                  <td></td>
                </tr>
           
            </table>          </td>
            <td></td>
          </tr>
      <tr>
        <td height="35"></td>

          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="32"></td>

        <td>&nbsp;</td>
        <td colspan="3" rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
          <!--DWLayoutTable-->
          <tr>
            <td width="538" height="202" valign="top">&nbsp;
			
			
			 <form method="post" name="form1" action="<?php echo $editFormAction; ?>">
        <table align="center">
		 <tr valign="baseline">
            <td nowrap align="right">Categorie:</td>
            <td><label>
			<select name="categorie" id="categorie">
                    <option>Choisir </option>
					<option selected="selected" value="<?php echo $type_de_marche; ?>"><?php echo $type_de_marche; ?></option>
                    <option>Fourniture</option>
                    <option>Service</option>
                    <option>Travaux</option>
                  </select>
                </label>			</td>
            <td>&nbsp;</td>
		 </tr>
          <tr valign="baseline">
            <td nowrap align="right">Date 
            <input name="date" type="text" id="date" /></td>
            <td>Montant 
            <input name="montant" type="text" id="montant" /></td>
            <td>&nbsp;</td>
          </tr>
         
          <tr valign="baseline">
            <td nowrap align="right">&nbsp;</td>
            <td><input type="submit" value="Inserer"></td>
            <td>&nbsp;</td>
          </tr>
        </table>
        <input type="hidden" name="MM_insert" value="form1">
      </form>     
			</td>
          </tr>
        </table>
        </td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="170"></td>
       
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="135"></td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
     
          <tr>
            <td height="19" colspan="7" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
                <!--DWLayoutTable-->
                <tr>
                  <td width="978" height="19" align="center" valign="middle"><span class="Style1">&copy; 2014 CHNU FANN /CONCEPTION BY PROMO 6 SID:UADB</span></td>
                </tr>
            </table>        </td>
          </tr>
    </table></td>
    <td></td>
  </tr>
  <tr>
    <td height="20"></td>
    <td>&nbsp;</td>
    <td></td>
  </tr>
  
</table>
</center>
</body>
</html>
<?php
mysql_free_result($Recordset1);

mysql_free_result($Recordset2);

mysql_free_result($Recordset3);

//mysql_free_result($Recordset5);
?>
Modifié en dernier par moogli le 23 oct. 2014, 23:50, modifié 3 fois.
Raison : bbcode php
Avatar du membre
Modérateur PHPfrance
Modérateur PHPfrance | 8758 Messages

23 oct. 2014, 23:51

Modération :
Afin d'améliorer la lisibilité de ton message,
pense à utiliser les balises [code] ou [php] (selon le langage utilisé).

Elles sont disponibles au-dessus de la zone de saisie de ton message
lorsque tu postes un nouveau message.

Des indications sont disponibles sur la manière de mettre en forme vos messages dans la FAQ
Il en faut peu pour être heureux ......
Avatar du membre
Modérateur PHPfrance
Modérateur PHPfrance | 8758 Messages

23 oct. 2014, 23:54

sans message d'erreur on ne peu pas t'aider.

@+
Il en faut peu pour être heureux ......
Mammouth du PHP | 2278 Messages

24 oct. 2014, 08:49

$insertSQL = sprintf("INSERT INTO finances (montant, date, type_de_marche) VALUES (%s, %s, %s)",

GetSQLValueString($_POST['montant'], "text"),
GetSQLValueString($_POST['date'], "text"),
GetSQLValueString($_POST['type_de_marche'], "text"));
print "$insertSQL";die(); //et passage par phpmyadmin
mysql_select_db($database_connexion, $connexion);
Vanitas vanitatum et omnia vanitas
Mes derniers livres :
Sauvez les Mots chez BoD,
Tous les chemins mènent à ROM chez BoD
   Répondre
4 messages   •   Page 1 sur 1
   Outils de sujet