Re: [Phpmyadmin-devel] Zoom Search
On Sat, Jun 4, 2011 at 9:57 PM, Ammar Yasir <ammaryasir.88@gmail.com> wrote:
On Wed, Jun 1, 2011 at 7:47 PM, Madhura Jayaratne <madhura.cj@gmail.com>wrote:
On Wed, Jun 1, 2011 at 5:30 PM, Marc Delisle <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>> wrote:
On Wed, Jun 1, 2011 at 2:10 AM, Ammar Yasir < 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>> 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
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. Regards, Ammar Yasir
------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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. 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
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.
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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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
Ammar Yasir a écrit :
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: 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
Ammar, OK, these scenarios work fine. Any opinion on Tyron's suggestion about using Highcharts? Otherwise, how do you plan to implement zooming, panning and clickable points? If Highcharts works well, it would be easier for us to handle just one library for charts. -- Marc Delisle http://infomarc.info
On Fri, Jun 10, 2011 at 6:12 PM, Marc Delisle <marc@infomarc.info> wrote:
Ammar Yasir a écrit :
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: 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
Ammar, OK, these scenarios work fine.
Any opinion on Tyron's suggestion about using Highcharts? Otherwise, how do you plan to implement zooming, panning and clickable points?
If Highcharts works well, it would be easier for us to handle just one library for charts.
I would probably have used jquery plugins or write my own code for it. SVG has <a> and events also so clickable points can be implemented that way. But i'll try highcharts now as tyron suggested.
-- 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
On Sun, Jun 12, 2011 at 1:14 AM, Ammar Yasir <ammaryasir.88@gmail.com>wrote:
On Fri, Jun 10, 2011 at 6:12 PM, Marc Delisle <marc@infomarc.info> wrote:
Ammar Yasir a écrit :
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: 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
Ammar, OK, these scenarios work fine.
Any opinion on Tyron's suggestion about using Highcharts? Otherwise, how do you plan to implement zooming, panning and clickable points?
If Highcharts works well, it would be easier for us to handle just one library for charts.
I would probably have used jquery plugins or write my own code for it. SVG has <a> and events also so clickable points can be implemented that way. But i'll try highcharts now as tyron suggested.
Hi, I've used Highcharts to create the plot functionality. For now, it plots for numeric fields only. it is zoomable (both in x and y) and also you can click the data points to view the row. You can try scenarios like: In sakila database: -> In films table, try film_id ( < 100 ) vs rental_rate and choose 'title' as the label. -> In films_actor table, try film_id vs actor_id. etc.. Regards, Ammar Yasir
--
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
On Thu, Jun 16, 2011 at 10:09 PM, Ammar Yasir <ammaryasir.88@gmail.com> wrote:
On Sun, Jun 12, 2011 at 1:14 AM, Ammar Yasir <ammaryasir.88@gmail.com> wrote:
On Fri, Jun 10, 2011 at 6:12 PM, Marc Delisle <marc@infomarc.info> wrote:
Ammar Yasir a écrit :
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: 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
Ammar, OK, these scenarios work fine.
Any opinion on Tyron's suggestion about using Highcharts? Otherwise, how do you plan to implement zooming, panning and clickable points?
If Highcharts works well, it would be easier for us to handle just one library for charts.
I would probably have used jquery plugins or write my own code for it. SVG has <a> and events also so clickable points can be implemented that way. But i'll try highcharts now as tyron suggested.
Hi,
I've used Highcharts to create the plot functionality. For now, it plots for numeric fields only. it is zoomable (both in x and y) and also you can click the data points to view the row. You can try scenarios like: In sakila database: -> In films table, try film_id ( < 100 ) vs rental_rate and choose 'title' as the label. -> In films_actor table, try film_id vs actor_id. etc..
For the chart export to work you'll need to define the a js variable in your php code like this: <script type="text/javascript"> pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>'; </script> ...or maybe we could put this into header.inc.php?
Regards, Ammar Yasir
-- 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
------------------------------------------------------------------------------ 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
Hi Dne Fri, 17 Jun 2011 10:13:07 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
For the chart export to work you'll need to define the a js variable in your php code like this:
<script type="text/javascript"> pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>'; </script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does not suggest it. We anyway use it for almost all data needs to be passed to javascript and do not change during one session. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
For the chart export to work you'll need to define the a js variable in your php code like this:
<script type="text/javascript"> pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>'; </script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does not suggest it. We anyway use it for almost all data needs to be passed to javascript and do not change during one session.
I would like to be able to add js vars dynamically. In the case of server_variables.php I need to know whether the current user is a superuser. Whereas in most other pages this information is not required. So instead of putting all possible vars there I'd rather prefer to have only 4-5 variables hardcoded and others addable dynamically through a function, lets call it PMA_AddJSVariable(). But having that in messages.php would means the browser cannot load the file once and use the cached version after. Also those variables might change in value, meaning the messages.php also needs to be refreshed by the browser each time. It might be better to have that in header.inc.php.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ 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
Ammar, when I replaced pChart I have added a method called PMA_createChart() into function.js I think we should use this method to create a chart, as it apply some default settings to the chart (which you can overwrite however). This way one can apply changes globally to all the charts. On Mon, Jun 20, 2011 at 3:02 PM, Tyron Madlener <tyronx@gmail.com> wrote:
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
For the chart export to work you'll need to define the a js variable in your php code like this:
<script type="text/javascript"> pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>'; </script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does not suggest it. We anyway use it for almost all data needs to be passed to javascript and do not change during one session.
I would like to be able to add js vars dynamically. In the case of server_variables.php I need to know whether the current user is a superuser. Whereas in most other pages this information is not required. So instead of putting all possible vars there I'd rather prefer to have only 4-5 variables hardcoded and others addable dynamically through a function, lets call it PMA_AddJSVariable(). But having that in messages.php would means the browser cannot load the file once and use the cached version after. Also those variables might change in value, meaning the messages.php also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ 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
On Mon, Jun 20, 2011 at 6:57 PM, Tyron Madlener <tyronx@gmail.com> wrote:
Ammar, when I replaced pChart I have added a method called PMA_createChart() into function.js
I think we should use this method to create a chart, as it apply some default settings to the chart (which you can overwrite however). This way one can apply changes globally to all the charts.
Okay, I'll look into it.
On Mon, Jun 20, 2011 at 3:02 PM, Tyron Madlener <tyronx@gmail.com> wrote:
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
For the chart export to work you'll need to define the a js variable in your php code like this:
<script type="text/javascript"> pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>'; </script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does not suggest it. We anyway use it for almost all data needs to be passed to javascript and do not change during one session.
I would like to be able to add js vars dynamically. In the case of server_variables.php I need to know whether the current user is a superuser. Whereas in most other pages this information is not required. So instead of putting all possible vars there I'd rather prefer to have only 4-5 variables hardcoded and others addable dynamically through a function, lets call it PMA_AddJSVariable(). But having that in messages.php would means the browser cannot load the file once and use the cached version after. Also those variables might change in value, meaning the messages.php also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
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
------------------------------------------------------------------------------ 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
On Mon, Jun 20, 2011 at 3:02 PM, Tyron Madlener <tyronx@gmail.com> wrote:
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
For the chart export to work you'll need to define the a js variable in your php code like this:
<script type="text/javascript"> pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>'; </script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does not suggest it. We anyway use it for almost all data needs to be passed to javascript and do not change during one session.
I would like to be able to add js vars dynamically. In the case of server_variables.php I need to know whether the current user is a superuser. Whereas in most other pages this information is not required. So instead of putting all possible vars there I'd rather prefer to have only 4-5 variables hardcoded and others addable dynamically through a function, lets call it PMA_AddJSVariable(). But having that in messages.php would means the browser cannot load the file once and use the cached version after. Also those variables might change in value, meaning the messages.php also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
With such solution I could also avoid some inline JSON Code places.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ 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
On Sat, Jun 25, 2011 at 12:50 PM, Tyron Madlener <tyronx@gmail.com> wrote:
On Mon, Jun 20, 2011 at 3:02 PM, Tyron Madlener <tyronx@gmail.com> wrote:
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
For the chart export to work you'll need to define the a js variable in your php code like this:
<script type="text/javascript"> pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>'; </script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does not suggest it. We anyway use it for almost all data needs to be passed to javascript and do not change during one session.
I would like to be able to add js vars dynamically. In the case of server_variables.php I need to know whether the current user is a superuser. Whereas in most other pages this information is not required. So instead of putting all possible vars there I'd rather prefer to have only 4-5 variables hardcoded and others addable dynamically through a function, lets call it PMA_AddJSVariable(). But having that in messages.php would means the browser cannot load the file once and use the cached version after. Also those variables might change in value, meaning the messages.php also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
With such solution I could also avoid some inline JSON Code places.
Any objections to this?
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ 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
On Mon, Jul 11, 2011 at 3:44 PM, Tyron Madlener <tyronx@gmail.com> wrote:
On Sat, Jun 25, 2011 at 12:50 PM, Tyron Madlener <tyronx@gmail.com> wrote:
On Mon, Jun 20, 2011 at 3:02 PM, Tyron Madlener <tyronx@gmail.com> wrote:
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
For the chart export to work you'll need to define the a js variable in your php code like this:
<script type="text/javascript"> pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>'; </script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does not suggest it. We anyway use it for almost all data needs to be passed to javascript and do not change during one session.
I would like to be able to add js vars dynamically. In the case of server_variables.php I need to know whether the current user is a superuser. Whereas in most other pages this information is not required. So instead of putting all possible vars there I'd rather prefer to have only 4-5 variables hardcoded and others addable dynamically through a function, lets call it PMA_AddJSVariable(). But having that in messages.php would means the browser cannot load the file once and use the cached version after. Also those variables might change in value, meaning the messages.php also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
With such solution I could also avoid some inline JSON Code places.
Any objections to this?
Hi,
I'm using PMA_createChart(settings) with my settings and If have some numeric values for my xAxis, it overwrites them as using a timeline on xAxis ( the markers on the xAxis are also not visible). git: http://repo.or.cz/w/phpmyadmin/ammaryasirr.git
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
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
------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Le 2011-07-11 06:14, Tyron Madlener a écrit :
On Sat, Jun 25, 2011 at 12:50 PM, Tyron Madlener<tyronx@gmail.com> wrote:
On Mon, Jun 20, 2011 at 3:02 PM, Tyron Madlener<tyronx@gmail.com> wrote:
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař<michal@cihar.com> wrote:
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200 Tyron Madlener<tyronx@gmail.com> napsal(a):
For the chart export to work you'll need to define the a js variable in your php code like this:
<script type="text/javascript"> pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>'; </script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does not suggest it. We anyway use it for almost all data needs to be passed to javascript and do not change during one session.
I would like to be able to add js vars dynamically. In the case of server_variables.php I need to know whether the current user is a superuser. Whereas in most other pages this information is not required. So instead of putting all possible vars there I'd rather prefer to have only 4-5 variables hardcoded and others addable dynamically through a function, lets call it PMA_AddJSVariable(). But having that in messages.php would means the browser cannot load the file once and use the cached version after. Also those variables might change in value, meaning the messages.php also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
With such solution I could also avoid some inline JSON Code places.
Any objections to this?
OK for me. -- Marc Delisle http://infomarc.info
participants (4)
-
Ammar Yasir -
Marc Delisle -
Michal Čihař -
Tyron Madlener