from db to array

nexx

hi, i want to retrive each row from the table's field and put into
array, not quite sure how to do it.

mysql_fetch_array() only retrieves one row i have a hundred of them in the field. wander how to put each of them into one array.

while($rs = mysql_fetch_array($result)){

$array = array($rs[1]);

could anyone advise

onion2k

You're nearly there already:

while($rs = mysql_fetch_array($result)){

$array[] = $rs[1];

}

jrmckee

This is what I do in MySQL:

$query = "Do some select here";
$res = MYSQL_QUERY($query);
$numrows = MYSQL_NUMROWS($res);

for($i=0;$i<$numrows;$i++) {
$row_array[$i]=MYSQL_FETCH_ARRAY($res);
}

MYSQL_FREERESULT($res);

This returns the multi-dimensional array $row_array[rownum][fieldname].

Jon

nexx

doesnt work, what im actually trying to do is to plot the content of the array on the graph. Normally its:

$data = array(10,15,16,18...)

Im trying to put the data from db into that array.

jrmckee

I guess I am not understanding what you are trying to do. What is your query? mysql_fetch_array returns a single row as a array.

Are you trying to pull data from a single field in the table and add that to a array? That would be:

for($i=0;$i<$numrows;$i++) {
$row[$i]=MYSQL_FETCH_ARRAY($res);
$data[$i]=$row[$i]["fieldname"];
}

I don't think I am following you here...

Jon

onion2k

Are you sure my suggestion doesn't work? I'd be very suprised.. Post your script here. I want to see what you're doing.

nexx

Exactly what Im trying to do - pull data from a single field in the table and add that to a array.

<?include ("include/jpgraph-1.14/src/jpgraph.php");           // call to main class
include ("include/jpgraph-1.14/src/jpgraph_line.php");      // call to draw a line charts

include ("include/dbcon.inc");
##########################################

$connection = mysql_connect($host,$dbuser,$dbpassword);
if(!$connection)
die("Couldnt connect");

mysql_select_db($database, $connection)
or die("couldnt connect to db".mysql_error());

$res = mysql_query("select quote from ftse")
or die("SELECT error".mysql_error());

while($rs = mysql_fetch_array($res))
{
$array[] = $rs[1];
}
##########################################

$ydata = $array; // works fine when $ydata =  array(1.354, 1.288, 1.798, etc )

#code bellow works perfectly provided there is something in that #array

// Create the graph. These two calls are always required
$graph = new Graph(500,270,"auto");
$graph->SetScale("textlin");

// Adjust the margin
$graph->img->SetMargin(57,25,35,45);


// Create the linear plot
$lineplot=new LinePlot($ydata);
$lineplot->mark->SetType(MARK_UTRIANGLE);
//$lineplot->value->show();                  //shows value on the graph if uncommented
$lineplot->value->SetColor('darkred');
$lineplot->value->SetFont(FF_FONT1,FS_BOLD);
$lineplot->value->SetFormat('$%0.1f');


// Add the plot to the graph
$graph->Add($lineplot);
$time = date('l jS F Y');
$graph->title->Set("FTSE teckMark Index $time");
$graph->xaxis->title->Set("trading hours");
//$graph->yaxis->title->Set("Share price");
$graph->yaxis->SetColor("red");

$txt=new Text("\$");
$txt->Pos(35,10);
$txt->SetColor("red");
$graph->AddText($txt);

$graph->title->SetFont(FF_FONT1,FS_BOLD);
$graph->yaxis->title->SetFont(FF_FONT1,FS_BOLD);
$graph->xaxis->title->SetFont(FF_FONT1,FS_BOLD);

//$result1 = mysql_query("select date from amzn");
//$array1 = mysql_fetch_array($result1);
// Specify text labels for the ticks. One label for each data point
// $time - trading hours on stock exchange
$time = array( 8, 8.5, 9, 9.5, 10, 10.5, 11, 11.5, 12, 12.5, 13, 13.5, 14, 14.5, 15, 15.5, 16, 16.5, 17);
//$time = $array1;

$graph->xaxis->SetTickLabels($time);
$graph->xaxis->SetFont(FF_FONT2);
$graph->xaxis->SetTextLabelInterval(2);

$lineplot->SetColor("blue");
$lineplot->SetWeight(1);

// Display the graph
$graph->Stroke();

?>

jrmckee

Ah. You can do this with the code I wrote above. I like 'for' loops, but you can also do it with while.

$res = mysql_query("select quote from ftse");
$num = mysql_numrows($res);

for($i=0;$i<$num;$i++) {
$row[$i]=mysql_fetch_array($res);
$ydata[$i]=$row[$i]["quote"];
}

Now $ydata is a array containing the value of the field 'quote'.

Jon

onion2k

Originally posted by nexx


while($rs = mysql_fetch_array($res))
{
$array[] = $rs[1];
}

[/B]

The problem is that theres only one thing coming out of the database. So it should be $rs[0] ... arrays start at 0, not one. My bad, I copied your original post...

onion2k

PS: For jrmckee:

Your code:

for($i=0;$i<$num;$i++) {
$row[$i]=mysql_fetch_array($res);
$ydata[$i]=$row[$i]["quote"];
}

My code:

while($rs = mysql_fetch_array($res)) {
$array[] = $rs[0];
}

They do exactly the same thing. Which one is more readable?

jrmckee

Depends on how one likes to code.

Jon

nexx

Thanx for your help guys, it works!

laserlight

Depends on how one likes to code.

Actually, I think orion2k is wrong when he says "They do exactly the same thing".

Your code wastes time incrementing the loop index.

jrmckee

Gee whiz. Nice to see this turned into a "my code is better than your code" thread. Is that what these boards are for?

Jon

nexx

Stuck

Cant work out an algorithm to calculate the following:

I have 3 fields, one contains morning price, 2nd contains evening price, 3rd containd the date.
I need to deduct from the evening price the morning price of the next day and add evening price of the same day -

loop
$result = yesterday$close - today$open +today$close
echo $total

bellow my attempts to construct the loop

 


include ("include/dbconnection.inc"); 
############################################### 
$connection = mysql_connect($host,$dbuser,$dbpassword); 
if(!$connection) 
die("Couldnt connect"); 

mysql_select_db($database, $connection) 
or die("couldnt connect to db".mysql_error()); 
$close = mysql_query("select close from am where sdate BETWEEN '2004-03-01' AND '2004-03-30'") 
or die("SELECT error".mysql_error()); 

$open = mysql_query("select open from am where sdate BETWEEN '2004-03-02' AND '2004-03-30'") 
or die("SELECT error".mysql_error()); 

while($resclose = mysql_fetch_row($close)){
  $total+=$resclose[0];
  echo $total;
while($resopen = mysql_fetch_row($open)){
$total = 0;
$calc = $resclose[0];
$calc2 = $resopen[0];
$total = $calc - $calc2;
}
}