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