Search & Replace
update tablename set field = replace(field,'search_for_this','replace_with_this');
Never been to CodeSnippets before?
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)
About this user
Sasha http://nothing-less.net
Showing 11 - 20 of
52
total
Sims 2 File Limit Fix
sudo sysctl -w kern.maxfiles=22000 sudo sysctl -w kern.maxfilesperproc=20000
Type this into Terminal in Mac OSX to fix the file size limit for The Sims 2, allowing you to have more than 5000 downloads.
Display Current Year
Useful for example for automatic copyright notices:
© Copyright 2004 - <?php echo date("Y") ?>
Date In The Future
<?php $nextmonth = mktime(0, 0, 0, date("m")+1, 1, date("Y")); echo date("F", $nextmonth); ?>
Total Number of Entries for one Weblog
{exp:stats weblog="weblog1"}{total_entries}{/exp:stats}
Entry Date
{entry_date format="%F %d, %Y"} {edit_date format="%F %d, %Y"}
More formatting options:
http://eedocs.pmachine.com/templates/weblog/variables.html#date_variables
http://eedocs.pmachine.com/templates/date_variable_formatting.html
Display In 2-Column Table
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.
<? $set_table="0"; ?> <table cellpadding="5" border="0"> {exp:gallery:categories gallery="{gallery_name}"} <? $fs_table = $set_table +1; if ($set_table == "1") {echo"<tr>";} ?> Insert other tags here. <? if ($set_table == "2") {echo"</tr>"; $set_table="0";} ?> {/exp:gallery:categories} </table>
Get Today's Date & Time
$today = date("F j, Y");
http://www.php.net/manual/en/function.date.php
Use PHP Inside EE Entries
You'll need the following plugins:
Allow EE Code: http://www.pmachine.com/plugins/allow-eecode/
Allow PHP: http://loweblog.com/archive/2005/06/03/ee-allow-php-plugin/
Set text formatting for the field you want to use this on to "None" (Admin > Weblog Administration > Custom Weblog Fields).
Change your template by adding the Allow EE tags around the field:
Now you can use PHP inside your entries like this:
Allow EE Code: http://www.pmachine.com/plugins/allow-eecode/
Allow PHP: http://loweblog.com/archive/2005/06/03/ee-allow-php-plugin/
Set text formatting for the field you want to use this on to "None" (Admin > Weblog Administration > Custom Weblog Fields).
Change your template by adding the Allow EE tags around the field:
{exp:allow_eecode}{body}{/exp:allow_eecode}
Now you can use PHP inside your entries like this:
<p>Bla bla regular entry text</p> {exp:allowphp} echo "This will be processed as PHP."; {/exp:allowphp}
Strip A String using explode
http://www.php.net/manual/en/function.explode.php
In this example, I need to strip the page's current URL to take off anything that follows a ? in that URL.
In this example, I need to strip the page's current URL to take off anything that follows a ? in that URL.
<? $fs_refer= $_SERVER ['REQUEST_URI']; $fs_refer = explode("?", $fs_refer); echo "$fs_refer[0] is now a URL without ?.<br />"; echo "$fs_refer[1] is the bit that used to follow the ?."; ?>
Showing 11 - 20 of
52
total
