PHP auto increment inside while loop

Question

this is my first question here. I'm facing a problem that is literally driving me crazy. I'm new to PHP and I feel that it is something really simple that I just can't figure out.

I have this code:

$busca_alimento = mysql_query("SELECT * FROM alimentos");
if (empty($busca_alimento)) { 
    echo 'Nothing found';
}

$count = 0;

while ($alimento_informacoes = mysql_fetch_array($busca_alimento)) {

    $alimento_id[$count++] = $alimento_informacoes['id'];
    $alimento_categoria[$count++] = $alimento_informacoes['categoria'];
    $alimento_nome[$count++] = $alimento_informacoes['nome'];
    $alimento_quantidade[$count++] = $alimento_informacoes['quantidade'];

}

I want to fetch the ID, Categoria, Nome and Quantidade rows and store the data in those vars like this:

$alimento_id[1]
$alimento_categoria[1]
$alimento_nome[1]
$alimento_quantidade[1]

but what is happening is this:

$alimento_id[1]
$alimento_categoria[2]
$alimento_nome[3]
$alimento_quantidade[4]

Does anyone know what's happening and how can I solve this? Thank you

Adam Wodon · Accepted Answer · 2014-09-28 15:11:24Z

1

I like this better, and no increment needed:

while ($alimento_informacoes = mysql_fetch_array($busca_alimento)) {
  $alimento_id[]         = $alimento_informacoes['id'];
  $alimento_categoria[]  = $alimento_informacoes['categoria'];
  $alimento_nome[]       = $alimento_informacoes['nome'];
  $alimento_quantidade[] = $alimento_informacoes['quantidade'];
}

answered Sep 28, 2014 at 15:11

Adam Wodon

153 bronze badges

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

Comments

Bob Brown · Accepted Answer · 2014-09-28 15:00:14Z

0

Increment $count one time only, then use it as a subscript.

while ($alimento_informacoes = mysql_fetch_array($busca_alimento)) {
    $count++;
    $alimento_id[$count] = $alimento_informacoes['id'];
    $alimento_categoria[$count] = $alimento_informacoes['categoria'];
    $alimento_nome[$count] = $alimento_informacoes['nome'];
    $alimento_quantidade[$count] = $alimento_informacoes['quantidade'];

}

Depending on the initial value of $count and what value you want to use, you may need to move $count++ to the end of the loop.

answered Sep 28, 2014 at 15:00

Bob Brown

1,5222 gold badges13 silver badges27 bronze badges

1 Comment

Cassiano Teodoro Over a year ago

I moved the $count to the end of the loop and worked. Thanks!

Kevin · Accepted Answer · 2014-09-28 14:59:23Z

0

Well, you're incrementing it everytime. Increment it just once:

while ($alimento_informacoes = mysql_fetch_array($busca_alimento)) {
    // so first loop, its just zero, 0
    $alimento_id[$count] = $alimento_informacoes['id'];
    $alimento_categoria[$count] = $alimento_informacoes['categoria'];
    $alimento_nome[$count] = $alimento_informacoes['nome'];
    $alimento_quantidade[$count] = $alimento_informacoes['quantidade'];
    // so before this line, its all zero
    $count++; // then increment
    // increment it after cycle is complete
}

answered Sep 28, 2014 at 14:59

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

Comments

Khrisna Gunanasurya · Accepted Answer · 2014-09-28 15:00:33Z

0

$busca_alimento = mysql_query("SELECT * FROM alimentos");
if (empty($busca_alimento)) { 
  echo 'Nothing found';
}

$count = 0;

while ($alimento_informacoes = mysql_fetch_array($busca_alimento)) {

$alimento_id[$count] = $alimento_informacoes['id'];
$alimento_categoria[$count] = $alimento_informacoes['categoria'];
$alimento_nome[$count] = $alimento_informacoes['nome'];
$alimento_quantidade[$count] = $alimento_informacoes['quantidade'];

$count++;
}

answered Sep 28, 2014 at 15:00

Khrisna Gunanasurya

7452 gold badges12 silver badges39 bronze badges

Comments

Casimir et Hippolyte · Accepted Answer · 2014-09-28 15:25:55Z

0

increment $count only one time in the loop:

$alimento_id[++$count] = $alimento_informacoes['id'];
$alimento_categoria[$count] = $alimento_informacoes['categoria'];
$alimento_nome[$count] = $alimento_informacoes['nome'];
$alimento_quantidade[$count] = $alimento_informacoes['quantidade'];

edited Sep 28, 2014 at 15:25

answered Sep 28, 2014 at 14:59

Casimir et Hippolyte

90k5 gold badges102 silver badges131 bronze badges

1 Comment

user2289510 Over a year ago

In this way, the other arrays will have different $count value than first, maybe you mean ++$count

Collectives™ on Stack Overflow

PHP auto increment inside while loop

5 Answers 5

Comments

1 Comment

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related