Databases
StackOverflow2013
Postsdbo
POMySQLI Prepared statement won't insert into DB
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMySQLI Prepared statement won't insert into DB
    text
    copied!<p>after I got advice to change my normal MySQLI query's to prepared statement, I've tried to change it all to prepared statement. The only thing is, is that my query then won't insert the info to the database.</p> <p>I've tried to use var_dump to know if something is wrong, but var_dump gives me this back:</p> <blockquote> <p>Warning: var_dump() [function.var-dump]: Property access is not allowed yet in /home/<strong><em>*</em></strong>/domains/<strong>**</strong>.nl/public_html/contact.php on line 123 object(mysqli_stmt)#3 (9) { ["affected_rows"]=> NULL ["insert_id"]=> NULL ["num_rows"]=> NULL ["param_count"]=> NULL ["field_count"]=> NULL ["errno"]=> NULL ["error"]=> NULL ["sqlstate"]=> NULL ["id"]=> NULL }</p> </blockquote> <p>My code:</p> <pre><code> $stringMelding = '&lt;div class="attention closable"&gt;&lt;strong&gt;Helaas!&lt;/strong&gt; Er is helaas een onbekende fout opgetreden met onze database, probeert u het later nog eens.&lt;/div&gt;'; $emailSent = true; //Controle spam. if($sDatum == $arrayInfoContact['datum'] &amp;&amp; $sIPadres == $arrayInfoContact['ipadres']) { $stringMelding = '&lt;div class="warning closable"&gt;&lt;strong&gt;Helaas!&lt;/strong&gt; U heeft in de afgelopen 24 uur al een bericht verzonden naar onze helpdesk!&lt;/div&gt;'; } else { $stringMelding = '&lt;div class="success closable"&gt;&lt;strong&gt;Bedankt!&lt;/strong&gt; Uw e-mail is verstuurd naar onze helpdesk, wij zullen zo snel mogelijk contact met u opnemen.&lt;/div&gt;'; //Prepared statement. $stmt = $mysqli-&gt;prepare("INSERT INTO contact(naam, mailadres, bericht, ipadres, datum) VALUES (?, ?, ?, ?, ?)"); $stmt-&gt;bind_param('sssss', $sName, $sEmail, $sMessage, $sIPadres, $sDatum); $sName = $mysqli-&gt;real_escape_string(trim($_POST['author'])); $sEmail = $mysqli-&gt;real_escape_string(trim($_POST['email'])); $sMessage = trim(nl2br($_POST['comment'])); $sIPadres = $_SERVER['REMOTE_ADDR']; $sDatum = date('d-m-Y'); $stmt-&gt;execute(); $stmt-&gt;close(); //End of prepared statement. $mail = mail($afMail, "Contact || RASolutions", $sBericht, $headers); </code></pre> <p>My query and whole system worked when I used MySQLI->query, so the query is working I guess, thank you for your help.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload