PHP Help

Question

welbyobeng 3 Junior Poster in Training

15 Years Ago

I have a fix code below

$values=array(
	
	       "advertisement1" => 34,
		"advertisement2" => 45,
		"advertisement3" => 16,

);

I want to take some information from my database and output the same way I have the code above but am getting an error.

I am using

$sql = "SELECT advertisement.adver_name, customer.number_customer FROM advertisement INNER JOIN customer ON advertisement.adver_id = customer.adver_id";
$result = mysql_query($sql);

while($row = mysql_fetch_array($result)){
	echo $row['adver_name']. " - ". $row['number_customer'];
	echo "<br />";
}

Where it outputs
advertisement1 - 34
advertisement2 - 45
advertisement3 - 16

I tried

$values=array(
	
while($row = mysql_fetch_array($result)){
	echo $row['adver_name']. " =>  ". $row['number_customer'];
	echo "<br />";
}

);

but i get an error

php

3 Contributors
10 Replies
105 Views
9 Hours Discussion Span
Latest Post 15 Years Ago Latest Post by welbyobeng

ShawnCplus 456 Code Monkey

15 Years Ago

A) Don't make a thread with a vague title, B) What's the error? there are a lot of possible errors

somedude3488 228 Nearly a Posting Virtuoso

15 Years Ago

Just a guess, but are you wanting something like this

<?php

$array = array();

$query = mysql_query( "SELECT advertisement.adver_name, customer.number_customer FROM advertisement INNER JOIN customer ON advertisement.adver_id = customer.adver_id" );
while( list( $name,$number ) = mysql_fetch_row( $query ) ) {
	$array[$name] = $number;
}

print_r( $array );

?>

ShawnCplus 456 Code Monkey

15 Years Ago

Yes, you told you the code you tried. But as I asked before: What is the error?

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

welbyobeng 3 Junior Poster in Training · Answer 1 · 2009-05-10T08:03:02+00:00

I am getting an error with

<?php
include("database.php");
$sql = "SELECT advertisement.adver_name, customer.number_customer FROM advertisement INNER JOIN customer ON advertisement.adver_id = customer.adver_id";
$result = mysql_query($sql);


	# ------- The graph values in the form of associative array
	echo "$values = array (";
while($row = mysql_fetch_array($result)){
echo '"'.$row['adver_name'].'" => '.$row['number_customer'].',';
}
echo ");"

	$img_width=450;
	$img_height=300; 
	$margins=20;

I think the problems comes from

while($row = mysql_fetch_array($result)){
echo '"'.$row['adver_name'].'" => '.$row['number_customer'].',';
}

I am trying to turn a sql into a array

welbyobeng 3 Junior Poster in Training · Answer 2 · 2009-05-10T08:07:26+00:00

Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in /mounted-storage/home119c/sub009/sc67000-JYEV/postwords.com/jinli/atsb/graph.php on line 14

ShawnCplus 456 Code Monkey Team Colleague · Answer 3 · 2009-05-10T08:10:50+00:00

See, that wasn't hard. Now post the contents of graph.php or point to which snippet you posted is graph.php

welbyobeng 3 Junior Poster in Training · Answer 4 · 2009-05-10T08:18:17+00:00

code below

<?php
include("database.php");
$sql = "SELECT advertisement.adver_name, customer.number_customer FROM advertisement INNER JOIN customer ON advertisement.adver_id = customer.adver_id";
$result = mysql_query($sql);


	# ------- The graph values in the form of associative array
	echo "$values = array (";
while($row = mysql_fetch_array($result)){
echo '"'.$row[0].'" => '.$row[1].',';
}
echo ");"

	$img_width=450;
	$img_height=300; 
	$margins=20;

 
	# ---- Find the size of graph by substracting the size of borders
	$graph_width=$img_width - $margins * 2;
	$graph_height=$img_height - $margins * 2; 
	$img=imagecreate($img_width,$img_height);

 
	$bar_width=20;
	$total_bars=count($values);
	$gap= ($graph_width- $total_bars * $bar_width ) / ($total_bars +1);

 
	# -------  Define Colors ----------------
	$bar_color=imagecolorallocate($img,0,64,128);
	$background_color=imagecolorallocate($img,240,240,255);
	$border_color=imagecolorallocate($img,200,200,200);
	$line_color=imagecolorallocate($img,220,220,220);
 
	# ------ Create the border around the graph ------

	imagefilledrectangle($img,1,1,$img_width-2,$img_height-2,$border_color);
	imagefilledrectangle($img,$margins,$margins,$img_width-1-$margins,$img_height-1-$margins,$background_color);

 
	# ------- Max value is required to adjust the scale	-------
	$max_value=max($values);
	$ratio= $graph_height/$max_value;

 
	# -------- Create scale and draw horizontal lines  --------
	$horizontal_lines=20;
	$horizontal_gap=$graph_height/$horizontal_lines;

	for($i=1;$i<=$horizontal_lines;$i++){
		$y=$img_height - $margins - $horizontal_gap * $i ;
		imageline($img,$margins,$y,$img_width-$margins,$y,$line_color);
		$v=intval($horizontal_gap * $i /$ratio);
		imagestring($img,0,5,$y-5,$v,$bar_color);

	}
 
 
	# ----------- Draw the bars here ------
	for($i=0;$i< $total_bars; $i++){ 
		# ------ Extract key and value pair from the current pointer position
		list($key,$value)=each($values); 
		$x1= $margins + $gap + $i * ($gap+$bar_width) ;
		$x2= $x1 + $bar_width; 
		$y1=$margins +$graph_height- intval($value * $ratio) ;
		$y2=$img_height-$margins;
		imagestring($img,0,$x1+3,$y1-10,$value,$bar_color);imagestring($img,0,$x1+3,$img_height-15,$key,$bar_color);		
		imagefilledrectangle($img,$x1,$y1,$x2,$y2,$bar_color);
	}
	header("Content-type:image/png");
	imagepng($img);
	$_REQUEST['asdfad']=234234;

?>

ShawnCplus 456 Code Monkey Team Colleague · Answer 5 · 2009-05-10T09:07:21+00:00

you forgot a ; in echo ");" (aka, exactly what the error says on the exact line number the error says)

welbyobeng 3 Junior Poster in Training · Answer 6 · 2009-05-10T09:13:31+00:00

you forgot a ; in echo ");" (aka, exactly what the error says on the exact line number the error says)

I got this error

= array ("advertisement1" => 34,"advertisement2" => 45,"advertisement3" => 16,);
Warning: Wrong parameter count for max() in /mounted-storage/home119c/sub009/sc67000-JYEV/postwords.com/jinli/atsb/graph.php on line 43

Warning: Division by zero in /mounted-storage/home119c/sub009/sc67000-JYEV/postwords.com/jinli/atsb/graph.php on line 44

Warning: Division by zero in /mounted-storage/home119c/sub009/sc67000-JYEV/postwords.com/jinli/atsb/graph.php on line 54

welbyobeng 3 Junior Poster in Training · Answer 7 · 2009-05-10T10:29:18+00:00

When I run

<?php
include("database.php");
$sql = "SELECT advertisement.adver_name, customer.number_customer FROM advertisement INNER JOIN customer ON advertisement.adver_id = customer.adver_id";
$result = mysql_query($sql);


# ------- The graph values in the form of associative array
 $values=array(
	"Jan" => 110,
	"Feb" => 130,
	"Mar" => 215,
	"Apr" => 81,
	"May" => 310,
	"Jun" => 110,
	"Jul" => 190,
	"Aug" => 175,
	"Sep" => 390,
	"Oct" => 286,
	"Nov" => 150,
	"Dec" => 196
); 

$img_width=450;
$img_height=300;
$margins=20;


# ---- Find the size of graph by substracting the size of borders
$graph_width=$img_width - $margins * 2;
$graph_height=$img_height - $margins * 2;
$img=imagecreate($img_width,$img_height);


$bar_width=20;
$total_bars=count($values);
$gap= ($graph_width- $total_bars * $bar_width ) / ($total_bars +1);


# ------- Define Colors ----------------
$bar_color=imagecolorallocate($img,0,64,128);
$background_color=imagecolorallocate($img,240,240,255);
$border_color=imagecolorallocate($img,200,200,200);
$line_color=imagecolorallocate($img,220,220,220);

# ------ Create the border around the graph ------

imagefilledrectangle($img,1,1,$img_width-2,$img_height-2,$border_color);
imagefilledrectangle($img,$margins,$margins,$img_width-1-$margins,$img_height-1-$margins,$background_color);


# ------- Max value is required to adjust the scale -------
$max_value=max($values);
$ratio= $graph_height/$max_value;


# -------- Create scale and draw horizontal lines --------
$horizontal_lines=20;
$horizontal_gap=$graph_height/$horizontal_lines;

for($i=1;$i<=$horizontal_lines;$i++){
$y=$img_height - $margins - $horizontal_gap * $i ;
imageline($img,$margins,$y,$img_width-$margins,$y,$line_color);
$v=intval($horizontal_gap * $i /$ratio);
imagestring($img,0,5,$y-5,$v,$bar_color);

}


# ----------- Draw the bars here ------
for($i=0;$i< $total_bars; $i++){
# ------ Extract key and value pair from the current pointer position
list($key,$value)=each($values);
$x1= $margins + $gap + $i * ($gap+$bar_width) ;
$x2= $x1 + $bar_width;
$y1=$margins +$graph_height- intval($value * $ratio) ;
$y2=$img_height-$margins;
imagestring($img,0,$x1+3,$y1-10,$value,$bar_color);imagestring($img,0,$x1+3,$img_height-15,$key,$bar_color);
imagefilledrectangle($img,$x1,$y1,$x2,$y2,$bar_color);
}
header("Content-type:image/png");
imagepng($img);
$_REQUEST['asdfad']=234234;

?>

I get no erros

but when I run

<?php
include("database.php");
$sql = "SELECT advertisement.adver_name, customer.number_customer FROM advertisement INNER JOIN customer ON advertisement.adver_id = customer.adver_id";
$result = mysql_query($sql);


# ------- The graph values in the form of associative array
echo "$values = array (";
while($row = mysql_fetch_array($result)){
echo '"'.$row[0].'" => '.$row[1].',';
}
echo ");";

$img_width=450;
$img_height=300;
$margins=20;


# ---- Find the size of graph by substracting the size of borders
$graph_width=$img_width - $margins * 2;
$graph_height=$img_height - $margins * 2;
$img=imagecreate($img_width,$img_height);


$bar_width=20;
$total_bars=count($values);
$gap= ($graph_width- $total_bars * $bar_width ) / ($total_bars +1);


# ------- Define Colors ----------------
$bar_color=imagecolorallocate($img,0,64,128);
$background_color=imagecolorallocate($img,240,240,255);
$border_color=imagecolorallocate($img,200,200,200);
$line_color=imagecolorallocate($img,220,220,220);

# ------ Create the border around the graph ------

imagefilledrectangle($img,1,1,$img_width-2,$img_height-2,$border_color);
imagefilledrectangle($img,$margins,$margins,$img_width-1-$margins,$img_height-1-$margins,$background_color);


# ------- Max value is required to adjust the scale -------
$max_value=max($values);
$ratio= $graph_height/$max_value;


# -------- Create scale and draw horizontal lines --------
$horizontal_lines=20;
$horizontal_gap=$graph_height/$horizontal_lines;

for($i=1;$i<=$horizontal_lines;$i++){
$y=$img_height - $margins - $horizontal_gap * $i ;
imageline($img,$margins,$y,$img_width-$margins,$y,$line_color);
$v=intval($horizontal_gap * $i /$ratio);
imagestring($img,0,5,$y-5,$v,$bar_color);

}


# ----------- Draw the bars here ------
for($i=0;$i< $total_bars; $i++){
# ------ Extract key and value pair from the current pointer position
list($key,$value)=each($values);
$x1= $margins + $gap + $i * ($gap+$bar_width) ;
$x2= $x1 + $bar_width;
$y1=$margins +$graph_height- intval($value * $ratio) ;
$y2=$img_height-$margins;
imagestring($img,0,$x1+3,$y1-10,$value,$bar_color);imagestring($img,0,$x1+3,$img_height-15,$key,$bar_color);
imagefilledrectangle($img,$x1,$y1,$x2,$y2,$bar_color);
}
header("Content-type:image/png");
imagepng($img);
$_REQUEST['asdfad']=234234;

?>

I get = array ("advertisement1" => 34,"advertisement2" => 45,"advertisement3" => 16,);
Warning: Wrong parameter count for max() in /mounted-storage/home119c/sub009/sc67000-JYEV/postwords.com/jinli/atsb/graph.php on line 43

Warning: Division by zero in /mounted-storage/home119c/sub009/sc67000-JYEV/postwords.com/jinli/atsb/graph.php on line 44

Warning: Division by zero in /mounted-storage/home119c/sub009/sc67000-JYEV/postwords.com/jinli/atsb/graph.php on line 54

Can someone help