title: Mysqli multiple row insert, simple multi insert query
body: <p>How do I insert this query with mysqli?...</p>
  
  <pre><code>INSERT INTO table (field1, field2, field3) VALUES ('value', 'value', 'value'), ('value', 'value', 'value'), ('value', 'value', 'value');
  </code></pre>
  
  <p>Normally in mysql this query is straight forward and will insert 3 rows, how do I do this in mysqli without using a prepared statement or maybe using a prepared statement but without getting too complicated?. I just wish to know if there is a way to execute such query without doing extra funky stuff in PHP.</p>
  
  <p>In essence, I have some extracted data  that has around 10 rows per insert (and also needs multiple inserts in addition to having multiple rows), and this is what I need it for. I only wish to do this with a query as I have normally done it with mysql,  and not add multiple insert as one per each row.</p>