php - Trying to convert mysqli code to pdo -


i have mysqli code , trying convert mysqli pdo. have attempted below having trouble converting all. can please?

<?php  require_once './config.php'; include './header.php'; include('db.php'); include('database.php');   if($_post) {        mysqli_real_escape_string($connection,$_post['amount']);     $values = str_replace(' ','',$_post['amount']);     $values = str_replace('£','',$values);     $values = explode('-',$values);     $min = $values[0];     $max = $values[1];     $res = mysqli_query($connection,'select `image`,`recipe_name`,`recipe_price` recipe `recipe_price` between "'.$min.'" , "'.$max.'"');     $count  =   mysqli_num_rows($res);     $html='';     if($count > 0)     {         while($row=mysqli_fetch_array($res))         {             $image       = $row['image'];             $recipe_name    = $row['recipe_name'];             $recipe_price      = $row['recipe_price'];                 $html .= '<div>';             $html .= '<br /><img src=images/'.$image.">";             $html .= 'name: '.$recipe_name;             $html .= '<br />price: '.$recipe_price;             $html .= '</div><br /><hr />';          }     }     else     {         $html='no recipes found';     } } else {     $min = 0;     $max = 10;     $html=''; }  ?>

could , tell me going wrong in code below? 

require_once './config.php'; include './header.php'; include('db.php'); include('database.php');   if($_post && isset($_post['amount'])){ $values = $_post['amount'];  $values = ['£', '', $values]; $values = explode('-',$values);  $min = $values[0]; $max = $values[1];  $sql = "select `recipe_name`, `recipe_price`,  `image` `recipe` `recipe_price` between "'.$min.'" , "'.$max.'"");      $count = $stmt->fetchall();         if ($count->fetchcolumn() > 0) { } while($row = $stmt->fetch(/* pdo::fetch_assoc */)) {     // loop stuff }        echo $row['recipe']; {          }      else     {      } else {     $min = 0;     $max = 10;     $html=''; } ?>

you need call prepare , execute perform query. had mistakes in how set $min , $max, rewrote unnecessarily.

$values = str_replace(array(' ', '£'), '', $_post['amount']); list($min, $max) = explode('-', $values); $sql = "select `recipe_name`, `recipe_price`,  `image`          `recipe`          `recipe_price` between :min , :max"); $stmt = $connection->prepare($sql); $stmt->execute(array(':min' => $min, ':max' => $max)); $rows = $stmt->fetchall(pdo::fetch_assoc); if (count($rows) > 0) {     foreach ($rows $row) {         // loop stuff     } } else {     $min = 0;     $max = 10;     $html = ''; }

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