*SOLVED* I had to add: array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")
to my new PDO. Il giorno martedì 21 maggio 2019 16:35:19 UTC+2, drigo ha scritto: > > Hi everybody, > > I am getting an odd behavior when I am trying to display a string column, > called "Series Name", through a google table chart > <https://developers.google.com/chart/interactive/docs/gallery/table>. > > You can find my php code below. Please note that if I drop the column > "Series Name" everything works fine. Otherwise, the output table > displays only the first 5 rows. Specifically, leaving the mentioned column > if I set LIMIT >= 5 no table chart is created. > > Let me stress that this issue appears on a new VPS where php and mysql db > have been installed. Same code works on my old VPS as expected. > > Any ideas how to overcome this issue? > > Thanks in advance, > > Drigo > > > <?php > > try { > /* Establish the database connection */ > $conn = new PDO("mysql:host=localhost;dbname=$dbname", $username, > $password); > $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); > > /* select relevant info for table googlechart */ > $result_RTI_VS_W_TABLE = $conn->query("SELECT * FROM > `video_series_rank_week` ORDER BY `Year` DESC, `WeekN` DESC, `Rank` ASC LIMIT > 15"); > > $rows_RTI_VS_W_TABLE = array(); > $table_RTI_VS_W_TABLE = array(); > $table_RTI_VS_W_TABLE['cols'] = array( > > /* Labels for your chart, these represent the column titles */ > array('label' => 'Rank', 'type' => 'number'), > array('label' => 'Year', 'type' => 'string'), > array('label' => 'WeekN', 'type' => 'number'), > array('label' => 'Series Name', 'type' => 'string'), > array('label' => 'Total Historical Constrained Ad Avails', 'type' => > 'number') > ); > /* Extract the information from $result */ > foreach($result_RTI_VS_W_TABLE as $r_RTI_VS_W_TABLE) { > > $temp_RTI_VS_W_TABLE = array(); > > /* the following line will be used to get a table */ > $temp_RTI_VS_W_TABLE[] = array('v' => (int) > $r_RTI_VS_W_TABLE['Rank']); > > /* Values */ > $temp_RTI_VS_W_TABLE[] = array('v' => (string) > $r_RTI_VS_W_TABLE['Year']); > $temp_RTI_VS_W_TABLE[] = array('v' => (int) > $r_RTI_VS_W_TABLE['WeekN']); > $temp_RTI_VS_W_TABLE[] = array('v' => (string) > $r_RTI_VS_W_TABLE['Series Name']); > $temp_RTI_VS_W_TABLE[] = array('v' => (int) $r_RTI_VS_W_TABLE['Total > Historical Constrained Ad Avails']); > > $rows_RTI_VS_W_TABLE[] = array('c' => $temp_RTI_VS_W_TABLE);} > > $table_RTI_VS_W_TABLE['rows'] = $rows_RTI_VS_W_TABLE; > > /* convert data into JSON format */ > $jsonTable_RTI_VS_W_TABLE = json_encode($table_RTI_VS_W_TABLE); > } catch(PDOException $e) {echo 'ERROR: ' . $e->getMessage();} > ?> > > -- 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/083f9d4a-2f31-4a75-86b5-8dfa504fe206%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
