php - Improve my Zend Stored Procedure calling code -

-

i'm wondering how can improve zend code calls stored procedure. @ moment i'm using mysql db, , action function in controller below works, seems nasty.

public function callspaction() {     $param = $this->_request->getparam('param', 0);      $bootstrap = $this->getinvokearg('bootstrap');     $config = $bootstrap->getoptions();      $mysqli = new mysqli(         $config['resources']['db']['params']['host'],         $config['resources']['db']['params']['root']['username'],         $config['resources']['db']['params']['root']['password'],         $config['resources']['db']['params']['dbname']);      $rs = $mysqli->query(sprintf('call mystoredprocedure(%d)',$param));     if(mysqli_error($mysqli))     {          throw new exception(mysqli_error($mysqli), mysqli_errno($mysqli));      }      $this->_helper->redirector('index', 'index'); }

i'd prefer use zend_db classes call stored procedure i'm not sure how can done?

since i'm calling number of stored procedures, think better create helper class wraps logic connecting db. expose methods wrap underlying stored procedure. controller code call

storedprocedurehelper::callmystoredprodecure($this->_request->getparam('param', 0);

is possible or recommended?

i favor use of models data access. also, advise define db adapter in application's config file it's transparent application code, , use pdo application not tied particular db manager in case need point different database in future.

for example, instead of having of data access logic in controller's action, simplified follows:

//within controller action $model = myubbercoolsupermodel(); $model->myubbercoolmethod($params);  //and in model, can extend zend_db_table_abstract public function myubbercoolmethod($params) {    $pdo = $this->getadapter()->prepare("call myprocedure(:param)");    $pdo->bindparam(':param', $param, pdo::param_str);     $pdo->execute();    // additional logic might want }

i think way clearer, controller responsible invoking method on model, model handles data access. if related data access needs refactored, changed, or whatever, know model have go instead of changing controller actions might impact other things.

hope helps ;)

cheers.


Comments

Post a Comment

Popular posts from this blog

javascript - Enclosure Memory Copies -

-
function myclass() { //lots , lots of vars , code here. this.bar = function() { //do numerous enclosed myclass vars } this.foo = function() { alert('hello'); //don't enclosed variables. } } each instance of myclass gets own copy of bar , foo, why prototyped methods use less memory. however, know more memory use of inner methods. it seems obvious me (1) below must true. agree? not distinct myclass instances have own distinct copies of bar, must have own distinct copies of myclass enclosure. (or else how bar method keep myclass variables straight on per instance basis?) now (2) question i'm after. since inner foo method doesn't use in myclass enclosure natural qustion is: javascript smart enough not keep myclass enclosure in memory use of foo? this depend entirely on implementation not language. naive implementations keep far more around others. answer true e.g. v8 (chrome's js engine) may not true spider...
Read more

php - Replacing tags in braces, even nested tags, with regex -

-
example preg_replace('/\{[a-za-z.,\(\)0-9]+\}/', 'replaced', 'lorem ipsum dolor sit {tag1({tag2()})}, consectetur adipiscing elit.'); the result: lorem ipsum dolor sit {tag1(replaced)}, consectetur adipiscing elit. question as can see "tag2" has been replaced, want replace "tag1" know how can this? (in cases might this: {tag1({tag2({tag3()})})}) , on.) btw using preg_replace_callback, easier show preg_replace here site can test code: http://www.spaweditor.com/scripts/regex/index.php you need add curly braces character set. here's pattern used: /\{[a-za-z.,\(\)\{\}0-9]+\}/ and here result: "lorem ipsum dolor sit replaced, consectetur adipiscing elit."
Read more