title: How to store each line of a multi-line text into mysql individually
body: <p>I am a beginner to php and mysql ,so bear with me if my question sounds dumb.</p>
  <p>I have a multi-line text and I need to store each line of that into a row of my table in mysql. I should mention that each line's string is separated by comma (&quot;,&quot;) as delimiter.</p>
  <p>Suppose that I have the following text:</p>
  <blockquote>
  <p>title1,name1,url1,number1</p>
  <p>title2,name2,url2,number2</p>
  <p>title3,name3,url3,number3</p>
  </blockquote>
  <p>I am not sure if I need to use</p>
  <p><code>$lines=explode(&quot;\n&quot;,$mytext)</code></p>
  <p>to explode the multi-line text because it would give me an array of lines and I do not know how to split each line to separate string variables and insert them into a table row.</p>
  <p>Any help would be much appreciated.</p>