mySQL indices, normalization and other tips

PHP Diary | Script School | PHP Scripts | TD Scripts.com

Online Offline Manager - Show the online/offline status of a group of users on a webpage

[back]

04/27/01 "mySQL indices, normalization - password retrieval"

Mouseovers using PHP only?

I am new to PHP Scripting. Is there any way to give mouse over effect using PHP Script without using Javascript?

PHP is a server side language, meaning you can only do things on the server side. When you move your mouse on your computer over an image you are doing something on the client side, therefore you'd need to check for the mouseover using JavaScript or VBscript (VB script is IE only, so JS is better). You can, however, create dynamic graphics using PHP using the gd library. There is a great chapter in the book Core PHP Programming by Leon Atkinson that shows how to do this. It is one of the reference books I suggest people new to PHP pick up. See this diary entry for more information: http://www.php-scripts.com/php_diary/072800.php3

Submit your question by clicking here

mySQL Normalization

Here's an excellent tutorial on mySQL database normalization: http://www.phpbuilder.com/columns/barry20000731.php3 by Barry Wise.

mySQL Indices

Here's an article on the proper use of indices in tables and their effectiveness. http://www.phpbuilder.com/columns/tim20010110.php3 by Tim Perdue. Bullet points from his article:

create indices on any field used in a WHERE clause

Password Retrieval Tools

Not quite about PHP, but useful, so I've included here ... have you forgotten what the ***** is in some of your local passwords? I recently got a new machine and had a few of those I needed to remember. Here's a slick FREE utility a friend sent me a link to which will help you retrieve them called snadboy's revelation (the url I found to the author of this program is now 404 snadboy.com :( if anybody knows the new URL for this author, please let me know so I can put up a link to their site):

http://www.zdnet.com/downloads/stories/info/0,,0013XM,.html

I understand it doesn't work with Windows ME or Windows 2000, but you probably haven't upgraded to that yet, right?

Please vote on the usefulness of this diary entry so other people will know if it is worth their time to read :)

[back] 04/27/01 "mySQL indices and normalization and password retrieval" [next]

PHP Diary | Script School | PHP Scripts | TD Scripts.com