0

I’m pretty much new to codeigniter and PHP. I need help with insertion of data in the db from multiple clone form fields(not using implode, I have used implode and managed to push data which I will post here), this from clone form fields(If I click add, it should display another clone of the same form field again is done). Pushing a single value is fine, but when I try pushing in multiple clone form fields at the same time, there is a problem. Or give me a hint as to how. I have attached an image of the dummy form I have used to try it out. I used SheepCloneit for jquery validation purpose.
Following are the two functions codes:

public function cascadehr()
    {
        //view file of the cascaded part(home and rooms)    
        $data['house']=$this->db->get('house')->result_array();
        $data['rooms']=$this->db->get('rooms')->result_array();
        //print_r($data['rooms']);
        //print_r($data['house']);  
        $this->load->view('cascadehomeroom',$data);
        }



public function savehr()
    {
        /*$config['upload_path']   =   "./uploadshouseroom/";
        $config['allowed_types'] =   "gif|jpg|jpeg|png";
        $config['max_size']      =   "10000";
        $config['max_width']     =   "2500";
        $config['max_height']    =   "1280";
        $config['encrypt_type']= true; 
        $this->load->library('upload',$config);
        if(!$this->upload->do_upload('Interior_house_room_image'))
        {
        echo $this->upload->display_errors();
        }
        else
        {
        $finfo=$this->upload->data();
        }
        *//*
        $data['Interior_house_id']=$_POST['interior_house_desc2'];
        $data['Interior_room_id']=$_POST['interior_room_desc2'];
        $data['Interior_house_room_image']= $finfo['file_name'];    
        $data['Interior_house_room_status']=$_POST['Interior_house_room_status'];
        $this->load->model('Think_model'); 
        */
        //print_r($_POST);exit;
        //print_r($this->input->post('interior_room'));
        $interior_room=implode(',',$this->input->post('interior_room'));
        $interior_house=implode(',',$this->input->post('interior_house'));
        $Interior_house_room_status=implode(',',$this->input->post('Interior_house_room_status'));
        //foreach($this->input->post('interior_room') as $value1)
        //      {
        //          $data_up2['interior_room_id']=$value1;
        //      }
        //    foreach($this->input->post('interior_house') as $key => $value)
        //  {
        //      
        //  $data_up1['Interior_house_id']=$value;
        //   }
        //  //  "Interior_house_room_status"=>$Interior_house_room_status[$key]);
        //  //print_r($data_up1);
        //  $data_up3=array_merge($data_up1,$data_up2);
        $data_up3=array('Interior_house_id'=>$interior_house,'interior_room_id'=>$interior_room, 'Interior_house_room_status'=>$Interior_house_room_status);
        $this->db->insert('house_room', $data_up3); 
        $result=$this->db->insert_id();

        //print_r($data_up3);
        //print_r($data_up1); exit;
        //$result=$this->Think_model->houseroom($data);
        if($result!="")
        {
        redirect('cascadehr');
        }
        else
        echo "failure";
        }

The second function is to save the form fields to the database, I have managed to insert data only(I need to insert image as well, which I will try once I can finish with data), as you will notice, using 'implode'. And in the comments you can see that I have tried to use a loop and failed miserably.

This is the view file,

<title> Home Enter</title>
 <link rel="stylesheet" href="<?php echo base_url();?>css/customMessages.css" />

<link rel="stylesheet" href="<?php echo base_url();?>css/validationEngine.jquery.css" />
<script type="text/javascript" src="<?php echo base_url();?>js/jquery-1.8.2.min.js"></script>
<script type="text/javascript" src="<?php echo base_url();?>js/jquery.validationEngine-en.js"></script>
<script type="text/javascript" src="<?php echo base_url();?>js/jquery.validationEngine.js"></script>
<script type="text/javascript" src="<?php echo base_url();?>js/jquery.sheepItPlugin.js"></script>


<script type="text/javascript">
jQuery(document).ready(function(){
            // binds form submission and fields to the validation engine
            jQuery("#formID").validationEngine();
        });
</script>

<script type="text/javascript">
jQuery(document).ready(function(){
            // binds form submission and fields to the validation engine
            jQuery("#formID1").validationEngine();
        });
</script>

<script type="text/javascript">
jQuery(document).ready(function(){
            // binds form submission and fields to the validation engine
            jQuery("#formID2").validationEngine();
        });
</script>



  <script type="text/javascript">
//sheepit plugin used for cloning third form content
$(document).ready(function() {

    var sheepItForm = $('#sheepItForm').sheepIt({
        separator: '',
        allowRemoveLast: true,
        allowRemoveCurrent: true,
        allowRemoveAll: true,
        allowAdd: true,
        allowAddN: true,
        maxFormsCount: 10,
        minFormsCount: 0,
        iniFormsCount: 1
    });

});

</script>

<style>

a {
    text-decoration:underline;
    color:#00F;
    cursor:pointer;
}

#sheepItForm_controls div, #sheepItForm_controls div input {
    float:left;    
    margin-right: 10px;
}


</style>

</head>

<body bgcolor="#5CB3FF">
<h3 align="left"> Type of Home </h3>
<form id="formID" class="formular" method="post" action="<?php echo base_url(); ?>savehome" enctype="multipart/form-data">
<table cellpadding="5">
<tr>

<th> Home name </th>
<td><input type="text" name="interior_house_desc" size="30" class="validate[required]"></td>
</tr>


<tr>
<th> Home image </th>
<td><input type="file" name="interior_house_image" value="upload" ></td>
</tr>
<tr>

<th>Current Status</th>
<td><select name="interior_house_status" class="validate[required]">
<option value="">Please select</option>
<option value="1">Active</option>
<option value="0">Inactive</option>
</select></td>
</tr>

<tr>
<td align="center"><input type="submit" value="submit">
<input type="reset" value="cancel">
</td>
</tr>
</table>
</form>


<form id="formID1" class="formular" method="post" action="<?php echo base_url(); ?>saveroom" enctype="multipart/form-data">
<p>Type of Room </p>
<table cellpadding="5">

<tr>
<th> Room name </th>
<td><input type="text" name="interior_room_desc" size="30" class="validate[required]"></td>
</tr>

<tr>
<th> Room image </th>
<td><input type="file" name="interior_room_image" value="upload" ></td>
</tr>

<tr>
<th>Current Status</th>
<td><select name="interior_room_status" class="validate[required]">
<option value="">Please select</option>
<option value="1">Active</option>
<option value="0">Inactive</option>
</select></td>
</tr>

<tr>
<td align="center"><input type="submit" value="submit">
<input type="reset" value="cancel"></td>
</tr>
</table>
</form>

<form id="formID2" class="formular" method="post" action="<?php echo base_url(); ?>savehr" enctype="multipart/form-data">

<!-- sheepIt Form -->
<div id="sheepItForm">

  <!-- Form template-->
  <div id="sheepItForm_template">

<h3>Home type</h3> 
<select name="interior_house[]" id="interior_house_desc" class="validate[required]">
<option value="">Please select</option>
<?php foreach($house as $ho){ ?>
<option value="<?php echo $ho['interior_house_id'];?>"><?php echo $ho['interior_house_desc'];?></option>
<?php } ?>
</select>

<h3>Room type</h3>
<select name="interior_room[]" id="interior_room_desc" class="validate[required]">
<option value="">Please select</option>
<?php foreach($rooms as $ro){ ?>
<option value="<?php echo $ro['interior_room_id'];?>"><?php echo $ro['interior_room_desc'];?></option>
<?php } ?>
</select>

<h4>House-Image</h4>
<input type="file" id="imagehr" name="Interior_house_room_image[]" value="upload"> 

<h4>Status </h4>
<td><select name="Interior_house_room_status[]" id="Interior_house_room_status" class="validate[required]">
<option value="">Please select</option>
<option value="1">Active</option>
<option value="0">Inactive</option>
</select></td>

<a id="sheepItForm_remove_current">
<img class="delete" src="images/remove.png" width="16" height="16" border="0">
</a>
</div>
<!-- /Form template-->

<!-- No forms template -->
<div id="sheepItForm_noforms_template"><a href="<?php echo base_url();?>cascadehr" >click to go add homes</a></div>
<!-- /No forms template-->

  <!-- Controls -->
<div id="sheepItForm_controls">
<div id="sheepItForm_add"><a><span>Add home</span></a></div>
<div id="sheepItForm_remove_last"><a><span>Remove</span></a></div>
<div id="sheepItForm_remove_all"><a><span>Remove all</span></a></div>
<div id="sheepItForm_add_n">
<input id="sheepItForm_add_n_input" type="text" size="4" />
<div id="sheepItForm_add_n_button"><a><span>Add</span></a></div></div>
</div>
<!-- /Controls -->

</div>
<!-- /sheepIt Form -->



<input name="Submit" type="submit" value="Submit">
<input name="Submit" type="reset" value="Cancel">
</form>

<a href="<?php echo base_url();?>gethr" >View list</a>
</body>

3 forms in one file, one house master, one room master, and one mix, i.e., the mix one is the values I enter in house get into the 3 form house dropdown, and room into the room drop down. After this I choose status as 1 or 0 and have an add button beside, which when clicking duplicates the same form fields. I haven't used any styles, I'll add them later. I just need to know like, if I choose house type and room type, and click add again both must come down(which I managed to get with the jquery plugin), but once the duplicate(clone) form fields come and I choose from duplicate form field, how to insert them all at once in database? The following are the fields I have made in my database-(id Interior_house_id Interior_room_id Interior_house_room_status Interior_house_room_image). This is a nightmare, I'm exasperated. Please help me.

c2806f3d5656da079b0ee48331ea29fb

Edited by kantigniter: Added the view

3
Contributors
3
Replies
36
Views
4 Years
Discussion Span
Last Post by renierdbruyn
0

Yes, I did, but I did understand that partially. After searching up a few, I managed to implode and get them through, but apparently each submit takes it in a single record. Which I can't edit? Plus from what I posted on there, I have made progress. I had no clue as to how to enter multiple data, now I do(using implode), but I don't want it that way. Time is short for me. The reason why I ask again.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.