CODEWITHSUNDEEP
phpmysqlpdoprepared-statement
no.
no.

Reputation: 2376

Not too sure why this Prepared Statement isn't working

For some reason this just isn't inserting into my database...

HTML

<form name="testimonials_form" method="post" action="insert/">
  Name
  <input type="text" name="from" maxlegnth="100" />
  Location
  <input type="text" name="where" maxlegnth="100" />
  Text Snippet
  <input type="text" name="text" maxlegnth="255">
  <input type="submit" name="submit" value="Continue" />
</form>

PHP

<?php

$from = $_POST['from'];
$where = $_POST['where'];
$text = $_POST['text'];

if (!$from || !$where || !$text) {
  $error = "You have missed some fields.";
  $solution = "Please go back and <a href=\"javascript:history.go(-1)\" target=\"_self\">try again</a>.";
} else {
  $data_array = array(':from' => $from, ':where' => $where, ':text' => $text);

  $insert_testimonial = $connect->prepare("
  INSERT INTO `testimonials` (
      text, from, where
  ) VALUES (
      :text, :from, :where
  )
  ");

  $insert_testimonial->execute($data_array);

  $amount = $insert_testimonial->rowCount();

  if ($amount < 1) {
    $error = "Something went wrong.";
    $solution = "Please go back and <a href=\"javascript:history.go(-1)\" target=\"_self\">try again</a>.";
  } else {
    header ("Location: ../");
  }
}

?>

All I keep getting back is my custom error "Something went wrong." so there's no 500 error (internal server error) and if I echo $from, $where and $text it displays what I typed in the form, I've re-written it about 5 times in case I wrote it wrong or something but still no luck. I know there can't be a symbol missing or in the wrong place since it would return a 500 error.

Does anyone have any clue as to what's up with it? I've written codes like this countless times but this just doesn't seem to be working, so I must be missing something.

Upvotes: 0

Views: 80

Answers (1)

Jared Farrish
Jared Farrish

Reputation: 49198

from, where

in your query need to be 

`from`, `where`

as from and where are a reserved words in MySQL:

http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

Those are backticks, by the way. IMO, you'd be better off not using those words as column names, but if you do, you most often need to use backticks.

Upvotes: 1

Related Questions