Read the contents of a text file into MySql using PHP

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • John Smith

    Read the contents of a text file into MySql using PHP

    Hi All,

    New to this, have the basics, can build a form and such. My problem is I
    need to be able to open a file on a pc/s on the network, read the data
    character by character, check to see if a certain character is present, if
    it is, update the database and continue reading the file until it comes
    across the character again, updates the database and so on . . . .

    Anybody got any suggestions, all help gratefuly received!!



  • Erwin Moller

    #2
    Re: Read the contents of a text file into MySql using PHP

    John Smith wrote:
    Hi All,
    >
    New to this, have the basics, can build a form and such. My problem is I
    need to be able to open a file on a pc/s on the network, read the data
    character by character, check to see if a certain character is present, if
    it is, update the database and continue reading the file until it comes
    across the character again, updates the database and so on . . . .
    >
    Anybody got any suggestions, all help gratefuly received!!
    Hi John,

    Go to www.php.net and search for:
    - fopen() and file() to open and read files (even over http)
    - substr() to get pieces out of a string.
    Or use the array-index approach:
    $myStr = "hello";
    echo $myStr[1]; // will echo e

    Regards,
    Erwin Moller

    Comment

    • John Smith

      #3
      Re: Read the contents of a text file into MySql using PHP

      Cheers, I'll give it a go.

      "Erwin Moller"
      <since_humans_r ead_this_I_am_s pammed_too_much @spamyourself.c omwrote in
      message news:45b72211$0 $335$e4fe514c@n ews.xs4all.nl.. .
      John Smith wrote:
      >
      >Hi All,
      >>
      >New to this, have the basics, can build a form and such. My problem is I
      >need to be able to open a file on a pc/s on the network, read the data
      >character by character, check to see if a certain character is present,
      >if
      >it is, update the database and continue reading the file until it comes
      >across the character again, updates the database and so on . . . .
      >>
      >Anybody got any suggestions, all help gratefuly received!!
      >
      Hi John,
      >
      Go to www.php.net and search for:
      - fopen() and file() to open and read files (even over http)
      - substr() to get pieces out of a string.
      Or use the array-index approach:
      $myStr = "hello";
      echo $myStr[1]; // will echo e
      >
      Regards,
      Erwin Moller

      Comment

      Working...