CakePHP RSS FeedCategories:
Blogging on Cake
November 09, 2007
It's been hard to blog about cake lately, which is why I have not. Any nifty new tricks I find are obsolete within a few weeks it seems. Cake is really changing rapidly these days, the devs are really working hard. Sorry about the lack of postings.
<br/>
<br/>Hopefully once the coding slows down and the cake code stabilizes I will be able to start posting cool things. Until then I really just don't see the point.
<br/>
<br/>-Rob
0 Comments >>
Tags:
CakePHP
Finding your ingredients in CakePHP
August 14, 2007
Ever get stuck trying to write code and don't know where to look? If you know the right way to find information within the cake community, you can save yourself time. Not only do you not have to wait for someone to help you, usually you find information you were not looking for.
<br/>
<br/>Some folks just hop right on IRC and start asking. Others post to groups, without even searching anywhere. There is a chain of command for these things. Many times people have already written articles on what you are looking for. You just have to know how to find what they have written.
<br/>
<br/>Here are my 5 easy steps to finding out what you want to know about CakePHP.
<br/>
<br/>Step 1. <strong>Search the <a href="http://bakery.cakephp.org/">Bakery</a></strong> - A lot of people have put a lot of time into putting a lot of good code onto the Bakery. It goes through an approval proccess by the cake developers. 80% of the time you'll find a cure for what ails you right here.
<br/>
<br/>Step 2. <strong>Search <a href="http://groups.google.com/group/cake-php">Groups</a></strong> - Chances are if you are having a problem, someone else has had this same problem before you. Most times a solution is also posted
<br/>
<br/>Step 3. <strong>Search the <a href="http://www.google.com/coop/cse?cx=006850030468302103399:mqxv78bdfdo">Blogs</a></strong> - There is a CakePHP custom search maintained by Ritesh that only searches a list of known Blogs. The many smart people within the Cake community discover new features and ways of doing things They post their findings on their blogs. Using this modern technology called the internet, you are able to go read what they have posted.
<br/>
<br/>Step 4. <strong>Ask for help</strong> - Depending on your problem it may be easier to ask on Groups or on IRC. I tend to ask smaller simpler questions on IRC. Things that are a bit more complex and take more to explain, I like to ask on Groups. If you are asking questions on IRC, try not to be a <a href="http://slash7.com/pages">drain</a>. People who help on there are not paid and only help because of their love for CakePHP. Technically it is your problem and it is really on you to solve it, not them.
<br/>
<br/>Step 5. <strong>Take the Cake apart</strong> - Sometimes even asking for help does not work. This is when you really have to start getting your hands dirty. You have to dive into Cake and find out what is going on for yourself. Add print statements, modify the cake core to see how things change. I have a sandbox set separate from my production sites. I use this whenever I need to experiment with Cake. This is far and away the best way to learn about Cake any ways.
<br/>
<br/>There you have it. Happy Baking.
4 Comments >>
Tags:
CakePHP
Model Field Names
July 30, 2007
Sometimes I've needed to get a list of fields that a Model's table has. This is a little function that I have in my AppModel just to make getting the list of fields easy.
<br/>
<br/>Dont forget, if you just want to know about one field, you can use the already builtin Model->hasField($name)
<br/>
<br/><div class="code"><pre><span class="cp"><?php</span>
<span class="k">class</span> <span class="nc">AppModel</span> <span class="k">extends</span> <span class="nx">Model</span> <span class="p">{</span>
<span class="c">/**</span>
<span class="c"> * Get a list of all fields of a the table this model is associated with</span>
<span class="c"> * @param bool, prefix all values with the name of this model eg: Model.fieldname </span>
<span class="c"> * @return array non-associative array with field names as values</span>
<span class="c"> * @author rtconner</span>
<span class="c"> */</span>
<span class="k">function</span> <span class="nf">fieldNames</span><span class="p">(</span><span class="nv">$prefix</span><span class="o">=</span><span class="k">false</span><span class="p">)</span> <span class="p">{</span>
<span class="k">if</span> <span class="p">(</span><span class="k">empty</span><span class="p">(</span><span class="nv">$this</span><span class="o">-></span><span class="na">_tableInfo</span><span class="p">))</span> <span class="p">{</span>
<span class="nv">$this</span><span class="o">-></span><span class="na">loadInfo</span><span class="p">();</span>
<span class="p">}</span>
<span class="nv">$arr</span> <span class="o">=</span> <span class="nf">array_keys</span><span class="p">(</span><span class="nv">$this</span><span class="o">-></span><span class="na">_tableInfo</span><span class="o">-></span><span class="na">combine</span><span class="p">(</span><span class="s1">'{n}.name'</span><span class="p">));</span>
<span class="k">if</span><span class="p">(</span><span class="nv">$prefix</span><span class="p">)</span> <span class="p">{</span>
<span class="nv">$func</span> <span class="o">=</span> <span class="nf">create_function</span><span class="p">(</span><span class="s1">'&$a, $key, &$obj'</span><span class="p">,</span> <span class="s1">'$a = $obj->escapeField($a);'</span><span class="p">);</span>
<span class="nf">array_walk</span><span class="p">(</span><span class="nv">$arr</span><span class="p">,</span> <span class="nv">$func</span><span class="p">,</span> <span class="nv">$this</span><span class="p">);</span>
<span class="p">}</span>
<span class="k">return</span> <span class="nv">$arr</span><span class="p">;</span>
<span class="p">}</span>
<span class="p">}</span>
<span class="cp">?></span><span class="x"></span>
</pre></div>
<div style='display:none'><?php
<br/>class AppModel extends Model {
<br/>
<br/> /**
<br/> * Get a list of all fields of a the table this model is associated with
<br/> * @param bool, prefix all values with the name of this model eg: Model.fieldname
<br/> * @return array non-associative array with field names as values
<br/> * @author rtconner
<br/> */
<br/> function fieldNames($prefix=false) {
<br/> if (empty($this->_tableInfo)) {
<br/> $this->loadInfo();
<br/> }
<br/>
<br/> $arr = array_keys($this->_tableInfo->combine('{n}.name'));
<br/> if($prefix) {
<br/> $func = create_function('&$a, $key, &$obj', '$a = $obj->escapeField($a);');
<br/> array_walk($arr, $func, $this);
<br/> }
<br/> return $arr;
<br/> }
<br/>}
<br/>
<br/>?></div>
0 Comments >>
Tags:
CakePHP
Rendering and not rendering
July 28, 2007
One of the most common questions I see on IRC is "How do I stop the view from displaying?".
<br/>
<br/>The controller has a handy little attribute <em>autoRender</em>, setting it to false will stop the view from being displayed.
<br/>
<br/>Also using the <em>render(...)</em> method automatically sets autoRender to false. This is handy if you want to another view aside from the default one for an action.
<br/>
<br/>Some example code:
<br/><div class="code"><pre><span class="cp"><?php</span>
<span class="c">// in a controllers action</span>
<span class="nv">$this</span><span class="o">-></span><span class="na">autoRender</span> <span class="o">=</span> <span class="k">false</span><span class="p">;</span>
<span class="nf">header</span><span class="p">(</span><span class="s1">'Content-type: application/pdf'</span><span class="p">);</span>
<span class="nf">readfile</span><span class="p">(</span><span class="s1">'/path/tp/pdf_file'</span><span class="p">);</span>
<span class="c">// or say you want to render an element as a view. </span>
<span class="c">// maybe you are using ajax</span>
<span class="k">if</span><span class="p">(</span><span class="nv">$this</span><span class="o">-></span><span class="na">RequestHandler</span><span class="o">-></span><span class="na">isAjax</span><span class="p">())</span> <span class="p">{</span> <span class="c">// is a cake component</span>
<span class="nv">$this</span><span class="o">-></span><span class="na">viewPath</span> <span class="o">=</span> <span class="s1">'elements'</span><span class="o">.</span><span class="nx">DS</span><span class="o">.</span><span class="s1">'products'</span><span class="p">;</span>
<span class="nv">$this</span><span class="o">-></span><span class="na">render</span><span class="p">(</span><span class="s1">'product_table'</span><span class="p">,</span> <span class="s1">'ajax'</span><span class="p">);</span>
<span class="p">}</span>
<span class="cp">?></span><span class="x"></span>
</pre></div>
<div style='display:none'><?php
<br/>
<br/>// in a controllers action
<br/>$this->autoRender = false;
<br/>header('Content-type: application/pdf');
<br/>readfile('/path/tp/pdf_file');
<br/>
<br/>// or say you want to render an element as a view.
<br/>// maybe you are using ajax
<br/>if($this->RequestHandler->isAjax()) { // is a cake component
<br/> $this->viewPath = 'elements'.DS.'products';
<br/> $this->render('product_table', 'ajax');
<br/>}
<br/>
<br/>?></div>
<br/>
<br/>Some links:
<br/><a href="http://api.cakephp.org/1.2/class_controller.html#90046e6b62c91452a987c9573372c2ac">Controller::render</a> [api.cakephp.org]
<br/><a href="http://api.cakephp.org/1.2/class_request_handler_component.html">RequestHandler</a> [api.cakephp.org]
<br/>
<br/>-rtconner
0 Comments >>
Tags:
CakePHP,
PHP
Static Data Helper
July 27, 2007
<strong>Static Data in my Database?</strong> Why would I want to store data in the database that never changes?
<br/>
<br/><strong>First,</strong> with proper usage you can minimize the load on your database server by permanently caching the results of the queries.
<br/><strong>Secondly,</strong> it becomes easy to JOIN to when you do need it. You never should need it though.
<br/><strong>Third,</strong> it becomes very easy for you as a developer to get data from a single row or get a full list of data with which you can create a <SELECT> dropdown.
<br/><strong>Fourth,</strong> It becomes exceedingling easy to say add a 51st state to your website. Just add a row to the table, and delete the cache. Perhaps adding an Order status at the request of a customer is a more common thing.
<br/>
<br/>A very simple to understand example of this is states. All you need to do is store all states in your database, and say you want to store where each user in your system lives. In the <em>Users</em> table create a <em>state_id</em> field. After you have installed the Helper, you can simply call <em><?= $static->status($User, 'name'); ?></em> to get the name of the state. This will not query your database, and will add zero extra load onto your database server. And notice how easy it was for you to write in code.
<br/>
<br/>Some real life usage examples
<br/><div class="code"><pre><span class="x"><!-- it's easy to make dropdown to choose a country --></span>
<span class="cp"><?php</span> <span class="k">echo</span> <span class="nv">$form</span><span class="o">-></span><span class="na">input</span><span class="p">(</span><span class="s1">'country_id'</span><span class="p">,</span> <span class="k">array</span><span class="p">(</span><span class="s1">'options'</span> <span class="o">=></span> <span class="nv">$static</span><span class="o">-></span><span class="na">countries</span><span class="p">(</span><span class="s1">'id'</span><span class="p">,</span> <span class="s1">'name'</span><span class="p">)));</span> <span class="cp">?></span><span class="x"></span>
<span class="x"><!-- quickly get the description of the status with ID = 40 --></span>
<span class="cp"><?php</span> <span class="k">echo</span> <span class="nv">$static</span><span class="o">-></span><span class="na">status</span><span class="p">(</span><span class="m">40</span><span class="p">,</span> <span class="s1">'desc'</span><span class="p">);</span> <span class="cp">?></span><span class="x"></span>
<span class="x"><!-- dropdown of abbreviated states (NY, CA, etc) --></span>
<span class="cp"><?</span><span class="o">=</span> <span class="nv">$form</span><span class="o">-></span><span class="na">select</span><span class="p">(</span><span class="s1">'user/state_id'</span><span class="p">,</span> <span class="nv">$static</span><span class="o">-></span><span class="na">states</span><span class="p">(</span><span class="s1">'id'</span><span class="p">,</span> <span class="s1">'abbrev'</span><span class="p">),</span> <span class="nv">$user</span><span class="p">[</span><span class="s1">'User'</span><span class="p">][</span><span class="s1">'state_id'</span><span class="p">]);</span> <span class="cp">?></span><span class="x"></span>
</pre></div>
<div style='display:none'><!-- it's easy to make dropdown to choose a country -->
<br/><?php echo $form->input('country_id', array('options' => $static->countries('id', 'name'))); ?>
<br/>
<br/><!-- quickly get the description of the status with ID = 40 -->
<br/><?php echo $static->status(40, 'desc'); ?>
<br/>
<br/><!-- dropdown of abbreviated states (NY, CA, etc) -->
<br/><?= $form->select('user/state_id', $static->states('id', 'abbrev'), $user['User']['state_id']); ?>
<br/></div>
<br/>
<br/>Sorry, you have to get the data to put into your database on your own. This Helper will cache the data from that data for 1 year, making it so the data is almost never selected from your database.
<br/>
<br/>Installation1. Take the code below and put it into the file app/views/helpers/static.php
<br/>2. Config the file if you want (I suggest changing the $tmp_folder var)
<br/>3. In your controller add <em>var $helpers = array('Static');
<br/>
<br/>The Code (intended to go in a helper named static.php)
<br/><div class="code"><pre><span class="cp"><?php</span>
<span class="c">/**</span>
<span class="c"> * CakePHP Helper to handle use of data in database that never changes</span>
<span class="c"> * </span>
<span class="c"> * array plural($order, $field='name'); // ready for use in FormHelper::select</span>
<span class="c"> * string singular($id, $field='name');</span>
<span class="c"> * </span>
<span class="c"> * usage examples (in Views):</span>
<span class="c"> * </span>
<span class="c"> * $static->states('abbrev'); // all states sorted by abbrev</span>
<span class="c"> * $static->statuses('id', 'name'); // get list of all status names, sorted by id </span>
<span class="c"> * $static->status(40, 'desc'); // description of status with id 40</span>
<span class="c"> * $status->countries(); // get all countries sorted by id</span>
<span class="c"> * </span>
<span class="c"> * @author Rob Conner aka rtconner</span>
<span class="c"> */</span>
<span class="k">class</span> <span class="nc">StaticHelper</span> <span class="k">extends</span> <span class="nx">Helper</span> <span class="p">{</span>
<span class="c">// set this to a folder within your app/tmp folder to store the data (no trailing slash)</span>
<span class="k">var</span> <span class="nv">$tmp_folder</span> <span class="o">=</span> <span class="s1">'cache'</span><span class="p">;</span>
<span class="k">var</span> <span class="nv">$cache_expires</span> <span class="o">=</span> <span class="s1">'+1 Year'</span><span class="p">;</span>
<span class="k">var</span> <span class="nv">$database</span> <span class="o">=</span> <span class="s1">'default'</span><span class="p">;</span>
<span class="c">//plural only please, will enable both plural and singular methods (status needs to be added to inflections.php)</span>
<span class="k">var</span> <span class="nv">$methods</span> <span class="o">=</span> <span class="k">array</span><span class="p">(</span><span class="s1">'states'</span><span class="p">,</span> <span class="s1">'countries'</span><span class="p">,</span> <span class="s1">'statuses'</span><span class="p">);</span>
<span class="k">function</span> <span class="nf">__call</span><span class="p">(</span><span class="nv">$method</span><span class="p">,</span> <span class="nv">$args</span><span class="p">)</span> <span class="p">{</span>
<span class="nv">$plural</span> <span class="o">=</span> <span class="nx">Inflector</span><span class="o">::</span><span class="na">pluralize</span><span class="p">(</span><span class="nv">$method</span><span class="p">);</span>
<span class="k">if</span><span class="p">(</span><span class="nf">in_array</span><span class="p">(</span><span class="nv">$plural</span><span class="p">,</span> <span class="nv">$this</span><span class="o">-></span><span class="na">methods</span><span class="p">))</span> <span class="p">{</span>
<span class="nf">array_unshift</span><span class="p">(</span><span class="nv">$args</span><span class="p">,</span> <span class="nv">$method</span><span class="p">);</span>
<span class="k">if</span><span class="p">(</span><span class="nv">$plural</span><span class="o">==</span><span class="nv">$method</span><span class="p">)</span> <span class="c">// return list of all static items</span>
<span class="k">return</span> <span class="nf">call_user_func_array</span><span class="p">(</span><span class="k">array</span><span class="p">(</span><span class="o">&</span><span class="nv">$this</span><span class="p">,</span> <span class="s1">'all'</span><span class="p">),</span> <span class="nv">$args</span><span class="p">);</span>
<span class="k">else</span> <span class="c">// return single item</span>
<span class="k">return</span> <span class="nf">call_user_func_array</span><span class="p">(</span><span class="k">array</span><span class="p">(</span><span class="o">&</span><span class="nv">$this</span><span class="p">,</span> <span class="s1">'row'</span><span class="p">),</span> <span class="nv">$args</span><span class="p">);</span>
<span class="p">}</span> <span class="k">else</span> <span class="c">// try to imitate php's errors</span>
<span class="nf">trigger_error</span><span class="p">(</span><span class="nf">sprintf</span><span class="p">(</span><span class="s1">'Call to undefined function: %s::%s().'</span><span class="p">,</span> <span class="nf">get_class</span><span class="p">(</span><span class="nv">$this</span><span class="p">),</span> <span class="nv">$method</span><span class="p">),</span> <span class="nx">E_USER_ERROR</span><span class="p">);</span>
<span class="p">}</span>
<span class="c">/**</span>
<span class="c"> * @param string $table to get list from</span>
<span class="c"> * @param string $order sort order of list</span>
<span class="c"> * @param string $field field data to return</span>
<span class="c"> * @return array</span>
<span class="c"> */</span>
<span class="k">function</span> <span class="nf">all</span><span class="p">(</span><span class="nv">$table</span><span class="p">,</span> <span class="nv">$order</span><span class="o">=</span><span class="s1">'id'</span><span class="p">,</span> <span class="nv">$field</span><span class="o">=</span><span class="s1">'name'</span><span class="p">)</span> <span class="p">{</span>
<span class="nv">$cache_name</span> <span class="o">=</span> <span class="nv">$this</span><span class="o">-></span><span class="na">tmp_folder</span><span class="o">.</span><span class="nx">DS</span><span class="o">.</span><span class="nv">$table</span><span class="o">.</span><span class="s1">'_'</span><span class="o">.</span><span class="nv">$order</span><span class="o">.</span><span class="s1">'_'</span><span class="o">.</span><span class="nv">$field</span><span class="p">;</span>
<span class="nv">$cache_data</span> <span class="o">=</span> <span class="nx">cache</span><span class="p">(</span><span class="nv">$cache_name</span><span class="p">,</span> <span class="k">null</span><span class="p">,</span> <span class="nv">$this</span><span class="o">-></span><span class="na">cache_expires</span><span class="p">,</span> <span class="s1">'tmp'</span><span class="p">);</span>
<span class="k">if</span> <span class="p">(</span><span class="k">empty</span><span class="p">(</span><span class="nv">$cache_data</span><span class="p">))</span> <span class="p">{</span>
<span class="nv">$db</span> <span class="o">=&</span> <span class="nx">ConnectionManager</span><span class="o">::</span><span class="na">getDataSource</span><span class="p">(</span><span class="nv">$this</span><span class="o">-></span><span class="na">database</span><span class="p">);</span>
<span class="nv">$table</span> <span class="o">=</span> <span class="nx">Inflector</span><span class="o">::</span><span class="na">tableize</span><span class="p">(</span><span class="nv">$table</span><span class="p">);</span>
<span class="nv">$qs</span> <span class="o">=</span> <span class="s1">'SELECT * FROM `'</span><span class="o">.</span><span class="nv">$table</span><span class="o">.</span><span class="s1">'` ORDER BY `'</span><span class="o">.</span><span class="nv">$order</span><span class="o">.</span><span class="s1">'`;'</span><span class="p">;</span>
<span class="nv">$results</span> <span class="o">=</span> <span class="nv">$db</span><span class="o">-></span><span class="na">fetchAll</span><span class="p">(</span><span class="nv">$qs</span><span class="p">,</span> <span class="k">false</span><span class="p">,</span> <span class="s1">'States'</span><span class="p">);</span>
<span class="nv">$list</span> <span class="o">=</span> <span class="k">array</span><span class="p">();</span>
<span class="k">foreach</span><span class="p">(</span><span class="nv">$results</span> <span class="k">as</span> <span class="nv">$r</span><span class="p">)</span>
<span class="nv">$list</span><span class="p">[</span><span class="nv">$r</span><span class="p">[</span><span class="nv">$table</span><span class="p">][</span><span class="s1">'id'</span><span class="p">]]</span> <span class="o">=</span> <span class="nv">$r</span><span class="p">[</span><span class="nv">$table</span><span class="p">][</span><span class="nv">$field</span><span class="p">];</span>
<span class="nv">$cache_data</span> <span class="o">=</span> <span class="nx">cache</span><span class="p">(</span><span class="nv">$cache_name</span><span class="p">,</span> <span class="nf">serialize</span><span class="p">(</span><span class="nv">$list</span><span class="p">),</span> <span class="nv">$this</span><span class="o">-></span><span class="na">cache_expires</span><span class="p">,</span> <span class="s1">'tmp'</span><span class="p">);</span>
<span class="p">}</span>
<span class="k">return</span> <span class="o">@</span><span class="nf">unserialize</span><span class="p">(</span><span class="nv">$cache_data</span><span class="p">);</span>
<span class="p">}</span>
<span class="c">/**</span>
<span class="c"> * @param string $table to get row from</span>
<span class="c"> * @param string $field name to return (ex: name, abbrev, etc)</span>
<span class="c"> * @param int $id primary id or item in row</span>
<span class="c"> * @return string $value</span>
<span class="c"> */</span>
<span class="k">function</span> <span class="nf">row</span><span class="p">(</span><span class="nv">$table</span><span class="p">,</span> <span class="nv">$id</span><span class="p">,</span> <span class="nv">$field</span><span class="o">=</span><span class="s1">'name'</span><span class="p">)</span> <span class="p">{</span>
<span class="nv">$all</span> <span class="o">=</span> <span class="nv">$this</span><span class="o">-></span><span class="na">all</span><span class="p">(</span><span class="nv">$table</span><span class="p">,</span> <span class="nv">$field</span><span class="p">);</span>
<span class="k">return</span> <span class="nf">array_key_exists</span><span class="p">(</span><span class="nv">$id</span><span class="p">,</span> <span class="nv">$all</span><span class="p">)</span>
<span class="o">?</span> <span class="nv">$all</span><span class="p">[</span><span class="nv">$id</span><span class="p">]</span>
<span class="o">:</span> <span class="k">null</span><span class="p">;</span>
<span class="p">}</span>
<span class="p">}</span>
</pre></div>
<div style='display:none'><?php
<br/>/**
<br/> * CakePHP Helper to handle use of data in database that never changes
<br/> *
<br/> * array plural($order, $field='name'); // ready for use in FormHelper::select
<br/> * string singular($id, $field='name');
<br/> *
<br/> * usage examples (in Views):
<br/> *
<br/> * $static->states('abbrev'); // all states sorted by abbrev
<br/> * $static->statuses('id', 'name'); // get list of all status names, sorted by id
<br/> * $static->status(40, 'desc'); // description of status with id 40
<br/> * $status->countries(); // get all countries sorted by id
<br/> *
<br/> * @author Rob Conner aka rtconner
<br/> */
<br/>class StaticHelper extends Helper {
<br/>
<br/> // set this to a folder within your app/tmp folder to store the data (no trailing slash)
<br/> var $tmp_folder = 'cache';
<br/>
<br/> var $cache_expires = '+1 Year';
<br/>
<br/> var $database = 'default';
<br/>
<br/> //plural only please, will enable both plural and singular methods (status needs to be added to inflections.php)
<br/> var $methods = array('states', 'countries', 'statuses');
<br/>
<br/> function __call($method, $args) {
<br/> $plural = Inflector::pluralize($method);
<br/> if(in_array($plural, $this->methods)) {
<br/> array_unshift($args, $method);
<br/> if($plural==$method) // return list of all static items
<br/> return call_user_func_array(array(&$this, 'all'), $args);
<br/> else // return single item
<br/> return call_user_func_array(array(&$this, 'row'), $args);
<br/> } else // try to imitate php's errors
<br/> trigger_error(sprintf('Call to undefined function: %s::%s().', get_class($this), $method), E_USER_ERROR);
<br/> }
<br/>
<br/> /**
<br/> * @param string $table to get list from
<br/> * @param string $order sort order of list
<br/> * @param string $field field data to return
<br/> * @return array
<br/> */
<br/> function all($table, $order='id', $field='name') {
<br/> $cache_name = $this->tmp_folder.DS.$table.'_'.$order.'_'.$field;
<br/> $cache_data = cache($cache_name, null, $this->cache_expires, 'tmp');
<br/>
<br/> if (empty($cache_data)) {
<br/>
<br/> $db =& ConnectionManager::getDataSource($this->database);
<br/>
<br/> $table = Inflector::tableize($table);
<br/> $qs = 'SELECT * FROM `'.$table.'` ORDER BY `'.$order.'`;';
<br/>
<br/> $results = $db->fetchAll($qs, false, 'States');
<br/>
<br/> $list = array();
<br/> foreach($results as $r)
<br/> $list[$r[$table]['id']] = $r[$table][$field];
<br/>
<br/> $cache_data = cache($cache_name, serialize($list), $this->cache_expires, 'tmp');
<br/> }
<br/>
<br/> return @unserialize($cache_data);
<br/> }
<br/>
<br/> /**
<br/> * @param string $table to get row from
<br/> * @param string $field name to return (ex: name, abbrev, etc)
<br/> * @param int $id primary id or item in row
<br/> * @return string $value
<br/> */
<br/> function row($table, $id, $field='name') {
<br/> $all = $this->all($table, $field);
<br/> return array_key_exists($id, $all)
<br/> ? $all[$id]
<br/> : null;
<br/> }
<br/>
<br/>}
<br/></div></em>
0 Comments >>
Tags:
CakePHP,
PHP