php - Number of bound variables does not match number of tokens with PDO -

-

i running through errors displayed in this post since 2 days.

here response var_dump($_post):

array (size=5)   'select_old' => string '2' (length=1)   'patient_name' => string '' (length=0)   'app_date' => string '2016-03-07' (length=10)   'app_time' => string '11:11' (length=5)   'app_reason' => string 'a' (length=1)

and here error got:

exception 'pdoexception' message 'sqlstate[hy093]: invalid parameter number: number of bound variables not match number of tokens' in c:\wamp\www\dentist\pages\add_appoint.php:35 stack trace:

0 c:\wamp\www\dentist\pages\add_appoint.php(35): pdostatement->execute() #1 {main}

here php code:

<?php //set error reporting on error_reporting(e_all); ini_set("display_errors", 1);  //include connection file require_once('../include/global.php');  //json , php header header('content-type: application/json');  $user = $_session['username']; $id_logged = $_session['login_id'];  try {     $arr = array();     //values ajax     $patient_name = $_post['patient_name'];     $date_app = $_post['app_date'];     $time_app = $_post['app_time'];     $reason = $_post['app_reason'];     $old_patient_id = $_post['select_old'];     //var_dump($_post);exit();     //if new patient     if($patient_name == "" && $old_patient_id != 0)     {          //see if date , time exist         $appexist = "select * appointment id_logged = :id_logged , date_app = :date_app , time_app = : time_app";         $appexiststmt = $conn->prepare($appexist);         $appexiststmt->bindvalue(":id_logged", $id_logged);         $appexiststmt->bindvalue(":date_app", $date_app);         $appexiststmt->bindvalue(":time_app", $time_app);         $appexiststmt->execute();         $appexiststmtcount = $appexiststmt->rowcount();          if($appexiststmtcount === 0)         {             //add appointment table             $appadd = "insert appointment(id_logged, patient_id, date_app, time_app, reason)                        values(:id_logged, :patient_id, :date_app, :time_app, :reason)";             $appaddstmt = $conn->prepare($appadd);             $appaddstmt->bindvalue(':id_logged', $id_logged);             $appaddstmt->bindvalue(':patient_id', $old_patient_id, pdo::param_int);             $appaddstmt->bindvalue(':date_app', $date_app);             $appaddstmt->bindvalue(':time_app', $time_app);             $appaddstmt->bindvalue(':reason', $reason);              $appaddstmt->execute();              echo "added";         }         else         {             echo "not added";         }     }      //if patient name exist     if($patient_name != "" && $old_patient_id == 0)     {         //add new patient         $addnewpatient = "insert patient(patient_name, id_logged) values(:patient_name, :id_logged)";         $addnewpatientstmt = $conn->prepare($addnewpatient);         $addnewpatientstmt->bindvalue(":patient_name", $patient_name);         $addnewpatientstmt->bindvalue(":id_logged", $id_logged);         $addnewpatientstmt->execute();          $lastid = $conn->lastinsertid();          //see if date , time exist         $appexist = "select * appointment id_logged = :id_logged , date_app = :date_app , time_app = : time_app";         $appexiststmt = $conn->prepare($appexist);         $appexiststmt->bindvalue(":id_logged", $id_logged);         $appexiststmt->bindvalue(":date_app", $date_app);         $appexiststmt->bindvalue(":time_app", $time_app);         $appexiststmt->execute();         $appexiststmtcount = $appexiststmt->rowcount();          if($appexiststmtcount == 0)         {             //add appointment table             $appadd = "insert appointment(id_logged, patient_id, date_app, time_app, reason)                        values(:id_logged, :patient_id, :date_app, :time_app, :reason)";             $appaddstmt = $conn->prepare($appadd);             $appaddstmt->bindvalue(":id_logged", $id_logged);             $appaddstmt->bindvalue(":patient_id", $lastid);             $appaddstmt->bindvalue(":date_app", $date_app);             $appaddstmt->bindvalue(":time_app", $time_app);             $appaddstmt->bindvalue(":reason", $reason);              $appaddstmt->execute();               $arr = array('patient_name'=>$patient_name, 'date_app' =>$date_app);             echo json_encode($arr);         }         else         {             $msg = "their existing appointment in same time, please specify date , time";             $arr = array('patient_name'=>$msg, 'date_app', $date_app, 'time_app', $time_app);         }     } } catch(pdoexception $m) {     $m->getmessage();     echo "error".$m; } ?>

line 35 $appexiststmt->execute();

: time_app

try remove space

:time_app

Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

reactjs - React router and this.props.children - how to pass state to this.props.children -

-
i'm using react-router first time , don't know how think in yet. here's how i'm loading components in nested routes. entry point .js reactdom.render( <router history={hashhistory} > <route path="/" component={app}> <route path="models" component={content}> </route> </router>, document.getelementbyid('app') ); app.js render: function() { return ( <div> <header /> {this.props.children} </div> ); } so child of app content component sent in. i'm using flux , app.js has state , listens changes, don't know how pass state down this.props.children. before using react-router app.js defines children explicitly, passing state natural don't see how now. using couple of react helper methods can add state, props , whatever else this.props.children render: function() { var children = react.ch...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more