mysql foreign key check

Posted by on 24/01/2012 No comments

turn off

SET FOREIGN_KEY_CHECKS=0;

turn on

SET FOREIGN_KEY_CHECKS=1;

ex.:

SET FOREIGN_KEY_CHECKS=0;
YOUR QUERY;
SET FOREIGN_KEY_CHECKS=1;

svn ignore

Posted by on 16/01/2012 No comments

1 – go to folder where your files are placed

2 – Edit the properties for the current directory

svn propedit svn:ignore .

3 – Add the files or patterns ex:

Ignores all .conf files on the current directory

*.conf

4 – Save your file (^X if you’re using nano)

5 – Confirm what you did (you can skip this)

You can see your property

svn propget svn:ignore .

You should see an ‘I’ next to the ignored files

svn status --no-ignore

6 – Commit your changes

svn commit -m 'svn ignore'

Now you can ask:
- Ok, but if I want to undo these changes or add some new files or patterns?

I say: Easy!

- If you and to add new files or patterns: Repeat all above steps (1 – 6)

If you want do undo these changes, you need to go to your directory and type:

svn propdel svn:ignore

chmod recursive on terminal

Posted by on 16/01/2012 No comments 
chmod permissionsettings dirname* -R

unrar files on linux ubuntu

Posted by on 13/01/2012 No comments 
sudo apt-get install unrar

unrar x file.rar

PHP Rest with cURL

Posted by on 12/01/2012 No comments

request.php

function request($request_type) {
 
	$ch = curl_init();
 
	curl_setopt ($ch, CURLOPT_URL, "http://localhost/server.php");
 
	switch (true) {
 
		case $request_type == 'get':
 
			curl_setopt ($ch, CURLOPT_HEADER, 0);
 
			break;
 
		case $request_type == 'post':
 
			curl_setopt($ch, CURLOPT_POST, 1);
			curl_setopt($ch, CURLOPT_POSTFIELDS, array('foo' => 'bar'));
 
			break;
 
		case $request_type == 'put' :
 
			curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'PUT');
 
			break;
 
		case $request_type == 'delete':
 
			curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'DELETE');
 
			break;
 
	}
 
	curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
 
	return curl_exec($ch);
}
 
var_dump(request('get'));
 
var_dump(request('post'));
 
var_dump(request('put'));
 
var_dump(request('delete'));

server.php

echo 'REQUESTED: ' . $_SERVER['REQUEST_METHOD'];

Smarty with php count function

Posted by on 04/01/2012 No comments 
{if $myarray|@count gt 0}...{/if}

Javascript Countdown

Posted by on 04/01/2012 No comments 
var countdown = {
    d : 0, h : 0, m : 0, s : 0,
    set : function(d, h, m ,s) {
        this.d = d;
        this.h = h;
        this.m = m;
        this.s = s;
        this.begin();
    },
 
    begin : function() {
 
    	if (this.d > 0 || this.h > 0 || this.m > 0 || this.s > 0) {
 
    		if (this.s == 0) {
 
    			if (this.m == 0) {
 
    				if (this.h == 0) {
 
    					if (this.d > 0) {
 
    						this.h = 23;
    						this.m = 59;
	    					this.s = 59;
    						this.d--;
 
    					} else {
 
    						this.h = 0;
	    					this.m = 0;
	    					this.s = 0;
    					}
 
    				} else {
 
    					this.h--;
    					this.m = 59;
    					this.s = 59;
    				}
 
    			} else {
 
    				this.m--;
    				this.s = 59;
    			}
 
    		} else {
 
    			this.s--;
    		}
 
	    	document.getElementById('day').innerHTML 	= (this.d <=9 ? '0' + this.d : this.d);
	    	document.getElementById('hour').innerHTML 	= (this.h <=9 ? '0' + this.h : this.h);
	    	document.getElementById('minute').innerHTML = (this.m <=9 ? '0' + this.m : this.m);
	    	document.getElementById('second').innerHTML = (this.s <=9 ? '0' + this.s : this.s);
 
    		setTimeout(function(){
	    		countdown.begin();
	    	}, 1000);
 
    	}
    }
}

usage:

Day:
<p id="day"></p>
<br />
Hour:
<p id="hour"></p>
<br />
Minute:
<p id="minute"></p>
<br />
Second:
<p id="second"></p>
<script type="text/javascript">
countdown.set(1, 0, 0, 3);
</script>

php.ini on ubuntu

Posted by on 02/01/2012 No comments 
/etc/php5/apache2/php.ini

Check if an email is valid with PHP

Posted by on 20/12/2011 No comments 
if(preg_match('/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/', $email_to_test) && filter_var($email_to_test, FILTER_VALIDATE_EMAIL)) {
echo 'is valid!';
} else {
echo 'is invalid! =(';
}

Add all unversioned files to svn

Posted by on 20/12/2011 No comments

Run this command on terminal

svn status | grep '?' | sed 's/^.* /svn add /' | bash

and after you can run this

svn commit -m 'Comments'
Page 1 of 212