title: Why does it work in development but not on live server?
body: <p>I have developed a working system on Xampp but when I transfer it to Server 2008 r2 I run into trouble. I have installed MySql 5.5.42 successfully and can login as root user through command line and pma. I have developed a web form in PHP which stores the field data in MySql but I am receiving a querying error now that my files are in use on the server &amp; the data is not reaching MySql server. It works without any problem on my development machine.</p>
  
  <p>I am using ‘localhost’ in my DB connection statements. I have also verified all passwords &amp; user names are correct. I have verified that PHP is also installed. My index.php page is reachable by clients without problem. Where it is falling down is the connection between PHP web form &amp; MySql. </p>
  
  <p>Sever management isn't my strong point and I’m hoping someone has come across this issue &amp; has a solution or helpful tips.</p>
  
  <p>DB connection</p>
  
  <pre><code>$dbc = mysqli_connect('localhost', 'root', 'password', 'dataBase')
  or die('Error connecting to MySQL server.');
  </code></pre>
  
  <p>insert data to table</p>
  
  <pre><code>$query = "INSERT INTO table (column_1, column_2, column_3, column_4, " .
      "column_5, column _6, column_7) " .
      "VALUES ('$column_1', '$column_2', '$column_3', '$column_4','$column_5', " .
               "'$column_6, '$column_7')";
  </code></pre>
  
  <p>Result, the error I receive is 'Error querying database'</p>
  
  <pre><code>$result = mysqli_query($dbc, $query)
  or die('Error querying database.');
  </code></pre>