Hey everyone. I am working on an assignment and need some help. I have no syntax errors but it won't connect to MySQL. My assignment is to do a poll on a fake company that I have set up on the fake company's products....well...take a look at my code and see if there is anything wrong...please!!!
<?php
//get vote from form
$vote=$_REQUEST['vote'];
//log in to database
if (!$db_conn = new mysqli('localhost', 'poll', 'poll', 'POLL'))
{
echo 'Could not connect to database<br/>';
exit;
}
if (!empty($vote)) //if they filled the form out, add their vote
{
$vote = addslashes($vote);
$query = "update poll_results
set num_votes = num_votes + 1
where SODA_NAME = '$vote'";
if(!($result = @$db_conn->query($query)))
{
echo 'Could not connect to database<br />';
exit;
}
}
//get current results of poll, regardless of whether they voted
$query = 'select * from poll_results';
if(!($result = @$db_conn->query($query)))
{
echo 'Could not connect to database<br />';
exit;
}
$num_SODA_NAME = $result->num_rows;
//calculate total number of votes so far
$total_votes=0;
while ($row = $result->fetch_object())
{
$total_votes += $row->num_votes;
}
$result->data_seek(0); //reset result pointer
/******************************
Initial calculations for graph
*******************************/
//set up constants
putenv('GDFONTPATH=/Applications/Font Book.app');
$width=500; //width of image in pixel-this will fit in 640x480
$left_margin = 50; //space to leave on left of graph
$right_margin = 50; //ditto right
$bar_height = 40;
$bar_spacing = $bar_height/2;
$font = 'ariel';
$title_size= 16; //point
$main_size= 12; //point
$small_size= 12; //point
$text_indent = 10; //postition for text labels from edge of image
//set up initial point to draw from
$x = $left_margin + 60; //place to draw baseline of the graph
$y = 50; //ditto
$bar_unit = (width-($x+$right_margin)) / 100; //one "point" on the graph
//calculate height of graph - bars plus gaps plus some margin
$height = $num_SODA_NAME * ($bar_height + $bar_spacing) + 50;
/******************
Set up base image
*******************/
//create a blank canvas
$im = imagecreateruecolor($width, $height);
//Allocate colors
$white=imagecolorallocate($im, 255, 255, 255, 255);
$blue=imagecolorallocate($im, 0, 64, 128);
$black=imagecolorallocate($im, 0, 0, 0);
$pink=imagecolorallocate($im, 255, 78, 243);
$text_color = $black;
$percent_color = $black;
$bg_color = $white;
$line_color = $black;
$bar_color = $blue;
$number_color = $pink;
//Create "canvas" to draw on
imagefilledrectangle($im, 0, 0, $width, $height, $bg_color);
//Draw outline around canvas
imagerectangle($im, 0, 0, $width-1, $height-1, $line_color);
//Add title
$title = 'The Beverage Company Poll Results';
$title_dimentions = imagettfbbox($title_size, 0, $font, $title);
$title_length = $title_dimentions[2] - $title_dimentions[0];
$title_height = abs($title_dimentions[7] - $title_dimentions[1]);
$title_above_line = abs($title_dimentions[7]);
$title_x = ($width-$title_length)/2; //center it in x
$title_y = ($y - $title_height)/2 + $title_above_line; //center in y gap
imagettftext($im, $title_size, 0, $title_x, $title_y,
$title_color, $font, $title);
//Draw a base line from a little above first bar location
//to a little below last
imageline($im, $x, $y-5, $x, $height-15, $line_color);
/********************
Draw data into graph
*********************/
//Get each line of db data and draw corresponding bars
while ($row = $result->fetch_object())
{
if($total_votes > 0)
$percent = intval(($row->num_votes/$total_votes)*100);
else
$percent = 0;
//display percent for this value
$percent_dimentions = imagettfbbox($main_size, 0, $font, $percent.'%');
$percent_length = $percent_dimentions[2] - $percent_dimentions[0];
imagettftext($im, $main_size, 0, $width-$percent_length-$text_indent,
$y+($bar_height/2), $percent_color, $font, $percent.'%');
//length of bar for this value
$bar_length = $x + ($percent * $bar_unit);
//draw bar for this value
imagefilledrectangle($im, $x, $y-2, $bar_length, $y+bar_height, $bar_color);
//draw title for this value
imagettftext($im, $main_size, 0, $text_indent, $y+($bar_height/2),
$text_color, $font, "$row->SODA_NAME");
//draw outline showing 100%
imagerectangle($im, $bar_length+1, $y-2,
($x+(100*$bar_unit)), $y+$bar_height, $line_color);
//display numbers
imagettftext($im, $small_size, 0, $x+(100*$bar_unit)-50, $y+($bar_height/2),
$number_color, $font, $row->num_votes.'/' .$total_votes);
//move down to next bar
$y=$y+($bar_height+$bar_spacing);
}
/*************
Display image
**************/
Header('Content-type: image/png');
imagepng($im);
/*****************
Clean up
******************/
imagedestroy($im);
?>
I appreciate any help. I am wondering if I have to do something in MySQL or Dreamweaver to connect PHP with MySQL that I have missed???
Thanks,
Beth
