如果我理解正确,那么下面的内容可能会有所帮助~尽管不清楚您使用的是哪种数据库API—这里假设是mysqli。
$sql = "INSERT INTO report (Director, Manager, Count) VALUES (?, ?, ?)";
$stmt=$db->prepare( $sql );
$stmt->bind_param('ssi',$first,$last,$int);
foreach( $array[0] as $key => $value ){
list( $first,$last,$int )=explode( ' ', $value );
$stmt->execute();
}
正如所指出的…数组中的第一个条目是一个字符串,因此有点重写
/* to rebuild the array as per question... */
$str='lvenkat anarajam 1, venuv vparames 2, sprabhud girshank 1, pmuralid akandare 1, vparames rahulg2 3, sprabhud kseshadr 1, lvenkat rganesam 1, lvenkat ssihi 1, svarghes denmathe 2, vparames shsreena 2, suniljo bakrish2 1, suniljo bkganesh 1, suniljo msomakum 3';
$array=array($str);
$src = $array[0];
$pieces = explode(',',$src);
$sql = "INSERT INTO report (Director, Manager, Count) VALUES (?, ?, ?)";
$stmt=$db->prepare( $sql );
$stmt->bind_param('ssi',$first,$last,$int);
foreach( $pieces as $key => $value ){
list( $first,$last,$int )=explode( ' ', $value );
$stmt->execute();
}