Issue Inserting Row MySQL, no MySQL Error

Question

I have the following php script snippet:

try{
  $con = new PDO("mysql:host=$host;dbname=$databaseName;charset=utf8",$user,$pass);
  $con->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
  $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

  $dat = $_REQUEST['dat'];
  $poll = $dat[0];
  $date = $dat[1];
  $zip = $dat[2];
  $answer = $dat[3];

  $q = $con->prepare("INSERT INTO votes (poll_id, date, location, answers) VALUES (:poll, :date, :zip, :answer)");
  $q->bindParam(':poll', $poll, PDO::PARAM_INT);
  $q->bindParam(':date', $date, PDO::PARAM_STR);
  $q->bindParam(':zip', $zip, PDO::PARAM_STR);
  $q->bindParam(':answer', $answer, PDO::PARAM_STR);

  if ($q->execute){
     echo "worked";
  } else {
     echo "didn't work";
  }
}catch(PDOException $e){
  echo $e->getMessage();
}

Every time I try and run this script, I get an internal server error (500). There is no echo, no error message, nothing. When I remove the error handling, I get 200, but the "didn't work" message.

Please help!

EDIT: Added ini_set("display_errors",1); to top of page. Some reason 500 error no longer occurs, but still getting "didn't work".

Turn on your php errors. Add ini_set("display_errors",1); at the top of your file. — Rikesh
– Rikesh, Commented Feb 20, 2014 at 16:04
Added, somehow the 500 error is now gone, but still receiving "didn't work". — user3317337
– user3317337, Commented Feb 20, 2014 at 16:08

Alon Eitan · Accepted Answer · 2014-02-20 16:08:57Z

4

try to change if ($q->execute){ to if ($q->execute()){

answered Feb 20, 2014 at 16:08

Alon Eitan

12k8 gold badges51 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3317337 Over a year ago

Buy @Alon a beer! Thanks! Will accept answer in couple minutes (once I get permission to =] )

Collectives™ on Stack Overflow

Issue Inserting Row MySQL, no MySQL Error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related