如何使用PHP中的数组更新多个值 [英] How to update the muliple values using array in PHP
本文介绍了如何使用PHP中的数组更新多个值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个表资格和venue.eligibility表有多个记录我传递使用dynfields数组插入数据下面是插入的代码。现在我想更新data.how我能做到这一点。请帮助我谢谢提前。
$ job_id = mysql_insert_id();
if ($ _POST [' dynfields' ]){
foreach ($ _POST [' dynfields'] as $ key => $ fieldArray){
$ keys = array_keys($ fieldArray);
$ values = array_map( mysql_real_escape_string 跨度>,$ fieldArray);
$ query = mysql_query( INSERT INTO `sk_c_eligibility`( .implode(' ,',$ keys)。 ,elg_job_id)VALUES(' .implode(' \',\'',$ values)。 ','$ job_id'))或 die(mysql_error());
}
}
我尝试了什么:
现在我正在尝试使用像这样更新这些字段。我不知道它是否应该工作。请事先帮助我。谢谢。
$ job_id = mysql_insert_id();
if ($ _POST [' dynfields' ]){
foreach ($ _POST [' dynfields'] as $ key => $ fieldArray){
$ keys = array_keys($ fieldArray);
$ values = array_map( mysql_real_escape_string 跨度>,$ fieldArray);
$ query = mysql_query( UPDATE` sk_c_eligibility` SET( .implode(' ,',$ keys)。 ,elg_job_id)VALUES(' .implode(' \',\'',$ values)。 ','$ job_id'))或 die(mysql_error());
}
}
解决方案
job_id = mysql_insert_id();
if (
_POST [' dynfields']){
foreach (
_POST [ ' dynfields'] as
i have a tables eligibility and venue.eligibility table have multiple records i am passing using dynfields array for inserting data below is the code for inserting.Now i want to update the data.how can i do that.please help me thanks in advance.
$job_id = mysql_insert_id();
if ($_POST['dynfields']) {
foreach ( $_POST['dynfields'] as $key=>$fieldArray ) {
$keys = array_keys($fieldArray);
$values = array_map("mysql_real_escape_string",$fieldArray);
$query = mysql_query("INSERT INTO `sk_c_eligibility` (".implode(',',$keys).",elg_job_id) VALUES ('".implode('\',\'',$values)."','$job_id')") or die(mysql_error());
}
}
What I have tried:
now i am trying to update those fields using like this.i dont know whether it should work or not .please help me.thanks in advance.
$job_id = mysql_insert_id();
if ($_POST['dynfields']) {
foreach ( $_POST['dynfields'] as $key=>$fieldArray ) {
$keys = array_keys($fieldArray);
$values = array_map("mysql_real_escape_string",$fieldArray);
$query = mysql_query("UPDATE`sk_c_eligibility` SET (".implode(',',$keys).",elg_job_id) VALUES ('".implode('\',\'',$values)."','$job_id')") or die(mysql_error());
}
}
解决方案
job_id = mysql_insert_id(); if (
_POST['dynfields']) { foreach (
_POST['dynfields'] as
这篇关于如何使用PHP中的数组更新多个值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文