PHP Tutorials

By Tim Perdue on January 8, 2001 CREATE INDEX mytable_categoryid_userid_adddate ON mytable (category_id,user_id,adddate); NOTICE: identifier “mytable_categoryid_userid_adddate” will be truncated to “mytable_categoryid_userid_addda” CREATE EXPLAIN SELECT * FROM mytable WHERE category_id=1 AND user_id=2 ORDER BY adddate DESC; NOTICE: QUERY PLAN: Sort (cost=2.03..2.03 rows=1 width=16) -> Index Scan using mytable_categoryid_userid_addda on mytable (cost=0.00..2.02…

By Tim Perdue on January 21, 2001 Last week I talked about how to best use indices in your database queries. Now let’s talk about transactions. Transactions may sound reasonably straightforward, as indexing does, but there are a lot of things you can do wrong which will haunt you in…

By Tim Perdue on August 3, 2000 I’m no graphic designer, but I am glad to unveil a new look for PHPBuilder. I knew it was time to upgrade when I was getting more offers to rewrite the site than offers to write articles 😉 Thanks to everyone for their…

By Tim Perdue on August 20, 2000 Whoever said CSS would solve all your cross-platform browser display issues needs to lay off the pipe a little. I have yet to get CSS to work perfectly across all browsers / platforms, but I have gotten it to work “good enough” to…

By Tim Perdue on August 20, 2000 At any rate, here’s my browser detection library. Just require() it at the top of your page and you’ll be able to call the slick functions to generate browser-specific HTML. <?php // // SourceForge: Breaking Down the Barriers to Open Source Development // Copyright 1999-2000 (c) The SourceForge Crew // http://sourceforge.net // // $Id: tim20000821.php3,v 1.2 2001/05/22 19:22:47 tim Exp $ unset ($BROWSER_AGENT); unset ($BROWSER_VER); unset ($BROWSER_PLATFORM); function browser_get_agent () {     global $BROWSER_AGENT;     return $BROWSER_AGENT;…

By Tim Perdue on August 20, 2000 There, now we can start using that library to determine font sizes. Internet Explorer on Wintel has the biggest default font by a long shot. If you don’t specify a font size, Wintel users will get huge fonts and they’ll yell to no…

By Tim Perdue on August 20, 2000 And that’s it. You’ve got the building blocks now to do browser detection in your code, and, if desired, generate a custom CSS style sheet for each user that visits your site. My hope is that the need for this will go away…

I’ve been wanting to write this article for a long time, but never really had the time to do it right. So rather than say this is going to be a

I’ve been wanting to write this article for a long time, but never really had the time to do it right. So rather than say this is going to be a

I’ve been wanting to write this article for a long time, but never really had the time to do it right. So rather than say this is going to be a