select query in view file in codeigniter [duplicate]

Question

This is my simple php html code.

<select id="district" name="district">
    <option value="">Select district</option>
<?php 
  $sql="SELECT * FROM district";

    $result = mysqli_query($sql);

    while($row = mysqli_fetch_array($result))
{
$district_id   = $row['district_id'] ;
$district_name = $row['district_name'];
?>
 <option value="<?php echo $district_id;?>"><?php echo $district_name;?></option>
<?php

}
?>      
</select>

But it's not working. database is autoloaded.What will be the problem.

You can call model function in view instead of calling query here. — Manwal
– Manwal, Commented Dec 24, 2014 at 6:15

Rakesh Sharma · Accepted Answer · 2014-12-24 06:27:54Z

7

you are using direct query not with CI db instance so you will not getting db connection try in CI way

$sql ="SELECT * FROM district";
$query = $this->db->query($sql);
if ($query->num_rows() > 0) {
  foreach ($query->result() as $row) {?>
     <option value="<?php echo $row->district_id;?>"><?php echo $row->district_name;?></option>
<?php }
}

or

  $this->db->from('district');
  $query = $this->db->get();
  if($query->num_rows > 0 ) {
    foreach ($query->result() as $row) {
      // do your stuff
    }
  }

Better method to work with MVC framework:- use model for db queries and return data on view via controller (do not use direct query on view)

edited Dec 24, 2014 at 6:27

answered Dec 24, 2014 at 6:21

Rakesh Sharma

13.7k5 gold badges41 silver badges44 bronze badges

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

Comments

vijaykumar · Accepted Answer · 2014-12-24 06:21:23Z

2

May be your get CI instance wirte you CI query directly

$CI =& get_instance();
$CI->load->model('modelname');
$result = $CI->modelname->functionname();

answered Dec 24, 2014 at 6:21

vijaykumar

4,8367 gold badges40 silver badges56 bronze badges

Comments

ktdrv · Accepted Answer · 2018-02-21 21:18:14Z

0

If you must access db directly from, view try this:

$this->load->view('view_name',["db"=>$this->db,"other_data=>"data"]);
//$this->db //CI db instance

In view you can now do:

$db->query("select * from table")->result();

edited Feb 21, 2018 at 21:18

ktdrv

3,6933 gold badges32 silver badges45 bronze badges

answered Feb 21, 2018 at 20:27

Joel Kimilu

11 bronze badge

Comments

Arun · Accepted Answer · 2014-12-24 06:18:22Z

-1

please try this

<select id="district" name="district">
<option value="">Select district</option>

$result = mysqli_query($sql);

while($row = $result->fetch_array())
{
 $district_id   = $row['district_id'] ;
 $district_name = $row['district_name'];
?>
  <option value="<?php echo $district_id;?>"><?php echo $district_name;?></option>
<?php } ?>

answered Dec 24, 2014 at 6:18

Arun

7605 silver badges12 bronze badges

Collectives™ on Stack Overflow

select query in view file in codeigniter [duplicate]

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Related