برنامه نویس

در پروژه ی ablog برای ساخت کوئری insert با متد Prepared statementsبه روشINSERT INTO `categories` ( title, urlkey, active ) VALUES ( ?, ?, ? )این ارور رو میدهWaing: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: parameter was not definedوقتی هم ازINSERT INTO `categories` ( title, urlkey, active ) VALUES (:title, :urlkey, :active)استفاده می کنم همه مقادیر جدول رو با 1 پر میکنهتابع کوئری public function query($query, $params = []) { $stmt = $this->con->prepare($query); foreach($params as $key => $value){ $stmt->bindparam($key, $value); } $stmt->execute(); retu $stmt; } تابع ساخت کوئری insert public function insert($params) { $result = "INSERT INTO `{$this->tableName}` ("; foreach($params as $key => $value){ $result .= ' ' . $key .','; } $res,prepare statement,prepare statement of cash flows,prepare statement mysql,prepare statement sql,prepare statement of retained earnings,prepare statement of cash flows from balance sheet,prepare statement of cash flows indirect method,prepare statement example,preparedstatement,prepare statement jdbc ...ادامه مطلب