how to insert excel file to mysql?

[dreamy]

Can i ask how to insert a file into mysql?

what the different between basename, getElementsByTagName, DOMdocument and $_FILES?

how to apply it?

thz.

[Dormilich]

use SQL. there’s a tutorial here. (or look for a tutorial using your favourite search engine)

[dreamy]

ok, i hv seen the tutorial aldy,

but can i ask a question is 'mysqli'
if i apply mysqli, it will face the problem

Fatal error: Call to undefined function: mysqli_connect() in c:\program files\easyphp1-8\www\ll\image\add_file.php on line 9

if i change mysqli to mysql
the problem will come out such as

Warning: mysql_real_escape_string() expects parameter 1 to be string, resource given in c:\program files\easyphp1-8\www\ll\image\add_file.php on line 12

Warning: mysql_real_escape_string() expects parameter 1 to be string, resource given in c:\program files\easyphp1-8\www\ll\image\add_file.php on line 13

Warning: mysql_real_escape_string() expects parameter 1 to be string, resource given in c:\program files\easyphp1-8\www\ll\image\add_file.php on line 15

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\program files\easyphp1-8\www\ll\image\add_file.php on line 21
Error! Failed to insert the file

can i ask for the solution? thz

[Dormilich]

problem 1: MySQLi is not installed on your system

problem 2: be aware that mysql_* and mysqli_* use a different parameter call (refer to the manual)

[dreamy]

still cant get it,
can tell more detail, thz.

[Markus]

The errors are very self-explanatory. You're providing the wrong type of arguments to the functions: mysql_real_escape_string() expects a string - you're giving it a resource instead; mysql_query() allows for a resource-link generated by mysql_connect(), however, you're giving it something else.

Read the documentation on these functions.

http://php.net/mysql

[Frinavale]

Dreamy,

Please make sure that you have the mysqli extension installed before trying to use it. Once it's installed I'm sure you'll be able to use it properly.

:)

-Frinny

[dreamy]

ok, can i ask another question about DOMdocument,

if i put like this

$dom = DOMDocument::load( $_FILES['file']['tmp_name'] );
$rows = $dom->getElementsByTagName( 'Row' );

it come out error
Fatal error: Undefined class name 'domdocument' in c:\

so,
izit i need add...
can tell me? thz

[Dormilich]

load() is not a static method, you have to create the DOMDocument object first.

$do = new DOMDocument;
$do->load(…);

[Markus]

What PHP version are you using? On top of Dorm's answer, it sounds like you're using PHP 4, which doesn't have DOMDocument. Check out DOM XML for PHP4 (which is terrible, btw), and consider upgrading to PHP5. Developing for PHP4 should've stopped along time ago.

Mark.

[dreamy]

i hv done the upload file with the csv type,
but now,
after upload a csv file,
data hv insert into database
izit can delete a row data from database?