₦airaland Forum

Mrng fellow webmaster, am currently building which has to do with upload excel file and insert the data into my database. Am using this script PHPExcel, I can display the excel cells on my page but am having problem inserting the cells into the database. Any help please on how to go about inserting the cells into my database

If you follow the example shown here http://dhtmlhub.com/blogs/15
You should be able to get your excel data as an array. The next issue is how to now parse the array into your database. We need to know the particular problem you are having. I somehow believe it has to do with working with arrays.

Thanks, where am having problem is inserting the array into my database and controlling the order of insertion

You cannever insert an array into your database, you create sql queries for the items while looping through the array.

within the loop I ran d insert query like this:
mysql_query ("insert into table values('$val[1]', '$val[2]')";

You need to first say

echo '<pre>';
print_r($val);
die();

so that you can get all the fields first, and then you will know what you need to insert, maybe it is:

mysql_query ("insert into table values('$val[3]', '$val[7]') " ;

CREATE DATABASE db_name
CREATE TABLE
then create your records
use the INSERT INTO to fill you table.
take an sql lesson @ w3schools.com

and if you need further help, call 08133884165/ mail segzy54@gmail.com

dwebdesign: CREATE DATABASE db_name
CREATE TABLE
then create your records
use the INSERT INTO to fill you table.
take an sql lesson @ w3schools.com

its not that I can't insert into a database but am having problem reading excel cells and insert it into a database.

^^Abi o, that is another way.

Thanks guys, have got it working using phpexcelreader

You are welcome bro.