Programming and Web Development

Thanks to Jose Hales-Garcia for his post on this on OSXForum . · Please add more, if you find any.

$value = 'bar'; // 'ba' and then CR-LF and then 'r'
insert into pairs values ('foo', 'ba\r\nr')
insert into pairs values ('foo', 'bar')
<?php$filename = '<some large file>';$unpack_time = 0.0;$unpack_time2 = 0.0;$unpack_custom_time = 0.0;$fp = fopen($filename, 'rb');while (!feof($fp)) {	$content = fread($fp, 1048576);	$start = microtime(true);	$array = unpack('N*', $content);	$stop = microtime(true);	$unpack_time += ($stop - $start);	$start = microtime(true);	$array = unpack('V*', $content);	$stop = microtime(true);	$unpack_time2 += ($stop - $start);	$start = microtime(true);	$array = unpack_custom($content);	$stop = microtime(true);	$unpack_custom_time += ($stop - $start);}fclose($fp);print "\$unpack_time = $unpack_time\n";print "\$unpack_time2 = $unpack_time2\n";print "\$unpack_custom_time = $unpack_custom_time\n";function unpack_custom($content) {	$len = strlen($content);	$result = array();	for ($i = 0; $i + 3 < $len; $i += 4) {		$result[] =		(ord($content[$i]) << 24) +		(ord($content[$i + 1]) << 16) +		(ord($content[$i + 2]) << 8) +		ord($content[$i + 3]);	}	return $result;}?>
$unpack_time = 1.34654474258$unpack_time2 = 1.44259476662$unpack_custom_time = 127.910765171

include_path=“.;C:\php\pear”

pear search Requestpear install HTTP_Request
php script.php datafile.txt 10 100

if (!isset($argv¹) {
print “Usage: php script.php  [ ]\n”;
exit(1);
}$filename = $argv¹;
…

Warning:  fsockopen(): no SSL support in this build
php -m
functional my_error_handler($errno, $error, $file, $line) {  ... handle the error ...}
ErrorDocument 500 /cgi-bin/crash-recoverErrorDocument 500 "Sorry, our script crashed. Oh dearErrorDocument 500 http://xxx/ErrorDocument 404 /Lame_excuses/not_found.htmlErrorDocument 401 /Subscription/how_to_subscribe.html
; String to output before an error message.error_prepend_string = "<fieldset>An error has occured. Please notify the <a href=\"mailto:admin@yourname.com\">administrator</a> with the following error message: <br>"; String to output after an error message.error_append_string = "</fieldset>"
php_value error_prepend_string "(... starting tags ...)"php_value error_append_string "(... ending tags ...)"
math.php
<?function square($x) {	return $x * $x;}function cube($x) {	return $x * $x * $x;}?>
mathtest.php
C:\simpletest
<?phpif (!defined('SIMPLE_TEST')) {	define('SIMPLE_TEST', 'C:\\simpletest\\');}require_once(SIMPLE_TEST . 'unit_tester.php');require_once(SIMPLE_TEST . 'reporter.php');require_once('math.php');class TestOfLogging extends UnitTestCase {	function TestOfLogging() {		$this->UnitTestCase();	}	function testSquare() {		$this->assertEqual(16, square(4));	}}$test = &new TestOfLogging();$test->run(new TextReporter());?>
php mathtest.php
square
testofloggingOKTest cases run: 1/1, Passes: 1, Failures: 0, Exceptions: 0
square
/*** This is a short description** This is a longer description of the element that* I will comment.  It can run over to as many lines* as necessary.  Notice the asteriks at the beginning* of each commenting line.*/
/*** Dispenses desired flavored ice cream** Called upon when user has entered their* favorite ice cream.  The function checks* if the desired flavor is available in the* amount desired.  If so, then it dispenses* the ice cream.** @access private* @param int $flavor Flavor of the desired ice cream* @param int $amount_desired Amount of ice cream user wants* @return $string Name of the flavor.  Returns error string if not available*/private function dispenseIceCream($flavor,$amount_desired){ ...return $name_of_flavor;}

[Registrar]
Driver  = FreeTDS
Description  = UCLA Registrar (SRDB)
Trace  = No
Server  = srdb.registrar.ucla.edu
Port  = 1433

[FreeTDS] 
Description     = v0.63 with protocol v8.0 
Driver          = /usr/lib/libtdsodbc.so

<? 
$conn = odbc_connect(‘Registrar’, $username, $password); 
$result = odbc_exec($conn, “EXECUTE CIS_facultyCourseStudentsGetAlpha2 ‘254049110’, ‘081’”); 
?> 

<?// Create an array with 100000 elements
$array = array();
for ($i = 0; $i < 100000; $i++) {
	$array[] = rand();
}
// Remove the last 1000 elements using array_pop
$start = microtime(true);
for ($i = 0; $i < 1000; $i++) {
	array_pop($array);
}
$stop = microtime(true);
printf(“array_pop takes %.5f seconds\n”, $stop – $start);
// Add back 1000 elements
for ($i = 0; $i < 1000; $i++) {
	$array[] = rand();
}
// Remove the first 1000 elements using array_shift
$start = microtime(true);
for ($i = 0; $i < 1000; $i++) {
	array_shift($array);
}
$stop = microtime(true);
printf(“array_shift takes %.5f seconds\n”, $stop – $start);
// Add back 1000 elements
for ($i = 0; $i < 1000; $i++) {
	$array[] = rand();
}
// Remove the first 1000 elements by reversing the array and popping 1000 elements
$start = microtime(true);
$array_rev = array_reverse($array);
for ($i = 0; $i < 1000; $i++) {
	array_pop($array_rev);
}
$stop = microtime(true);
printf(“array_reverse + array_pop takes %.5f seconds\n”, $stop – $start);
?>

array_pop takes 0.00089 seconds
array_shift takes 15.15544 seconds
array_reverse + array_pop takes 0.03934 seconds

function NumbersOnly(Object) {	if(CurrentCellClicked) {		if((event.shiftKey && event.keyCode == 9) || event.keyCode==37) {			event.returnValue=true;			return ;		}		else if(event.keyCode==9 || event.keyCode==39) {			event.returnValue=true;			return ;		}	}	if(event.keyCode == 36 || event.keyCode == 35 || event.keyCode == 46 || event.keyCode == 8) event.returnValue=true;	else if((event.shiftKey && event.keyCode == 9) || event.keyCode==37) {		var t = parseInt(Object.nextField);		if(t > 2) {			t = GlobalForm['c'+(t-2)];			if(t.disabled) {				GlobalForm['c'+(t.nextField-2)].select();				GlobalForm['c'+(t.nextField-2)].focus();			}			else {				t.select();				t.focus();			}			event.returnValue = false;		}	}	else if(event.shiftKey) event.returnValue = false;	else if(event.keyCode==9 || event.keyCode==39) {		var t = GlobalForm['c'+Object.nextField];		if(t.disabled) {			GlobalForm['c'+t.nextField].select();			GlobalForm['c'+t.nextField].focus();		}		else {			t.select();			t.focus();		}		event.returnValue = false;	}	else {		event.returnValue = ((event.keyCode >= 48 && event.keyCode <= 57) || (event.keyCode>=96 && event.keyCode<=105));	}}

function CurrencyOnly(Object) {
	if(CurrentCellClicked) {
		if((event.shiftKey && event.keyCode == 9) || event.keyCode==37) {
			event.returnValue=true;
			return ;
		}
		else if(event.keyCode9 || event.keyCode39) {
			event.returnValue=true;
			return ;
		}
	}if(event.keyCode == 36 || event.keyCode == 35 || event.keyCode == 46 || event.keyCode == 8) event.returnValue=true;
	else if((event.shiftKey && event.keyCode == 9) || event.keyCode37) {		var t = parseInt(Object.nextField);		if(t > 2) {			t = GlobalForm['c'+(t-2)];			if(t.disabled) {				GlobalForm['c'+(t.nextField-2)].select();				GlobalForm['c'+(t.nextField-2)].focus();			}			else {				t.select();				t.focus();			}			event.returnValue = false;		}	}	else if(event.shiftKey) event.returnValue = false;	else if(event.keyCode9 || event.keyCode==39) {
		var t = GlobalForm[’c’+Object.nextField];
		if(t.disabled) {
			GlobalForm[’c’+t.nextField].select();
			GlobalForm[’c’+t.nextField].focus();
		}
		else {
			t.select();
			t.focus();
		}
		event.returnValue = false;
	}
	else {
		event.returnValue = (event.keyCode == 110 || event.keyCode == 190 || event.keyCode == 109 || event.keyCode == 189 || (event.keyCode != 47 && ((event.keyCode>=45 && event.keyCode<=57) || (event.keyCode>=96 && event.keyCode<=105))));
	}
}

function DateOnly(Object) {
	if(CurrentCellClicked) {
		if((event.shiftKey && event.keyCode == 9) || event.keyCode==37) {
			event.returnValue=true;
			return ;
		}
		else if(event.keyCode9 || event.keyCode39) {
			event.returnValue=true;
			return ;
		}
	}if(event.keyCode == 36 || event.keyCode == 35 || event.keyCode == 46 || event.keyCode == 8) event.returnValue=true;
	else if((event.shiftKey && event.keyCode == 9) || event.keyCode37) {		var t = parseInt(Object.nextField);		if(t > 2) {			t = GlobalForm['c'+(t-2)];			if(t.disabled) {				GlobalForm['c'+(t.nextField-2)].select();				GlobalForm['c'+(t.nextField-2)].focus();			}			else {				t.select();				t.focus();			}			event.returnValue = false;		}	}	else if(event.keyCode9 || event.keyCode==39) {
		var t = GlobalForm[’c’+Object.nextField];
		if(t.disabled) {
			GlobalForm[’c’+t.nextField].select();
			GlobalForm[’c’+t.nextField].focus();
		}
		else {
			t.select();
			t.focus();
		}
		event.returnValue = false;
	}
	else {
		event.returnValue = (event.keyCode == 109 || event.keyCode == 189 || event.keyCode == 191 || event.keyCode == 111 || (event.keyCode>=47 && event.keyCode<=57) || (event.keyCode>=96 && event.keyCode<=105));
	}
}

function IsDate(DateObject) {
	var month, year, day;
	if(DateObject.value.length < 6) {
		var datePat = /^(\d{1,2})(\/|-)(\d{1,2})$/;
		var matchArray = DateObject.value.match(datePat); // is the format ok?
		if (matchArray == null) 
			return false;month = matchArray¹; // parse date into variables
		day = matchArray³;
		year = (new Date()).getFullYear();		
	}
	else {
		var datePat = /^(\d{1,2})(\/|-)(\d{1,2})(\/|-)(\d{2,4})$/;
		var matchArray = DateObject.value.match(datePat); // is the format ok?
		if (matchArray == null) 
			return false;
month = matchArray¹; // parse date into variables
		day = matchArray³;
		year = matchArray⁵;
	}
if (month < 1 || month > 12) { // check month range
		throw (new Exception(“Month must be between 1 and 12.”));
	}
	if (day < 1 || day > 31) {
		throw (new Exception(“Day must be between 1 and 31.”));
	}
	if ((month4 || month6 || month9 || month11) && day==31) {
		throw (new Exception("Month “month” doesn’t have 31 days"));
	}
	if (month == 2) { // check for february 29th
		var isleap = (year % 4 == 0 && (year % 100 != 0 || year % 400 == 0));
		if (day > 29 || (day==29 && !isleap)) {
			throw (new Exception("February " + year + " doesn’t have " + day + " days!"));
		}
	}
	if(year.toString().length>2) {
		year = year = year.toString().substring(2);
	}
	DateObject.value = (parseInt(month)) + ‘/’ + (parseInt(day)) + ‘/’ + year;
	return true; // date is valid
}

public class SelfComparableOnly<T> implements Comparable<SelfComparableOnly<T>> {    ...    public int compareTo(SelfComparableOnly<T> o) {	// Compare itself to o    }    ...}

apt-get install package_name

/path/to/restored/backup 123.123.123.123(rw,async,no_root_squash,insecure_locks)

exportfs -a

mkdir /mnt/restore

spare_server_hostname:/path/to/restored/backup /mnt/restore nfs rw,rsize=4096,wsize=4096,hard,intr,async,nodev,nosuid 0 0

mount /mnt/restore

/etc/init.d/mysql stop
/etc/init.d/apache2 stop

cd /var/lib
rm -Rf mysql
ln -s /mnt/restore/var/lib/mysql

cd /etc/mysql
rm debian.cnf
ln -s /mnt/restore/etc/mysql/debian.cnf

cd /etc
rm -Rf apache2
ln -s /mnt/restore/etc/apache2

chown -R www-data.www-data /mnt/restore/path/to/webroot
chown -R mysql.mysql /mnt/restore/var/lib/mysql

/etc/init.d/mysql start
/etc/init.d/apache2 start

a2dismod name_of_module

1. <html><head><title>Form Feed Test</title>2. <STYLE TYPE="text/css"> P.newpage {page-break-before: always} </STYLE>3. </head>4. <body>5. <center><h1>Page 1</h1></center>6. <P CLASS="newpage">7. <center><h1>Page 2</h1></center>
Data.fs.old

// Create a query that matches something like “everything AND NOT term2”
MatchAllDocsQuery everyDocClause = new MatchAllDocsQuery();
TermQuery termClause = new TermQuery(new Term(“text”, “term2”));
BooleanQuery query = new BooleanQuery();
query.add(everyDocClause, BooleanClause.Occur.MUST);
query.add(termClause, BooleanClause.Occur.MUST_NOT);
…
IndexSearcher searcher = new IndexSearcher(“/path/to/index”);
Hits hits = searcher.search(query);
// hits contains only documents that do not contain term2

FieldSelector lazyFieldSelector = new FieldSelector() {	public FieldSelectorResult accept(String fieldName) {	    return FieldSelectorResult.LAZY_LOAD;	}};
IndexReader reader;...// Open the index reader...Document doc = reader.document(docId, lazyFieldSelector);
Fieldable fieldable = document.getFieldable(fieldName);String value = fieldable.stringValue();// Use the field value
String fieldToIterate = "field1";...FieldSelector lazyFieldSelector = new FieldSelector() {	public FieldSelectorResult accept(String fieldName) {		if (fieldName.equals(fieldToIterate))			return FieldSelectorResult.LOAD_AND_BREAK;		else			return FieldSelectorResult.NO_LOAD;	}};
/path_of_gcj/bin/gcj lucene-core-2.3.0.jar lucene-demos-2.3.0.jar -o indexer --main=org.apache.lucene.demo.IndexFiles
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/path_of_gcj/lib
cat /logs/httpd/ssl_error_log* | awk '{ print $1"-"$2" "$3" "$5" "$4 }' | uniq -c | sort -g
      5 [Mon-Jul 02 2012] 07:45:42      5 [Mon-Jul 02 2012] 16:35:18      5 [Tue-Jun 26 2012] 13:40:40      6 [Fri-Jun 29 2012] 13:44:16      6 [Thu-Jul 19 2012] 15:35:59      6 [Thu-Jul 19 2012] 15:36:27      6 [Thu-Jul 19 2012] 15:36:57      6 [Thu-Jul 19 2012] 15:39:43      6 [Thu-Jul 19 2012] 15:40:58      6 [Thu-Jul 19 2012] 15:41:18      6 [Wed-Jul 04 2012] 21:32:38      7 [Thu-Jul 26 2012] 15:06:29
grep -c "/2015:" /logs/*access_log | sort -t : -k2nr
/logs/brh.ucla.edu-access_log:28351/logs/harrt.ucla.edu-access_log:27078/logs/jag.ucla.edu-access_log:25690/logs/epr.ucla.edu-access_log:24894

cat access_log* | grep browseinst | awk -F\" ‘{ print $1" [“$2”] [“$6”] "$3 }’ | grep browseinst | awk ‘{if ($NF > 1000000) print $0}’

128.97.62.186 - - [14/Jul/2010:10:25:18 -0700]  [GET /?page=browseinst&term=101&lastalpha=I&instructor=2 HTTP/1.1] [Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6 ( .NET CLR 3.5.30729)]  200 1026117128.97.198.33 - - [14/Jul/2010:22:48:16 -0700]  [GET /?page=browseinst&term=101&lastalpha=T&instructor=1207888 HTTP/1.1] [Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6]  200 1059649...
cat /logs/httpd/ssl_access_log | awk -F\" '{ print $1" [URL: "$2"] [BROWSER: "$6"] [REFERER: "$4"] [SECONDS: "$7"] "$3 }' | awk '{if ($NF > 1000000) print $0}'75.47.248.169 - - [27/Nov/2011:04:16:50 -0800]  [URL: GET /file.php/7826/course_materials/Anthro33Lecture13.ppt.pdf?forcedownload=1 HTTP/1.1] [BROWSER: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2] [REFERER: https://.../course/view/11F-ANTHRO33-1?topic=7] [SECONDS:  16]  200 129891475.47.248.169 - - [27/Nov/2011:04:17:08 -0800]  [URL: GET /file.php/7826/course_materials/Anthro33Lecture15.ppt.pdf?forcedownload=1 HTTP/1.1] [BROWSER: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2] [REFERER: https://.../course/view/11F-ANTHRO33-1?topic=8] [SECONDS:  19]  200 1578667
<label for="searchbox">Search this Site:</label><input type="text" id="searchbox" value="search" size="16" onblur="if (this.value == '') {this.value = 'search';}" onfocus="if (this.value == 'search') {this.value = '';}" />
body { 	font-size: 76%; }p { font-size: 1em; }h1 { font size: 1.8em; }h2 { font-size: 1.6em; }li { font-size: .9em; }/** etc **/

ldd /path/to/program

numOccur = (length(haystack) - length(replace(haystack, needle, ""))) / length(needle)
SELECT a.phrase,       sum((length(b.title) - length(replace(b.title, a.phrase, ''))) / length(a.phrase))       + sum((length(b.abstract) - length(replace(b.abstract, a.phrase, ''))) / length(a.phrase))FROM phrases AS a,     articles AS bGROUP BY a.phrase
#! /usr/bin/perluse strict;use Image::Magick;opendir(DH, 'input');my $image = Image::Magick->new();my @files = readdir(DH);@files = sort @files;foreach my $file (@files) {  next if ($file =~ /^\.{1,2}$/);  print "input/$file\n";  $image->Read(filename=>"input/$file");}$image->Write(filename=>"animated.gif",              delay=>"100");
<html><%   String timeInMillis = ""+System.currentTimeMillis();%><body><center> <h1>University of California Grid Virtual Desktop</h1>    <div class="selector">        <div class="list">            <h2>Which campus are you from: </h2>            <form method="get" action="https://wayf.incommonfederation.org/InCommon/WAYF">                <p>                    <input type="hidden" name="shire" value="https://youdomain/Shibboleth.sso/SAML/POST" />                    <input type="hidden" name="target" value="cookie" />                    <input type="hidden" name="providerId" value="https://yourdomain/incommon" />                    <input type="hidden" name="time" value="<%=timeInMillis%>" />                    <input type="hidden" name="action" value="selection" />                    <select name="origin">                            <option value="urn:mace:incommon:ucop.edu">                                        University of California - Office of the President                            </option>                            <option value="urn:mace:incommon:berkeley.edu">                                        University of California, Berkeley                            </option>                            <option value="urn:mace:incommon:ucdavis.edu">                                        University of California, Davis                            </option>                            <option value="urn:mace:incommon:ucmerced.edu">                                        University of California, Merced                            </option>                            <option value="urn:mace:incommon:ucr.edu">                                        University of California, Riverside                            </option>                            <option value="urn:mace:incommon:uci.edu">                                        University of California-Irvine                            </option>                            <option value="urn:mace:incommon:ucla.edu">                                        University of California-Los Angeles                            </option>                            <option value="urn:mace:incommon:ucsd.edu">                                        University of California-San Diego                            </option>                    </select>                    <input type="submit" value="Select" />                    <select name="cache">                        <option value="false" selected> Do not remember                        <option value="session"> Remember for session                        <option value="perm"> Remember for a week                    </select>                </p>            </form>        </div></body></html>

<?xml version=“1.0” encoding=“UTF-8” ?> 

  <![CDATA[ 
  ]]>

<!DOCTYPE html>

Test

Test

document.write(‘’);
document.write(‘’);
document.write(‘’);
document.write(‘’);
document.write(‘’);
document.write(‘’);

var specUrl0 = ‘$your_website/YourGadget/yourgadget.xml’;

package $your_namespace_dots.gwt.client;

	public EntryPoint entryPoint = this;

this.@$your_namespace_dots.gwt.client.SomeGadget::handleResponse(L$your_namespace_folders/gwt/client/SomeObject;)(obj);

	public void handleResponse(YourRecord rr) {
		Window.alert(rr.getTitle());
	}
	native void callMakeRequest(EntryPoint ep) /{
		$wnd[“response”] = function(obj) {
			ep.@$your_namespace_dots.gwt.client.YourGadget::handleResponse(L$your_namespace_folders/gwt/client/YourRecord;)(obj);
		};
		var params = {};
		params[gadgets.io.RequestParameters.CONTENT_TYPE] = gadgets.io.ContentType.DOM;
		var url = “http://www.clicc.ucla.edu/rss/laptops.php”;
		gadgets.io.makeRequest(url, response, params);
	}/;

callMakeRequest(entryPoint);

export VAR1=testing
bash script2.sh

echo $VAR1

bash-3.00$ bash script1.sh 
testing
bash-3.00$ echo $VAR1bash-3.00$ echo $UNDEFINED_VAR
bash-3.00$ 

export VAR1=testing
bash script2.sh
echo $VAR1

VAR1=overwritten
echo $VAR1

bash-3.00$ bash script1.sh 
overwritten
testing
bash-3.00$ 

@echo offecho param0: %0echo param1: %1echo param2: %2echo param3: %3echo param4: %4
param0: testparam1: aparam2: bparam3:param4:
ft_min_word_len=3[myisamchk]ft_min_word_len=3
$wgScriptPath	    = "/w";$wgArticlePath      = "/wiki/$1";
Alias /wiki "/path/to/wiki/w/index.php"

    RewriteEngine On
Exclude actual file path and robots.txt (otherwise this would be a wiki page).
	An alias cannot be used because there’s not a unique path.
	Note this cannot go in the  section since it would cause a loop.
    RewriteCond %{REQUEST_URI} !^/robots.txt [NC]
    RewriteCond %{REQUEST_URI} !^/w/ [NC]
    RewriteRule ^(.*)$ /w/index.php/$1 [L]

$wgScriptPath	    = “/w”;
$wgArticlePath      = “/$1”;

% echo 'testing'testing% echo 'test'ing'Unmatched '.% echo 'test\'ing'Unmatched '.% echo 'test\\'ing'Unmatched '.% echo 'test''ing'testing% echo 'test'\''ing'test'ing
Speaking generally, Steve Krug's Third Law of Usability states:"Get rid of half the words on each page, then get rid of half of what'sleft." (Don't Make Me Think, page 45)Here's a neat trick: copy the text from a "blah-blah" page and paste itinto Word. Then, run Tools > AutoSummarize (at least that's what it'scalled in Word 2004 for Mac). Set it to reduce it to 25% of the original.I tried this with a couple of pages and was surprised at how well itworked. If we could just build this into the CMS...
Content-Disposition: inline; filename=image.gif
Content-Type: image/gif
<?// Suppose you want to send a GIF file to the browser// Send the headers firstheader('Content-Disposition: inline; filename=image.gif');header('Content-Type: image/gif');// Then print the content of the GIF file// e.g.// print file_get_contents('some_gif_file.gif');?>
httpurl        = "http://" hostport [ "/" hpath [ "?" search ]][definition of hostport omitted]hpath          = hsegment *[ "/" hsegment ]hsegment       = *[ uchar | ";" | ":" | "@" | "&" | "=" ]search         = *[ uchar | ";" | ":" | "@" | "&" | "=" ]uchar          = unreserved | escapeunreserved     = alpha | digit | safe | extraalpha          = lowalpha | hialphalowalpha       = "a" | "b" | "c" | "d" | "e" | "f" | "g" | "h" |                 "i" | "j" | "k" | "l" | "m" | "n" | "o" | "p" |                 "q" | "r" | "s" | "t" | "u" | "v" | "w" | "x" |                 "y" | "z"hialpha        = "A" | "B" | "C" | "D" | "E" | "F" | "G" | "H" | "I" |                 "J" | "K" | "L" | "M" | "N" | "O" | "P" | "Q" | "R" |                 "S" | "T" | "U" | "V" | "W" | "X" | "Y" | "Z"digit          = "0" | "1" | "2" | "3" | "4" | "5" | "6" | "7" |                 "8" | "9"safe           = "$" | "-" | "_" | "." | "+"extra          = "!" | "*" | "'" | "(" | ")" | ","escape         = "%" hex hexhex            = digit | "A" | "B" | "C" | "D" | "E" | "F" |                 "a" | "b" | "c" | "d" | "e" | "f"

Programming and Web Development

PHP

How do I update root certificates in Apache/PHP/cURL environment

UNIX

Windows

What are the differences between addslashes(), mysql_escape_string() and mysql_real_escape_string()

PHP and ODBC

Speed of unpack() in PHP

Configuring PEAR on Windows

How do I use cURL in PHP on Windows?

Passing command-line arguments into PHP

Using SSL socket in PHP under Windows

Problem

Cause

Solution

PHP Resources

PHP error reporting

Error levels

Custom Error Handler

Apache

Pretty-printing Error Messages

PHPXref vs PHPDocumentor

Create a PHP unit test case using SimpleTest

PHP Commenting Style

Basic Syntax

Useful Tags

Other Tags to Note

phpMyAdmin Security

PHP

How can I make phpMyAdmin avoid sending MySQL passwords in the clear?

PHP ODBC Setup Guide

Performance of array_shift and array_pop in PHP

JavaScript

Javascript

Numeric Validation JavaScript

Series I : Validation (AJAX Presentation CWP)

The advantages of Javascript

jQuery Tutorial

Which Javascript framework should I use?

jQuery and JavaScript Coding: Examples and Best Practices

Java

Java

XML and Java

Converting Java content into AJAX (Javascript and XML)

Create a Java class that is only comparable to itself

Removing old Java versions

Java Server Faces

SQL

MySQL Resources

PostgreSQL Resources

Why doesn't mysqlshow work for databases or tables with underscores in their names?

What is mysqlshow good for?

How can I search/replace strings in MySQL?

Microsoft Access, OpenOffice and MySQL

SQL joins

Get rid of default annoyances in MySQL Workbench

Who uses PostgreSQL at UCLA?

Why NoSQL Matters

Git and Version Control

Subversion

What is Subversion?

Tools for use with Subversion

General tools

IDE integration

The Subversion Book / Documentation

Revision Control

What is Revision Control?

Why should I (a programmer) use Revision Control?

Links / Documents

Revision Control Systems Compared

Comparison charts

Popular Systems and their Pros/Cons

Visual SourceSafe

CVS

Subversion

Perforce

Others

Distributed Version Control Systems

Future Expansion

Installing Subversion on Windows