Make lowercase followed by uppercase data

Question : I have table A with field id, name and address. The data in name field seem not consistent, big letter name sometime found in record. How to update that field with uppercase in name field. For example :                  id              name                                       address                  1               FreAKHolicz  wORker            the moon                  2              tHE atMOSFER bluEZ            …

More

Export picture from mysql database to file

[amazonify]032152599X:left[/amazonify] As our data getting mobile and copying picture is annoying for me I decide to save the picture in the database (mysql). Another challenge came when other division need the data exported in a directory with same dimension (135 x 180 pixel). Structure for table ‘student_pic’  : CREATE TABLE `student_pic` (   `image_id` int(10) …

More

PHP 5.2.5 Released, 7 security enhancements & fixes

From php.net The PHP development team would like to announce the immediate availability of PHP 5.2.5. This release focuses on improving the stability of the PHP 5.2.x branch with over 60 bug fixes, several of which are security related. All users of PHP are encouraged to upgrade to this release. Further details about the PHP …

More

Create Paging with PHP : Link collection

Soon or later everyone who learn php will face this thing : ‘paging‘ blog, guest book, search result are using paging for displaying data. Make it easy to read and more friendly some picture of paging implementation :    Good paging code will survive when record in database or file system getting bigger. many url …

More

Beware, wordpress exploit released, upgrade your wordpress!

From milw0rm exploits : # Pwnpress implements multiple techniques, bugs and tricks for compromising # WordPress-based blogs, combining the exploits in the necessary order for # retrieving any necessary information to make the exploitation process as # reliable as possible. # # Covertness capability is provided, dynamically adapting the payloads and # operations to lower …

More