what is the use of $rows=array()

Question

I need to know what to do with $rows=array(). why it is used and how i could use it further. would like to get some suggestions and answers

  <?php


    $dbhost = "localhost"; 
    $dbuser = "root";
    $dbpass = "";
    $dbdb = "yumyum";


    $connect = mysql_connect($dbhost, $dbuser, $dbpass) or die("connection error");


    mysql_select_db($dbdb) or die("database selection error");


    $id = $_POST['id'];


    $query1=mysql_query("SELECT Quantity,id FROM `yumyum`.`food` where  `food`.`id` LIKE $id");
    $rows = array();

    while($r = mysql_fetch_assoc($query1)) {

        $output = $r['Quantity'];


            echo $output;
            $query2=mysql_query("UPDATE food SET Quantity = Quantity - 1 where  `food`.`id` LIKE ".$r["id"]);
    }

    ?>

In your coding, it is simply nothing. – Krish R Nov 23 '13 at 16:36 — Krish R, Nov 23 '13 at 16:36

score 6 · Answer 1 · answered Nov 23 '13 at 16:35

6

In your script it does nothing but initialize the variable $row with an array type. It would probably be intended to be used in your while loop ($r):

...
$query1=mysql_query("SELECT Quantity,id FROM `yumyum`.`food` where  `food`.`id` LIKE $id");
$r = array();

while($r = mysql_fetch_assoc($query1)) {
...

See PHP basics:

It is not necessary to initialize variables in PHP however it is a very good practice.

You should also stop using mysql_ functions. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which.

answered Nov 23 '13 at 16:35

Kermit

33,827
13
85
121

i am new so cant use stack overlow please give me a gmail – user3025252 Nov 23 '13 at 16:39
@user3025252 I don't give out my e-mail. You can join [the Heap](http://chat.stackexchange.com/rooms/179/the-heap-consultancy-) room. – Kermit Nov 23 '13 at 16:40
i do not have enough reputation to tlk on heap – user3025252 Nov 23 '13 at 16:42
What's your question? – Kermit Nov 23 '13 at 16:43
my coding can decrement an individual item quantity by 1 can u suggest how to decrement multiple item quantties simultaneously – user3025252 Nov 23 '13 at 16:44
@user3025252 [This question](http://stackoverflow.com/questions/1262786/mysql-update-query-based-on-select-query) addresses that. – Kermit Nov 23 '13 at 16:46
Thanx but based on my code what should i edit? – user3025252 Nov 23 '13 at 16:47
please have a look at it if possible – user3025252 Nov 23 '13 at 16:49
@user3025252 please make a new question for it. – Kermit Nov 23 '13 at 16:50
why just tell me how to edit accordingly – user3025252 Nov 23 '13 at 16:51

what is the use of $rows=array()

1 Answers1