title: Having trouble storing html form resources into mySQL using mysqli method alongside file function
body: <p>PHP that is run before the form</p>
  <pre><code>&lt;?php
  error_reporting(E_ALL);
  ini_set('display_errors',1);
  
  include 'config.php';
  include 'pageblocks.php';
  include 'functions.php';
  
  if ( isset( $_POST ) &amp;&amp; ! empty( $_FILES ) ) {
    echo upload_file();
  
    echo '1';
    $stmt = $conn-&gt;prepare(&quot;INSERT INTO art_content (headline, content_type, postdate, title,
    content, index_thumb) VALUES (?,?,?,?,?,?)&quot;);
    echo '2';
    $stmt-&gt;bind_param('ssssss', $_POST['headline'],
    $_POST['content_type'], $_POST['postdate'], $_POST['title'], $_POST['content'],
      $_POST['file']);
    echo '3';
    $stmt-&gt;execute();
    echo '4';
    $conn-&gt;close();
    unset($_POST);
  }
  
  metablock('content upload page');
  headerblock('');
  ?&gt;
  </code></pre>
  <p>The form that I'm trying to implement on site</p>
  <pre><code>&lt;form method =&quot;post&quot; action=&quot;&quot; enctype=&quot;multipart/form-data&quot;&gt;
    &lt;label for=&quot;headline&quot;&gt;&lt;strong&gt;Choose Index Headline&lt;/strong&gt;&lt;/label&gt;&lt;br&gt;&lt;br&gt;
    &lt;select name=&quot;headline&quot;&gt;
      &lt;option value=&quot;addition to gallery&quot;&gt;addition to gallery&lt;/option&gt;
      &lt;option value=&quot;new patron content&quot;&gt;new patron content&lt;/option&gt;
      &lt;option value=&quot;new youtube video&quot;&gt;new youtube video&lt;/option&gt;
      &lt;option value=&quot;new addition to articles&quot;&gt;new addition to articles&lt;/option&gt;
    &lt;/select&gt;&lt;br&gt;&lt;br&gt;
  
    &lt;label for=&quot;content_type&quot;&gt;&lt;strong&gt;Choose content type:&lt;/strong&gt;&lt;/label&gt;&lt;br&gt;&lt;br&gt;
    &lt;select name=&quot;content_type&quot;&gt;
      &lt;option value=&quot;digital photograph&quot;&gt;digital photograph&lt;/option&gt;
      &lt;option value=&quot;digital painting&quot;&gt;digital painting&lt;/option&gt;
      &lt;option value=&quot;traditional painting&quot;&gt;traditional painting&lt;/option&gt;
      &lt;option value=&quot;twitch branding&quot;&gt;twitch branding&lt;/option&gt;
      &lt;option value=&quot;article&quot;&gt;article&lt;/option&gt;
    &lt;/select&gt;&lt;br&gt;&lt;br&gt;
  
    &lt;label&gt;&lt;strong&gt;post date&lt;/strong&gt;&lt;/label&gt;&lt;br&gt;&lt;br&gt;
    &lt;input name=&quot;postdate&quot; type=&quot;text&quot;&gt;&lt;br&gt;&lt;br&gt;
  
    &lt;label&gt;&lt;strong&gt;title&lt;/strong&gt;&lt;/label&gt;&lt;br&gt;&lt;br&gt;
    &lt;input name=&quot;title&quot; type=&quot;text&quot;&gt;&lt;br&gt;&lt;br&gt;
  
    &lt;label&gt;&lt;strong&gt;text content&lt;/strong&gt;&lt;/label&gt;&lt;br&gt;&lt;br&gt;
    &lt;textarea name=&quot;content&quot; type=&quot;text&quot;&gt;&lt;/textarea&gt;&lt;br&gt;&lt;br&gt;
  
    &lt;input type=&quot;file&quot; name=&quot;file&quot;&gt;
    &lt;input type=&quot;submit&quot; value=&quot;Upload&quot;&gt;
  &lt;/form&gt;
  </code></pre>
  <p>My upload file function works fine but MySQL data doesn't seem to make it to server.
  I can't figure out what to do, thinking about trying the PDO method cause it seems less confusing but feels bad giving up on mysqli method to connect</p>