如何在PHP中利用匿名函數(shù)操作數(shù)據(jù)庫?針對(duì)這個(gè)問題,這篇文章詳細(xì)介紹了相對(duì)應(yīng)的分析和解答,希望可以幫助更多想解決這個(gè)問題的小伙伴找到更簡單易行的方法。
專注于為中小企業(yè)提供做網(wǎng)站、成都網(wǎng)站制作服務(wù),電腦端+手機(jī)端+微信端的三站合一,更高效的管理,為中小企業(yè)長葛免費(fèi)做網(wǎng)站提供優(yōu)質(zhì)的服務(wù)。我們立足成都,凝聚了一批互聯(lián)網(wǎng)行業(yè)人才,有力地推動(dòng)了成百上千家企業(yè)的穩(wěn)健成長,幫助中小企業(yè)通過網(wǎng)站建設(shè)實(shí)現(xiàn)規(guī)模擴(kuò)充和轉(zhuǎn)變。具體方法如下
Base dao class illustrating the usefulness of closures.* Handles opening and closing of connections.* Adds slashes sql* Type checking of sql parameters and casts as appropriate* Provides hook for processing of result set and emitting one or more objects.* Provides hook for accessing underlying link and result objects. getConnection(); $this->setParams($sql, $params); $return = null; if(($result = mysql_query($sql, $link)) != null) if($callback != null) $return = $callback($result, $link); if($link != null) mysql_close($link); if(!$result) die("Fatal Error: Invalid query '$sql' : " . mysql_error()); return $return; } function getList($sql, $params, $callback) { return $this->executeQuery($sql, $params, function($result, $link) use ($callback) { $idx = 0; $list = array(); while ($row = mysql_fetch_assoc($result)) if($callback != null) $list[$idx] = $callback($idx++, $row); return $list; }); } function getSingle($sql, $params, $callback) { return $this->executeQuery($sql, $params, function($result, $link) use ($callback) { if ($row = mysql_fetch_assoc($result)) $obj = $callback($row); return $obj; }); }} class Example { var $id; var $name; function Example($id, $name){ $this->id = $id; $this->name = $name; } function setId($id){ $this->id = $id; }} class ExampleDao extends BaseDao { function getAll(){ return parent::getList("select * from nodes", null, function($idx, $row) { return new Example($row["id"], $row["name"]); }); } function load($id){ return parent::getSingle("select * from nodes where id = %1\$s", array($id), function($row) { return new Example($row["id"], $row["name"]); }); } function update($example){ return parent::executeQuery("update nodes set name = '' where id = -1", null, function($result, $link){ return $result; }); } function insert(& $example){ return parent::executeQuery("insert into nodes", null, function($result, $link) use ($example){ $id = mysql_insert_id($link); $example->setId($id); return $result; }); } } $exampleDao = new ExampleDao(); $list = $exampleDao->getAll()); $exampleObject = $exampleDao->load(1)); $exampleDao->update($exampleObject); ?>
關(guān)于如何在PHP中利用匿名函數(shù)操作數(shù)據(jù)庫問題的解答就分享到這里了,希望以上內(nèi)容可以對(duì)大家有一定的幫助,如果你還有很多疑惑沒有解開,可以關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道了解更多相關(guān)知識(shí)。