PHP-Using $this->db->get()->result() in Codeigniter

Question

I'm trying to create a web page that when user click on the below link,it will bring user to the next page

<a href="../try/sewcutrptsummary?pro={$row ->idmsul}" target="blank"">Link

My question is,how can i retrieve the same data from 1st page & display it in a textbox in 2nd page as shown in below pictuce?

Retrieve data

This is the view for the 2nd page

<div class="control-group">
<label for="proid" class="control-label">MSUL ID</label>
<div class="controls"> 
 <input type="text" id="txtinput" name="txtinput"value="">
<select id="prodtype" name="prodtype"onchange="checknumber();">
<option selected >--Select Product Type--</option>
 <option value="Main"  >Main</option>
 <option value="Sub">Sub</option>
</select>
</div>
<div class="controls" id="after" style="display : none">         
<select id="cutprod" name="cutprod" class="input-xxlarge">
</select>

<input id="generatebtn" type="button" class="btn-primary btn-small" onclick="generateRpt();" value="Generate" ></div>
</div>

and this is the controller

function index() {
        $this -> smarty -> assign("page", "View Cutting Report Summary");
        $this -> smarty -> assign("dataname", "Cutting Report Summary");
        $this -> smarty -> assign("pagename", "sewcutrptsummary");
        $this -> smarty -> assign("msg", "");
        $this -> smarty -> assign("script", "Yes");

        $idmsul = $this -> input -> get_post("pro");
        $query = "Select idmsul from sindi_schedule where idmsul='{$idmsul}' group by idmsul";
        $result = $this -> global_model -> query($query) -> result();
        $data['idmsul'] = $result;

        $this -> smarty -> view('sewcutrptsummary.tpl',$data);
        }

Can anybody assist me on this problem?

Your help is greatly appreciate.

The question is actually quite clear, especially with the provided image. — Peter Meadley
– Peter Meadley, Commented Sep 5, 2017 at 6:48

JYoThI · Accepted Answer · 2017-09-05 07:18:35Z

1

Simple pass the data pro to view like this

In controller :

.....
$data['idmsul'] = $result;
$data['id'] =$this->input->get_post("pro"); //here pass the id to view 
$this->smarty->view('sewcutrptsummary.tpl',$data);
....

In view :

<input type="text" id="txtinput" name="txtinput" value="{$id}">

edited Sep 5, 2017 at 7:18

answered Sep 5, 2017 at 6:56

JYoThI

12.1k1 gold badge13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dn91 Over a year ago

i try to do as you say,but it display this in the textbox <?php if(isset($id)){ echo $id; } ?>

JYoThI Over a year ago

Try this <input type="text" id="txtinput" name="txtinput" value="{$id}"> @Dn91

Peter Meadley · Accepted Answer · 2017-09-05 06:38:07Z

0

You are passing the data as a query string, therefore the following should work

if(isset($_GET["pro")) {  // Safeguard in case value is not there
    $pro = $_GET["pro"];
}

Then assign the value of your textbox to $pro

answered Sep 5, 2017 at 6:38

Peter Meadley

5192 silver badges16 bronze badges

2 Comments

Dn91 Over a year ago

Sorry for asking,do i need to change $data['idmsul'] = $result; into $data = $_GET["pro"]; ??

Dn91 Over a year ago

Thank you for taking time to help me,but i don't really understand how u do it...can u help explain a bit to me??

Collectives™ on Stack Overflow

PHP-Using $this->db->get()->result() in Codeigniter

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related