Displaying results in bar/pie graph form?[Solved]
Moderator: General Moderators
Displaying results in bar/pie graph form?[Solved]
Does anyone have any resource links that goes into how get the values from a table's column and then depict the % of occurances using bar charts or pie chart?
like , let's say you have the columns IP's and Browsers. You parse the data and get the overall % of occurances and then project those findings into a bar graph or pie chart.
thanks
edit:
n/m, found a post on it here:
viewtopic.php?t=10673&highlight=pie+chart
like , let's say you have the columns IP's and Browsers. You parse the data and get the overall % of occurances and then project those findings into a bar graph or pie chart.
thanks
edit:
n/m, found a post on it here:
viewtopic.php?t=10673&highlight=pie+chart
Last edited by infolock on Thu Nov 06, 2003 7:14 pm, edited 1 time in total.
yeah.. i spent about 3 hours yesturday looking through google or i wouldn't have even posted. the thing that sux is, they are all written in perl and i don't know how to convert it over to php..
i downloaded perl and had thoughts of just implimenting it within the script, but decided that was just too many different sources and would end up taking too much time trying to figure out all their calls..
oh well, i think i found one to work with, but not really sure atm if it is gonna go through...

i downloaded perl and had thoughts of just implimenting it within the script, but decided that was just too many different sources and would end up taking too much time trying to figure out all their calls..
oh well, i think i found one to work with, but not really sure atm if it is gonna go through...
Maybe you just need to know how to look.
http://www.google.com/search?hl=en&lr=& ... %A0results
Cheers,
BDKR
http://www.google.com/search?hl=en&lr=& ... %A0results
Cheers,
BDKR
hehe, yeah i saw all that. i guess i wasn't very clear. they keep mentioning GD 2.0 and stuff, and i've never heard of it before. i downloaded the GD class, but i have no idea how to install it. the online documentation for the install expects you to be a guru, which i am far from being, so it's kinda impossible for me to get going.. oh well. thanks anyways 
Edit:
yes, i've seen the installation instructions on how to install to php, but they assume you are using linux which i am not. i'm using winblows, and unfortunately, i'm kinda at a loss.
Edit:
yes, i've seen the installation instructions on how to install to php, but they assume you are using linux which i am not. i'm using winblows, and unfortunately, i'm kinda at a loss.
GD isn't something you can just download and use like a PHP class it needs to be installed on the server which hosts your website....
To enable GD-support configure PHP --with-gd[=DIR], where DIR is the GD base install directory. To use the recommended bundled version of the GD library (which was first bundled in PHP 4.3.0), use the configure option --with-gd. In Windows, you'll include the GD2 DLL php_gd2.dll as an extension in php.ini. The GD1 DLL php_gd.dll was removed in PHP 4.3.2.
CHECK IT --> [php_man]GD[/php_man]
To enable GD-support configure PHP --with-gd[=DIR], where DIR is the GD base install directory. To use the recommended bundled version of the GD library (which was first bundled in PHP 4.3.0), use the configure option --with-gd. In Windows, you'll include the GD2 DLL php_gd2.dll as an extension in php.ini. The GD1 DLL php_gd.dll was removed in PHP 4.3.2.
CHECK IT --> [php_man]GD[/php_man]
right, i read that... but i don't know how to include php_gd2.dll as an extension in the ini... i have no idea where to add the directory or declare the extension... any help would be appreciated.GD isn't something you can just download and use like a PHP class it needs to be installed on the server which hosts your website....
To enable GD-support configure PHP --with-gd[=DIR], where DIR is the GD base install directory. To use the recommended bundled version of the GD library (which was first bundled in PHP 4.3.0), use the configure option --with-gd. In Windows, you'll include the GD2 DLL php_gd2.dll as an extension in php.ini. The GD1 DLL php_gd.dll was removed in PHP 4.3.2.
edit :
i did download the GD library thingie from the site as well, but there was no php_gd2.dll included.... only a bunch of .c files, and some others. but no dll's at all...
jeez don't i feel stupid... the php_gd.dll file was in the extensions directory of my php directory 
well, i edited php.ini and found the extensions declarations, and i uncommented php_gd2.dll.
however, i still am getting the same message as before :
Last, it says i also need png support with lng (which i also downloaded ), and that i have to declare it in my php.ini file as well with the declaration :
--with-png-dir=DIR
again, i downloaded what it requested ( the reason i need png is because the graphic i'm gonna be using is a png and the script also says it needs it ), but i don't know what i'm suposed to do with it...
too bad they don't have GD for dummies. i'd buy it
i learn fast, and i'm all ears and eyes
edit 2 *****
i just did an info request for php to see if GD was installed, and it's not even listing it.... i went back and made sure i had the dll in place (hell, i copied it not only to the c:\php directory, but my htdocs directory, and my system32 directory ), but still no help.
I checked to see what the extensions_dir was set to in the info request page, and it says "C:\php4", but in the php.ini file, it says it's just "C:\php\" ??? what is going on here? lol sorry for being so newbish, but we all gotta start somewhere i supose...
well, i edited php.ini and found the extensions declarations, and i uncommented php_gd2.dll.
however, i still am getting the same message as before :
so, is there somewhere that i'm suposed to put this gd library directory that i just downloaded? i did, however, see a patch on the gd site, and wh en i looked into it, it had that function imagecreatetruecolor, along with some others, but i have no idea if i'm suposed to download it and put it somewhere. and if i'm suposed to install it, how to install itFatal error: Call to undefined function: imagecreatetruecolor()
Last, it says i also need png support with lng (which i also downloaded ), and that i have to declare it in my php.ini file as well with the declaration :
--with-png-dir=DIR
again, i downloaded what it requested ( the reason i need png is because the graphic i'm gonna be using is a png and the script also says it needs it ), but i don't know what i'm suposed to do with it...
too bad they don't have GD for dummies. i'd buy it
i learn fast, and i'm all ears and eyes
edit 2 *****
i just did an info request for php to see if GD was installed, and it's not even listing it.... i went back and made sure i had the dll in place (hell, i copied it not only to the c:\php directory, but my htdocs directory, and my system32 directory ), but still no help.
I checked to see what the extensions_dir was set to in the info request page, and it says "C:\php4", but in the php.ini file, it says it's just "C:\php\" ??? what is going on here? lol sorry for being so newbish, but we all gotta start somewhere i supose...
Which php.ini file are you editing because PHP spits out two of them. I made this mistake when I first installed PHP and Apche, basically there is an .ini file in the PHP folder and one gets dumped into the Windows folder (c:/window/) I believe. It's the one in the windows folder that PHP reads and uses so you need to edit that one...... not the one in the PHP folder.
Confused? So was I........ for about 2 weeks
Confused? So was I........ for about 2 weeks
Yeah, I run Windows also and I simply got that .dll in the proper folder and removed a ; from php.ini and I was up and running, after a server restart.
Same went from ming and other little mods I added.
Here is a useful link for ya:
http://www.hotscripts.com/PHP/Scripts_a ... index.html
Same went from ming and other little mods I added.
Here is a useful link for ya:
http://www.hotscripts.com/PHP/Scripts_a ... index.html
yeah, i was editing the .ini in my system32... i did, however, check the other .ini-dist and ini-recommended just in case. none of them are set to "C:\php4" though
sami, thanks for the link, but it doesn't tell me what i'm doing wrong as far as installing GD.... it just shows me a bunch of graphs that use the GD library...
all i'm saying is this : i have the php_gd.dll, and the gd library from the download at bench or whatever....
I edited my php.ini file and uncommented teh ;extensions=php_db2.dll
but it is not even recognizing the fact i did this,a nd is not showing it in my php.info(); ....
i copied the dll to every directory i could think of, but no help.
is there not a down and dirty installation guide for windows users? people who aren't absolute guru's and are instead beginning develolpers ? that's the type of link i need...because they are only telling the guru's how to install GD for php support...
sami, thanks for the link, but it doesn't tell me what i'm doing wrong as far as installing GD.... it just shows me a bunch of graphs that use the GD library...
all i'm saying is this : i have the php_gd.dll, and the gd library from the download at bench or whatever....
I edited my php.ini file and uncommented teh ;extensions=php_db2.dll
but it is not even recognizing the fact i did this,a nd is not showing it in my php.info(); ....
i copied the dll to every directory i could think of, but no help.
is there not a down and dirty installation guide for windows users? people who aren't absolute guru's and are instead beginning develolpers ? that's the type of link i need...because they are only telling the guru's how to install GD for php support...
AHHHHHHHHHHH hahahahahahahahahahahahahahahaha, i GOT it!!
the problem is, when you install php, you have to define where HTDOCS is. Unfortunately, the example they give you in the "readme.txt" file that tells you how to do this, inadverdently forget to tell you that you must be "" marks around your path
lol, i put those in there, rebooted apache, and PRESTO, i gots GD 
*does hillbilly hippo dance*
the problem is, when you install php, you have to define where HTDOCS is. Unfortunately, the example they give you in the "readme.txt" file that tells you how to do this, inadverdently forget to tell you that you must be "" marks around your path
*does hillbilly hippo dance*