On Thu, Jun 9, 2011 at 10:35 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.

Hi,
 
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,
)

I fixed this issue. The notice comes if you do not select a label, I added a default to it so the notice should not come now.

2. What should I enter as data label to have meaningful results? Please
give an example.

Actually, we had to show a label for each data point. So for example in 'film' table or 'actor' table 'name' could be a label for points. I haven't implemented showing the label yet, the selection just stores the label for each point internally. I thought showing the label for now (without the zoom feature) would make the plot very difficult to understand.
 
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.

I've added plotting string fields too, so some scenarios in sakila database you can check:
    'film_list' or 'nicer_but_slower_film_list' tables, plot fid vs category
    'sales_by_film_category'  table, plot total_sales vs category
    'payment' table, plot customer_id vs amount
   
 
--
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