<div>
<div class="content wysiwyg-content">
I am trying to devise a script that will open and read a text file and create a separate MySQL row for content separated by two carriage returns<br />
<br />
For example the following text file would create three MySQL rows:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;hello<br />
&nbsp; &nbsp; &nbsp; &nbsp;my name is fred<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;more random stuff<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;even more<br />
&nbsp; &nbsp; &nbsp; &nbsp;bananas and whatnot<br />
<br />
The source text file contains some 18k words.<br />
<br />
Is this possible?
</div>
</div>


I am trying to devise a script that will open and read a text file and create a separate MySQL row for content separated by two carriage returns

For example the following text file would create three MySQL rows:

       hello
       my name is fred

       more random stuff

       even more
       bananas and whatnot

The source text file contains some 18k words.

Is this possible?

Populate MySQL table with dissected text file?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.