保存阵列mysql数据库/ PHP [英] save array to database mysql/php
本文介绍了保存阵列mysql数据库/ PHP的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我具有由显示DATABSE信息生成的形式。用户将能够使这些数据了一些修改，我想将它保存到数据库中，所以我有以下FORW（这code是生成一个）
I have a form that is generated by the databse information displayed. The user will be able to make some modifications on this data, and I would like to save it to database, so I have the following forw (this code is the generated one)
<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é" size="12" style="background-color:#FF0"></td>
<td nowrap><a href="#" onClick="return confirm('Vous ne pouvez pas é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é" 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é" 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é" 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é" 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é" 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é" 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é" 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é" 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é" 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é" 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é" 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 ÉFFECTUÉES"></p>
</form>
现在我想要做的就是这个表保存到我的DATABSE，其实我只是想更新数据，所以我写了下面的code：
What I would like to do is now to save this table into my databse, In fact I just would like to update data, so I've written the following 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ées, vous pouvez poursuivre vos actions.</div>";
}?>
后续代码var_dump不diplay这个结果：
The var_dump does diplay this results:
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 =>
等。
现在当我尝试这一点，显示保存到我以下错误：
Now When I try to save this it display to me the following errors:
的通知（！）：未定义指数：说明在C：\\ WAMP \\ WWW \\ GESTION \\ edit_scenario.php上线237
此行reffers为：
( ! ) Notice: Undefined index: description in C:\wamp\www\GESTION\edit_scenario.php on line 237 this line reffers to:
description = "'.mysql_real_escape_string($array['description']).'",
和下一：
注意：未定义指数：ID在C：\\ WAMP \\ WWW \\ GESTION \\ edit_scenario.php线240
Notice: Undefined index: id in C:\wamp\www\GESTION\edit_scenario.php on line 240
这行reffers为：
this line reffers to:
WHERE id ="'.mysql_real_escape_string($array['id']).'"';
我真的不知道什么发生的事情有想法，我所有的变量都声明。
I really have no idea of what's happened there, all of my variables are declared.
任何形式的帮助或建议，将大大AP preciated。
Any kind of help or advice will be much appreciated.
亲切的问候。
SP。
推荐答案
您应该正确地调用您的数组中的值。在这些数字可以看到，你有一个迭代器。
You should call the values in your array correctly. On the numbers you can see that you have an iterator.
echo $array[0]['description']
或
foreach ($array as $out) {
echo $out['description];
}
把一些数据到数据库可以序列数组或对象，并把序列化的字符串到一个数据库字段。
to put some data to the database you can serialize the array or objects and put the serialized string to a database field.
serialize($array);
这篇关于保存阵列mysql数据库/ PHP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
