Friday, 15 June 2012

php - Codeigniter multiple Selection and insertion to a database -



php - Codeigniter multiple Selection and insertion to a database -

i trying build fantansy football game league codeigniter , far have problem players selection specific fantansy team. far can see players button add together player @ time. question how create code select 15 players first , insert players database instead of adding 1 @ time...here controller

public function addplayer($playerid) { $this->load->model('team_model'); $data=array( 'gk1'=>$playerid, ); $this->team_model->add_player($data); $this->load->view('header'); $this->load->view('transfer_view'); $this->load->view('footer'); }

and model

function add_player($data){ $this->db->insert('fantansyteams',$data); }

i using grocery grud togenerate views

public function transfers($output = null) { $crud = new grocery_crud(); $crud->set_theme('datatables'); $crud->set_table('player'); $crud->add_action('add', '', 'team/addplayer','ui-icon-plus'); $crud->columns('playername','value','position'); $output = $crud->render(); $this->load->view('header'); $this->load->view('transfer_view',$output); $this->load->view('footer'); }

i think :

create model homecoming players create form checkbox list

example :

<?php foreach ($players $player) : ?> <input type="checkbox" name="players[]" value="<?= $player->id ?>" > <?= $player->name ?> </input> <?php endforeach; ?>

i tried in php file

if (isset($_post['players'])) { // players id list var_dump($_post['players']); } // players list echo "<form action='' method='post' > <input type='checkbox' name='players[]' value='1'> player 1 </input> <input type='checkbox' name='players[]' value='2'> player 2 </input> <input type='checkbox' name='players[]' value='3'> player 3 </input> <input type='checkbox' name='players[]' value='15'> player 15 </input> <input type='submit' value='add'> </form>";

for illustration when take player 1 , 15 var_dump result :

array (size=2) 0 => string '1' (length=1) 1 => string '15' (length=2)

i haven't seek codeigniter if have used codeigniter's forms easy think :)

i hope answers question.

php codeigniter crud

No comments:

Post a Comment