湿湿手

Updates from 十一月, 2009 Toggle Comment Threads | 键盘快捷键

• 

  admin 17:21 on 2009-11-05 链接地址 | 回复
  Tags: cakephp ( 3 ), LEFT JOIN ( 2 ), PHP ( 4 )   

  cakephp中的LEFT JOIN实现 

  1. $this->Recipe->bindModel(array(
  2. 'hasAndBelongsToMany' => array(
  3. 'Tag' => array('conditions'=>array('Tag.name'=>'Dessert'))
  4. )));
  5. $this->Recipe->find('all');

  上面是cakephp手册中的一段不好的示范，但是这让我想起是否SQL中from子句的LEFT JOIN 可以用是bindModel实现。

  http://book.cakephp.org/view/86/creating-and-destroying-associations-on-the-fly

   

  回复 取消回复

  Required fields are marked *

  姓名 *

  电子邮件 *

  站点

  

• 

  admin 16:42 on 2009-11-05 链接地址 | 回复
  Tags: association, cakephp ( 3 ), model, PHP ( 4 )   

  关于cakephp的model部分的Associations问题 

  假设有一个model叫Company，另一个叫Member。

  Company和Member是1：n的关系。

  如果Company中加了hasmany的关系。

  那执行$Company->find()的时候，是不是会把所有的member数据也一次取出？

  如果是，这样必然导致性能低下，甚至站点瘫痪。

  参看文章：http://book.cakephp.org/complete/66/Models#Associations-Linking-Models-Together-78

  以下摘自cakephp手册

  1. hasone
     • Once this association has been defined, find operations on the User model will also fetch a related Profile record if it exists
  2. belongsto
     • Once this association has been defined, find operations on the Profile model will also fetch a related User record if it exists:
  3. hasmany
     • Once this association has been defined, find operations on the User model will also fetch related Comment records if they exist:
     • 但是提供了’limit‘,  ‘offset‘, ‘finderQuery‘，来让你自己决定如何取many端
  4. hasAndBelongsToMany（HABTM）
     • Once this association has been defined, find operations on the Recipe model will also fetch related Tag records if they exist:

  结论：

  1. 如上所示，find操作会取出所有定义了的related的Model数据，需要谨慎设置 hasmany和habtm。
  2. 根据mannual来看，cakephp在执行find的时候是不会递归取关系数据的。比如取company的时候会取出members数据，但是不会递归去除member的company数据。

  重要补充

  cakephp可以指定find操作时，递归取数据的层数。上面结论的第二条错误。

   
• 

  admin 17:50 on 2009-11-03 链接地址 | 回复
  Tags: cakephp ( 3 ), PHP ( 4 )   

  cakephp学习要点 

  • 命名规则
    • class名字，class文件名，数据库表名字的命名规则

  • 配置设定
    • debug 输出信息级别设定
    • session 的相关设定，可以设定cookie的名称，可以设定session存储方式，可以设定安全级别（当为high时，每个request时候，存在cookie中的session ID都会改变，防止被监听）
    • acl 可以设定访问列表
  • URL 与 Controller的Action的mapping规则
    • 默认匹配
    • 带名字的参数匹配
    • In CakePHP, controllers are named after the model they handle, in plural form.    eg:The Recipe model is handled by the RecipesController, the Product model is handled by the ProductsController, and so on.
  • 可以静态化页面 HTML，route 会自动过滤扩展名
  • 命名规则中的单复数映射关系
  • Bootstrap的使用规则即 在什么情况下推荐使用bootstrap
  • persistModel
  • Redirect & Flash
  • Callbacks
  • requestAction
    • if you are using named or passed parameters, you must put them in a second array and wrap them with the correct key. This is because requestAction only merges the named args array into the Controller::params member array and does not place the named args in the key ‘named’.
  • 关于Component
    1. Components are packages of logic that are shared between controllers.
    2. You might also want to utilize other components inside a custom component.
    3. To access/use a model in a component is not generally recommended.
  • 依据Model规则创建数据库
    • title & name
    • created & modified
  • 从数据库返回树结构数据
  • 数据安全处理
  • Model中的create(array $data = array())方法
    • This method resets the model state for saving new information.
  • Model中如果要使用Transation
    • For transactions to work correctly in MySQL your tables must use InnoDB engine. Remember that MyISAM tables do not support transactions.
  • counterCache
  • Model之间的关系
    • Remember that associations are defined ‘one way’. If you define User hasMany Recipe that has no effect on the Recipe Model. You need to define Recipe belongsTo User to be able to access the User model from your Recipe model
  • bindModel（creating-and-destroying-associations-on-the-fly）
    • Removing or adding associations using bind- and unbindModel() only works for the next model operation only unless the second parameter has been set to false. If the second parameter has been set to false, the bind remains in place for the remainder of the request.
  • Multiple relations to the same model
  • Model的userdbconfig属性可以用来做负载均衡
  • find操作时递归取related model的层数设定
  • validate
  • 给Model添加自己方法或属性时的原则
    • Any operation that handles the saving and fetching of data is best housed in your model classes. This concept is often referred to as the fat model.
  • 如何写自己的数据源
    • 网络上的资源也可以作成数据源，如手册中的例子，twitter的api的读和写。
  • 在View的element里面使用requestAction示范
    • 如何在controller中判断是否来自requestAction
    • 如何缓存element及缓存element的不同版本
  • media view
    • Media views allow you to send binary files to the user. For example, you may wish to have a directory of files outside of the webroot to prevent users from direct linking them. You can use the Media view to pull the file from a special folder within /app/, allowing you to perform authentication before delivering the file to the user.
   
• 

  admin 00:19 on 2009-10-08 链接地址 | 回复  

  PHP内存溢出问题 

  最近在写PHP代码的时候，遇到下面问题
  PHP Fatal error: Allowed memory size of 33554432 bytes exhausted
  (tried to allocate 16 bytes) in memleak.php on line 17

  参考1：http://bugs.php.net/bug.php?id=33595
  参考2：http://blog.zol.com.cn/781/article_780182.html

  我自己在程序中，循环 $htmlObj = new simple_html_dom(); … unset($htmlObj); 却发现内存是放不掉。一直到内存耗尽，报出Fatal Error。

  对程序修改后，问题解决。
  $htmlObj = new simple_html_dom();
  …
  $htmlObj->__destruct();
  unset($htmlObj);

   
• 

  admin 10:55 on 2009-07-03 链接地址 | 回复
  Tags: Drupal   

  Drupal相关的书籍资源@51leifeng 

  Pro Drupal Development, Second Edition (PDF英文版)

  http://www.51leifeng.net/viewthread.php?tid=16436

  homessage

  Qqxxxxxx

   
• 

  admin 16:53 on 2009-06-30 链接地址 | 回复
  Tags: PHP ( 4 ), 书签   

  PHP相关书签 

  • FusionCharts Free – Animated Flash Charts and Graphs…
  • Drupal专业开发指南 | lamppr
  • Zend debugger 的配置安装 | zhupou.cn
  • PHPEye开源社区 – PHP教程|PHP5|PEAR|框架 – Powered by HappyCMS
  • drupal.org | Community plumbing
  • Joomla Hacks :: Joomla Components, Joomla Modules, Joomla…
  • More Than 2200 Free Joomla CMS Templates – Templates…
  • Joomla-开源天空
  • Joomla!之门 – Joomla!之门
  • Joomlatools – Training, consulting and extensions for Joomla
  • Joomla!™ 中国·中文·组件·模板
  • zend下载|zend studio下载|zend 注册机下载|zend…
  • Joomla!
  • PHPChina 开源社区门户 – PHP论坛|PHP教程|PHP源码|P…
  • PHP代码片段收集工具 – http://www.php-csl.com
   
• 

  admin 16:12 on 2009-06-30 链接地址 | 回复  

  PHP编写WEB程序的框架比较 

  中国都有哪些国产的PHP框架和使用人数最多的PHP框架[收集帖]