如果我存储值为S5001:31,32,33 | S5002:42,44,46 | S5003:21,23,25 ……等
在数据库中,如何使用implode函数检索值,以便我可以单独显示标记以查找HTML表中每个注册号码的总数?
$internalmark_col="mark_internal";
$student_internal_marks_array = array();
if(isset($student_internal_mark->$internalmark_col))
{
$internalmarks_stud_code_arr=explode(',',$student_internal_mark->$internalmark_col);
foreach($internalmarks_stud_code_arr as $marks_each)
{
$internalcode_mark=explode(':',$marks_each);
if(isset($internalcode_mark[0]) && isset($internalcode_mark[1]))
$student_internal_marks_array[$internalcode_mark[0]]=$internalcode_mark[1];
}
}
print_r($student_internal_marks_array);
exit;
对于上面的代码我得错了输出.期望的输出是:
Register No | Mark 1 | Mark 2 |Mark 3 | Total
-------------------------------------
S5001 | 3 | 2 | 3 | 8
S5002 |4 | 4 |6 | 14
S5003 |1 |3 |5 | 9
解决方法:
从下面的代码中,您将获得所需的输出:
$data = "S5001:31,32,33|S5002:42,44,46|S5003:21,23,25";
$d = explode("|",$data);
foreach ($d as $value) {
$register_no_arr = explode(":",$value);
$register_no = $register_no_arr[0];
$marks = explode(',',$register_no_arr[1]);
echo '
Register No :- '.$register_no;
for($i=0;$i
echo "
Mark ".($i+1)." :- ".$marks[$i];
}
}
标签:php,codeigniter
来源: https://codeday.me/bug/20190828/1755026.html