[Phpmyadmin-devel] Zoom Search

Tyron Madlener tyronx at gmail.com
Thu Jun 9 19:49:33 CEST 2011


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 at infomarc.info> wrote:
> Ammar Yasir a écrit :
>>
>> On Sat, Jun 4, 2011 at 9:57 PM, Ammar Yasir <ammaryasir.88 at gmail.com
>> <mailto:ammaryasir.88 at gmail.com>> wrote:
>>
>>
>>
>>     On Wed, Jun 1, 2011 at 7:47 PM, Madhura Jayaratne
>>     <madhura.cj at gmail.com <mailto:madhura.cj at gmail.com>> wrote:
>>
>>
>>
>>         On Wed, Jun 1, 2011 at 5:30 PM, Marc Delisle <marc at infomarc.info
>>         <mailto:marc at infomarc.info>> wrote:
>>
>>             Madhura Jayaratne a écrit :
>>              >
>>              >
>>              > On Wed, Jun 1, 2011 at 4:30 PM, Madhura Jayaratne
>>             <madhura.cj at gmail.com <mailto:madhura.cj at gmail.com>
>>              > <mailto:madhura.cj at gmail.com
>>             <mailto:madhura.cj at gmail.com>>> wrote:
>>              >
>>              >
>>              >
>>              >     On Wed, Jun 1, 2011 at 2:10 AM, Ammar Yasir
>>             <ammaryasir.88 at gmail.com <mailto:ammaryasir.88 at gmail.com>
>>              >     <mailto:ammaryasir.88 at gmail.com
>>             <mailto:ammaryasir.88 at gmail.com>>> wrote:
>>              >
>>              >
>>              >
>>              >         On Wed, Jun 1, 2011 at 1:55 AM, Marc Delisle
>>             <marc at infomarc.info <mailto:marc at infomarc.info>
>>              >         <mailto:marc at infomarc.info
>>             <mailto:marc at infomarc.info>>> wrote:
>>              >
>>              >             Ammar Yasir a écrit :
>>              >              >
>>              >              >
>>              >              > On Tue, May 31, 2011 at 10:14 PM, Marc Delisle
>>              >             <marc at infomarc.info
>>             <mailto:marc at infomarc.info> <mailto:marc at infomarc.info
>>             <mailto:marc at infomarc.info>>
>>              >              > <mailto:marc at infomarc.info
>>             <mailto:marc at infomarc.info> <mailto:marc at infomarc.info
>>             <mailto:marc at 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.
>
> 1. 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,
> )
>
>
> 2. What should I enter as data label to have meaningful results? Please
> give an example.
>
> 3. 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>




More information about the Developers mailing list