Relational Database Design is one of the most powerful ways to ensure
data integrity and a great way to kick-off any project. Very often the
first thing developers do when starting a new project, or stub-project,
is to design the database. This way the structure of the application is
already in place and we just have to fill in the pieces with some
server-side code. I've found when adding relational constraints to your
database design you add in a very powerful error reporting tool that
will let you know during the development process that you have allowed
something to happen that shouldn't have. In this article, I go through,
step by step, showing how to set up a simple relational database and
discuss the benefits that are enjoyed.
Being able to develop on my local machine with urls like
htto://testsite/index.php has been a godsend. Mostly because I am able
to take full advantage of the document root. If I were to develop on
something like http://localhost/testsite/index.php I would be extremely
limited and forced to used relative urls. In this article I've listed
the steps in order to enable this functionality in a wamp server
environment.
Blake over at PHP vs .NET has written up a very nice article to prepare those who are interviewing for a php job soon. He basically gives a bunch of php snippets and asks where the bugs are. The article somewhat morphs into a mish-mash of good-practice/bad-practice comparison and explains why one way is better than the other.
From the article:
Find the errors in the following code:
<?php
function baz($y $z) {
$x = new Array();
$x[sales] = 60;
$x[profit] = 20:
foreach($x as $key = $value) {
echo $key+" \"+$value+\"<BR>\";
}
}
?>
Most people who use MySQL know that MyISAM and InnoDB are the two most-common database engines available with the popular opensource datbase provider. I would be that most of those people don't even take the time to select a storage-engine and just accept the database default. Those of you who are left probably heard from a friend who saw something online that said one of the two is better than the other. Those of you who are left will still probably learn a thing or two here :)
I had an issue lately where image styles that I inputted through TinyMCE
weren't working. For example, my images would not align right or left,
my borders weren't appearing, and even padding wasn't working. I
checked the HTML source and found that no styles at all were making it
from the popup Image Dialog to the editor!
Coding Horror has a pretty amusing article on the infinite number of names programmers give common ascii symbols. $, %, &, |, etc are seen across a lot of languages but somehow they have accumulated more names than the entire ascii library combined.
