All Entries in the "database" Category
Basic Linux Commands | usefull for a webdeveloper
List Directory shell>ls Find a file or directory shell>find filename Edit a File shell>vi filename.txt Then file will be open, if you want to save that file then 1. press Esc 2. Type “:” (colon) 3. Type “wq” (w- write,q – quit) | Type “q!” (quit without save/write ) Mysql Prompt shell>mysql -u username [...]
Symfony 1.4 Doctrine Pagination
Doctrine Pagination is made very simple . public function executeIndex(sfWebRequest $request) { $this->pager = new sfDoctrinePager(‘TableName’, sfConfig::get(‘app_max_jobs_on_homepage’); $this->pager->setQuery(Doctrine::getTable(‘TableName’)->createQuery(‘a’)); $this->pager->setPage($request->getParameter(‘page’, 1)); $this->pager->init(); } Success page <?php foreach ($pager->getResults() as $post): ?><div> <?php if($post->getTitle()) { echo link_to($post->getTitle(), ‘news/fullstory?expand=’.$post->getId(),’class=”mhead”‘); } ?> <?php if($post->getDn2()!=”) { echo image_tag($post->getDn2()); } ?> <?php $content=$post->getContent(); $stripcontent=substr($content,” “,700); echo $stripcontent; ?> <div style=”display:block;” > [...]
PHP 6 upgrade : Advantages covered
PHP Personal Home Page now it is Hypertext Pre Processor. Version : 6 (PHP 6) Advantages, Addition of improved MySql Extension PHP 6 support Unicode, so that PHP 6 can handle all languages in the world. I faced lot of problems with ‘Malayalam’ font integration. PHP 6 cleans up a lot of garbbages that was [...]
My Cv page updated
Go through my cv page http://arunrajr.com/blog/my-cv/
How to create a directory structure ?
How to create a directory structure ? or How to creata a tree structure ? or How to design a database for a tree structure ? or How to design a database for storing hierarchical structure ? using single table Create a table like this CREATE TABLE `category` ( `id` int(11) NOT NULL auto_increment, `name` [...]
