Skip to content

Instantly share code, notes, and snippets.

@samatsav
samatsav / Cascade delete syntax
Created September 20, 2013 13:53
Cascade delete syntax
ALTER TABLE orders_items ADD FOREIGN KEY (orderID) REFERENCES orders(orderID) ON DELETE CASCADE
@samatsav
samatsav / Javascript only numeric
Created September 20, 2013 13:51
Allow only numeric input inside text field
document.getElementsByTagName('input')[0].onkeypress = function(e) {
e = e || event
var chr = getChar(e)
if (!isNumeric(chr) && chr !== null) {
return false
}
}
// helper functions
function isNumeric(val) {
@samatsav
samatsav / Clean URL
Created September 20, 2013 13:48
Rewrite clean URL .htaccess
RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^ index.php?q=%{REQUEST_URI} [L]
// SAU ALTA VARIANTA MAI BUNA PT PHP EASE(17.10.2013)
RewriteEngine on