ansaurus

Question

Answer 1

+2 A:

That is because you are echoing out side of the loop there by giving you only first row records eg bikes, you should do like:

$category=array();
$query = "SELECT * FROM categories ORDER BY name ASC";
$result = $db->query($query);
$category=array('category_id'=>$category_id, 'category_name'=>$category_name);
while ($row = $result->fetch_array()){
    $category_id=$row['category_id'];
    $category_name=$row['name'];
?>
<input type='radio' value='<?PHP echo $category['category_id']; ?>' 
name='category[]'><?PHP echo $category['category_name']; ?>
<?php
}

Web Logic 2010-05-24 21:18:42

If you do `$row = $result->fetch_array()` then the `$row` array contains all data if you check it with `print_r($row);`

Web Logic 2010-05-24 21:26:04

@jpjp: You are welcome.........

Web Logic 2010-05-24 21:27:55

Answer 2

+3 A:

You are doing three things wrong, first you are not actually setting $category to equal anything - only the values of two undefined values, which default to null. So you end up with an array like:

array('category_id' => null, 'name' => null)

Second, you are doing nothing with the values of $category_id and $category_name when you do set them. Next, you are not going through the array item by item, you simply output the initial way it was set - which is linked to another problem that your array is short of a dimension. It should be 2-dimensional, not 1-dimensional.

This code sums up the gist of it all. I would suggest reading up on how arrays work in PHP and how to define them, they're a very commonly used data type throughout frameworks and the like.

$query = "SELECT * FROM categories ORDER BY name ASC";
$result = $db->query($query);

$categories=array();

while ($row = $result->fetch_array()){
    $categories[] = array('category_id' => $row['category_id'], 'category_name' => $row['name']);
}

Then when you need to output:

foreach ( $categories as $category ) {
    ?>
    <input type='radio' value='<?php echo $category['category_id']; ?>' name='category[]'><?php echo $category['category_name']; ?>
    <?php
}

This can of course be cleaned up further.

Geoff Adams 2010-05-24 21:26:27

you sir are the man! thank you, I was trying to do it this way,but blanked out on the foreach loop.

jpjp 2010-05-24 21:29:20

Is it possible to do this with array_push if I have keys? Because the first parameter has to be an array, but say I want it to be in the 'category_id' and not [0],[1],etc

jpjp 2010-05-24 21:31:42

I'm not sure what you mean - the syntax $categories[] is equivalent to array_push().

Geoff Adams 2010-05-24 21:34:41

Furthermore, with this structure you have this: array( 0 => array('category_id' => ..., 'category_name' => ...), 1 => array('category_id' => ..., 'category_name' => ...), ... )

Geoff Adams 2010-05-24 21:35:41

yes your way is much more cleaner. I wasn't sure what I was doing..

jpjp 2010-05-24 21:37:07

Answer 3

+1 A:

You are assigning to variables $category_id and $category_name, rather than to the array $category, so you're only seeing the first row returned from the query.

I normally use PDO, and would write it something like this:

<?php
  $db = ...
  $sql = 'SELECT * FROM categories ORDER BY category_name ASC';
  $categories = $db->query($sql);
?>

<html>
<body>
<? foreach ($categories as $category): ?>
<input type="radio" name="category[]" value="<?= $category->category_id ?>">
  <?= $category->category_name ?>
</input>
<? endforeach ?>
</body>
</html>

ChrisV 2010-05-24 21:32:30

ansaurus

tags:

views:

answers:

How do I create this array? (PHP)

related questions