DZone Snippets: php code

Run a simple Update Query

nothingless (Sasha) — Thu, 26 Apr 2007 11:48:06 GMT

In PHP.



$result = mysql_query("UPDATE example SET age='22' WHERE age='21'") 

or die(mysql_error());

Generate a dropdown with months in a year

nothingless (Sasha) — Thu, 31 Aug 2006 17:08:18 GMT

The below code will generate a form dropdown for all 12 months, with the current month selected. Handy for those date pickers!

Generate a dropdown with days of the month

nothingless (Sasha) — Thu, 31 Aug 2006 17:06:21 GMT

The below code will generate a form dropdown for all the days of the month, with today's day selected. Handy for those date pickers!

Loop in PHP Using For (Descending)

nothingless (Sasha) — Tue, 20 Jun 2006 15:26:45 GMT

For those times you need to do a loop in PHP, but have the outcome be in descending order (ie, start at 10 and end at 1).



$totalcode="10";

for($i=$totalcode; $i>0; $i--){



 echo"$i";

}

Loop in PHP Using For (Ascending)

nothingless (Sasha) — Tue, 20 Jun 2006 15:25:17 GMT

If you have a set number of times you need to repeat a piece of coding, using the for loop is the easiest way to accomplish this.

$i is the starting number, 1 in this case. This loop will repeat itself until $i reaches 10 - you can change this to any desired number. The bit inbetween the { and } is simply what is repeated - replace this with anything you want. :)



for ($i = 1; $i <= 10; $i++) {

   echo $i;

}

Pad Numbers in PHP

nothingless (Sasha) — Tue, 20 Jun 2006 15:20:51 GMT

Sometimes I need numbers to always be two digits, even if they're less than 10. The below snippet will format all numbers to be two digits, inserting a 0 if they're under 10 - creating, for example, 09 instead of 9.



$raw = 1;

$formatted = sprintf("%02d", $raw);

echo $formatted;



//outputs 01

Random Number

nothingless (Sasha) — Sat, 21 Jan 2006 21:41:29 GMT

Replace 1 and 10 with the range you want to pick a number between. This example will pick a random number between 1 and 10.



$randomnumber= rand(1,10);

Display Current Year

nothingless (Sasha) — Sat, 21 Jan 2006 21:37:00 GMT

Useful for example for automatic copyright notices:



© Copyright 2004 -

Date In The Future

nothingless (Sasha) — Sat, 21 Jan 2006 21:36:41 GMT

How to display a date in the future - in this case, next month.



 $nextmonth = mktime(0, 0, 0, date("m")+1, 1, date("Y"));

 echo date("F", $nextmonth);

 ?>

Display In 2-Column Table

nothingless (Sasha) — Sat, 21 Jan 2006 21:35:28 GMT

The below can be applied to MT, EE, etc, and will display the content in a 2 column table. The EE tags below are just an example, it will work equally well if you replace it with MT, Wordpress, etc, tags.








{exp:gallery:categories gallery="{gallery_name}"}

$set_table = $set_table +1;

if ($set_table == "1") {echo"";} ?>



Insert other tags here.



";  $set_table="0";} ?>

{/exp:gallery:categories}