$query = "INSERT INTO `Staff` (`email`, `fullname`, `mobile`, `telephone`, `work-phone`, `faddress`, `postcode`, `marital`, `children`, `dob`, `hobbies`, `health`, `gid`, `cv`, `wages`, `employment`) VALUES (:email, :fullname, :mobile, :telephone, :work-phone, :faddress, :postcode, :marital, :children, :dob, :hobbies, :health, :gid, :cv, :wages, :employment)"; $dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING ); $q = $dbh->prepare($query); $insert = array(':email'=>$contact, ':fullname' => $fullname, ':mobile' => $mofo, ':telephone' => $telephone, ':work-phone' => $workTelephone, ':faddress' => $faddress, ':postcode' => $pc, ':marital' => $ms, ':children' => $children, ':dob' => $dob, ':hobbies' => $hobbies, ':health' => $health, ':gid' => $gid, ':cv' => $cv, ':wages' => $wages, ':employment' => $empl); $q->execute($insert);
SQLSTATE[HY093]: Invalid parameter number: parameter was not defined on line 67I'm new to PDO so could someone please tell me what the problem is here.
SQLSTATE[HY093]: Invalid parameter number on line 67
|form button worked now it doesnt anymore||9||42|
|datetime in sql||6||31|
|Testing a string condition in PHP||6||10|
|MS SQL Server - Looking to filter rows based on column value||3||11|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!