import excel data to database

makana

hey can any1 help me out n mail me the sample code of how to import the excel data n store it in database i need it urgetly thanks

tron00

Open your file in excel and save it as a comma separated text file. Then use the following code:

[pre]
$dbHost = "your_db_host";
$dbName = "your_db_name";
$dbUser = "your_username";
$dbPass = "your_password";

// DB connect
function dbConnect() {
global $dbHost, $dbUser, $dbPass, $dbName;
mysql_pconnect("$dbHost", "$dbUser", "$dbPass")
or die("Error1: Sorry, a connection to the database could not be made. Please try again later.");
mysql_select_db("$dbName")
or die("Error2: Sorry, unable to select database $dbName. Please try again later.");
}
dbConnect();

$fcontents = file ('your_file.txt');

for($i=0; $i<sizeof($fcontents); $i++) {
$line = trim($fcontents[$i]);
$arr = explode("\t", $line);
$sql = "insert into users values ('". implode("','", $arr) ."')";
mysql_query($sql);

echo $sql ."<br>\n";
if(mysql_error()) {
	echo mysql_error() ."<br>\n";
}

}
[/pre]

makana

thanks a lot for ur reply i'll c to tat it works else i'll post the quey again thanks again

makana

hiii the above code only works with text file i want to import the excel sheet to database can u plss help me out

tron00

In the following line in the code:

$sql = "insert into users values ('". implode("','", $arr) ."')";

make sure to substitute "users" with the table that you want to put your data into. Also, be sure that the fields in your database matches the data in your excel file. Good luck

tron00

makana wrote:
hiii the above code only works with text file i want to import the excel sheet to database can u plss help me out

Yes, you must open your file in excel and save it as a .txt file comma delimited. It is one of the options when you go to "file > save as".

makana

i did try tat way too bt isn't woking hmmmm wot to do now