Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
$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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.