Dynamic Checkbox in php/html

Question

I've written these lines of code in order to crate my dynamic(fetch data from a database) checkbox.

**<?php 

   db_connect();

   $sql = mysql_query('SELECT title  FROM products WHERE cname LIKE "Coffee"') or die(mysql_error());     

   while($row = mysql_fetch_array($sql, MYSQL_BOTH)){
       echo "<input type='checkbox' name='products[]' value='".$row['title']."'>"
        .$row['title'];
   }

?>**

The problem is that the results come in the same line in my webpage, but I'd like them to be appeared as a list so as to create an order-list /menu of me cafeteria. How can I correct this?

j08691 · Accepted Answer · 2013-09-23 17:34:57Z

3

Change:

while($row = mysql_fetch_array($sql, MYSQL_BOTH)){
    echo "<input type='checkbox' name='products[]' value='".$row['title']."'>"
     .$row['title'];
}

to

echo "<ul>\n":
while($row = mysql_fetch_array($sql, MYSQL_BOTH)){
    echo "<li><input type='checkbox' name='products[]' value='".$row['title']."'>"
     .$row['title']."</li>";
}
echo "</ul>\n":

answered Sep 23, 2013 at 17:34

j08691

208k33 gold badges269 silver badges281 bronze badges

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

2 Comments

Suspicius Over a year ago

The same here! It is just transfered from the left to the right.

j08691 Over a year ago

This would only appear inline if you had CSS that caused it to render that way,

frank_ivan · Accepted Answer · 2013-09-23 17:34:52Z

0

try with this:

<?php
db_connect();
$sql = mysql_query('SELECT title  FROM products WHERE cname LIKE "Coffee"') or     die(mysql_error());
echo "<ul>";
while($row = mysql_fetch_array($sql, MYSQL_BOTH)){

echo "<li> <input type='checkbox' name='products[]' value='".$row['title']."'></li>"
    .$row['title'];}//end while

echo"</ul>";

answered Sep 23, 2013 at 17:34

frank_ivan

1235 bronze badges

4 Comments

Suspicius Over a year ago

I tried it but it only changed the align from left to the right part of the page but all my entries are still in the same line.

frank_ivan Over a year ago

I'm sorry, and here the changes :D

Suspicius Over a year ago

Thanks but we still have problem! :/

Suspicius Over a year ago

Problem solved pals! I've just added "echo "<br />";" in my while loop. Sorry for this comment but I;m not allowed to answer my own question yet! Thanks a lot for you suggestions! :D

jedwards · Accepted Answer · 2013-09-23 17:36:34Z

0

Well, the easiest solution would be to add line breaks (<br />) after each row.

You could also use a table. For example, something like:

<?php 
    echo '<table>';
    while($row = mysql_fetch_array($sql, MYSQL_BOTH)){
        echo "<tr><td>";
        echo "<input type='checkbox' name='products[]' value='".$row['title']."'>";
        echo $row['title'];
        echho "</td></tr>";
   }
   echo '</table>'
?>

But there are better alternatives that involve divs and CSS.

answered Sep 23, 2013 at 17:36

jedwards

30.3k3 gold badges69 silver badges94 bronze badges

Comments

nathanfirth · Accepted Answer · 2013-09-23 17:41:09Z

0

You could put them in to a unordered list (UL):

<ul>
<?php 
db_connect();

$sql = mysql_query('SELECT title  FROM products WHERE cname LIKE "Coffee"') or die(mysql_error());

while($row = mysql_fetch_array($sql, MYSQL_BOTH)){
echo "<li><input type='checkbox' name='products[]' value='".$row['title']."'>"
    .$row['title']."</li>";}

?>
</ul>

answered Sep 23, 2013 at 17:41

nathanfirth

273 bronze badges

Comments

Bitopan Das · Accepted Answer · 2013-09-24 07:02:36Z

0

<?php 

   db_connect();

   $sql = mysql_query('SELECT title  FROM products WHERE cname LIKE "Coffee"') or die(mysql_error());     

   while($row = mysql_fetch_array($sql, MYSQL_BOTH)){
       echo "<input type='checkbox' name='products[]' value='".$row['title']."'>"
        .$row['title']."<br/>";
   }

?>

answered Sep 24, 2013 at 7:02

Bitopan Das

1

Collectives™ on Stack Overflow

Dynamic Checkbox in php/html

5 Answers 5

2 Comments

4 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related