Newbie quistion

[jorgen_100]

Hi all,

 

Just arrived on this forum and in PHP/MySQL country.

I am having a problem, and know to little to solve this.

 

I want to put some data in a Mysql database from a large text field, but not all data which will be submitted.

this is the data what will be put in the text field, http://www.vr6blackwidow.nl/jorgen/test.txt

and i only want a few things put into the database, like rank progress, bullets and a few other things

 

I know how to make the connection and put text boxes into a database but i have no clue how to pick a few lines out the text field and add it to the database, and no idea if it is even possible.

 

Could someone push me in the right direction?

 

Cheers

Jorgen

[o3d]

You could loop through all lines in the file and find the lines you are looking for by using preg_match

 

while looping through lines you could use something similiar to:

 

while (!eof)

{

if (preg_match("/Honour points/i", $CurrentFileLine)) {

  //match was found

  //do character handling (explode or somtin) to store the value after the Honour points e.g.

  $Value = substr($CurrentFileLine, strpos($CurrentFileLine, "Honour points")+strlen("Honour points"), strlen($CurrentFileLine) - strpos($CurrentFileLine, "Honour points")+strlen("Honour points");

}

}

 

Hope this helps.

[jorgen_100]

Thanks for the Reply.

Seems i need to learn a lot more before i can make what i want, but requested some books at the library