Hi Google, please index thse sites:
http://centralsquareballarat.com.au/
http://www.beatriceoffor.com.au/
Archive for March, 2007
Dan McKee posted a comment on this site asking if I could modify my byte calculator widget to allow decimal places. I managed to get it done fairly easily but in the end I kind of re-wrote so its better. This new version has the following new features:
- No need for a select box/input box - just type in the unit you want to convert from and the other fields will automatically convert.
- easily copy the converted value to the clipboard by focusing on the field (mouse click or tab)
- Decimal points allowed (only one) and a better mothod of number input validation is used.
Click on the screenshot to download.
I’m a bit excited about CS3 coming later this month. I’m so excited that I’ve scribbled down some of the features I’m dreaming of:
Dreamweaver:
- Faster, better FTP - no timeouts would be ideal!
- The ability to view ftp passwords or have an option so that passwords arn’t encrypted at all. I don’t know how many times I’ve lost my password for a site and my only copy in dreamweaver. The way firefox handles passwords would be ideal - one password that handles them all.
- Universal Version
- validate php/php debugger with breakpoints
- CVS support
- A Linux version
Flash:
- Some sort of bone system so that characters could be easily animated and distorted.
- A Universal version
- A Linux version
Sometimes when I'm developing a website I might have a string of id values that are comma delimited and want to extract related data from a database. What I could do is explode the string into an array and then run multiple queries by looping through the array. While this works find, its not ideal to query the database so many times. What you can do is loop through the array and create a single query. What I normally do is use the implode function to create the single query.
So anyway, here is some code:
CODE:
-
$ids = "1,2,3,4,5";
-
$idarray = explode(",",$ids);
-
$sql = "SELECT * FROM users WHERE id='".implode("' OR id='",$idarray)."'";
So thats fairly simple, saves having a 'while' loop or a 'for' loop and concatenating a string. Its also helpful if you have multiple queries that have an additional condition. For example you might want to test if each user is active. You example...
CODE:
-
$ids = "1,2,3,4,5";
-
$idarray = explode(",",$ids);
-
$sql = "SELECT * FROM users WHERE active='y' AND id='".implode("' OR active='y' AND id='",$idarray)."'";
