Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to generate graphs and charts from mysql database in php [closed]

Tags:

php

mysql

graph

charts

How can I generate graphs and charts from a mysql database using php?

I'm trying to use "chart director" but I can't even install it properly, because I'm using php version 5.3, and it's using a deprecated function dl.

Do you know of any alternatives that:

  • fully support php 5.3
  • are easy to use for beginners
  • can access the mysql database and chart its data
like image 271
Wern Ancheta Avatar asked Dec 04 '10 08:12

Wern Ancheta

People also ask

Can you make graphs in MySQL?

Nope, a database is for storing and retrieving data efficiently and safely. Not for other purposes. Use any client application to retrieve the data the way you need it (from MySQL), and to graph it accordingly. Show activity on this post.

How can you retrieve data from the MySQL database using PHP?

Data can be fetched from MySQL tables by executing SQL SELECT statement through PHP function mysql_query. You have several options to fetch data from MySQL. The most frequently used option is to use function mysql_fetch_array(). This function returns row as an associative array, a numeric array, or both.

1 Answers

You can use JPGraph and Graphpite

http://jpgraph.net/

http://graphpite.sourceforge.net/

like image 87
sushil bharwani Avatar answered Oct 14 '22 15:10

sushil bharwani
Sign in to Comment

Related questions

How to read only 5 last line of the text file in PHP?
Fatal error: Class 'PHPMailer' not found
Cyrillic transliteration in PHP
how to get length of integers in PHP ?
Facebook + UserBundle authentication with symfony2
How to download large files through PHP script [duplicate]
PHP php_network_getaddresses: getaddrinfo failed: No such host is known
Stripe: No such token.. a similar object exists in test mode, but a live mode key was used to make this request
PHP Syntax checking pre-source control
Running PHPUnit within a Docker container with PhpStorm
Retrieving Facebook / Google+ / Linkedin profile picture having email address only
Equivalent of PHP error_log for info logs?
How do I verify Android in-app-billing transactions on MY server?
phpStorm, do not index a folder / tree [closed]
Associative Array versus SplObjectStorage
How to mark code as stable using Composer?
Where to learn Yii? [closed]
What keeps a php session alive?
Migration Foreign Key Vs Eloquent Relationships in Laravel
Should I allow 'allow_url_fopen' in PHP?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!