How to return html with php variables?

Question

I want to return cats value in select options and cats id as option id.I am successfully returning cats values as follows.

if($nu) {

                $cat_name = array();

                while ($row = mysqli_fetch_array ($sq2)) {
                    $cat_name[] = $row['cat_name'];
                }
                return $cat_name;

            }

But I want to return both cats values and their ids in option tag.I tried this but failed .Please help

if($nu) {

                $cat_name = array();
                $cat_id = array();

                while ($row = mysqli_fetch_array ($sq2)) {
                    $cat_name[] = $row['cat_name'];
                    $cat_id[] = $row['id'];
                }
                  return "<option id='$cat_id'>$cat_name</option>";

            }

Your variables are arrays, so you need an index. Do you want to return just one cat or all of them? — Hanlet Escaño
– Hanlet Escaño, Commented Nov 20, 2013 at 16:36
@HanletEscaño I am using while loop,That means i needed all the related rows — user1452376
– user1452376, Commented Nov 20, 2013 at 16:42

GautamD31 · Accepted Answer · 2013-11-20 16:37:53Z

3

Try like

$html = '';
while ($row = mysqli_fetch_array ($sq2)) {
    $cat_name = $row['cat_name'];
    $cat_id = $row['id'];

    $html .= "<option id='".$cat_id."'>".$cat_name."</option>";
}
return $html;

answered Nov 20, 2013 at 16:37

GautamD31

28.8k10 gold badges66 silver badges86 bronze badges

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

Comments

jdcookie · Accepted Answer · 2013-11-20 16:38:50Z

0

Something more like this, need to add each line as you go

if($nu) {


$option = "";

while ($row = mysqli_fetch_array ($sq2)) {
   $option.= <option id="$row['id']">$row['cat_name']</option>
}
 return $option;

}

answered Nov 20, 2013 at 16:38

jdcookie

1211 silver badge6 bronze badges

Comments

Techniv · Accepted Answer · 2013-11-20 16:40:53Z

0

You want to return 1 option by cat ?

Your need to concat your HTML in the loop.

if($nu) {

            $html = "";

            while ($row = mysqli_fetch_array ($sq2)) {
                $html .= "<option id='".$row['id']."'>".$row['cat_name']."</option>"
            }
            return $html;

        }

answered Nov 20, 2013 at 16:40

Techniv

1,96715 silver badges22 bronze badges

Collectives™ on Stack Overflow

How to return html with php variables?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related