By the way, what about using Highcharts for this project?
Highcharts can have clickable points: http://www.highcharts.com/demo/line-ajax And is zoomable (altough mouse-wheel zoom would be nicer): http://www.highcharts.com/demo/line-time-series
On Thu, Jun 9, 2011 at 7:05 PM, Marc Delisle marc@infomarc.info wrote:
Ammar Yasir a écrit :
On Sat, Jun 4, 2011 at 9:57 PM, Ammar Yasir <ammaryasir.88@gmail.com mailto:ammaryasir.88@gmail.com> wrote:
On Wed, Jun 1, 2011 at 7:47 PM, Madhura Jayaratne <madhura.cj@gmail.com mailto:madhura.cj@gmail.com> wrote:
On Wed, Jun 1, 2011 at 5:30 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Madhura Jayaratne a écrit : > > > On Wed, Jun 1, 2011 at 4:30 PM, Madhura Jayaratne <madhura.cj@gmail.com mailto:madhura.cj@gmail.com > <mailto:madhura.cj@gmail.com mailto:madhura.cj@gmail.com>> wrote: > > > > On Wed, Jun 1, 2011 at 2:10 AM, Ammar Yasir <ammaryasir.88@gmail.com mailto:ammaryasir.88@gmail.com > <mailto:ammaryasir.88@gmail.com mailto:ammaryasir.88@gmail.com>> wrote: > > > > On Wed, Jun 1, 2011 at 1:55 AM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info > <mailto:marc@infomarc.info mailto:marc@infomarc.info>> wrote: > > Ammar Yasir a écrit : > > > > > > On Tue, May 31, 2011 at 10:14 PM, Marc Delisle > <marc@infomarc.info mailto:marc@infomarc.info <mailto:marc@infomarc.info mailto:marc@infomarc.info> > > <mailto:marc@infomarc.info mailto:marc@infomarc.info <mailto:marc@infomarc.info mailto:marc@infomarc.info>>> > wrote: > > > > Ammar Yasir a écrit : > > > > > Parts refactored are: > > > - Setting titles (titles['Browse']]) > > > - getting fields list (getting column details) > > > - setting sub-tabs (Table search and Zoom search) > > > - setting table header of QBE display > > > - displaying foreign data > > > - search criteria input elements (HTML content > generation for the > > input > > > elements) > > > > Very good! > > > > Another trick you can use: when a function returns an > array, like your > > PMA_tbl_getFields(), to fill all the returned values > in one statement > > you can use this syntax: > > > > list($fields_list, $fields_type, $fields_collation, > $fields_null) = > > PMA_tbl_getFields($table,$db); > > > > > > I made some more changes. > > OK. There are still a few tab characters (found some in > libraries/tbl_select.lib.php). > > > Should I proceed now to try the charting libraries? > > Yes but in your proposal you wrote that you preferred > jQuery-SVG so I > assume you'll try this one first? > > I'll try SVG first. I'm following what others have to say about > SVG, Madhura is using it for his GIS visualization. Tyron > proposed real-time charting but I don't think it'll be of much > help in our case. > > > Hi Ammar, > > I'm not sure what exactly your requirement is. But pls have a look > at the visualization of data at [1] by clicking on the 'Visualize > GIS data' link in the 'Query results operations' section towards the > bottom of the page. Try out zooming by double clicking and panning > by dragging. I believe you are looking for something like this for > your zoom search feature.
Madhura,
I have issues operating panning and zooming. Here is the scenario:
1. Browse world_cities and click Visualize GIS data 2. Click-drag: pans OK 3. Double-click: this is a zoom out, I guess 4. Click-drag: no panning 5. Click "zoom out": data points are enlarging, isn't this a zoom-in?
Marc,
This is a Firefox compatibility problem. Resolved and pushed to the repo. Demo will take some time to upgrade to the new version. Meanwhile if you have Chrome, you can still experience what it's suppose to do.
-- Thanks and Regards,
Madhura Jayaratne
Hi, I was looking up jQuery-SVG and SVG past two days. There has been a discussion going on in the list about whether to include a different plotting library than existing(pChart). For now, instead of including another plotting library, I've developed a prototype that creates the plot using just SVG. I'll push it to my repo sometime later today.
Hi,
I've pushed my work. The basic plot functionality is implemented along with classes for the same. Currently it works only for numeric fields, I'll add support for other data types after some testing. You can try scenarios in 'sakila' database and search 'films' or 'film_actor' table.
Ammar, I'm concentrating on testing the interface right now, haven't looked at the code yet.
- Let's say I choose film_actor, activate actor_id and film_id and
enter 1 as the actor id. When I get the results, I no longer see the value I entered in the dialog.
But this scenario gives me a notice: Notice in ./libraries/svg_plot/pma_scatter_plot.php#224 Undefined index:
Backtrace
./libraries/svg_plot/pma_scatter_plot.php#161: PMA_Scatter_Plot->_prepareDataSet( array, integer 0, array, string , ) ./libraries/svg_plot/pma_scatter_plot.php#176: PMA_Scatter_Plot->_svg() ./libraries/tbl_select.lib.php#373: PMA_Scatter_Plot->asSVG() ./tbl_zoom_select.php#131: PMA_SVG_scatter_plot( array, array, )
- What should I enter as data label to have meaningful results? Please
give an example.
- Did you find a table (in sakila) for which choosing two columns and
generating a plot would make me recognize some kind of trend in the data?
As an example, on a copy of the film table I did update film_copy set length = length*3 where film_id > 500
and I was able to see some trend in the plot.
-- Marc Delisle http://infomarc.info
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel