CRUD application with Yii framework.

Please note that, this is a very minimal sample application done for a USER model using yii framework. How to run, 1 – Please download the attachment.  http://www.mediafire.com/download/qd8zjcc94b4h3gc/yiiDemo.zip 2 – Create a db called “demoYii” and import the script file named (demoYii.sql)...

NIC me, another andorid app

Happy to announce my android application which i have named as Nic Me (nik me).. A basic app which will give you the birth day and some other information ones you enter your NIC number. It is my second attempt with android and stuffs so may not be that professional and standadrd. Grin I have included...

No CHECK Constraint in MYSQL

It looks like MYSQL doesn’t really validate for check constraint. I checked for mysql manual and noticed its true. Copied the following section from MySQL manual. (http://dev.mysql.com/doc/refman/5.5/en/alter-table.html) The CHECK clause is parsed but ignored by all storage engines. See Section...

PHP has no FINALLY

I am so curious why PHP doesn’t have FINALLY block along with normal TRY CATCH blocks. It’s very much necessary and will let us stay away from code duplication. Finally is simply to do something at last after try catch block. Even if there is an exception finally will be called at last. class A...

Make case sensitive table names in MySQL database

Are table names in mysql case sensitive?  The answer is no. When you create a tabled called “User” or “USER”,  both are considered as “user” which means it’s not case sensitive. How can we force mysql to do this ? it’s a just matter of minor change in mysql ini file. Below given are...

MYSQL Table locking

his topic can be new to some but its very much important when working with concurrent access to a particular table row (record). for example lets say we have a inventory table which has some product details as records. now, a scenario arises like user purchases a product and we need to update its...

PHP Incrementing & Decrementing Operators

What is the meaning of ++ increment operator and - – decrement operator and how can we use it ? Below is a small explanation on what it does, ++$a means Pre-increment, It increments $a by one, then returns $a. $a++ means Post-increment, It returns $a, then increments $a by one. - – $a means...