Friday, 18 April 2008

mysql privileges to only one database rather than global

Here is the Mysql command for database specific user privileges rather than global:
grant all on database.* to 'user'@'localhost' identified by 'password';

Friday, 11 April 2008

print HTML block inside code

Here is an old classic for printing HTML block inside PHP:
$html = <<< EOH


EOH;
echo($html);

Tuesday, 8 April 2008

yahoo yui document page width

Here are the page widths from the yahoo yui
750px
950px
974px
100%

Monday, 7 April 2008

php and Javascript to rotate an image

The random image rotator uses PHP to get a list of images in a specified directory. This listing is then used in combination with the JavaScript Rotate Images code and its Random Rotation component to randomly swap in these images on a timer. You can specify whether to include all the directory's images or limit the number.
source here
and an example can be found here http://www.hanslips.com/

php to pull down rss feeds with cURL

Here is three lines of PHP to pull down RSS feeds:
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,
'http://www.somewebsite.com');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$contents = curl_exec ($ch);

Wednesday, 2 April 2008

mysql command for creating a primary index

here is a mysql command for creating a primary index for a table:
id INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT

php function to submit values to a form

Here is a php function to submit values to a form:
function hitForm($loginURL, $loginFields, $referer=”") {
$ch = curl_init();
curl_setopt($ch, CURLOPT_COOKIEJAR, “cookies.txt”);
curl_setopt($ch, CURLOPT_COOKIEFILE, “cookies.txt”);
curl_setopt($ch, CURLOPT_URL, $loginURL);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_REFERER, $referer);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $loginFields);
$ret = curl_exec($ch);
curl_close($ch);
return $ret;
}
hitForm(”http://technorati.com/login.php”, “username=wagerank&password=%pass%”);
You can read the original here