Print SELECT list from databse using Mysqli array function

Question

I want to print a select list on my webpage using Mysqli select query. I have checked a lot of questions there, but i am failed to find my problem. Pls help.

php

<select name="bcat" id="bcat" required="required" class="search-field">
<option value="" selected="selected" disabled="disabled">Select a Category</option>
<?php getTierOne(); ?>
</select>

getTierOne()

function getTierOne()
{
   $result = mysqli_query($mysqli,"SELECT bcat FROM advertise");

   while($tier = mysqli_fetch_assoc($result))   
   {
     echo '<option value="' .$tier['bcat'] . '">' . $tier['bcat'] . '</option>';
   }
}

db.php

$mysqli = new mysqli('localhost', 'root', '', 'lwv');

if($mysqli->connect_errno > 0){
die('Unable to connect to database [' . $mysqli->connect_error . ']');
}

It is working absolutely fine with sql query and syntax but not working with mysqli query. I don't have knowledge about mysqli queries so please help me out. Thanks in advance.

what is the error?let us know the exact error.You can view it from error_log also set error_reporting on — Dipanwita Kundu, Apr 25 '16 at 09:24

score 1 · Answer 1 · answered Apr 25 '16 at 09:27

1

you have to pass $mysqli to the finction

try this

$mysqli = new mysqli('localhost', 'root', '', 'lwv');


if($mysqli->connect_errno > 0){
die('Unable to connect to database [' . $mysqli->connect_error . ']');
}
?>
<select name="bcat" id="bcat" required="required" class="search-field">
<option value="" selected="selected" disabled="disabled">Select a Category</option>
<?php getTierOne($mysqli); ?>
</select>


<?php
function getTierOne($mysqli)
{
$result = mysqli_query($mysqli,"SELECT bcat FROM advertise");

  while($tier = mysqli_fetch_assoc($result)) 

    {
       echo '<option value="' .$tier['bcat'] . '">' . $tier['bcat'] . '</option>';
    }

}

answered Apr 25 '16 at 09:27

Osama Jetawe

2,697
6
24
40

Thank you so much...it is working absolutely for me.... – Ashish Garg Apr 25 '16 at 09:30
you are welcome, please mark the answer as accepted – Osama Jetawe Apr 25 '16 at 09:32
this answer worked for me...i would like to mark it as correct... – Ashish Garg Apr 30 '16 at 06:37

score 0 · Answer 2 · answered Apr 25 '16 at 09:27

0

You are not getting variable $mysqli inside the function.

Make this variable global.

Change

function getTierOne() {

to

function getTierOne() {
 global $mysqli;

Or, else pass database connection as parameter:

function getTierOne($mysqli = NULL) {

answered Apr 25 '16 at 09:27

Pupil

23,834
6
44
66

Print SELECT list from databse using Mysqli array function

2 Answers2