how can we parse excel sheet and insert its values into mysql database table using php?
indoreankita
0
Newbie Poster
Recommended Answers
Jump to Posthow can we parse excel sheet and insert its values into mysql database table using php?
$filename=$_FILES['imp']['tmp_name']; $handle = fopen("$filename", "r"); $i=0; while (($data = fgetcsv($handle, 1000, "\t")) !== FALSE) { $proid = $data[0]; $proname = addslashes($data[1]); $dblquotpara = '"'."\r\n"; // double quote+CR+LF $sglquotpara = "'"."\r\n"; // …
All 8 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
rajabhaskar525
1
Junior Poster
muralibobby2015
17
Posting Pro
rajabhaskar525
1
Junior Poster
muralibobby2015
17
Posting Pro
indoreankita
0
Newbie Poster
rajabhaskar525
1
Junior Poster
crohole
0
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.