search

Orange-OpenSource / YACassandraPDO

Cassandra PDO Driver fork
Apache License 2.0
85 stars 32 forks source link

PHP Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in /home/izsk357idj7w/public_html/amaira_admin/include/function.php #93

Closed bobb9855977905 closed 5 years ago

bobb9855977905 commented 5 years ago

$update_product_query = $con->prepare("UPDATE products SET cat_id='$cat_id',subcat_id='$subcat_id',att_id='$att_id',brand_id='$brand_id',post_date='NOW()',pro_title='$pro_title',serial_num='$serial_num',model_num='$model_num',mrp='$mrp',pro_sale_price='$pro_sale_price',pro_disc='$pro_disc',pro_feature1='$pro_feature1',pro_feature2='$pro_feature2',pro_feature3='$pro_feature3',keyword='$keyword',stock='$stock',pro_aval='$pro_aval' WHERE pro_id='$pro_id'");

if($update_product_query->execute()) { echo ""; echo ""; }else { echo ""; }

bobb9855977905 commented 5 years ago

$update_product_query = $con->prepare("UPDATE products SET cat_id='$cat_id',subcat_id='$subcat_id',att_id='$att_id',brand_id='$brand_id',post_date='NOW()',pro_title='$pro_title',serial_num='$serial_num',model_num='$model_num',mrp='$mrp',pro_sale_price='$pro_sale_price',pro_disc='$pro_disc',pro_feature1='$pro_feature1',pro_feature2='$pro_feature2',pro_feature3='$pro_feature3',keyword='$keyword',stock='$stock',pro_aval='$pro_aval' WHERE pro_id='$pro_id'");

if($update_product_query->execute()) { echo ""; echo ""; }else { echo ""; }