php PDO 在PHP中使用PDO$sql="......";$statement->($sql);执行报下面的错误Invalid parameter ariables does not match number of tokens 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 $sql = "INSERT INTO company (csf_code,hq_ctry_cd,hq_post_code,reg_ctry_cd,reg_post_code,create_date_loc,registed_capital,capital_curr_cd,fin_year,cpny_listed,cpny_covered,cpny_status,crt_stmp,crt_user,pub_stmp,pub_user,upd_stmp,upd_user) VALUES (:csf_code,:hq_ctry_cd,:hq_post_code,:reg_ctry_cd,:reg_post_code,:create_date_loc,:registed_capital,:capital_curr_cd,:fin_year,:cpny_listed,:cpny_covered,:cpny_status,:crt_stmp,:crt_user,:pub_stmp,:pub_user,:upd_stmp,:upd_user)"; $statement = $this->PDO->prepare($sql); $statement->bindParam(":csf_code",$company['comCSFCode'],PDO::PARAM_STR); $statement->bindParam(":hq_ctry_cd",$company['comHQCountryCode'],PDO::PARAM_STR); $statement->bindParam(":hq_post_code",$company['comHQPostCode'],PDO::PARAM_STR); $statement->bindParam(":reg_ctry_cd",$company['comRegCountryCode'],PDO::PARAM_STR); $statement->bindParam(":reg_post_code",$company['comRegPostCode'],PDO::PARAM_STR); $statement->bindParam(":create_date_loc",$company['comCreateDateLocale'],PDO::PARAM_STR); $statement->bindParam(":registed_capital",$company['comRegCapital'],PDO::PARAM_STR); $statement->bindParam(":capital_curr_cd",$company['comRegCapitalCurrCode'],PDO::PARAM_STR); $statement->bindParam(":fin_year",$company['comFinYear'],PDO::PARAM_STR); $statement->bindParam(":cpny_listed",$company['comListed'],PDO::PARAM_INT); $statement->bindParam(":cpny_covered",$company['comCovered'],PDO::PARAM_INT); $statement->bindParam(":cpny_status",$company['comUpdating'],PDO::PARAM_INT); $statement->bindParam(":crt_stmp",$company['comCreateTime'],PDO::PARAM_STR); $statement->bindParam(":crt_user",$company['comCreateUser'],PDO::PARAM_INT); $statement->bindParam(":pub_stmp",$company['comPubTime'],PDO::PARAM_STR); $statement->bindParam(":pub_user",$company['comPubUser'],PDO::PARAM_INT); $statement->bindParam(":upd_stmp",$company['comUpdateTime'],PDO::PARAM_STR); $statement->bindParam(":upd_user",$company['comUpdUser'],PDO::PARAM_INT); $statement->execute(); PHP做论坛,用面向对象的思想可行吗? PHP的代码本身没有大问题,但会停止运行,请指教 求教:如何在另一页面获取取得的值 通过PDO连接ORACLE出现错误,请路过的帮忙解答 程序在运行时怎么显示信息? 现在大家运行PHP是在IIS下还是用Apache多呢。。 怎么正常显示包括日韩语,繁体,和¶这些特殊字符混合的页面? 应用smarty模版做PHP页面的问题!急! 不知道改用asp 还是 php。。。 php get数据问题请教 怎么得到一年中每个月的天数啊... 来,帮忙跑跑小程序,看看会不会报错
$sql = "INSERT INTO company (csf_code,hq_ctry_cd,hq_post_code,reg_ctry_cd,reg_post_code,create_date_loc,registed_capital,capital_curr_cd,fin_year,cpny_listed,cpny_covered,cpny_status,crt_stmp,crt_user,pub_stmp,pub_user,upd_stmp,upd_user) VALUES (:csf_code,:hq_ctry_cd,:hq_post_code,:reg_ctry_cd,:reg_post_code,:create_date_loc,:registed_capital,:capital_curr_cd,:fin_year,:cpny_listed,:cpny_covered,:cpny_status,:crt_stmp,:crt_user,:pub_stmp,:pub_user,:upd_stmp,:upd_user)";
$statement = $this->PDO->prepare($sql);
$statement->bindParam(":csf_code",$company['comCSFCode'],PDO::PARAM_STR);
$statement->bindParam(":hq_ctry_cd",$company['comHQCountryCode'],PDO::PARAM_STR);
$statement->bindParam(":hq_post_code",$company['comHQPostCode'],PDO::PARAM_STR);
$statement->bindParam(":reg_ctry_cd",$company['comRegCountryCode'],PDO::PARAM_STR);
$statement->bindParam(":reg_post_code",$company['comRegPostCode'],PDO::PARAM_STR);
$statement->bindParam(":create_date_loc",$company['comCreateDateLocale'],PDO::PARAM_STR);
$statement->bindParam(":registed_capital",$company['comRegCapital'],PDO::PARAM_STR);
$statement->bindParam(":capital_curr_cd",$company['comRegCapitalCurrCode'],PDO::PARAM_STR);
$statement->bindParam(":fin_year",$company['comFinYear'],PDO::PARAM_STR);
$statement->bindParam(":cpny_listed",$company['comListed'],PDO::PARAM_INT);
$statement->bindParam(":cpny_covered",$company['comCovered'],PDO::PARAM_INT);
$statement->bindParam(":cpny_status",$company['comUpdating'],PDO::PARAM_INT);
$statement->bindParam(":crt_stmp",$company['comCreateTime'],PDO::PARAM_STR);
$statement->bindParam(":crt_user",$company['comCreateUser'],PDO::PARAM_INT);
$statement->bindParam(":pub_stmp",$company['comPubTime'],PDO::PARAM_STR);
$statement->bindParam(":pub_user",$company['comPubUser'],PDO::PARAM_INT);
$statement->bindParam(":upd_stmp",$company['comUpdateTime'],PDO::PARAM_STR);
$statement->bindParam(":upd_user",$company['comUpdUser'],PDO::PARAM_INT);
$statement->execute();