我的阵列看起来像
Array ( [0] => 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 )
mysql中的mytable
Director Manager Count
如何将元素中的空白空间作为下一个字段插入数据库?
例如,我想要我的桌子看起来像
Director Manager Count
lvenkat anarajam 1
我试过了
foreach
循环插入,但我不知道如何将空间分隔为新字段或变量。
foreach ($array as $val) {
$data = implode ($val); //confuse starts here
$sql = "INSERT INTO report (Director, Manager, Count)
VALUES (?, ?, '?)";
}