title: How do I use regex to insert srt files into mysql?
body: <p>I have a directory of SRT files, formated:</p>
  
  <pre><code>8
  00:00:45,879 --&gt; 00:00:50,680
  - Oh! Just leave me in the car with the window open a crack.
  - That's the plan.
  
  9
  00:00:50,784 --&gt; 00:00:54,117
  I think it's nice we're doing something
  Maggie will enjoy for once.
  
  10
  00:00:54,220 --&gt; 00:00:58,350
  Besides, I'm sure Storytown Village
  is also fun for everyone...
  </code></pre>
  
  <p>I'm trying to get certain values into a MySQL database but am completely stumped on how to do that with a regex and php.</p>
  
  <p>I'd like to put the first time (i.e. 00:00:50) into "time" and any lines of text associated with that time into "text".</p>
  
  <p>I'm not even 100% sure regex is the way to go, if there's an easier way to do this?</p>