User Profile

Sanitprof · Dec 31 '13, 05:09 AM

thanks for ur willingness. i really appreciate u.

file is getting uploaded but not storing into db. so at line 26 i added if..else to check whether query is executing or not, then it returns 'Query was empty'.

i was on search, then i found these code, it solved my problem.
http://coyotelab.org/php/upload-csv-...-phpmysql.html

thanks....

Sanitprof · Dec 30 '13, 04:59 AM

Look out these sample codes Luuk and zmbd

html code to set upload

Code:

<div id="mainbody">
    <form method="post" action="e2.php" enctype="multipart/form-data">
        <input type="file" name="file" /> <br />
        <input type="submit" name="submit" value="Submit" />

...

Sanitprof · Dec 28 '13, 08:58 AM

yea phpmyadmin is a server tool to access and manage the db's on mysql servers. thanks for correcting me:)

in that link, by manually importing/exporting of excel data into mysql., such things has given.

what i required is that at by run time excel file has to uploaded and stored into database. check out my attachment, the sample format that to be stored.

to Mukesh : i've seen something about php_excel_reade r,...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

how to upload excel file and its data to be stored into phpmyadmin