Converting Cutenews to Mysql

[timsweb]

Hey,

Ok, basically i want to convert all my news from cutenews in to a mysql database, if you didnt know cutenews is stored in a txt file called news.txt,

I was just looking at it, and its layed out like this:

unixtime|username|title|shortstory|longstory||||

So, first is the unix time, then | then username who submitted it, then |, then news title, then |, then short story, then |, then longstory, and then each article is seperated by ||||,

Now, how do i get it to explode them, and then put each one as a variable?

i.e. what is the code to explode it, and then make each one a variable? i.e unixtime, username etc.?

Thanks, Tim

[dnast]

If you're using PHP...

You said it yourself - explode()

There are examples on the link. The function returns an array, but you can just assign its values to other variables if you wish.

You'll also want to look at some of the filesystem functions

[LAD]

Or just go thru their code and see how they split them apart, but instead of displaying it, you insert it in the dbase. Voila!

[Echilon]

Once you've read the text file, you can use explode("|",$values), then insert them into a database, and use mysql_fetch_array to read them from the DB. I'd recommend wordpress though, it uses MySQL and has loads of features.

[matt74441]

Well considering you have little knowledge of PHP, I would suggest that you just find yourself a ready made news script that uses a mySQL database and just insert all of your news into it. By looking at your site you don't have to worry about the comments, or lack thereof.