IPTABLES common tasks 
//list rules
iptables -L --line-numbers
iptables --list

//inserting rules
iptables -I INPUT -p tcp --dport 80 -j ACCEPT //inserts a rule on top
iptables -I INPUT 5 -p tcp --dport 21 -j ACCEPT //inserts a rule on the 5th position

//deleting rules by line number
iptables -D INPUT 5 //deletes the 5th rule

//saving rules
service iptables save //centos



[ view entry ] ( 1403 views )   |  print article
Set a PHP Cookie to expire at midnight 
//You might find strtotime useful in these situations.

setcookie('cons', 1, strtotime('today 23:59'), '/');


http://stackoverflow.com/questions/1313 ... t-midnight

[ view entry ] ( 1534 views )   |  print article
Gnome Terminal 2.16.0 Basic Tasks 
//Open a new tab
ctrl+shift+T

//Switching tabs
ctrl+pageUp

//Also: Switching consoles in linux:
ctrl+alt+F1
ctrl+alt+F2
ctrl+alt+F3
ctrl+alt+F4
ctrl+alt+F5
ctrl+alt+F6
ctrl+alt+F7


[ view entry ] ( 1781 views )   |  print article
Simple cURL example in PHP 
<?php

/*
We'll get the content of a remote page to display locally ;)
*/

$curl=curl_init();
// Set some options - we are passing in a useragent too here
curl_setopt_array($curl, array(
CURLOPT_RETURNTRANSFER => 1,
CURLOPT_URL => 'http://www.televisa.com/us/',
CURLOPT_BINARYTRANSFER=>true,
));

// Send the request & save response to $resp
$resp = curl_exec($curl);

// Close request to clear up some resources
curl_close($curl);

echo $resp;

?>

[ view entry ] ( 1684 views )   |  print article
Selecting Random Rows in MySQL 
SELECT * FROM tablename
WHERE somefield='something'
ORDER BY RAND() LIMIT 5


[ view entry ] ( 1672 views )   |  print article
Populating a Table from another Table 
INSERT INTO NewTable (col1, col2, col3) SELECT col1, col2, col3 FROM OldTable

Page 985 in MySQL Developer's Library (Paul DuBois), and
http://stackoverflow.com/questions/3140 ... to-another

[ view entry ] ( 1754 views )   |  print article
How to part DATE and TIME from DATETIME field type in MySQL? 
//Use the following query:
SELECT DATE(`date_time_field`) AS date_part, TIME(`date_time_field`) AS time_part FROM `your_table`;

//Also you can use:
SELECT DATE_FORMAT(colName,'%Y-%m-%d') DATEONLY,DATE_FORMAT(colName,'%H:%i:%s') TIMEONLY FROM `your_table`;

http://stackoverflow.com/questions/1233 ... e-in-mysql

[ view entry ] ( 1432 views )   |  print article
Is NOW Between a Time Range? 

$current_time = strtotime('now');
if ($current_time > strtotime('wednesday this week 8:00pm') && $current_time < strtotime('thursday this week 2:00am')) {
// Special logo
}

http://stackoverflow.com/questions/5413 ... ther-times



[ view entry ] ( 1407 views )   |  print article
SimpleXML: Reading/Updating Node Attributes (non namespaced and namespaced ones) 

//non namespaced attributes

<?php

$data=<<<XML


<rss version="2.0" xmlns:media="http://search.yahoo.com/mrss/">
<channel>
<item>
<title>Title: 0</title>
<link test="test" test2="This is a test">Link:0</link>
<media:thumbnail url="0"/>
<media:content url="0" type="video/mp4" />
</item>
<item>
<title>Title: 1</title>
<link>Link:1</link>
<media:thumbnail url="1"/>
<media:content url="1" type="video/mp4" />
</item>
<item>
<title>Title: 2</title>
<link>Link:2</link>
<media:thumbnail url="2"/>
<media:content url="2" type="video/mp4" />
</item>
<item>
<title>Title: 3</title>
<link>Link:3</link>
<media:thumbnail url="3"/>
<media:content url="3" type="video/mp4" />
</item>
</channel>
</rss>

XML;

$xml=simplexml_load_string($data);

echo $xml->channel[0]->item[0]->title."<br>";
echo $xml->channel[0]->item[0]->link->attributes()->test2="This is a NEW test!.";


//Creates update.xml with updated test2 value
$xml->asXml('updated.xml');


?>

===============================================================================
//namespaced attributes

<?php

$data=<<<XML

<rss version="2.0" xmlns:media="http://search.yahoo.com/mrss/">
<channel>
<item>
<title>Title: 0</title>
<link test="test" test2="This is a test">Link:0</link>
<media:thumbnail url="Thumbnail URL: 0"/>
<media:content url="Content URL: 0" type="video/mp4" />
</item>
<item>
<title>Title: 1</title>
<link>Link:1</link>
<media:thumbnail url="1"/>
<media:content url="1" type="video/mp4" />
</item>
</channel>
</rss>

XML;



$xml=simplexml_load_string($data);

//reading simple node
echo $xml->channel[0]->item[0]->title;

echo "<br>----------------------------------<br>";

//reading/updating simple node's attribute
echo $xml->channel[0]->item[0]->link->attributes()->test2="This is a NEW test!.";

echo "<br>----------------------------------<br>";

//reading/updating namespaced node's attribute
echo $xml->channel[0]->item[0]->children('media',TRUE)->content->attributes()->type="VIDEO/MP6";

//saving...
$xml->asXml('updated.xml');

?>



[ view entry ] ( 1591 views )   |  print article
HEREDOC Appending 

<?php

$xml_content= <<<XML
<rss version="2.0" xmlns:media="http://search.yahoo.com/mrss/">
<channel>

XML;


for($i=0;$i<=8;$i++){

$xml_content.=<<<XML
<item>
<title>$i</title>
<link>$i</link>
<media:thumbnail url="$i"/>
<media:content url="$i" type="video/mp4" />
</item>

XML;

}


$xml_content.=<<<XML
</channel>
</rss>
XML;

echo $xml_content;

//use {$...} to embed variables in heredoc

?>


[ view entry ] ( 1512 views )   |  print article

<<First <Back | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | Next> Last>>


2024 By Angel Cool