php - I have an error in mySQL -


fatal error: uncaught exception 'pdoexception' message 'sqlstate[42000]: syntax error or access violation: 1064 have error in sql syntax; check manual corresponds mysql server version right syntax use near '' @ line 1' in /home//domains//public_html/new/.php:140 stack trace: #0 /home//domains//public_html/new/.php(140): pdostatement->execute() #1 {main} thrown in /home//domains//public_html/new/***.php on line 140

below find code:

if(count($errors) == 0) {     $title = trim($_post['title']);     $category = trim($_post['category']);     $ing = trim($_post['ing']);     $ing_pond = trim($_post['ing_pond']);     $ing_note = trim($_post['ing_note']);     $description = trim($_post['description']);     $time = trim($_post['time']);     $insert = $dbh->prepare('insert recettes (id, id_user, title, category, ing, ing_pond, ing_note, description, graad, time) values (null, :meid :title, :category, :ing, :ing_pond, :ing_note, :description, :graad, :time');     $insert->bindparam(':meid', $me['id'], pdo::param_int);     $insert->bindparam(':title', $title, pdo::param_str);     $insert->bindparam(':category', $category, pdo::param_str);     $insert->bindparam(':ing', $ing, pdo::param_str);     $insert->bindparam(':ing_pond', $ing_pond, pdo::param_str);     $insert->bindparam(':ing_note', $ing_note, pdo::param_str);     $insert->bindparam(':description', $description, pdo::param_str);     $insert->bindparam(':graad', $graad, pdo::param_str);     $insert->bindparam(':time', $time, pdo::param_str);     $insert->execute();     $uid = $dbh->lastinsertid();     echo alert('uw gerecht succesvol toegevoegd.', 'success');     $added = true; }else{     echo alert('er ging wat mis. de volgende dingen gingen fout:<ul><li>' . join('</li><li>', $errors) . '</li></ul>het gerecht helaas niet toegevoegd.', 'danger'); }

how solved, can please me :-)

thnx lot!

replace line:

$insert = $dbh->prepare('insert recettes (id, id_user, title, category, ing, ing_pond, ing_note, description, graad, time) values (null, :meid :title, :category, :ing, :ing_pond, :ing_note, :description, :graad, :time');

with line:

$insert = $dbh->prepare('insert recettes (id, id_user, title, category, ing, ing_pond, ing_note, description, graad, time) values (null, :meid, :title, :category, :ing, :ing_pond, :ing_note, :description, :graad, :time)');

you forget last ) in code , comma , between :meid , :title


Comments

Post a Comment

Popular posts from this blog

shopping cart - Page redirect not working PHP -

im trying redirect user when click "empty cart". redirect working "add cart" not "empty cart". ideas great. in main .php file set current url seen $current_url = base64_encode("http://$_server[http_host]$_server[request_uri]"); then below cartaction.php file handles actions such "add cart" , "empty cart" <?php session_start(); include_once 'config.php'; //add item in shopping cart if(isset($_post["add"])) { $product_id = $_post["product_id"]; //product id $return_url = base64_decode($_post["return_url"]); //return url $qty = $_post["qty"]; $product = $mysqli->query("select product_name, unit_price, unit_quantity products product_id = '$product_id'"); $obj = $product->fetch_object(); if(!isset($_session['products'])) { $_session['products'] = array(); } if(array_key_exists($product_id...
Read more

php - How to modify a menu to show sub-menus -

i have custom php menu made person, displays categories menu. however, need display subcategories well. tried adding hierarchical parameter didn't work. hoping assistance! here code: <ul> <?php /* categories wp e-commerce products */ $wpec_product_categories = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=0&exclude=298'); $myarray = array(); foreach($wpec_product_categories $wpec_categories){ $myarray[$wpec_categories->term_id]['name'] = $wpec_categories->name; $myarray[$wpec_categories->term_id]['slug'] = $wpec_categories->slug; $myarray[$wpec_categories->term_id]['term_id'] = $wpec_categories->term_id; } foreach($myarray $wpec_categories1){ $wpec_term_name = $wpec_categories1['name']; $wpec_term_slug = $wpec_categories1['slug']; $wpec_term_id = $wpec_categories1['term_id']; echo '<li> <a href="'.get_page_link(19)....
Read more

python - Installing PyDev in eclipse is failed -

unable read repository @ http://pydev.sf.net/updates/content.xml. sun.security.validator.validatorexception: pkix path building failed: sun.security.provider.certpath.suncertpathbuilderexception: unable find valid certification path requested target i installing pydev in eclipse using python, doesn't install successfully. gives above error. happened? how solve error? i had error when trying install on laptop behind corporate firewall. couldn't tell setup of firewall, not sure of root cause. i got passed error installing pydev eclipse when out behind firewall. another way got around have eclipse on non-firewalled machine, install pydev eclipse, , copy whole eclipse directory non-firewalled machine firewalled machine. there better way, , way fix properly, didn't have time work out firewall doing. this on windows 7 machine (yeah know) not work *nix versions installed through package manager yum or apt.
Read more