title: SQL, PHP, Prepared Statement
body: <p>I am trying to use a prepared statement to populate my table from PHP.</p>
  
  <p>No errors are being thrown however, the data is not entering the table. Here is my code:</p>
  
  <pre><code>$stmt = $mysqli-&gt;prepare("INSERT INTO Parks VALUES (null,?,?,?,?,?,?,?,?,?,?,?,?,?,Now(),?,?,?, 0, 0, 0)");
      if ($stmt === FALSE) {
      die ("Mysql Error: " . $mysqli-&gt;error);
      }
      $stmt-&gt;bind_param('ssssssssssssssss', $name, $theme, $size, $mountains, $hills, $river, $lake, $island, $setofislands, $ocean, $waterfalls, $file, $image, $description, $author,$cs);
  
      $stmt-&gt;execute();
      $stmt-&gt;close();
      $mysqli-&gt;close();
  </code></pre>
  
  <p>Thanks in advance.</p>
  
  <p><strong>Data Types:</strong></p>
  
  <ul>
  <li>ID (Int(autoincrement))</li>
  <li>Name (varchar(255))</li>
  <li>Theme (varchar(255))</li>
  <li>Size (varchar(255))</li>
  <li>Mountains (varchar(255))</li>
  <li>Hills (varchar(255))</li>
  <li>Rivers (varchar(255))</li>
  <li>Lake (varchar(255))</li>
  <li>Island (varchar(255))</li>
  <li>Setofislands (varchar(255))</li>
  <li>Ocean (varchar(255))</li>
  <li>Waterfall (varchar(255))</li>
  <li>File (varchar(255))</li>
  <li>Image (varchar(255))</li>
  <li>DateUploaded (date)</li>
  <li>Description(varchar(255))</li>
  <li>Author (varchar(255))</li>
  <li>CS(varchar(2000))</li>
  <li>Download(int(255))</li>
  <li>Rating(double)</li>
  <li>FileSize(BigInt(20)</li>
  </ul>
  
  <p>(total 21)</p>
  
  <p>Note: I have tried prepared statements on a test database, which just had one column and that worked...</p>