在这里停留了一段时间.
我尝试运行代码时会收到此错误:
警告:pdostatement :: execute():sqlstate [hy093]:无效参数 编号:参数未定义 /applications/xampp/xamppfiles/htdocs/projectwebsite/php/pdo.php on 第111行
第111行是代码的第一行
$result1 = $query1->execute( array( ':transactionID'=>$transactionID, ':personalID'=>$array['personalID'], ':description'=>$array['description'], ':cost'=>$array['cost'], ':datetime'=>$array['datetime'] ) );function createTransaction($array){$db = connection();$stmt = $db->prepare("Select MAX(`transactionID`)+1 AS transactionID FROM transaction ");$stmt->execute();$transactionID = null;$results = $stmt->fetchAll(); foreach ($results as $result) {$transactionID =$result['transactionID'];}if(isset($transactionID)){$sql = "INSERT INTO `transaction`(`transactionID`, `personalID`, `description`, `cost`, `dateTime`)". " VALUES (:transactinID,:personalID,:description,:cost,CAST(:datetime AS DATETIME)";$query1 = $db->prepare( $sql );$result1 = $query1->execute( array( ':transactionID'=>$transactionID, ':personalID'=>$array['personalID'], ':description'=>$array['description'], ':cost'=>$array['cost'], ':datetime'=>$array['datetime'] ) );var_dump($result1);if ( $result1 ){ return $transactionID;} return null;}}推荐答案您的查询中有一个错别字:
:transactinID应该是:transactionID
其他推荐答案很简单您有一个错字:替换:
$sql = "INSERT INTO `transaction`(`transactionID`, `personalID`, `description`, `cost`, `dateTime`)". " VALUES (:transactinID,:personalID,:description,:cost,CAST(:datetime AS DATETIME)";with:
$sql = "INSERT INTO `transaction`(`transactionID`, `personalID`, `description`, `cost`, `dateTime`)". " VALUES (:transactionID,:personalID,:description,:cost,CAST(:datetime AS DATETIME)";