PHP and PDO dynamic parameter binding -

-

i'm trying fix butchered bit of code - might have guessed, i'm cocking bind param syntax. in fact, i'm not sure i'm trying possible. here's class method...

/*** * * @select values table * * @access public * * @param string $table name of table * * @param array $fieldlist fields return in results, defaults null * * @param array $criteria search criteria keyed fieldname * * @param int $limit limit of records return, defaults 10 * * @return array on success or throw pdoexception on failure * */ public function dbsearch($table, $fieldlist = null, $criteria = null, $limit = 10) {     // setup $this->db point pdo instance     $this->conn();      // build fieldlist     if( is_null($fieldlist) or !is_array($fieldlist) or count($fieldlist) == 0) {         $returnfields = '*';     } else {         $returnfields = "'".implode("', '", $fieldlist)."'";     }      // build criteria     if( is_null($criteria) or !is_array($criteria) or count($criteria) == 0) {         $whereclause = '';     } else {         $whereclause = array();         foreach ($criteria $key => $value){            $bind_name    = 'bind_'.$key; //generate name bind1, bind2, bind3...            $$bind_name   = $value; //create variable name value in            $bind_names[] = & $$bind_name; //put link variable in array            $whereclause[] = "'$key' = :$bind_name";         }         $whereclause = count($whereclause) > 0 ? ' '.implode( ' , ' , $whereclause ) : '';     }      $sql = "select $returnfields '$table' $whereclause limit $limit";       $stmt = $this->db->prepare($sql);      if( $whereclause != '') {         call_user_func_array(array(&$stmt, 'bindparam'), $bind_names);     }      $stmt->execute();     return $stmt->fetchall(pdo::fetch_assoc); }

... @ point want call using along these lines...

// users in database... $user_recs = $crud->dbsearch('user', array('user_name'), array('user_name'=> $_post['username'])); $users = $user_recs->fetchall(pdo::fetch_assoc);

how bonkers this? possible? need pass in param types somehow? gratefully received!

i don't understand how function better conventional

$stmt = $db->prepare("select user_name user user_name = ?"); $stmt->execute($_post['username']); $users = $stmt->fetchall();

mind you,

  • it keeps query flexible. limit ?,? possible
  • it keeps query readable. natural english of sql stays in place. still can tell query do, without need of learning brain-damaging language. side effect, other developer can comprehend code too.

Comments

Post a Comment

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array( ...
Read more

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub ...
Read more

Using django-mptt to get only the categories that have items -

-
sample structure: all uppercase: category mixed case: item root ├── books │   ├── fiction │   │   └── classics │   └── non-fiction ├── clothing └── electronics ├── laptops ├── phones │   ├── apple │   │   ├── iphone 6 │   │   ├── iphone 6 plus │   │   ├── iphone 6s │   │   └── iphone 6s plus │   ├── motorola │   │   ├── moto g4 │   │   ├── moto g4 play │   │   ├── moto g4 plus │   │   └── moto x │   └── samsung └── tablets └── apple i'm trying have index page show "electronics" category. "clothing" category shouldn't show since it's empty , "books" category shouldn't show either since, although has child categories, child categories don't have items. similarly, "electronics" page should show "phones" category. "laptops" category shouldn't show since it's empty , "tablets" category shouldn't show either since...
Read more