Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread Chrystopher Medina
i could change that about the date in the server thanks my friend u know could u help me with this.. i think that is the most important part of the web site .. i have to login to the users i have this file: but i dont think so that this is the best way to do ... u know ido a lot of querys

Re: [visualization-api] Re: Google Column Chart is not working in IE8

2012-12-28 Thread Hari K D
Vertical line at the left of the chart, and I also cant set vertical grid lines. On Wednesday, December 26, 2012 11:10:16 PM UTC+5:30, asgallant wrote: What is it that you want to set for the axis? On Wednesday, December 26, 2012 11:27:40 AM UTC-5, Hari K D wrote: asgallant, the fix is

[visualization-api] Re: Geochart multiple markers in the same city

2012-12-28 Thread Carlos Moreira
When I have this problem, i usually set a small offset for the lat/lon so when the zoom feature kicks in, it show's the markers separated. Fede, a bit offtopic, but what modal script did you use? i'm looking for an easy one to use in some of my scripts.. cheers! Sexta-feira, 28 de Dezembro de

[visualization-api] Pie Chart - Project Severity

2012-12-28 Thread JPrasanna Venkatesan
Hi, I have a pie chart which connect Account Name and Number of projects in that account Say Account Names can be Asia, Africa, America, Europe and Number of Projects can be 11,12,13,14 Asia11 Africa 12 America 13 Europe 14 I want the pie slice size to be based on the

[visualization-api] Re: Link on interactive google Chart

2012-12-28 Thread Chia Wei Han
Hi, I have added what you recommended but its not working.. html head script type=text/javascript src=https://www.google.com/jsapi;/script script type=text/javascript google.load(visualization, 1, {packages:[corechart]}); google.setOnLoadCallback(drawChart); function

[visualization-api] Re: Link on interactive google Chart

2012-12-28 Thread asgallant
That code snippet is missing the visualization keyword in google.visualization.events... google.visualization.events.addListener(chart, 'select', function() { // whatever you want, ex: window.location.replace(http://www.google.com;) }); is what you need. I accidentally left that out of

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread asgallant
Here's a basic tutorial: http://www.phpeasystep.com/phptu/6.html. It looks like you are already doing most of what the tutorial shows already. I can help you convert your script to PDO's, if you want. On Friday, December 28, 2012 3:45:00 AM UTC-5, Chrystopher Medina wrote: i could change

Re: [visualization-api] Re: Google Column Chart is not working in IE8

2012-12-28 Thread asgallant
You may or may not be able to get the baseline you want or the vertical gridlines, depending on the type of x-axis you have. If you have a numeric, date, or datetime axis, then gridlines and a baseline are both supported. If your x-axis is string type, then they are not supported. On Friday,

[visualization-api] Re: Pie Chart - Project Severity

2012-12-28 Thread asgallant
You can create a DataTable with 3 columns (location, number of projects, and severity), and use the severity information to populate an array of color values that you can pass to the chart's colors option. Use a DataView to filter out the severity column when drawing the chart. See an

[visualization-api] multiple charts

2012-12-28 Thread Arush
Please explain how to have multiple series lines for the same x axis values when using dynamic data via ajax in json through php -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To view this discussion on the web visit

[visualization-api] Re: multiple charts

2012-12-28 Thread asgallant
Put each series of data into its own column. It is fundamentally no different than using a single series of data. On Friday, December 28, 2012 2:47:19 PM UTC-5, Arush wrote: Please explain how to have multiple series lines for the same x axis values when using dynamic data via ajax in json

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread Chrystopher Medina
yes my friend please help me to convert my script to PDO¨s please.please thanks again my friend -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-api@googlegroups.com. To

[visualization-api] Re: multiple charts

2012-12-28 Thread Arush
thanks for the reply but how do i change colour and other options for the 2 series? On Saturday, December 29, 2012 1:58:13 AM UTC+5:30, asgallant wrote: Put each series of data into its own column. It is fundamentally no different than using a single series of data. On Friday, December

[visualization-api] Re: multiple charts

2012-12-28 Thread Arush
For mulitple columns i get data like this but it doesnt draw both the lines ... { cols: [ {label:Dat,type:date,role:annotation}, {label:RETURNING VISITS,type:number} ], rows: [{c:[{v:Date(2012,11,28)}, {v: 0}]},{c:[{v:Date(2012,11,29)}, {v: 0}]},], cols: [

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread asgallant
A great deal of your PHP code was redundant, you can collapse it all into a single query and the script becomes quite simple: ?php if ($_POST['usuario'] != '' $_POST['password']!= '') { try { $db = new PDO(mysql:dbname=encuestasavandaro, root,chrystopher); } catch (PDOException $e) { die

[visualization-api] Re: multiple charts

2012-12-28 Thread asgallant
Your JSON isn't formatted correctly. First of all, the annotation role isn't valid for the domain column (Dat in your example). Also, you need to include all 3 column definitions together, and populate all rows with 3 columns of data, like this: { cols: [ {label:Dat,type:date},

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread Chrystopher Medina
if ($_POST['usuario'] != '' $_POST['password']!= '') { try { $db = new PDO(mysql:dbname=encuestasavandaro, root,chrystopher); } catch (PDOException $e) { die ($e-getMessage()); } $query = $db-prepare('SELECT a.rol, b.usuario FROM rollusuario a, usuarios b WHERE a.id_rol = b.id_rol AND

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread asgallant
Sorry, I missed that. Use this: $_SESSION[usuario]= $_POST[usuario].|.$results[0]['rol']; On Friday, December 28, 2012 7:15:44 PM UTC-5, Chrystopher Medina wrote: if ($_POST['usuario'] != '' $_POST['password']!= '') { try { $db = new PDO(mysql:dbname=encuestasavandaro, root,chrystopher);

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread Chrystopher Medina
my friennd in this part $query-execute(array('usario' = $_POST['usuario']//here is something like this ,'password' = $_POST['password'])); $results = $query-fetchAll(PDO::FETCH_ASSOC); // gracefully exit the database $query = null; $db = null; -- You received this message because you are

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread asgallant
Yes, that should be: $query-execute(array('usario' = $_POST['usuario'], 'password' = $_POST['password'])); On Friday, December 28, 2012 7:58:17 PM UTC-5, Chrystopher Medina wrote: my friennd in this part $query-execute(array('usario' = $_POST['usuario']//here is something like this

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread Chrystopher Medina
my friend i tried the query and its ok.. but it doesn´t work if echo 0 = the user has been logued in... if echo 1= the values are wrong and if echo 2; = there are not values entered by the user ?php if ($_POST['usuario']!= '' $_POST['password']!= ''){ $username = root; $password =

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread Chrystopher Medina
my friend it works sorry i just had wrong a letter i had 'usario' = $_Post['usuario'] and it is 'usuario' = $_Post['usuario'] thanks again my friend and tell me this avoid a little sqlinjection -- You received this message because you are subscribed to the Google Groups Google Visualization

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread asgallant
What doesn't work? On Friday, December 28, 2012 8:20:02 PM UTC-5, Chrystopher Medina wrote: my friend i tried the query and its ok.. but it doesn´t work if echo 0 = the user has been logued in... if echo 1= the values are wrong and if echo 2; = there are not values entered by the

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread asgallant
You're welcome. On Friday, December 28, 2012 8:38:20 PM UTC-5, Chrystopher Medina wrote: my friend it works sorry i just had wrong a letter i had 'usario' = $_Post['usuario'] and it is 'usuario' = $_Post['usuario'] thanks again my friend and tell me this avoid a little sqlinjection --

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread Chrystopher Medina
My friend u know i want to do na application for the restaurants Here in mexico. Where i live is called valle de bravo really is a turistic place. And i want to do the aplication for cellphones. In jquery i think. But do u recomend jquery movile. I ve Heard about phonegap But i Dont know what is

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread asgallant
I haven't used either jQuery Mobile or Phonegap. You'll have to research them to see which best fits your needs. On Friday, December 28, 2012 8:54:18 PM UTC-5, Chrystopher Medina wrote: My friend u know i want to do na application for the restaurants Here in mexico. Where i live is called

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread Chrystopher Medina
And then save It in my computer -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-api@googlegroups.com. To unsubscribe from this group, send email to

Re: [visualization-api] Re: Google Charts with PHP and MySQL

2012-12-28 Thread asgallant
Do you want this just for you, or for some set of users? If it's just you (or other site admins), you can install