Where the error occurs is your addRows() call. You believe you are passing an array, but since the error message is claiming otherwise, I would check that with the debugger.
Can you point us to your web page so we can try to debug it? On Fri, Jan 27, 2017 at 10:55 AM, franck danard <[email protected]> wrote: > HI > Thanks for your replay > > [["Room 200","Danard Franck *","DATE(2017,0,28)","DATE(2017,0,31)"], > ["Room 200","Danard Franck *","DATE(2017,0,29)","DATE(2017,0,31)"]] > No way. > Even with DATE, nothing. > > I don't understand why . > Excepted DATE should be new DATE() but even with this, nothing. > > The error returned by console: > Error: > > *Argument given to addRows must be either a number or an array*Where???? > What? Clue? Nothing. > My argument is array , ok... > What argument is wrong? I don't know. > > On Friday, January 27, 2017 at 4:21:14 PM UTC+1, Daniel LaLiberte wrote: >> >> Your debug output shows that the format of your date values is >> incorrect. You'll need to return the dates using the string representation >> that looks like this: "Date(2017,0,28)". See the documentation here: >> https://developers.google.com/chart/interactive/docs/datesa >> ndtimes#dates-and-times-using-the-date-string-representation >> >> >> On Fri, Jan 27, 2017 at 9:50 AM, franck danard <[email protected]> >> wrote: >> >>> Hi all. >>> >>> I've some problems to get some datas with JSON. >>> I've PHP function which send the value like this. >>> >>> $_booking = $this->getPMSbooking(""); >>> foreach($_booking as $key => $value){ >>> $confirmed = $value["confirmed"]; >>> $conf = ""; >>> if($confirmed == "0") >>> $conf = "*"; >>> list($_date_ci, $time_ci) = explode(" ", >>> $value["date_ci"]); >>> list($yci, $mci, $dci) = explode("-", >>> $_date_ci); >>> $mci = strval(intval($mci)-1); >>> $dtci = array($yci, $mci, $dci); >>> list($_date_co, $time_co) = explode(" ", >>> $value["date_co"]); >>> list($yco, $mco, $dco) = explode("-", >>> $_date_co); >>> $mco = strval(intval($mco)-1); >>> $dtco = array($yci, $mci, $dco); >>> $_rooms = $this->getPMS_all_rooms("id = ". >>> $value["room_id"]); >>> $_guest = $this->getPMS_all_guest("id = ". >>> $value["guest_id"]); >>> $room_name = $_rooms[0]["room_name"]; >>> $guest_name = $_guest[0]["last_name"]." ". >>> $_guest[0]["first_name"]." ".$conf; >>> $data[$key] = array($room_name, $guest_name, >>> $dtci, $dtco ); >>> } >>> >>> return json_encode($data, JSON_NUMERIC_CHECK); >>> >>> Next, i put in my page this. >>> >>> >>> <script type="text/javascript" src="https://www.gstatic.com/c >>> harts/loader.js"></script> >>> <script type="text/javascript"> >>> google.charts.load("current", {packages:["timeline"]}); >>> google.charts.setOnLoadCallback(drawChart); >>> function drawChart() { >>> $.ajax({ >>> url: "ajax.php?module=ddd&booking=1", >>> dataType:"json", >>> success: function (json) { >>> >>> var container = document.getElementById('timeline'); >>> var chart = new google.visualization.Timeline(container); >>> var dataTable = new google.visualization.DataTable(); >>> console.debug(json); >>> dataTable.addColumn({ type: 'string', id: 'Term' }); >>> dataTable.addColumn({ type: 'string', id: 'Name' }); >>> dataTable.addColumn({ type: 'date', id: 'Start' }); >>> dataTable.addColumn({ type: 'date', id: 'End' }); >>> >>> dataTable.addRows(json); >>> >>> chart.draw(dataTable); >>> } >>> }); >>> } >>> </script> >>> >>> But it doesn't' display anything. >>> >>> Message returns this : >>> >>> [["Room 200","Danard Franck *",[2017,0,28],[2017,0,31]],["Room 200","Danard >>> Franck *",[2017,0,29],[2017,0,31]]] >>> >>> Sure, something is wrong in my code, but i don't know what. >>> >>> The format gave by google looks like this: >>> >>> dataTable.addRows([ [ '1', 'George Washington', new Date(1789, 3, 30), new >>> Date(1797, 2, 4) ], >>> [ '2', 'John Adams', new Date(1797, 2, 4), new >>> Date(1801, 2, 4) ], >>> [ '3', 'Thomas Jefferson', new Date(1801, 2, 4), new >>> Date(1809, 2, 4) ]]); >>> >>> I think that are the sames. >>> >>> >>> Could you help me please. >>> >>> Regards >>> >>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Google Visualization API" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at https://groups.google.com/grou >>> p/google-visualization-api. >>> To view this discussion on the web visit https://groups.google.com/d/ms >>> gid/google-visualization-api/76a0b287-320d-4c0a-aa22-349c70 >>> 78928b%40googlegroups.com >>> <https://groups.google.com/d/msgid/google-visualization-api/76a0b287-320d-4c0a-aa22-349c7078928b%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >> [email protected] 5CC, Cambridge MA >> > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to google-visualization-api@ > googlegroups.com. > Visit this group at https://groups.google.com/ > group/google-visualization-api. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/google-visualization-api/aa86514f-6ae7-4868-8a2a- > 79ecdc98a6fc%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/aa86514f-6ae7-4868-8a2a-79ecdc98a6fc%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge MA -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJP%2B8e%3Df4zQkG-ih%2Bvtusmmog4atu_YPMAjk2%2BuH2yg-8A%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
