[SOLVED] PHP File

[sam06]

Simple really, but not sure how I would do it.

 

I have a text file of numbers, seperated on a new line.

 

I plan to move all these into a mysql database- how would I do this?

 

I assume it would be a loop, and then the php file code would gather the line of data, to a variable. Than a mysql query would post this to the database, and this all would be looped.

 

Any help on the php file split bit?

 

Cheers,

Sam

[DeanWhitehouse]

Give an example of how the numbers are stored.

[trq]

<?php

  foreach (file('yourtextfile.txt') as $number) {
    $number = mysql_real_escape_string($number);
    $sql = "INSERT INTO tablename (fieldname) VALUES ($number);";
    if (mysql_query($sql)) {
      echo "$number inserted successfully<br />";
    }
  }

?>

[sam06]

Thats brilliant, sorry for the late reply.

 

Many thanks,

Sam