DHH on PHP

src: http://www.loudthinking.com/posts/23-the-immediacy-of-php

Even David Heinemeier Hansson himself talks about using PHP.

40 ways to optimize php code

Wonderful link!

http://reinholdweber.com/?p=3

how to change phpmyadmin theme

I just don’t want the default theme that came in with PHPMyAdmin they are huge and my eyes hurt when I look at them. If you are like me that doesn’t want to take extra step to develop themes and just want to have it appear smaller then this procedure is for you.

• Got to http://www.phpmyadmin.net/home_page/downloads.php?themes and download your selected themes there
• Unzip it to c:\<path to xampp> \phpmyadmin\themes
• Reload PhpMyAdmin or refresh if you are still using IE by now. :D
• Choose your theme in the home page of phpMyAdmin mine is at http://localhost:8080/phpmyadmin

Enjoy!

resetting the auto_increment field in mysql

Oftentimes one needs to test web application to see if it works. But during those times one doesn’t have to retain all of the test data and after you delete the test data the auto_increment field(mostly id’s) don’t reset itself.

Here is a way to reset the auto_increment column in your mysql database:

alter table account auto_increment=4;

Guessing that I have 3 accounts I wanted to retain.

find the next auto_increment number in mysql

Finding the next auto_increment is easy on phpmyadmin. Just select your database from the left side dropdown box. Then select the table on the lower part of it. Then click structure.

But what if it’s in mysql? or in PHP?
In PHP:

<?
$tablename         = “tablename”;
$next_increment     = 0;
$qShowStatus         = “SHOW TABLE STATUS LIKE ‘$tablename’”;
$qShowStatusResult     = mysql_query($qShowStatus) or die ( “Query failed: ” . mysql_error() . “<br/>” . $qShowStatus );

$row = mysql_fetch_assoc($qShowStatusResult);
$next_increment = $row['Auto_increment'];

echo “next increment number: [$next_increment]“;
?>

source: http://blog.jamiedoris.com/geek/560/

In MySQL prompt:

SHOW TABLE STATUS LIKE ‘tablename’;

php mysql interview questions and answers

See:

PHP-MySQL Interview Question « Boolean Dreams

nailed around 95% of the questions without looking for answers. Helpful so go and read.

Powered by ScribeFire.

my first dip onto cake

21 things I learned about CakePHP – Avatar Financial Group

Few days ago I have been experimenting about PHP frameworks that would be the best candidate for my projects. After CodeIgniter CakePHP comes in second for the test. Have read this blog and will soon be posting all my notes on this.

Powered by ScribeFire.

PHP 6

Minutes PHP Developers Meeting

Got this link from my friend who befriends google always. It talks about the next PHP release.

powered by performancing firefox

notable security blogs in php and mysql

Been an avid fan of Chris’ blog at shiflett.org here is one of my favorite.

http://shiflett.org/archive/255

top two php security practises

filter input
escape output

These two security patches has been devised by Chris Shiflett  and can be found here. Generally these are the basic security measures one can take to provide the most common attack a stop on php applications.