speichern, array in Datenbank mysql/php

Ich habe ein Formular, generiert durch die Datenbank-Informationen angezeigt. Die Benutzer werden in der Lage sein, einige änderungen vornehmen, die auf diese Daten, und ich möchte speichern Sie es auf der Datenbank, also ich habe Folgendes vor (in diesem code ist die generierte)

 <form action="#" method="post">

      <input type="hidden" name="liasse" value="liasse_a"/>
      <input type="hidden" name="n_doss" value="120015660001"/>  
<table id="box-table-a" width="100%">
    <tr>
         <th scope="col"><input name="data[0][code_s]" type="text" value="CODE S" size="10" ></th>
         <th scope="col"><input name="data[0][libelle]" type="text" value="LIBELLE" size="30"></th>
          <th scope="col"><input name="data[0][action]" type="text" value="ACTION" size="15"></th>
         <th scope="col"><input name="data[0][libelle]" type="text" value="DESCRIPTION" size="40"></th>
          <th scope="col"><input type="text" name="data[0][date]" value="DATE D'ACTION" size="12"></th>   <th scope="col"><input type="text" name="data[0][date]" value="VALIDATION" size="12"></th>
          <th scope="col"><strong>ETAT</strong></th></tr>

      <tr>
         <td><input name="data[1][code_s]" type="text" value="5F" size="10" style="background-color:#FF0"><input type="hidden" name="data[1][id]" value="667"></td>
         <td><input name="data[1][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style="background-color:#FF0"></td>
         <td><input name="data[1][action]" type="text" value="RELANC1" size="15" style="background-color:#FF0"></td>
         <td><input name="data[1][description]" type="text" value="1ère relance" size="40" style="background-color:#FF0"></td>
         <td>   <input type="date" name="data[1][date]" class="date" id="date1" value="09-10-2012" size="12" style="background-color:#FF0"  readonly="readonly"></td>
 <td nowrap><input type="text" name="data[1][date_validation]" id="data[1][date_validation]" value="Non trait&eacute;" size="12" style="background-color:#FF0"></td>
         <td nowrap><a href="#" onClick="return confirm('Vous ne pouvez pas &eacute;diter ou changer la date d\'une action appartenant à votre passif !')"><img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=667&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="#" onClick="return confirm('Vous ne pouvez pas supprimer une action appartenant à votre passif !')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  <tr>
         <td><input name="data[2][code_s]" type="text" value="5F" size="10" style=""><input type="hidden" name="data[2][id]" value="668"></td>
         <td><input name="data[2][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style=""></td>
         <td><input name="data[2][action]" type="text" value="RELANC2" size="15" style=""></td>
         <td><input name="data[2][description]" type="text" value="2ème relance" size="40" style=""></td>
         <td>   <input type="date" name="data[2][date]" class="date" id="date2" value="17-10-2012" size="12"  required="true" ></td>
 <td nowrap><input type="text" name="data[2][date_validation]" id="data[2][date_validation]" value="Non trait&eacute;" size="12" style=""></td>
         <td nowrap><a href="edit-action.php?id=668&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal">img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=668&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="delete-action.php?id=668&n_doss=120015660001&liasse=liasse_a" onClick="return confirm('voulez vous vraiment supprimer cette action ?')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  <tr>
         <td><input name="data[3][code_s]" type="text" value="5F" size="10" style=""><input type="hidden" name="data[3][id]" value="669"></td>
         <td><input name="data[3][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style=""></td>
         <td><input name="data[3][action]" type="text" value="MINITEL" size="15" style=""></td>
         <td><input name="data[3][description]" type="text" value="recherches CREDITSAFE" size="40" style=""></td>
         <td>   <input type="date" name="data[3][date]" class="date" id="date3" value="12-11-2012" size="12"  required="true" ></td>
 <td nowrap><input type="text" name="data[3][date_validation]" id="data[3][date_validation]" value="Non trait&eacute;" size="12" style=""></td>
         <td nowrap><a href="edit-action.php?id=669&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=669&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="delete-action.php?id=669&n_doss=120015660001&liasse=liasse_a" onClick="return confirm('voulez vous vraiment supprimer cette action ?')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  <tr>
         <td><input name="data[4][code_s]" type="text" value="5F" size="10" style=""><input type="hidden" name="data[4][id]" value="670"></td>
         <td><input name="data[4][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style=""></td>
         <td><input name="data[4][action]" type="text" value="MEDLRAR" size="15" style=""></td>
         <td><input name="data[4][description]" type="text" value="mise en demeure LRAR" size="40" style=""></td>
         <td>   <input type="date" name="data[4][date]" class="date" id="date4" value="14-11-2012" size="12"  required="true" ></td>
 <td nowrap><input type="text" name="data[4][date_validation]" id="data[4][date_validation]" value="Non trait&eacute;" size="12" style=""></td>
         <td nowrap><a href="edit-action.php?id=670&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=670&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="delete-action.php?id=670&n_doss=120015660001&liasse=liasse_a" onClick="return confirm('voulez vous vraiment supprimer cette action ?')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  <tr>
         <td><input name="data[5][code_s]" type="text" value="5F" size="10" style=""><input type="hidden" name="data[5][id]" value="671"></td>
         <td><input name="data[5][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style=""></td>
         <td><input name="data[5][action]" type="text" value="TRANSAV" size="15" style=""></td>
         <td><input name="data[5][description]" type="text" value="$ Transmission des pièces à l'avocat pour référé" size="40" style=""></td>
         <td>   <input type="date" name="data[5][date]" class="date" id="date5" value="10-12-2012" size="12"  required="true" ></td>
 <td nowrap><input type="text" name="data[5][date_validation]" id="data[5][date_validation]" value="Non trait&eacute;" size="12" style=""></td>
         <td nowrap><a href="edit-action.php?id=671&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=671&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="delete-action.php?id=671&n_doss=120015660001&liasse=liasse_a" onClick="return confirm('voulez vous vraiment supprimer cette action ?')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  <tr>
         <td><input name="data[6][code_s]" type="text" value="5F" size="10" style=""><input type="hidden" name="data[6][id]" value="672"></td>
         <td><input name="data[6][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style=""></td>
         <td><input name="data[6][action]" type="text" value="POSITION" size="15" style=""></td>
         <td><input name="data[6][description]" type="text" value="RF procédure de référé en cours" size="40" style=""></td>
         <td>   <input type="date" name="data[6][date]" class="date" id="date6" value="10-12-2012" size="12"  required="true" ></td>
 <td nowrap><input type="text" name="data[6][date_validation]" id="data[6][date_validation]" value="Non trait&eacute;" size="12" style=""></td>
         <td nowrap><a href="edit-action.php?id=672&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=672&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="delete-action.php?id=672&n_doss=120015660001&liasse=liasse_a" onClick="return confirm('voulez vous vraiment supprimer cette action ?')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  <tr>
         <td><input name="data[7][code_s]" type="text" value="5F" size="10" style=""><input type="hidden" name="data[7][id]" value="673"></td>
         <td><input name="data[7][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style=""></td>
         <td><input name="data[7][action]" type="text" value="AVOCA186" size="15" style=""></td>
         <td><input name="data[7][description]" type="text" value="Demande de date d'audience" size="40" style=""></td>
         <td>   <input type="date" name="data[7][date]" class="date" id="date7" value="28-12-2012" size="12"  required="true" ></td>
 <td nowrap><input type="text" name="data[7][date_validation]" id="data[7][date_validation]" value="Non trait&eacute;" size="12" style=""></td>
         <td nowrap><a href="edit-action.php?id=673&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=673&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="delete-action.php?id=673&n_doss=120015660001&liasse=liasse_a" onClick="return confirm('voulez vous vraiment supprimer cette action ?')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  <tr>
         <td><input name="data[8][code_s]" type="text" value="5F" size="10" style=""><input type="hidden" name="data[8][id]" value="674"></td>
         <td><input name="data[8][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style=""></td>
         <td><input name="data[8][action]" type="text" value="CLI6108" size="15" style=""></td>
         <td><input name="data[8][description]" type="text" value="$ cette affaire sera appelée à l'audience du..." size="40" style=""></td>
         <td>   <input type="date" name="data[8][date]" class="date" id="date8" value="02-01-2013" size="12"  required="true" ></td>
 <td nowrap><input type="text" name="data[8][date_validation]" id="data[8][date_validation]" value="Non trait&eacute;" size="12" style=""></td>
         <td nowrap><a href="edit-action.php?id=674&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=674&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="delete-action.php?id=674&n_doss=120015660001&liasse=liasse_a" onClick="return confirm('voulez vous vraiment supprimer cette action ?')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  <tr>
         <td><input name="data[9][code_s]" type="text" value="5F" size="10" style=""><input type="hidden" name="data[9][id]" value="675"></td>
         <td><input name="data[9][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style=""></td>
         <td><input name="data[9][action]" type="text" value="AVOCAT69" size="15" style=""></td>
         <td><input name="data[9][description]" type="text" value="Demande résultat dernière audience" size="40" style=""></td>
         <td>   <input type="date" name="data[9][date]" class="date" id="date9" value="28-01-2013" size="12"  required="true" ></td>
 <td nowrap><input type="text" name="data[9][date_validation]" id="data[9][date_validation]" value="Non trait&eacute;" size="12" style=""></td>
         <td nowrap><a href="edit-action.php?id=675&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=675&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="delete-action.php?id=675&n_doss=120015660001&liasse=liasse_a" onClick="return confirm('voulez vous vraiment supprimer cette action ?')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  <tr>
         <td><input name="data[10][code_s]" type="text" value="5F" size="10" style=""><input type="hidden" name="data[10][id]" value="676"></td>
         <td><input name="data[10][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style=""></td>
         <td><input name="data[10][action]" type="text" value="CLIEN117" size="15" style=""></td>
         <td><input name="data[10][description]" type="text" value="Ordonnance de référé rendue en votre faveur" size="40" style=""></td>
         <td>   <input type="date" name="data[10][date]" class="date" id="date10" value="18-02-2013" size="12"  required="true" ></td>
 <td nowrap><input type="text" name="data[10][date_validation]" id="data[10][date_validation]" value="Non trait&eacute;" size="12" style=""></td>
         <td nowrap><a href="edit-action.php?id=676&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=676&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="delete-action.php?id=676&n_doss=120015660001&liasse=liasse_a" onClick="return confirm('voulez vous vraiment supprimer cette action ?')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  <tr>
         <td><input name="data[11][code_s]" type="text" value="5F" size="10" style=""><input type="hidden" name="data[11][id]" value="677"></td>
         <td><input name="data[11][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style=""></td>
         <td><input name="data[11][action]" type="text" value="DEB6000" size="15" style=""></td>
         <td><input name="data[11][description]" type="text" value="$ Avons ordonnance de référé, menace d'exécution forcée si pas de règlement" size="40" style=""></td>
         <td>   <input type="date" name="data[11][date]" class="date" id="date11" value="08-03-2013" size="12"  required="true" ></td>
 <td nowrap><input type="text" name="data[11][date_validation]" id="data[11][date_validation]" value="Non trait&eacute;" size="12" style=""></td>
         <td nowrap><a href="edit-action.php?id=677&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=677&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="delete-action.php?id=677&n_doss=120015660001&liasse=liasse_a" onClick="return confirm('voulez vous vraiment supprimer cette action ?')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  <tr>
         <td><input name="data[12][code_s]" type="text" value="5F" size="10" style=""><input type="hidden" name="data[12][id]" value="678"></td>
         <td><input name="data[12][libelle]" type="text" value="FRAIS A NOTRE CHARGE: référé" size="30" style=""></td>
         <td><input name="data[12][action]" type="text" value="SCENARIO" size="15" style=""></td>
         <td><input name="data[12][description]" type="text" value="EXF CHAINAGE VERS SCENARIO EXECUTION FORCEE " size="40" style=""></td>
         <td>   <input type="date" name="data[12][date]" class="date" id="date12" value="28-03-2013" size="12"  required="true" ></td>
 <td nowrap><input type="text" name="data[12][date_validation]" id="data[12][date_validation]" value="Non trait&eacute;" size="12" style=""></td>
         <td nowrap><a href="edit-action.php?id=678&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/gtk-edit.png" width="24" height="24"></a> <a href="validate-action.php?id=678&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"><img src="images/go.gif" width="24" height="24"></a> <a href="delete-action.php?id=678&n_doss=120015660001&liasse=liasse_a" onClick="return confirm('voulez vous vraiment supprimer cette action ?')"><img src="images/trash-paper.png" width="24" height="24"></a></td>
    </tr>

  </td></tr></table>     

   <p align="center"><input type="submit" name="enreg" value="ENREGISTRER LES MODIFICATIONS &Eacute;FFECTU&Eacute;ES"></p>
  </form>

Was ich gerne tun würde, ist nun speichern Sie diese Tabelle in meine Datenbank, In der Tat, ich möchte nur die Daten zu aktualisieren, so dass ich geschrieben habe folgenden code:

<?php if(isset($_POST['enreg'])) { 
var_dump($_POST['data']) ;

$value = $_POST['data'] ; 

foreach($value as $key => $array)
{

        $sql = 'UPDATE agenda SET
        liasse = "'.mysql_real_escape_string($_GET['liasse']).'",
        code_s = "'.mysql_real_escape_string($array['code_s']).'",
        date_action = "'.date('Y-m-d',strtotime($array['date'])).'", 
        libelle = "'.mysql_real_escape_string($array['libelle']).'",
        action = "'.mysql_real_escape_string($array['action']).'",
        description = "'.mysql_real_escape_string($array['description']).'",
        n_doss = "'.mysql_real_escape_string($_GET['n_doss']).'",
        qualite = "'.mysql_real_escape_string($_GET['qualite']).'"
        WHERE id ="'.mysql_real_escape_string($array['id']).'"';
mysql_query($sql) or die(__LINE__.mysql_error().$sql);

}
echo "<div class=\"success\">Les modifications sont bien enregistr&eacute;es, vous pouvez poursuivre vos actions.</div>";
}?>

Den var_dump hat diplay diese Ergebnisse:

1 => 
    array (size=7)
      'code_s' => string '5F' (length=2)
      'id' => string '667' (length=3)
      'libelle' => string 'FRAIS A NOTRE CHARGE: référé' (length=28)
      'action' => string 'RELANC1' (length=7)
      'description' => string '1ère relance' (length=12)
      'date' => string '09-10-2012' (length=10)
      'date_validation' => string 'Non traité' (length=10)
  2 => 
    array (size=7)
      'code_s' => string '5F' (length=2)
      'id' => string '668' (length=3)
      'libelle' => string 'FRAIS A NOTRE CHARGE: référé' (length=28)
      'action' => string 'RELANC2' (length=7)
      'description' => string '2ème relance' (length=12)
      'date' => string '17-10-2012' (length=10)
      'date_validation' => string 'Non traité' (length=10)
  3 => 
    array (size=7)
      'code_s' => string '5F' (length=2)
      'id' => string '669' (length=3)
      'libelle' => string 'FRAIS A NOTRE CHARGE: référé' (length=28)
      'action' => string 'MINITEL' (length=7)
      'description' => string 'recherches CREDITSAFE' (length=21)
      'date' => string '12-11-2012' (length=10)
      'date_validation' => string 'Non traité' (length=10)
  4 =>

und so weiter.

Wenn ich jetzt versuche zu sparen das Sie zeigt mir den folgenden Fehler:

( ! ) Notice: Undefined index: Beschreibung C:\wamp\www\GESTION\edit_scenario.php on line 237
diese Linie reffers:

description = "'.mysql_real_escape_string($array['description']).'",

und weiter:

Notice: Undefined index: id in C:\wamp\www\GESTION\edit_scenario.php auf der Linie 240

diese Zeile reffers:

WHERE id ="'.mysql_real_escape_string($array['id']).'"';

Ich habe wirklich keine Ahnung von dem, was dort passiert ist, alle meine Variablen deklariert werden.

Jede Art von Hilfe oder Beratung wird sehr geschätzt.

Freundlichen GRÜßEN.

SP.

ja, sir, Sie sind so benannt wie, data[1][id] - und data[1][Beschreibung], die Anzahl hängt davon ab, welche Zeilen ich bin
<a href="edit-action.php?id=677&n_doss=120015660001&liasse=liasse_a&qualite=Débiteur Principal"> fehl. Stellen Sie sicher, dass Sie urlencode urls wie diese. Ich beziehe mich auf den Débiteur Principal Teil.
Ich weiß nicht, wie Sie es immer tun ändern Sie alle Akzent-und der Platz, den es zu ersetzen durch %20
versuchen Sie dumping aus die $sql-variable, nachdem Sie es bauen... stellen Sie sicher, es ist das schreiben der Werte, die Sie erwarten. Ist es möglich, dass someof die array-Felder kommen in unset?
Nein, es ist nicht möglich, auf diese Weise, ich habe getan ein var_dump($_POST['Daten']) wie Sie sehen, sind alle Werte im array

InformationsquelleAutor Stanislas Piotrowski | 2012-10-09

  1. 7

    Rufen Sie die Werte in das array korrekt. An den zahlen kann man sehen, dass Sie einen iterator.

    echo $array[0]['description']

    oder 

    foreach ($array as $out) {
  echo $out['description];
}

    einige Daten in der Datenbank können Sie serialisieren des Arrays oder Objekte und setzen den serialisierten string in ein Datenbank-Feld.

    serialize($array);

    php.net Serialisieren

    Sehr geehrter Herr, auf jedem Beginn von Linien habe ich diese Daten[<?php echo ++$i; ?>][code_s]
    Ja, es ist richtig. Sie haben viele Datensätze in einem array mit verschiedenen Daten. So serialisieren Sie das komplette array oder schreiben Sie jeden array in die Datenbank.
    Ok, ich werde versuchen, dies; ich danke Ihnen so sehr für die Hilfe

    InformationsquelleAutor René Höhle

Schreibe einen Kommentar