This is an old revision of the document!


Cheat Sheet (ASP, PHP, MySQL, JavaScript, Java, ...)

PHP

http://www.php.net/manual/en/

str_replace($search_for, $replace_with, $subject);
explode($delimiter, $subject);
date('d.m.Y H:i:s', $unixtime);

VBS/ASP (!.NET)

http://www.w3schools.com/vbscript/vbscript_ref_functions.asp

Replace(Subject, SearchFor, ReplaceWith)
Split(Subject, Delimiter)
DateSerial(Y, M, D)
DateAdd(Interval, Number, Date)

HTML

document.getElementById("id").innerHTML = "...";

MySQL

http://dev.mysql.com/doc/refman/5.1/en/index.html
http://mm.gene.cz/ [cz]

DATE_FORMAT(DATE, '%d.%m%.%Y %H:%i:%s')
UNIX_TIMESTAMP(DATE)

FireBird

http://www.firebirdsql.org/manual/qsg10-firebird-sql.html

concat: SELECT 'a' || 'b' || 'c'
date/time: SELECT CURRENT_DATE + 7, CURRENT_TIME + 3, CURRENT_TIMESTAMP + .25

Java

gui_sheet, threads_sheet, jdbc_sheet

// message_type = JOptionPane.ERROR_MESSAGE ...
JOptionPane.showMessageDialog(Opbejct parent, String message[, String window_name, int message_type]);

(g)Vim

  • search: :%s/<search for>/<replace with>/g(lobal)c(onfirm)i(nsensitiv)I(-sensitiv)
  • diff: poiter to different block and do (diff obtain), dp (diff put)

Bazaar

http://bazaar-vcs.org/

resolving conflict:

  1. .BASE - common base, .THIS - my changes, .OTHER - changes in parent branch
  2. make changes in .THIS and move it to original filename (or copy and delete .THIS file)
  3. bzr resolve original filename (.BASE & .OTHER will be deleted)

More

 
coding/cheatsheet.1223141358.txt.gz · Last modified: 2008/10/04 19:29 by funtom
 
Recent changes RSS feed Creative Commons License Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki