// Query
$query = sprintf("SELECT * FROM users WHERE user='%s' AND password='%s'",
mysql_real_escape_string($user),
mysql_real_escape_string($password));
jQuery.ajax({
url: "http://xxx",
...
error:function (xhr, ajaxOptions, thrownError){
$("body").append(xhr.status);
$("body").append(xhr.responseText );
alert(thrownError);
}
});
protected function _initNavigation()
{
$this->bootstrap('layout');
$layout = $this->getResource('layout');
//$view = $layout->getView(); //加了這行...會導致在layout.phtml呼叫helper會掛...所以..註解掉...
$config = new Zend_Config_Xml(APPLICATION_PATH . '/configs/navigation.xml', 'nav'); //指定要讀取的架構檔，命名為navigation.xml
$container = new Zend_Navigation($config);
Zend_Registry::set("Zend_Navigation", $container); //範例裡沒加，但沒加又跑不動...怪...
//$view->navigation($container); //嗯...也是能動咧...
}<?xml version="1.0" encoding="UTF-8"?>
<configdata>
<nav>
<home>
<label>Home</label>
<uri>/</uri>
</home>
<courses>
<label>球場管理</label>
<uri>/courses/</uri>
<pages>
<add>
<label>新增球場</label>
<uri>/courses/add/</uri>
</add>
<edit>
<label>編輯球場</label>
<uri>/courses/edit/</uri>
</edit>
</pages>
</courses>
<about>
<label>關於我們</label>
<uri>/index/about/</uri>
</about>
</nav>
</configdata><body>
...
<?php echo $this->navigation()->Menu()?>
<?php echo $this->navigation()->breadcrumbs()->setLinkLast(false)->setMinDepth(0)->render(); ?>
...public function init()
{
//navigation
$uri = $this->_request->getPathInfo(); //原作是寫這樣啦，不過遇到有參數的uri就噴了
$uri = $this->_request->getControllerName()."/". $this->_request->getActionName(); //我把比對的uri改成這樣，也不怕最後有沒有斜線結尾
$activeNav = $this->view->navigation()->findByUri(strtolower($uri)); //避免大小寫問題，全轉為小寫
$activeNav->active = true;
//$activeNav->setClass("active"); //uri沒配對到時 會出現error,所以...
}過去，放store_procedure或script都不算好但一開始要不容易抽，所以折衷先放controller
UC都是片斷，有滿足即可，不要流程，至於滿足的程度依"Session"來判斷
隨時都在調，因此文件要少、精簡，過程中都是只是最後文件的snapshot
EA做Sequence Diagram時，拉物件會要選擇"Simple link or Instance", 選instance,因為是物件
隱含的method用加雙斜線 ex.到db抓資料=>//select
不用每個UC都畫Sequence，只畫比較需要的UI, Controller 應分開獨立的Project
何謂需要
programmer無法看出必要的method(無共識時)
<php
include "phth to PHPUnit";
class StackTest extends PHPUnit_Framework_TestCase
{
public function testPushAndPop()
{
$stack = array();
$this->assertEquals(0, count($stack));
array_push($stack, 'foo');
$this->assertEquals('foo', $stack[count($stack)-1]);
$this->assertEquals(1, count($stack));
$this->assertEquals('foo', array_pop($stack));
$this->assertEquals(0, count($stack));
}
}
?>wget https://phar.phpunit.de/phpunit.phar chmod +x phpunit.phar mv phpunit.phar /usr/local/bin/phpunit
$('form:first').trigger("submit");//根目錄 - 從web root到public
$this->baseUrl('course/add'); //參數加入即會自動補
=>/myweb/public/course/add$this->url(array('controller'=>'course','action'=>'add')); //如果當前的url是在同一個controller下的話，可以不用給controller參數
=>/myweb/public/course/add/$request = Zend_Controller_Front::getInstance()->getRequest();
$controllerName = $request->getControllerName();
$actionName = $request->getActionName();
$paramArray = $request->getParams();
$params = '';
foreach($paramArray as $key => $value)
$params .= $key . "/" . $value;//將js,css放在public裡的js,css資料夾
<script type="text/javascript" src="<?php echo $this->baseUrl('js/jquery-xxx.min.js');? >" >
</script?>
<link rel="stylesheet" type="text/css" href="<?php echo $this->baseUrl('css/xxx.css'); ? >" >
$db = Zend_Db::factory('Pdo_Mysql', array(
'host' => '127.0.0.1',
'username' => 'webuser',
'password' => 'xxxxxxxx',
'dbname' => 'course'
));$stmt = $db->query('SELECT * FROM course');
//Zend_Db提供fecth()，可抓出row object
while($row = $stat->fetch()){
echo $row['name'];
}$sql = 'SELECT * FROM course WHERE nam = ? AND status = ?';
$stmt = new Zend_Db_Statement_Mysqli($db, $sql); //mysql就用mysqli
$stmt->execute(array('demo course','display'));//db1 resources.multidb.course.adapter = "PDO_MYSQL" resources.multidb.course.host = "localhost" resources.multidb.course.username = "root" resources.multidb.course.password = "ok1234" resources.multidb.course.dbname = "course" resources.multidb.course.driver_options.1002 = "SET NAMES utf8" resources.multidb.teegle.default = true //db2 resources.multidb.admin.adapter = "PDO_MYSQL" resources.multidb.admin.host = "localhost" resources.multidb.admin.username = "root" resources.multidb.admin.password = "ok1234" resources.multidb.admin.dbname = "admin" resources.multidb.admin.driver_options.1002 = "SET NAMES utf8"
$resource = $this->PluginResource('multidb');
$resource->init();
$db = $resource->getDb('course'); //取得course db
$db->select()
->from( ... ) //多個from
->where( ... );Zend_Db_Table::setDefaultAdapter($db);
$courseTable = new Zend_Db_Table('course');$resultSet = $table->fetchAll(
$table->select()
->where('status = ?', 'NEW') //有多個where就再下一次where(xx)
->order('id ASC')
->limit(10, 0)
);
//塞進array
$entries = array();
foreach ($resultSet as $row) {
$object = row->id; // or row['id'];
$entries[] = $object;
}//application/Bootstrap.php
class Bootstrap extends Zend_Application_Bootstrap_Bootstrap
{
$resource = $this->getPluginResource('multidb'); //假設存放在multidb裡,參考如何設定多個db
$resource->init(); //初始化，不然不會動
//註冊要讀取的DB - admin
$admin = $resource->getDb('admin');
Zend_Registry::set("admin", $admin);
}class Application_Model_DbTable_User extends Zend_Db_Table_Abstract {
protected $_name = 'user';
//方法一
public function __construct($config=array()){
$this->read = Zend_Registry::get('admin');
$this->write = Zend_Registry::get('admin');
$config['db'] = Zend_Registry::get('admin');
return parent::__construct($config);
}
//方法二
protected function __setupDatabaseAdapter(){
}
}//Build this query:
// Select p."product_id",p."product_name", l.*
// From "products" AS p JOIN "line_items" AS l
// ON p.product_id = l.product_id
$select = $db->select()->from (array('p'=> 'products'),
array('product_id','product_name'))->join(array('l' => 'line_items'), 'p.produt_id = l.product_id');