TweetRecently, I got a situation where I needed to select only the first 50% (half) records from a database table. The constraint was that I could not use programming language to add a variable to the MySQL limit clause. Under normal circumstances the code would look something like this PLAIN TEXT PHP: // Connect to [...]
TweetDo you have a backup of your important mysql databases ? No ? Think about it .. What if you have a Operating System / Filesystem crash ? What if your databases get corrupted due to some reason ? What if you accidentally drop your database or some important tables ? What if you want [...]
TweetThese days I am getting more and more into Sphinx and falling in love with it . In this post we will see how to make use of SQL data source to create indexes. Sphinx has inbuilt support for MySQL and PostgreSQL databases. The drivers for these databases can connect to the database using its [...]
TweetIn the previous article, we learned how to setup Lithium and create a simple blog to add/edit/delete posts. Now, we will see how to add comments to the post and display them back on post view page. Unfortunately, Lithium doesn't support relationships yet, so we will query the comments table on our own. Let us [...]
Amit and his colleagues from SANIsoft were a great help in getting my web app idea from concept to production in no time at all.
- Tijs Teulings, Co-founder Automatique
SANIsoft offers PHP and CakePHP consulting. Whatever your need we can help you with your project. We build PHP/CakePHP web applications rapidly, all our developers are Zend Certified Engineers with excellent communication skills. If you are a developer yourself and need assistance with a project or best practices, we would be happy to help.
Contact us for PHP and CakePHP consulting.
SANIsoft © 2011
Argue for your limitations and sure enough they are yours - Richard Bach