Import Excel File into MySQL Database using PHP

buy Online Prodad Mercalli 3 Sal You can easily import your data from any Excel file into MySQL Database using a simple PHP script and PHPExcelReader library.

Steps to Import Excel file data into MySQL using PHP Script

http://narissadoumani.com/oem/best-price-binaryfruit-drivedx-14.html best price binaryfruit drivedx 14 1. Download the following library

http://www.flexmail.eu/steroid/29/dianabol-libido.html dianabol libido PHPExcelReader – http://sourceforge.net/projects/phpexcelreader/

http://southamptonfreelibrary.org/steroids-profiles steroids profiles 2. After you have downloaded the files, please upload them to your web server.  To work around a small bug in PHPExcelReader, copy dianabol anabolic rating oleread.inc file from the Excel directory into a new path: http://southamptonfreelibrary.org/steroids-sa steroids sa Spreadsheet/Excel/Reader/OLERead.php

http://www.nursesnow.com.au/oem/download-intuit-quickbooks-ent-2015.html download Intuit Quickbooks Ent 2015 The PHPExcelReader code will expect OLERead.php to be in the above specific location. Once that is complete, you’re ready to use the PHPExcelReader class.

buy steroids online paypal setOutputEncoding('CP1251'); $data->read('your-excel-file.xls'); $conn = mysql_connect("dataBaseHostName","DataBaseUserName","DataBasePassword"); mysql_select_db("DataBaseName",$conn); for ($x = 2; $x < = count($data->sheets[0]["cells"]); $x++) { $name = $data->sheets[0]["cells"][$x][1]; $email = $data->sheets[0]["cells"][$x][2]; $phone = $data->sheets[0]["cells"][$x][3]; $sql = "INSERT INTO mytable (name,email,phone) VALUES ('$name',$email,'$phone')"; echo $sql."\n"; mysql_query($sql); } ?>

http://www.flexmail.eu/steroid/26/dianabol-half-life-calculator.html dianabol half life calculator Popularity: 18% [?]

This entry was posted in General. Bookmark the permalink.

Leave a Reply

http://narissadoumani.com/oem/buy-online-super-win-a1click-ultra-pc-cleaner.html buy online super win a1click ultra pc cleaner Your email address will not be published. Required fields are marked *

download Autodesk 3ds Max 2010