Archive | June, 2002

Save Money – Surf the web by Satellite

Posted on 26 June 2002 by Demian Turner

According to this article, you can now contract your web connection by satellite (at a zippy 768 Kbit/s) for the equivalent of only USD 20 per month.

The catch – you have to be a resident of Germany. Hope that comes to my country soon 😉

Comments (2)

Simplicity is Best: Interface Design

Posted on 19 June 2002 by Demian Turner

From Jacob Nielsen’s
User interface complexity increases when a single feature or hypertext link is presented in multiple ways. Users rarely understand duplicates as such, and often waste time repeating efforts or visiting the same page twice by mistake.

Comments (0)

Dictionary Lookup Block

Posted on 18 June 2002 by Demian Turner

Another PHP block – look up a word at in a new window. Very simple code, just plain HTML I’m afraid:

<div align=”center”>
<form name=”dictionary” method=”get” action=”” target=”new”>
<input type=”text” name=”q”><BR>
<input type=”submit” name=”submit” value=”get definition”>

Comments (1)

Very Nice dHTML Calendar

Posted on 12 June 2002 by Demian Turner

While not exactly being PHP, this freeware dHTML calendar will doubtless come in handy for any date-related app.

After searching some time for a popup date picker for a project, I realised that I am unable to find one which at the same time has a layout that caught my eyes, and one that can fulfill the minimum requirement of cross browser compatibility and user friendliness. At the same time, I am beginning to be awed by the ability of DHTML, hence set myself this project to do after my work during my free time.

Comments (3)

Avoiding Duplicate Rows in MySQL

Posted on 12 June 2002 by Demian Turner

Add a field to your table called md5hash or something similar. Make this field unique. Then when adding a new record, concatenate the other fields into a string and md5 it. Then write the md5 hash into the md5hash field.

This way if the record already exists MySQL will ignore the duplicate entry.

Comments (3)

Current Date Stamp

Posted on 11 June 2002 by Demian Turner

This little function returns the current date stamp.

function get_current_datestamp(){

//get the current timestamp
$currdate = gmdate(\"Ymd\");
$currday = substr($currdate,6,2);
$currmonth = substr($currdate,4,2);
$curryear = substr($currdate,0,4);
$currdate_stamp = ($curryear . \"-\" . $currmonth . \"-\" . $currday);
return $currdate_stamp;

}//end of function get_current_datestamp;



$current_datestamp = get_current_datestamp()

It\’s kind of cool if you want to query a database and need a date based result – e.g. news added that day, people on holiday that day.

Comments (2)

A HOWTO on Optimizing PHP

Posted on 10 June 2002 by Demian Turner

Check out this article by John Lim, author of the site, for tips on optimising your:

  • PHP code
  • MySQL setup
  • Apache setup
  • Object oriented code
  • server hardware

The article features an insightful case study and a handy ‘summary of tweaks’.

Comments (0)

The Future of PHP

Posted on 10 June 2002 by Demian Turner

Taken from a recent posting on Zend:

After yet another round of these letters over the last couple of weeks, there has been a very long chat
between most of the developers as to where PHP is heading. For those who are interested – here it is

Comments (0)

How To Install Big Brother

Posted on 10 June 2002 by Demian Turner

Read more for simple installation instructions for the Big Brother block for geeklog users.

Comments (11)

Javascript Worm Now Attacking SQL Servers Worldwide

Posted on 09 June 2002 by Demian Turner

Spida (js.spida.b.worm, also known as Double Tap and SQLSnake) is an Internet worm now attacking Microsoft SQL servers worldwide.

Written in JavaScript, Spida actively scans port 1433 for access into systems with blank system administrator accounts.

According to the SANS Institute, a computer research organization, system administrators began noticing an upsurge in scans on port 1433, which is used by Microsoft’s SQL servers, on Monday, May 20, 2002. Within the first 12 hours, the number of scanned and infected systems rose sharply to more than 1,600, and those systems are now scanning for others on the Internet.

Comments (0)



Demian Turner's currently-reading book recommendations, reviews, favorite quotes, book clubs, book trivia, book lists



PHPkitchen recommends you also check out the following sites :

Accounting for Small Businesses

FreeAgent sign-up