title: Inserting data from html form using php into data table in mysql database
body: <p>I'm new here and have recently started studying various forms of code to create simple solutions to my various projects. I've used many of the helpful tips a lot of you have posted on this website but I think I have finally reached a point where I can't figure out for the life of me how to fix. So I decided to turn to you all for help. It seems like it should be a simple solution to me but I cannot find it so maybe fresh eyes will help. So here it is I hope someone may be able to assist me. I help run an event here in my city that uses the video game Rock Band for karaoke purposes. I have a table setup called rbn_setlist_small that has two columns of 'Artist' and 'Song Title'. I have to periodically insert more songs into the table to account for newly purchased songs. So I created a form to insert the data into the table. It's a Simple form that has two fields Artist and Song Title. Whenever I enter test information (say Artist: 123, Song Title: test) it says the data has been entered but when I go and check the table the new data that has been entered just has a blank spot under Artist and Title under Song Title. So I'm sure I'm missing a comma or something somewhere but I cannot find it.</p>
  
  <p>This is the php for the form:</p>
  
  <pre><code>&lt;?php
  /* Attempt MySQL server connection.*/
  $link = mysqli_connect("host", "user", "pass", "db");
  
  /*Check connection*/
  if (mysqli_connect_errno()) {
      printf("Connect failed: %s\n", mysqli_connect_error());
      exit();
  }
  
  /*attempt insert query execution*/
  $query = "INSERT INTO `rbn_setlist_small`(`Artist`, `Song Title`) 
  
  VALUES ('$Artist', '$Song Title')";
  if ($result = mysqli_query($link, $query)) {
      echo "Records added successfully.";
  } else{
      echo "ERROR: Could not execute $sql. " . mysqli_error($link);
  }
  
  /*close connection*/
  mysqli_close($link);
  ?&gt;
  </code></pre>
  
  <p>and this the HTML for the form:</p>
  
  <pre><code>&lt;!DOCTYPE html&gt;
  &lt;html lang="en"&gt;
  &lt;head&gt;
  &lt;meta charset="UTF-8"&gt;
  &lt;title&gt;Add Music to Database&lt;/title&gt;
  &lt;/head&gt;
  &lt;body&gt;
  &lt;form action="insert.php" method="post"&gt;
      &lt;p&gt;
          &lt;label for="Artist"&gt;Artist:&lt;/label&gt;
          &lt;input type="text" name="Artist" id="Artist"&gt;
      &lt;/p&gt;
      &lt;p&gt;
          &lt;label for="Song Title"&gt;Song Title:&lt;/label&gt;
          &lt;input type="text" name="Song Title" id="Song Title"&gt;
      &lt;/p&gt;
      &lt;input type="submit" value="Submit"&gt;
  &lt;/form&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>Also any assistance in my coding is appreciated I'm a super novice.
  Thank you all for any assistance.</p>