首页 / PHP / 求助一段代码的执行结果输出代码编写
求助一段代码的执行结果输出代码编写
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了求助一段代码的执行结果输出代码编写,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4703字,纯文字阅读大概需要7分钟。
内容图文
![求助一段代码的执行结果输出代码编写](/upload/InfoBanner/zyjiaocheng/236/079be125c86a4ed0bf2b5e326372bdd8.jpg)
下面是$new_data数组(数组1)文件内容。
需要完成的结果是程序循环执行完成后能判断那一处操作数据库失败,哪一处成功。程序会在循环内执行多次数据库操作,输出结果为全部成功输出{"ok":true},完全失败{"ok":false}部分失败(详细输出部位比如{"del":false,"del_err":$u_id|$tasw_id,"up":false,"up_err":$u_id|$tasw_id}
请注意循环内会执行多次删除,更新,插入数据库操作,当然可重写代码,但是数组格式固定,$new_data数组(数组1)在执行到$u_id=$res['u_id'];会生成以下$res数组(数组2),方便数据库操作
foreach($new_data as $key){
$res = array();
foreach ($key as $itm) {
foreach ($itm as $it=>$valu) {
$res[Shortstr2($it)] = $valu;
}
}
$u_id=$res['u_id'];
$res['tasw_id']=$tasw_id;
if($tasw_p =='x'){
//执行删除操作
$tasw_u_id=substr($e[0],1,strlen($e[0]));
if(!db_del($tasw_id,$tasw_u_id)){
$tasw_err['d_err']=false;
}else{
$tasw_err['d_ok']=true;
}
}
$chk_u_id=$db->FirstValue("SELECT COUNT(*) FROM {$tbi} WHERE u_id='{$u_id}' and t_id='{$tasw_id}'");
if($chk_u_id>0){
//更新
unset($res['u_id']);
if(!$db->AutoExecute($tbi,$res,'UPDATE'," u_id='{$u_id}' and tree_id='{$tasw_id}'")){
$tasw_err['u_err']=false;
}else{
$tasw_err['u_ok']=true;
}
}else{
//插入
if(!$db->AutoExecute($tbi,$res)){
$tasw_err['i_err']=false;
}else{
$tasw_err['i_ok']=true;
}
}
}
数组1
Array
(
[VLZC9] => Array
(
[0] => Array
(
[i] => VLZC9
[^] => ASRWE
[g] => m
[l] => 12
)
[1] => Array
(
[i] => VLZC9
[p] => 2
)
)
[FQE10] => Array
(
[0] => Array
(
[i] => FQE10
[^] => ASRWE
[g] => f
[s] => VLZC9
[l] => 12
)
[1] => Array
(
[i] => FQE10
[p] => 1
)
)
[ASRWE] => Array
(
[0] => Array
(
[i] => ASRWE
[m] => FQE10
[f] => VLZC9
)
)
[WEESA] => Array
(
[0] => Array
(
[i] => WEESA
[x] =>
)
)
)
数组2
Array
(
[u_id] => VLZC9
[s_s] => ASRWE
[g] => m
[l] => 12
[p] => 2
)
Array
(
[u_id] => FQE10
[s_s] => ASRWE
[g] => f
[s] => VLZC9
[l] => 12
[p] => 1
)
Array
(
[u_id] => ASRWE
[m] => FQE10
[f] => VLZC9
)
回复内容:
下面是一段php代码,主要功能是操作数据库,但是是根据$new_data数组(数组1)进行数据库操作,所以每次都会进行多次数据库操作
下面是$new_data数组(数组1)文件内容。
需要完成的结果是程序循环执行完成后能判断那一处操作数据库失败,哪一处成功。程序会在循环内执行多次数据库操作,输出结果为全部成功输出{"ok":true},完全失败{"ok":false}部分失败(详细输出部位比如{"del":false,"del_err":$u_id|$tasw_id,"up":false,"up_err":$u_id|$tasw_id}
请注意循环内会执行多次删除,更新,插入数据库操作,当然可重写代码,但是数组格式固定,$new_data数组(数组1)在执行到$u_id=$res['u_id'];会生成以下$res数组(数组2),方便数据库操作
foreach($new_data as $key){
$res = array();
foreach ($key as $itm) {
foreach ($itm as $it=>$valu) {
$res[Shortstr2($it)] = $valu;
}
}
$u_id=$res['u_id'];
$res['tasw_id']=$tasw_id;
if($tasw_p =='x'){
//执行删除操作
$tasw_u_id=substr($e[0],1,strlen($e[0]));
if(!db_del($tasw_id,$tasw_u_id)){
$tasw_err['d_err']=false;
}else{
$tasw_err['d_ok']=true;
}
}
$chk_u_id=$db->FirstValue("SELECT COUNT(*) FROM {$tbi} WHERE u_id='{$u_id}' and t_id='{$tasw_id}'");
if($chk_u_id>0){
//更新
unset($res['u_id']);
if(!$db->AutoExecute($tbi,$res,'UPDATE'," u_id='{$u_id}' and tree_id='{$tasw_id}'")){
$tasw_err['u_err']=false;
}else{
$tasw_err['u_ok']=true;
}
}else{
//插入
if(!$db->AutoExecute($tbi,$res)){
$tasw_err['i_err']=false;
}else{
$tasw_err['i_ok']=true;
}
}
}
数组1
Array
(
[VLZC9] => Array
(
[0] => Array
(
[i] => VLZC9
[^] => ASRWE
[g] => m
[l] => 12
)
[1] => Array
(
[i] => VLZC9
[p] => 2
)
)
[FQE10] => Array
(
[0] => Array
(
[i] => FQE10
[^] => ASRWE
[g] => f
[s] => VLZC9
[l] => 12
)
[1] => Array
(
[i] => FQE10
[p] => 1
)
)
[ASRWE] => Array
(
[0] => Array
(
[i] => ASRWE
[m] => FQE10
[f] => VLZC9
)
)
[WEESA] => Array
(
[0] => Array
(
[i] => WEESA
[x] =>
)
)
)
数组2
Array
(
[u_id] => VLZC9
[s_s] => ASRWE
[g] => m
[l] => 12
[p] => 2
)
Array
(
[u_id] => FQE10
[s_s] => ASRWE
[g] => f
[s] => VLZC9
[l] => 12
[p] => 1
)
Array
(
[u_id] => ASRWE
[m] => FQE10
[f] => VLZC9
)
$valu) {
$res[Shortstr2($it)] = $valu;
}
}
$u_id = $res['u_id'];
$res['tasw_id'] = $tasw_id;
$tasw_err = array();
if ($tasw_p === 'x') {
//执行删除操作
$tasw_u_id = substr($e[0], 1, strlen($e[0]));
if (!db_del($tasw_id,$tasw_u_id)) {
$tasw_err['del'] = false;
$tasw_err['del_err'] = sprintf('%d|%d', $u_id, $tasw_id);
}
}
$chk_u_id=$db->FirstValue("SELECT COUNT(*) FROM {$tbi} WHERE u_id='{$u_id}' and t_id='{$tasw_id}'");
if($chk_u_id>0){
//更新
unset($res['u_id']);
if (!$db->AutoExecute($tbi,$res,'UPDATE'," u_id='{$u_id}' and tree_id='{$tasw_id}'")) {
$tasw_err['up'] = false;
$tasw_err['u_err'] = sprintf('%d|%d', $u_id, $tasw_id);
}
}else{
//插入
if(!$db->AutoExecute($tbi,$res)){
$tasw_err['in'] = false;
$tasw_err['i_err'] = sprintf('%d|%d', $u_id, $tasw_id);
}
}
if (!empty($tasw_err)) {
$result[] = $tasw_err;
}
}
if (empty($result)) {
$result = array(
'ok' => true,
);
} elseif (count($result) === count($new_data)) {
$result = array(
'ok' => false,
);
}
die(json_encode($result));
内容总结
以上是互联网集市为您收集整理的求助一段代码的执行结果输出代码编写全部内容,希望文章能够帮你解决求助一段代码的执行结果输出代码编写所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。