June 18, 201412 yr I am using Google charts with PHP but it is not displaying the charts.I checked the page source It has all the data from database to plot the charts.Below is my code: <?php include 'dbConnect.php'; $query=mysql_query("SELECT DATE_FORMAT( DateModified, '%m-%d-%Y' ) AS Date, count( * ) AS NewBooks FROM Books GROUP BY DATE_FORMAT( DateModified, '%m-%d-%Y' )"); if (! $query){ echo 'Database error: ' . mysql_error(); } $arr1[]="['DateModified','NewBooks']"; while($res=mysql_fetch_assoc($query)) { $invDate=$res['Date']; $tot=$res['NewBooks']; $arr1[]="['".$invDate."',".$tot."]"; } $queryPie=mysql_query("SELECT Publisher, count( Title )as Titles FROM Books GROUP BY Publisher ASC "); if (! $queryPie){ echo 'Database error: ' . mysql_error(); } $arrPie[]="['Publisher','Titles']"; while($res1=mysql_fetch_assoc($queryPie)) { $pub=$res1['Publisher']; $qty=$res1['Titles']; /*echo 'Publisher : '.$pub.'<br>'; echo 'Quantity : '.$qty.'<br>';*/ $arrPie[]="['".$pub."',".$qty."]"; } mysql_select_db("northwind",$con); $queryGeo=mysql_query("SELECT country, count( * ) AS popularity FROM customers GROUP BY country ASC "); if (! $queryGeo){ echo 'Database error: ' . mysql_error(); } $arrGeo[]="['City','Popularity']"; while($resGeo=mysql_fetch_assoc($queryGeo)) { $city=$resGeo['country']; $popularity=$resGeo['popularity']; $arrGeo[]="['".$city."',".$popularity."]"; } mysql_close($con); ?> <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 drawChart() { var data = google.visualization.arrayToDataTable([ <?php echo(implode(",",$arr1));?> ]); var options = { title: 'New Arrivals' }; var chart = new google.visualization.ColumnChart(document.getElementById('chart_col')); chart.draw(data, options); var dataPie = google.visualization.arrayToDataTable([ <?php echo(implode(",",$arrPie));?> ]); var optionsPie = { title: 'Titles By Publisher', is3D:true, }; var chartPie = new google.visualization.PieChart(document.getElementById('piechart_3d')); chartPie.draw(dataPie, optionsPie); var dataGeo = google.visualization.arrayToDataTable([ <?php echo(implode(",",$arrGeo));?> ]); var optionsGeo = {}; var chartGeo = new google.visualization.GeoChart(document.getElementById('chart_geo')); chartGeo.draw(dataGeo, optionsGeo); } </script> </head> <body> <div id="chart_col" style="width: 600px; height: 500px; ;</div> <div id="piechart_3d" style="width: 475px; height: 500px; margin-top: -500px; margin-left:600px"></div> <p>Your Popularity</p><br/><br/> <div id="chart_geo" style="width: 800px; height: 800px; margin-left:80px; margin-top:-50px;"></div> </body> </html> Whenever I purposely generate error in query of Pie chart ($queryPie)the other two charts are displayed. but if every thing is perfect thanno chart is working Even if error in other charts is generated no chartswork. I have attached the file for reference Please Help . AdminCharts.php
June 18, 201412 yr Author Here is the code after running the php <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 drawChart() { var data = google.visualization.arrayToDataTable([ ['DateModified','NewBooks'],['06-17-2014',18225],['06-18-2014',18225] ]); var options = { title: 'New Arrivals' }; var chart = new google.visualization.ColumnChart(document.getElementById('chart_col')); chart.draw(data, options); var dataPie = google.visualization.arrayToDataTable([ ['Publisher','Titles'],['',244],[' PRENTICE HAL',2],['A K PETERS, LTD.',2],['A K PETERS/CRC PRESS',2],['ACADEMIC',2],['ACADEMIC PRESS',92],['ACTAR',64],['ADDISON WESLEY LONGMAN',2],['ADDISON-WESLEY',4],['ADDISON-WESLEY (AN IMPRINT OF PEARSON EDUCATION)',2],['AEG LITERARY PUB SERV INC',2],['AGRI-BIOVET PRESS',6],['AMACOM BOOKS',6],['AMER INST OF PHYSICS',42],['AMER MATHEMATICAL SOCIETY',2],['AMERICAN INST. OF PHYSICS',2],['AMERICAN INSTITUTE OF PHYSICS',2],['AMERICAN PSYCHIATRIC PUB',2],['ANAMAYA PUBLISHERS',2],['ANE BOOKS (SUPPLIER)',4],['AOAC',2],['APHA',2],['APPLE ACADEMIC PRESS',10],['APRESS',534],['APRESS/SPRINGER-VERLAG',4],['APRESSAPRESS',2],['ARCHITECTURAL PRESS',14],['ARCHIWORD',18],['ARCHIWORLD',16],['ARTECH HOUSE',56],['ASHGATE PUBLISHING LTD.',10],['ASM',4],['ASM PRESS',8],['ASTRAL INT',4],['ASTRAL INTERNATIONAL PRIVATE LIMITED,',4],['AUERBACH',16],['AUTHORHOUSE',2],['AVENTINUM, PRAGUE',2],['BAILLIERE TINDALL',2],['BARRON'S EDUCATIONAL',4],['BARRONS EDUCATIONAL SERIES INC.',2],['BENJAMIN / CUMMINGS PUBLISHING COMPANY',8],['BENJAMIN CUMMINGS',2],['BENJAMIN/CUMMINGS PUB CO',2],['BERRETT-KOEHLER PUB',2],['BH',2],['BIKHAUSER',2],['BIRKH?�USER',2],['BIRKHAEUSER�',48],['BIRKHAUSER',300],['BIRKHAUSER ARCHITECTURE',64],['BIRKHAUSER BOSTON',2],['BIRKHAUSER VERLAG',96],['BIRKHäUSER BOSTON',2],['BIRKH�USER',2],['BIRKH�USER ARCHITECTURE',12],['BIRKH�USER BASEL',22],['BIRKH�USER BOSTON',12],['BLACK DOG PUBLISHER',2],['BLACKIE ACADEMIC & PROFESSIONAL',2],['BLACKWELL PUBLISHING',4],['BLACKWELL SCIENCE',2],['BLADON MEDICAL PUB',2],['BLANCHARD AND LOEB',4],['BNA BOOKS',2],['BOOQS PUBLISHER',4],['BRAMBLE CO',2],['BRILL ACADEMIC PUB',2],['BRITANNICA',2],['BRITANNICA.CO.UK LTD',6],['BROADCAST INTERVIEW',2],['BROOKS/COLE CENGAGE LEARNING',6],['BROOKS/COLE PUB CO',2],['BROOKS/COLE PUBLISHING COMPANY',2],['BS BOOKS',4],['BS PUBLICATIONS',64],['BSC PUBLISHERS & DISTRIBUTORS',2],['BSP',36],['BSP BOOKS',16],['BSP BOOKS PVT. LTD.',44],['BUTTERWORTH HEINEMANN',28],['BUTTERWORTHS PUBLISHERS',2],['BWE',2],['C PARIX',2],['CABI',158],['CABI INTERNATIONAL',8],['CABI PUBLISHING',12],['CAMBRIDGE UNIV PR',8],['CAMBRIDGE UNIVERSITY PRESS',34],['CAMBRIDGE UNIVERSITY PRESS INDIA PVT. LTD.',28],['CBS',10],['CBS PUBLISHERS & DISTRIBUTOR PVT. LTD. (PUR)',28],['CENEAGE LEARNING',2],['CENGAGE',6],['CENGAGE INDIA',938],['CENGAGE LEARNING',446],['CHAMPMAN & HALL',8],['CHAPMAN & HALL',2],['CHAPMAN & HALL',16],['CHAPMAN & HALL/CRC',18],['CHAPMAN AND HALL/CRC',2],['CHELSEA GREEN PUB CO',2],['CHURCHILL LIVINGSTONE',70],['COLD SPRING HARBOR LABORATORY PRESS',2],['COLD SPRING HARBOUR LABORATORY PRESS',2],['COPERNICUS BOOKS',18],['COSIMO INC',2],['COURSE TECHNOLOGY',2],['COURSE TECHNOLOGY CENGAGE LEARNING',2],['COURSE TECHNOLOGY/THOMSON LEARNING',6],['CPC',38],['CRC',44],['CRC PR I LLC',2],['CRC PRES',8],['CRC PRESS',972],['CRC PRESS BOOK',2],['CRC PRESS;',2],['CRCRS',4],['CRS',2],['CSHL PRESS',2],['CSHLRS',2],['CUP',8],['CURRENT MEDICINE GROUP',8],['D. REIDEL PUB CO',20],['DAYA PUBLISHING HOUSE (SUPPLIER)',2],['DE GRUYTER',106],['DESIGN MEDIA PUBLISHING LTD.',2],['DGV',2],['DIE GESTALTEN VERLAG',2],['DK PUB',2],['DOVER',32],['DOVER PUBLICATIONS',76],['DOVER PUBLICATIONS, INC.',162],['EDICIONES UNIVERSAL',2],['EFPL PRESS',2],['EISELT MICHAEL',2],['ELSEIVER',2],['ELSEVIER',508],['ELSEVIER ACADEMIC PRESS',2],['ELSEVIER BUTTERWORTH HEINEMANN',2],['ELSEVIER HEALTH AND SCIENCE',2],['ELSEVIER INDIA',394],['ELSEVIER SCIENCE PUBLISHERS',4],['ELSEVIER/AP',2],['ENCYCLOPEDIA BRITANNICA (INDIA) PVT. LTD.',2],['ERNST & SOHN',2],['ESWAR PRESS',24],['EUREKAH.COM INC',2],['FACET PUB',12],['FACET PUBLISHING',2],['FAIRMONT PRESS',6],['FALCONGUIDES',2],['FOCAL PRESS',4],['FRIENDS OF ED',2],['FRIENDSOFED',2],['FT PRESS',2],['GARLAND',2],['GARLAND PUBLISHING',2],['GARLAND PUBLISHING INC,US',2],['GARLAND SCIENCE',4],['GARLND',2],['GORDON AND BREACH PUBLISHERS',2],['GRAHAM & TROTMAN',4],['GREEN LEAF PUBLICATION (PUB)',2],['GREENHAVEN PR',2],['GROVE PRESS',2],['GUILFORD',4],['GUILFORD PRESS',48],['GUILFORD PUBLICATION',10],['GUILFORD PUBLISHER',2],['GUILFORS PRESS',2],['GULF PROFESSIONAL PUBLISHING/AN IMPRINT OF B-H',2],['GULF PUBLISHING COMPANY',10],['HARPER COLLINS',2],['HARRY N. ABRAMS',2],['HINDUSTAN BOOK AGENCY',2],['HINDUSTAN BOOK AGENCY (INDIA)',132],['HOLT, RINEHART AND WINSTON',2],['HOUGHTON MIFFLIN HARCOURT',2],['HP',6],['HPC PUB (ELSEVIER)',2],['HUMAN KINETICS',12],['HUMAN KINETICS PUBLISHERS',2],['HUMAN KINTECIS',2],['HUMAN PRESS',2],['HUMANA',4],['HUMANA PR INC',152],['HUMANA PRESS',410],['I-MERSION LLC',2],['I.K. INTERNATIONAL PUBLISHING',6],['I.K. INTERNATIONAL PUBLISHING HOUSE PVT. LT.D',2],['I.K.INTERNATIONAL PVT. LIMITED',440],['ICE',4],['ICE PUBLIHSER',2],['ICE PUBLISHER',2],['ICE PUBLISHING',18],['IET',62],['IET PUBLISHER',16],['IK PUBLISHER',2],['IMAGES PUB.',8],['IMPERIAL COLLEGE PRESS',2],['INFORMA',2],['INFORMA HEALTHCARE',8],['INSTITUTION OF CIVIL ENGINEERS',12],['INTERCEPT LTD',2],['INTERNATIONAL PUBLISHING HOUSE',2],['INTERNATIONAL THOMSON BUSINESS PRESS',2],['INTERPHARM PRESS',2],['IOP PRESS',4],['ISLAND PR',2],['ISLAND PRESS',8],['IUNIVERSE, INC.',2],['J ROSS',2],['J. ROSS PUBLISHING',36],['JAIN BROTHERS [PUB]',10],['JAYA',2],['JAYA PUBLISHERS',4],['JAYA PUBLISHING',4],['JOHN BALE SONS & DANIELSSON LTD',2],['JOHN BANJAMINS',8],['JOHN BENJAMINS',22],['JOHN HOPKINS UNIVERSITY PRESS',20],['JOHN WIELY & SONS',2],['JOHN WILEY',1480],['JOHN WILEY & SONS',8],['JOHN WILEY & SONS INC.',2],['JOHN WILEY & SONS, INC.',2],['JOHN WILEY (WIE)',76],['JOHN WILEY BLACKWELL',2],['JOHNS HOPKINS UNIVERSITY PRESS',2],['JONES & BARTLETT',4],['JONES & BARTLETT LEARNING',6],['JONES & BARTLETT PUBLISHERS',2],['JONES AND BARTLETT',4],['JONES AND BARTLETT LEARNING',68],['JONES AND BARTLETT PUBLISHERS',36],['JONESBARTLETT',2],['JONH WILEY',4],['JWOEX',2],['JWOSPL',2],['KESSINGER PUBLISHING',2],['KEY COLLEGE PUB',2],['KLUWER',8],['KLUWER / PLENUM PUBL',8],['KLUWER ACADEMIC',2],['KLUWER ACADEMIC PRESS',52],['KLUWER ACADEMIC PRINT ON DEMAND',16],['KLUWER ACADEMIC PUB',480],['KLUWER ACADEMIC PUBLISHER',4],['KLUWER ACADEMIC PUBLISHERS',72],['KLUWER ACADEMIC PUBLISHERS, NETHERLANDS',2],['KLUWER ACADEMIC/PLENUM PUBLISHERS',38],['KLUWER LAW INTERNATIONAL',8],['KLUWER LAW INTL',22],['KLUWER THE LANGUAGE OF SCIENCE',2],['KONEMANN',2],['LANDES BIOSCIENCE',2],['LARS MULLER PUBLISHERS',6],['LARS M�LLER PUBLISHERS',2],['LAURENCE KING',2],['LAXMI PUBLICATIONS',2],['LEWIS PUBLISHERS',4],['LIPPINCOTT',4],['LIPPINCOTT - RAVEN',2],['LIPPINCOTT WILLIAMS & WILKINS',14],['LLEWELLYN WORLDWIDE LTD',2],['LONGMAN',4],['LWW',4],['LWWRS',2],['MACMILLAN',2],['MANSON PUBLISHING',6],['MANSON PUBLISHING LTD.',2],['MARCEL',2],['MARCEL DEKKAR',6],['MARCEL DEKKER',74],['MARTINUS NIJHOFF',2],['MC-GRAW HILL',2],['MCGARW HILL',2],['MCGRAW - HILL',10],['MCGRAW HILL',138],['MCGRAW-HILL',22],['MCGRAW-HILL EDUCATION',2],['MCGRAW-HILL�',4],['MCGRAWHILL�',2],['MD',16],['MEDITECH',2],['MEDTEC',30],['MEHUL BOOK SALES',2],['MERCK & CO',2],['METROBOOKS',2],['MGH ',50],['MICROSOFT PR',2],['MISC',2],['MIT PRESS',8],['MIT PRESS (MA)',2],['MITTAL PUBLICATIONS',56],['MORGAN KAUFMANN',4],['MORGAN KAUFMANN PUBLISHERS',2],['MORGAN KAUFMANN PUBLISHERS/ACADEMIC PRESS',6],['MOSBY',74],['MOSBY�',2],['NARENDRA PUBLISHING HOUSE',54],['NEHA PUBLISHERS',2],['NELSON THORNES LTD.',6],['NEW AGENCY PUBLISHING AGENCY',2],['NEW HOLLAND',2],['NEW INDIA',4],['NEW INDIA PUB. AGENCY',4],['NEW INDIA PUBLISHING',2],['NEW INDIA PUBLISHING AGENCY',30],['NEW INDIA PUBLISHING AGENCY (SUPP)',66],['NEW INDIAN PUB. AGENCY',2],['NEWNES',8],['NIA PUBLISHER',2],['NIPA',8],['NORTON & CO',2],['NORTON & COMPANY',2],['NOTTINGHAM UNIVERSITY PRESS',2],['NOVA PUBLISHERS',4],['NPH',70],['OCLC',2],['OREILLY & ASSOCIATES, INC.',2],['ORO EDITION',2],['OUP',8],['OUTSKIRTS PR',2],['OXFORD',4],['OXFORD SCIENCE PUBLICATIONS',4],['OXFORD UNIV PR',2],['OXFORD UNIVERSITY',2],['OXFORD UNIVERSITY PRESS',4],['OXFORD UNIVERSITY PRESS (OUP)',72],['OXFORD UNIVESITY PRESS',2],['PALGRAVE',6],['PAN STANFORD PUBLISHING',14],['PARRAGON BOOKS',4],['PEA',6],['PEACHPIT PR',2],['PEACHPIT PRESS',2],['PEARSON',2630],['PEARSON COLLEGE DIV',2],['PEARSON CUSTOM PUBLISHING',2],['PEARSON EDUCATION',948],['PEARSON EDUCATION (HIGHER)',2],['PEARSON EDUCATION ASIA',2],['PEARSON EDUCATION LTD.',8],['PEARSON INDIA',2],['PEER INFORMATION',2],['PESARO',2],['PETERSONS',2],['PHARMA BOOK SYNDICATE',14],['PHARMAMED PRESS',26],['PHI',1528],['PHI LEARNING',2],['PHYSICA-VERLAG',54],['PHYSICA-VERLAG HD',2],['PHYSICA-VERLAG HEIDELBERG',2],['PLENUM PRESS',58],['PLENUM PUB CORP',340],['PLENUM PUBLISHERS',18],['PLENUM PUBLISHING CORPORATION',10],['PMP',2],['POGUE PRESS',2],['PRASHANT BOOK AGENCY (SUPPLIER)',4],['PRAXIS',4],['PRAXIS PUBLISHING',2],['PRENTICE HALL',86],['PRENTICE HALL OF INDIA',2],['PRENTICE HALL PRESS',2],['PRENTICE-HALL',2],['PRESTEL PUBLISHING',2],['PRODUCTIVITY PRESS',14],['PSYCHOLOGY PRESS',2],['R.G. LANDES CO',2],['RANDALL',4],['REGAN BOOKS',2],['REPUBLIC OF TEXAS',2],['RESPONSE BOOKS',6],['RIBA PUBLISHING',2],['RIVER PUBLISHERS',2],['RIZZOLI PUBLISHER',2],['ROCKPORT',2],['ROUTLEDGE',124],['ROUTLEDGE (TAYLOR & FRANCIS)',2],['ROYAL HORTICULTURAL SOCIETY',2],['ROYAL SOCIETY',36],['ROYAL SOCIETY OF CHEMISTR',2],['ROYAL SOCIETY OF CHEMISTRY',330],['ROYAL SOCIETY OF MEDICINE PR LTD',12],['RSC PUBLISHING',34],['SAGE',80],['SAGE PUBLICATIONS',2],['SAGE PUBLICATIONS INDIA PVT. LTD.',74],['SAGE PUBLICATIONS, INC.',8],['SAGE PUBLISHER',250],['SAMS',2],['SATISH SERIAL PUBLISHING HOUSE',10],['SAUNDER',2],['SAUNDER ELSEVIER',2],['SAUNDERS',178],['SAUNDERS / AN IMPRINT OF ELSEVIER',70],['SAUNDERS�',6],['SCHLUTERSCHE',2],['SCI TECH PUBLISHING',2],['SCI TECH PUBLISHING LLC',10],['SCIENCE PUBLISHERS, INC.',10],['SCIENTIFIC INTERNATIONAL',2],['SCIENTIFIC INTERNATIONAL PVT. LTD.',8],['SCITECH',2],['SCITECH PUBLICATIONS (INDIA)',2],['SCITECH PUBLISHING',6],['SCITECH PUBLISHING/IET',2],['SCRIBNER',2],['SHANKAR'S BOOK AGENCY',2],['SHANKAR'S BOOK AGENCY PVT. LTD.',2],['SIMON SPOTLIGHT/NICKELODEON',2],['SINAUER ASSOCIATES, INC.',22],['SKYHORSE PUB CO INC',2],['SOUTH-WESTERN /CEGAGE LEARNING',2],['SOUTH-WESTERN COLLEGE',2],['SOUTH-WESTERN COLLEGE PUB/THOMSON LEARNING',8],['SOUTHERN BOOK STAR (SUPP)',4],['SPEKTRUM AKADEMISCHER VERLAG GMBH',16],['SPIRINGER',2],['SPIRNGER',2],['SPON PRESS',10],['SPR',62],['SPRIINGER',4],['SPRIMGER',2],['SPRING',36],['SPRINGER',8630],['SPRINGER (SIE)',240],['SPRINGER FRANCE EDITIONS',6],['SPRINGER LONDON LTD',2],['SPRINGER PUB CO',22],['SPRINGER SCIENCE + BUSINESS MEDIA, INC.',2],['SPRINGER SCIENCE GROUP',2],['SPRINGER VERLAG',6],['SPRINGER VERLAG WIEN',56],['SPRINGER VIENNA ARCHITECT',2],['SPRINGER VIENNA ARCHITECTURE',54],['SPRINGER WIEN NEW YORK',2],['SPRINGER-VERLAG',3050],['SPRINGER-VERLAG BERLIN AND HEIDELBERG GMBH & CO. K,',2],['SPRINGER-VERLAG NEW YORK INC',1798],['SPRINGER.COM',18],['SPRINGER/LANDES BIOSCIENCE',2],['SPRINGERS',2],['SRPINGER',2],['STANLEY THORNES',2],['STEINKOPFF DARMSTADT',8],['STUDIUM PRESS',6],['STUDIUM PRESS (INDIA) PVT.LTD.',2],['SYNGRESS',2],['S[PRINGER',2],['T&F',50],['T.M.C. ASSER INSTITUUT',10],['T/F INDIA',10],['TALOR & FRANCIS',2],['TATA MCGRAH HILL',8],['TATA MCGRAW - HILL',2],['TATA MCGRAW HILL',2],['TATA MCGRAW-HILL',292],['TATA MCGRAW-HILL PUB. CO. LTD.',4],['TAYLOR $ FRANCIS',2],['TAYLOR & FRANCIS',952],['TAYLOR & FRANCIS BOOKS INDIA PVT. LTD.',2],['TAYLOR AND FRANCIS ',688],['TAYLOR AND FRANCIS (CRC)',2],['TBH',2],['TBH PUBLISHERS & DISTRIBUTERS',38],['TBH PUBLISHERS AND DISTRIBUTERS',16],['TBS',2],['TECHNOMIC PUBLISHING CO, INC',2],['TELOS PR',4],['TERI',28],['TERI PRESS',62],['TF',2],['THAMES AND HUDSON',2],['THE INSTITUTION OF ENGINEERING AND TECHNOLOGY',4],['THE MIT PRESS',2],['THOMAS TELFORD',4],['THOMPSON BOOK COMPANY',2],['THOMSON LEARNING',4],['TMH',10],['UKAAZ',16],['UKAAZ PUBLICATIONS',30],['UMBRAGE EDITIONS INC',2],['UNIVERSITIES PRESS',104],['UNIVERSITY SCIENCE BOOKS',4],['VAN NOSTRAND REINHOLD',6],['VCH PUB',2],['VERLAG FORM',2],['VIEWEG + TEUBNER VERLAG',4],['VIV',6],['VIVA',6],['VIVA BOOKS',4],['VIVA BOOKS PRIVATE LIMITED',2],['VSP',2],['W W NORTON & COMPANY',2],['W.B. SAUNDERS COMPANY',2],['WADSWORTH',24],['WAGENINGEN',8],['WATERMARK PRESS',2],['WAVELAND',4],['WILEY',410],['WILEY - BLACKWELL',8],['WILEY - BLACKWELL',2],['WILEY BLACK WELL',2],['WILEY INDIA',328],['WILEY INDIA PVT LTD',2],['WILEY PUBLISHING, INC.',36],['WILEY VCH',2],['WILEY-BLACEWELL',2],['WILEY-BLACKWEL',4],['WILEY-BLACKWELL',94],['WILEY-IEEE',12],['WILEY-IEEE PRESS',10],['WILEY-INTERSCIENCE',2],['WILEY-ISTE',32],['WILEY-VCH',44],['WILLAN',2],['WOOD HEAD',2],['WOODHEAD',10],['WOODHEAD PUB',4],['WOODHEAD PUBLISHER',20],['WOODHEAD PUBLISHING',8],['WOODHEAD PUBLISHING INDIA PVT. LTD.',48],['WOODHEAD PUBLISHING LIMITED',338],['WOODHEAD PUBLISHING LTD',10],['WORDWARE',2],['WORLD BANK',2],['WORLD SCIENTIFIC',8],['WORLD SCIENTIFIC PUB CO INC',10],['WP',16],['YALE UNIVERSITY PRESS',2],['YES DEE PUBLISHING',2],['YESDEE',30],['�ELSEVIER',2] ]); var optionsPie = { title: 'Titles By Publisher', is3D:true, }; var chartPie = new google.visualization.PieChart(document.getElementById('piechart_3d')); chartPie.draw(dataPie, optionsPie); var dataGeo = google.visualization.arrayToDataTable([ ['City','Popularity'],['',2],['Argentina',3],['Austria',2],['Belgium',2],['Brazil',9],['Canada',3],['Denmark',2],['Finland',2],['France',11],['Germany',11],['Ireland',1],['Italy',3],['Mexico',5],['Norway',1],['Poland',1],['Portugal',2],['Spain',5],['Sweden',2],['Switzerland',2],['UK',7],['USA',13],['Venezuela',4] ]); var optionsGeo = {}; var chartGeo = new google.visualization.GeoChart(document.getElementById('chart_geo')); chartGeo.draw(dataGeo, optionsGeo); } </script> </head> <body> <div id="chart_col" style="width: 600px; height: 500px; ;</div> <div id="piechart_3d" style="width: 475px; height: 500px; margin-top: -500px; margin-left:600px"></div> <p>Your Popularity</p><br/><br/> <div id="chart_geo" style="width: 800px; height: 800px; margin-left:80px; margin-top:-50px;"></div> </body> </html>
June 18, 201412 yr Your issue is the "BARRON'S EDUCATIONAL" record in your database or any record within the database that contains a single quote. You could remove this quote or escape it like this Replace: $arrPie[]="['".$pub."',".$qty."]";With: $arrPie[]="['".addslashes($pub)."',".$qty."]";
June 18, 201412 yr No problem, glad i could help It may be worth you using json_encode rather then implode that way it does all the escaping for you Edited June 18, 201412 yr by D4Y0
Create an account or sign in to comment