use or_like with where condition in codeigniter

$this->db->like('body', $body);$this->db->or_like('author', $author);
You can do it like this

$this->db->where('id', $id);
$this->db->where('(`title` LIKE \'%'.$title.'%\' OR `body` LIKE \'%'.$body.'%\' OR `author` LIKE \'%'.$author.'%\')', NULL, FALSE);

Comments

Post a Comment

Popular posts from this blog

Various platform for PHP Development

Cross-platform Aptana Studio – Eclipse-based IDE, able to use PDT plugins, visual JS editor. Open-source, free project. (Community edition merged in). Bluefish – A multipurpose editor with PHP syntax support, in-line PHP documentation, etc. With GVFS, supports SFTP, FTP, WebDAV, and SMB. CodeLite – an open source, cross platform IDE for C/C++ and PHP. The built-in plugins supports SVN, SSH/SFTP access, Git database browsing and others. Eclipse – PHPEclipse and PHP Development Tools projects. With additional plugins supports SVN, CVS, database modelling, SSH/FTP access, database navigation, Trac integration, and others. Editra – Versatile open source editor. Syntax highlighting and (partial) code completion for PHP + HTML and other IDE-like features like code browser etc. Emacs – Advanced text editor. The nXhtml addon has special support for PHP (and other template languages). The major mode web-mode.el is designed for editing mixed HTML templates. Geany – Syntax highlighting for HTML +...
Read more

Enable the imap in support in xampp server

As default, the IMAP support for PHP is deactivated in XAMPP due to some mysterious initialization errors with some home versions like Windows 98. If you work with NT systems, you can open the file "\xampp\php\php.ini" to activate the php exstension by removing the beginning semicolon at the line ";extension=php_imap.dll". It should be: extension=php_imap.dll Now restart Apache and IMAP should work. You can use the same steps for every extension, which is not enabled in the default configuration.
Read more