出于某种原因,我的for循环不是从看起来的外观开始.我通过在其中放置一个echo语句来测试它并且它没有显示所以必须有一些错误,也许我的语法,但我看了几个小时后看不到它.
谢谢你的时间.
echo $completedstaffrows; // value of 5
echo $completedeventrows; //value of 4
echo "
";
//Staff
//For loop to enter the correct amount of rows as entered in the form
for ($i=0; $i > $completedstaffrows; $i++)
{
//Data not inserted into Staff table, FK given from dropdown on form to insert in linking table
$staffdata = array
(
'staff_id' => $this->input->post ('staff'.$i),
'procedure_id' => $procedurefk,
'quantity' => $this->input->post ('staff_quantity'.$i),
'quantity_sterilised' => NULL, //not implemented yet
);
$inserthumanresource = $this->db->insert ('hr', $staffdata);
echo "hello world"; // to test if for loop working
}
//Events
//For loop to enter all events rows completed by user
for ($i=0; $i > $completedeventrows; $i++)
{
//First input into "Medical Supplies" table
$medsupplies = array
(
'name' => $this->input->post ('supplies'.$i),
'manufacturer' => "Bruce Industries" //To be implemented
);
//Insert data into table
$insertmeds = $this->db->insert ('med_item', $insertmeds);
//Get med supplies foreign key for linking table
$medsuppliesfk = $this->db->insert_id();
//Then input into table "Event"
$eventdata = array
(
'time' => $this->input->post ('time'.$i),
'event' => $this->input->post ('event'.$i),
'success' => $this->input->post ('success'.$i),
'comment' => $this->input->post ('comment'.$i),
'procedure_id' => $procedurefk
);
//Insert
$insertevent = $this->db->insert ('procedure_event', $eventdata);
//Get event fk for linking table
$eventfk = $this->db->insert_id();
//Linking table "Resources"
$resourcedata = array
(
'event_id' => $eventfk,
'medical_item_id' => $medsuppliesfk,
'quantity' => NULL, //Not implemented yet
'unit' => NULL
);
$insertresource = $this->db->insert ('resources', $resourcedata);
解决方法:
更改
for($i = 0; $i> $completedstaffrows; $i)
至
for($i = 0; $i< $completedstaffrows; $i)
你想迭代,而我比可变数量少,而不是更多.
标签:php,for-loop,codeigniter
来源: https://codeday.me/bug/20190713/1444778.html