Skip to content
View in the app

A better way to browse. Learn more.

Web Designer Forum

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

JohnF

Members
  • Joined

  • Last visited

  1.    JohnF reacted to a post in a topic: Google charts with PHP & MYSQL not displayed
  2. 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>
  3. 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 than no chart is working Even if error in other charts is generated no charts work. I have attached the file for reference Please Help . AdminCharts.php
  4. Yes.. Now its working fine..... Thanks Everyone
  5. Is it saying that the file is too big to upload
  6. In my php.ini i have written the below lines: ; Maximum allowed size for uploaded files. upload_max_filesize = 40M ; Must be greater than or equal to upload_max_filesize post_max_size = 40M BUt still cant upload files greater than 1 MB Please download the zip file and see whether changes to be done are in the code....
  7. I have to upload excel file's data t0 MySQL database using php I have found the code for that but i am unable to upload large files. Can Anyone Please tell me that how can i increase the max file size limit for the code below. I have also attached the source files. <?php include 'db.php'; include 'Excel/reader.php'; function uploadFile($fieldName, $fileType, $folderName, $name = "") { $flg = 0; $MaxID = ""; $ext = ""; $uploadfile = ""; if (isset($fieldName) AND $fieldName['name'] != '') { $flg = 1; $allowed_filetypes = $fileType; //I want to increase the Max File Size.... I Tried increasing the below value but it had no effect. $max_filesize = 1048576; $filename = $fieldName['name']; if ($name == "") $MaxID = time() . time() . rand(1, 100); else $MaxID = $name; $ext = substr($filename, strpos($filename, '.'), strlen($filename) - 1); if($ext==".xlsx") $ext=".xls"; if (!in_array($ext, $allowed_filetypes)) echo "<h1>The file you attempted to upload is not allowed...</h1>"; else if (filesize($fieldName['tmp_name']) > $max_filesize) echo "<h1>The file you attempted to upload is too large...</h1>"; else { $uploadfile = $folderName . "/" . $MaxID . $ext; if (move_uploaded_file($fieldName['tmp_name'], $uploadfile) == FALSE) { echo "<h1>Error in Uploading File...</h1>"; $MaxID = ""; } else $MaxID = $MaxID . $ext; } } return $MaxID; } if(isset($_POST['submit'])) { if($_FILES['csvFile']['name']!="") { $fileName=uploadFile($_FILES['excelFile'],array(".csv"),"excel_file"); $row=0; if(($handle = fopen("excel/".$fileName , "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $num = count($data); //print_r($data); $query="INSERT INTO StudentData(FirstName,LastName,MobileNo,City)VALUES('".$data[0]."','".$data[1]."','".$data[2]."','".$data[3]."')"; mysql_query($query); } fclose($handle); } } else if($_FILES['excelFile']['name']!="") { $fileName=uploadFile($_FILES['excelFile'],array(".xls",".xlsx"),"excel_file"); $data = new Spreadsheet_Excel_Reader(); $data->read('excel_file/'.$fileName); for($i=1;$i<=$data->sheets[0]['numRows'];$i++) { $firstname=$data->sheets[0]['cells'][$i][1]; $lastname=$data->sheets[0]['cells'][$i][2]; $mobile=$data->sheets[0]['cells'][$i][3]; $city=$data->sheets[0]['cells'][$i][4]; $query="INSERT INTO StudentData(FirstName,LastName,MobileNo,City)VALUES('".$firstname."','".$lastname."','".$mobile."','".$city."')"; mysql_query($query); } } } if(isset($_POST['delete'])) { mysql_query("DELETE FROM StudentData"); } ?> excelToSql.zip
  8.    JohnF reacted to a post in a topic: How to Import Excel Data To MySQL Using PHP
  9. Thanks a lot...Your idea worked..according to my requirement.
  10.    JohnF reacted to a post in a topic: Need help passing hidden form field (PHP)
  11. Totally agree with webdesigner93.. Very Helpful..for debugging.
  12. When i changed $rollno!=$rows['RollNo'] to 0 != 1 it does enter the if block it means my rollno and rows['RollNo'] are always the same. But i am confused that how do i check for the existing roll no and new roll no? if existing rollno:- update query if new roll no:- insert query HOW?....If anybody can tell.... Please
  13. According to me you must change the sequence of variables. You must check whether the mail is sent successfully or not. For that you can add the below code. if(!mail($to, $subject, $message, $name)){ die("Error Sending email"); }else{ die('Email sent!'); }
  14. Yup... I did it. But there is no error.. there is some logical flaw... i am unable to trace it out
  15. i am not geting errors while executing... but the code is going wrong somewhere... It is not inserting the new records from the same excel file. It updates the records perfectly. I Want to inser the new records from same excel file to the database
  16. Hi, Can anyone tell me: I have to upload the excel file and put all its data in database, but the condition is that if any of the records are existing already in the database i have to fire an update query. else fire an insert query for new records. I am comparing the Roll No from database with Roll No from excel . It works fine with the existing data i.e It Updates all the existing . But it is not inserting the new data. Please check the code from :else if($num_rows>0) Please Help Me. Below is the code: if($_FILES['excelFile']['name']!="") { $fileName=uploadFile($_FILES['excelFile'],array(".xls",".xlsx"),"excel_file"); $data = new Spreadsheet_Excel_Reader(); $data->read('excel_file/'.$fileName); $ans=mysql_query("SELECT * FROM StudentData"); $num_rows = mysql_num_rows($ans); for($i=1;$i<=$data->sheets[0]['numRows'];$i++) { $rollno=$data->sheets[0]['cells'][$i][1]; $firstname=$data->sheets[0]['cells'][$i][2]; $lastname=$data->sheets[0]['cells'][$i][3]; $mobile=$data->sheets[0]['cells'][$i][4]; $city=$data->sheets[0]['cells'][$i][5]; if($num_rows<=0) { echo('Inserting : '.$rollno); $query="INSERT INTO StudentData(RollNo,FirstName,LastName,MobileNo,City)VALUES ('".$rollno."','".$firstname."','".$lastname."','".$mobile."','".$city."')"; mysql_query($query); } else if($num_rows>0) { while($rows=mysql_fetch_array($ans)) { if($rollno!=$rows['RollNo']) { echo('<p style="color:green">Inserting : '.$rollno.'</p>'); $query="INSERT INTO StudentData(RollNo,FirstName,LastName, MobileNo,City)VALUES('".$rollno."','".$firstname."','".$lastname."','".$mobile."','".$city."')"; mysql_query($query); mysql_error(); break; } else { echo('<p style="color:red">Updating Roll:'.$rollno.'and DBR:'.$rows['RollNo'].'</p>'); $query="UPDATE StudentData SET FirstName='".$firstname."',LastName='".$lastname."', MobileNo='".$mobile."',City='".$city."' WHERE RollNo='".$rollno."'"; mysql_query($query); break; } } } } }

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.