Sorry for that mouthful of a subject, but that's what I need to do! I'm not quite a PHP programmer, as this is my first real go at it, but I do know Java and JSP. In fact, I wrote Java code that does exactly what I need. Problems are, you can't execute a Java class via a browser and my web host won't take my WAR file, so I can't execute my own JSPs on my site. I figure PHP can do it, but I don't know where to start.

A little about the text file: it is not a CSV file, nor is it delimited by anything other than two spaces. If there is a negative value, it is cut to one space. (Here is a good breakdown of one of the files: http://ehm.fhockey.com/playersehm%20101.htm) And this is only on certain lines. I have five of them (for now) that I need to parse and insert into my SQL database on my server. For the most part, I understand how to acquire that data via PHP, but I'm not quite sure on the parsing and inserting part.

Can anyone help me out? I've attached my Java code and an example of one of the files I need parsed. (n.b. I was connecting a local Derby server via Netbeans... I'm now looking to go through a mySQL server)

Thanks!
Chester

http://www.webdevelopersnotes.com/tu...ql_tables.php3

look at that maybe that will get you started

Originally Posted by goheadtry

http://www.webdevelopersnotes.com/tu...ql_tables.php3

look at that maybe that will get you started

I've got the SQL part down. That Java code I posted can insert my data into my SQL database after parsing. I just need to know how I can set up something in PHP to correctly parse my text files so I can insert them into my SQL database.

Take a look at this:

http://hr.php.net/manual/en/function.file.php

and then this

http://hr.php.net/manual/en/function.explode.php

Hope this helped you, if so... talkupatin++

Cheers!

Those will do the trick. Turns out iterating through my file isn't as bad as I thought without knowing the language. It's similar to Java, with just some new structures on how to write code. I just tested part of my new PHP script, and it successfully did what I told it to: parse the file, insert into SQL database, enjoy. Thanks guys!