PHP loop increment

Question

I have a PHP loop generating a dataset for a chart. It queries two fields I have in a database table.

<?php

    $server = "myserver:1234";
    $user="dbuser";
    $password="userpass";  
    $database = "dbname";

    $connection = mysql_connect($server,$user,$password);
    $db = mysql_select_db($database,$connection);

    $query = "SELECT X, Y FROM dbtable";
    $result = mysql_query($query);        

    while($row = mysql_fetch_assoc($result))
    {
        $dataset1[] = array($row['X'],$row['Y']);
    }
    $final = json_encode($dataset1,JSON_NUMERIC_CHECK);

?>

Currently data in X is meaningless (it's actually an ID column), and a number increment of 1 starting at 1 will be more useful. This is because I only want to plot a line chart, where X values are fixed. ID would be fine but the values put distracting axis labels on my chart.

How can I use PHP to generate this instead of the database select that I currently have?

Many thanks:)

Please, don't use mysql_* functions in new code. 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. If you choose PDO, here is a good tutorial. — ThiefMaster
– ThiefMaster, Commented Oct 19, 2013 at 12:09
Thanks for the heads up. I got that expression from somewhere else online. I'm not a developer per say, what should I be using instead? I'm not being lazy, I just struggle to follow heavy documentation. — square_eyes
– square_eyes, Commented Oct 20, 2013 at 14:42
Have a look at the PDO tutorial (last link in my previous comment). — ThiefMaster
– ThiefMaster, Commented Oct 20, 2013 at 14:55

Amal · Accepted Answer · 2013-10-19 12:08:06Z

2

Declare a variable outside your loop and increment it on each iteration:

$i = 1;
while($row = mysql_fetch_assoc($result))
{
    $dataset1[] = array($i, $row['Y']);
    $i++;
}

answered Oct 19, 2013 at 12:08

Amal

76.8k18 gold badges133 silver badges154 bronze badges

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

Collectives™ on Stack Overflow

PHP loop increment

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related