>>>>>>>>>>>>>>>> < Useful Links > (updated 2011-06-15T21:30) <<<<<<<<<<<<<<<< CSS ******* Z-index Stacking http://www.impressivewebs.com/a-detailed-look-at-the-z-index-css-property/ http://www.charlescooke.me.uk/web/lab_notes/layers.html http://www.vanseodesign.com/css/css-stack-z-index/ SQL ***** SQL Data Types http://www.tizag.com/sqlTutorial/sqldatatypes.php List of standard field lengths for database http://stackoverflow.com/questions/20958/list-of-standard-lengths-for-database-fields UK Government Data Standards Catalogue (on length of data fields) https://www.justice.gov.uk/guidance/docs/electoral-reg-standards.pdf Database Design Standard for Column Sizes http://answers.google.com/answers/threadview/id/102056.html MySQL Commands http://www.pantz.org/software/mysql/mysqlcommands.html SQL Injection Cheat Sheet http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/ SQL Injection Attacks by Example http://www.unixwiz.net/techtips/sql-injection.html MySQL Tutorial on SQL Injection http://www.tizag.com/mysqlTutorial/mysql-php-sql-injection.php Zend Framework **************** Heavily Corrected Zend Framework Quickstart Tutorial (WinXP + XAMPP) http://www.bogartcomputing.com/web-programming-answers/213/a-heavily-corrected-windows-xp-xampp-zend-framework-quickstart-tutorial-revision/ Using Zend Framework without htaccess (3 urls) http://forums.zend.com/viewtopic.php?f=69&t=565&p=2231&hilit=without+htaccess#p2231 http://forums.zend.com/viewtopic.php?f=69&t=13018 http://codeutopia.net/blog/2007/11/16/routing-and-complex-urls-in-zend-framework/ PHP Programming ***************** Secure File Upload in PHP http://blog.insicdesigns.com/2009/01/secure-file-upload-in-php-web-applications/ Introduction to PHP PDO (PHP Data Objects) http://phpro.org/tutorials/Introduction-to-PHP-PDO.html 30 PHP Best Practices for Beginners http://net.tutsplus.com/tutorials/php/30-php-best-practices-for-beginners/ Presentation on PHP Best Practices http://talks.php.net/show/php-best-practices/ Object Oriented Programming (OOP) in PHP http://www.devarticles.com/c/a/PHP/Object-Oriented-Programming-in-PHP/ Cross Site Scripting (XSS) Cheat Sheet http://ha.ckers.org/xss.html Good White Hat Sites ********************** la.ckers.org www.0x000000.com ha.ckers.org www.gnucitizen.org www.owasp.org www.cert.org www.sans.org www.securityfocus.com .NET C# Programming ****************** .NET Streams Explained http://ondotnet.com/pub/a/dotnet/2003/04/14/streams.html Clear explanation of .NET and COM Interoperability http://www.c-sharpcorner.com/UploadFile/akchavali/Interoperabilityin11282005052912AM/Interoperabilityin.aspx Useful website on string formatting http://blog.stevex.net/string-formatting-in-csharp/ ENGLISH ********* Dictionary.com http://www.dictionary.com Find the famous quote you need http://en.thinkexist.com/ Merriam-Webster's Online Dictionary (hear the pronunciation of words) http://www.m-w.com/dictionary The Blue Book of Grammar and Punctuation (click the links on the left) http://www.grammarbook.com/ Common Latin and Non-English Abbreviations Used in Research (such as etc, RSVP, NB, sic) http://web.cn.edu/kwheeler/latin.html Common Errors in English (eg. lay, lie) http://wsu.edu/~brians/errors/errors.html Ask Oxford (FAQ on English grammar and usage) http://www.askoxford.com/asktheexperts/faq/aboutgrammar/meandi?view=uk --- Repository of Collective Nouns http://community-2.webtv.net/solis-boo/Collectives/ Animal Group, Young Names, and Male/Female Names http://dictionary.reference.com/writing/styleguide/animal.html Cool Quiz: What do you call a group of ... http://www.coolquiz.com/trivia/didyouknow/animal_groups.asp --- CHINESE ********* Google PinYin tool for Windows XP http://tools.google.com/pinyin/ Dictionary Lookup Tool software for Windows XP (shows Pinyin for Chinese characters) http://dltool.sourceforge.net/ Convert Chinese Characters to Pinyin http://www.chinesetopinyin.com/ Chinese Terms http://chineseterms.zaobao.com/ Online Chinese Tools http://www.mandarintools.com/ Chinese to English Dictionary http://www.mandarintools.com/cedict.html GB2312 Character Tables http://www.chinasfuture.org/Chinese/ UniHan Database (Unicode Chinese Character Database) http://www.unicode.org/charts/unihan.html MATHEMATICS ************* National Library of Virtual Manipulatives (for Maths) http://nlvm.usu.edu/en/nav/vlibrary.html Virtual Base 10 blocks Java applet (fantastic!) http://arcytech.org/java/b10blocks/b10blocks.html AAA Math (choose grade level and topic to see online practices) http://www.aaamath.com RoboLab @ Tufts Activities for students involving Lego to teach curriculum, eg. Science http://www.ceeo.tufts.edu/robolabatceeo/ --- Primary Games - Educational Math Games for the primary classroom http://www.primarygames.co.uk/ Mike Keith's Alphametic Page (SEND + MORE = MONEY) http://users.aol.com/s6sj7gt/mikealp.htm **Alphametic Puzzles, Solver & Generator (the tools are superb!) http://www.tkcs-collins.com/truman/alphamet/index.shtml Arithmagons & solving methods (nos in squares = sum/diff of nos. in adjacent circles) http://www.nrich.maths.org/public/viewer.php?obj_id=2670&part=index&refpage=viewer.php Magic Squares (includes Constructor) http://www.magic-squares.de/magic.html --- PEDAGOGY ********** Asking Questions in Class (types of questions) http://www.ust.hk/celt/ta/taguide/skills/asking.htm Bloom's Taxonomy http://www.coun.uvic.ca/learn/program/hndouts/bloom.html http://chiron.valdosta.edu/whuitt/col/cogsys/bloom.html http://www.teachers.ash.org.au/researchskills/dalton.htm Mobile Internet (for handphones) ********************************** Google SG Mobile http://www.google.com.sg/m Yahoo! SG Mobile (WAP) http://sg.m.yahoo.com/p/mail Hotmail Mobile http://mobile.live.com/hm Internet ********** Portable Apps (Open Source) http://www.portableapps.com WhoIs Source (detailed info on domains. Try "www.whois.sc/kitthrng.com") http://www.whois.sc/ World Wide Consortium (info on HTML standards, stylesheets, etc) http://www.w3.org HTML Special Character Reference (eg. how to display division symbol in webpages) http://www.chami.com/tips/internet/050798I.html Picture Editing ***************** How Many Pixels Do I Need for Printing Photos http://graphicssoft.about.com/cs/digitalimaging/f/pixelsprint.htm Photo print sizes http://en.wikipedia.org/wiki/Photographic_printing Paper sizes http://en.wikipedia.org/wiki/A4_paper_size Programming ************* Java 2 Standard Edition v1.5.0 API Specification http://java.sun.com/j2se/1.5.0/docs/api/ MySQL Reference Manual -> Command, Type and Function Index http://dev.mysql.com/doc/mysql/en/Function_Index.html PHP Function List http://sg.php.net/manual/en/index.functions.php JavaScript Functions http://www.w3schools.com/js/js_functions.asp VBScript Functions (ASP) http://www.w3schools.com/vbscript/vbscript_ref_functions.asp ------------- ASCII Table http://www.asciitable.com/ Inserting Dates in mySQL http://mysqld.active-venture.com/Using_DATE.html Regular Expressions PHP Tutorial http://weblogtoolscollection.com/regex/regex.php MySQL Reference Manual -> Regular Expression http://dev.mysql.com/doc/mysql/en/Regexp.html ------------- Anti-Virus ************ Symantec Virus Encyclopedia http://securityresponse.symantec.com/avcenter/vinfodb.html Avast! Anti-Virus (comes with VirusShield) http://www.avast.com/ Free F-PROT for DOS http://www.datafellows.com/download-purchase/tools.shtml Trend Micro http://www.trendmicro.com/ Hardware ********** Drivers Guide http://www.driversguide.com/ (userid=drivers, pwd=all) Modem Commands in Depth http://www.smeal.psu.edu/misweb/datacomm/ID/HAYES_AT.HTM OS **** Windows Registry Guide (formerly RegEdit.com) http://www.winguides.com/registry Linux Newbie Guide - Shortcuts and Commands http://www.isid.ac.in/~statmath/resources/linux/Linux_commands.htm Finance ********* Yahoo! Currency Converter http://finance.yahoo.com/currency Language ********** AltaVista BabelFish http://babelfish.altavista.com/ PowerWord Dictionary (find various possible translations for single words) http://cb.kingsoft.com Latin-English / English-Latin Dictionary http://www.sunsite.ubc.ca/LatinDictionary/ The Latin Lover (Famous Latin quotes) http://www.nibbler.de/oldpage/latin.html French/English Dictionary http://www.french-linguistics.co.uk/dictionary/ << END >>