انشاء القاعدة
CREATE DATABASE `phpchart` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;


انشاء الجدول
ويجب عدم انشاء حقول للعمليات الحسابية مثل المجموع او المتوسط
CREATE TABLE `table1` (
  `name` VARCHAR(20) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `degree` INTEGER(11) NOT NULL,
  PRIMARY KEY (`degree`)

)ENGINE=MyISAM
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

ادخال البيانات الاساسية
INSERT INTO `table1` (`name` ,`degree` ) VALUES 
('احمد', '25'),
('تامر', '46'),
('سمير', '75'),
('فاروق', '65');
ينصح باستخدام برنامج النودباد بلس بلس
notepad++<BR>ومن قائمة <BR>format  -> convert to utf without bom


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>Libchart horizontal bars demonstration</title>
<meta http-equiv="Content-Language" content="ar-eg"/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>
<body>
	<img alt="Horizontal bars chart"  src="generated/demo2.png" style="border: 1px solid gray;"/>
</body>
</html>
<?

include "libchart/classes/libchart.php";
	$chart = new HorizontalBarChart(600, 170);
	$dataSet = new XYDataSet();
	
$connection = mysql_connect("localhost", "root", "") or die ( mysql_error());
mysql_select_db("phpchart", $connection) or die(mysql_error());
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
mysql_query("SET character_set_database=utf8");
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_server=utf8");
mysql_query(" set character_set_server='utf8'");
mysql_query("set names= 'utf8'");

$querya = "SELECT * FROM `table1`";
$showa = mysql_query($querya,$connection)or die(mysql_error());

$num_rows = mysql_num_rows($showa);
//echo "$num_rows";

while($row = mysql_fetch_array($showa)) 
  { 	
	$dataSet->addPoint(new Point($row['name'], $row['degree']));
	$dataSet->addPoint(new Point($row['name'], $row['degree']));
	$dataSet->addPoint(new Point($row['name'], $row['degree']));
	$dataSet->addPoint(new Point($row['name'], $row['degree']));
	 } 
	$chart->setDataSet($dataSet);
	$chart->getPlot()->setGraphPadding(new Padding(5, 30, 20, 140));

	$chart->setTitle("title");
	$chart->render("generated/demo2.png");
?>

