Monday 21 April 2008

http://centricle.com/tools/html-entities/

The previous post used: http://centricle.com/tools/html-entities/ to search and replace the open tag brackets

How to use Google Translate to offer your website in different languages

Here is the form details to submit to Google translate, you need to replace the image source in the text below:

<form action="http://www.google.com/translate" >

<script language="JavaScript">
<!--
document.write ("<input name=u value="+location.href+" type=hidden>")
// -->
</script>

<input name="hl" value="en" type="hidden">

<input name="ie" value="UTF8" type="hidden">

<input name="langpair" value="" type="hidden">

<input name="langpair" value="en|fr" title="French" src= "images/flags/fr.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|de" title="German" src= "images/flags/de.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|it" title="Italian" src= "images/flags/it.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|pt" title="Portuguese" src= "images/flags/pt.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|es" title="Spanish" src= "images/flags/es.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|ja" title="Japanese" src= "images/flags/jp.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|ko" title="Korean" src= "images/flags/kr.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|zh-CN" title="Chinese Simplified" src= "images/flags/cn.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair2" value="en|ar" title="Arabic" src= "images/flags/sa.png" onclick="this.form.langpair.value=this.value" type="image" />
</form>

Friday 18 April 2008

Foreign Keys in Mysql

Here is a MYSQL statement to insert Foreign Keys:
create table table1(lid int(11) not null, tid mediumint(9), tag text, FOREIGN KEY(lid) REFERENCES table2(lid) ON DELETE CASCADE, FOREIGN KEY(tid) REFERENCES table3(tid) ON DELETE CASCADE, PRIMARY KEY(lid,tid));

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