[Phpmyadmin-devel] Zoom Search
Marc Delisle
marc at infomarc.info
Thu Jun 9 19:05:03 CEST 2011
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
More information about the Developers
mailing list