December 2009
6 posts
PHP
<?php
$q=$_GET["q"];
$con = mysql_connect('localhost', 'peter', 'abc123');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("ajax_demo", $con);
$sql="SELECT * FROM user WHERE id = '".$q."'";
$result = mysql_query($sql);
echo "";
Javascript
var xmlhttp;
function showUser(str)
{
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
{
alert ("Browser does not support HTTP Request");
return;
}
var url="getuser.php";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlhttp.onreadystatechange=stateChanged;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}
function stateChanged()
{
if...
CSS
/*This is a comment*/
p
{
text-align:center;
/*This is another comment*/
color:black;
font-family:arial
}
MySQL import from CSV
LOAD DATA LOCAL INFILE '/Users/Dave/Downloads/codes.csv'
INTO TABLE codes
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
1 tag
Useful MySQL Commands
Change engine:
ALTER TABLE tbl_name ENGINE=InnoDB;
Change charset:
ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Google Street View Examples
Google Street View API Docs
http://code.google.com/apis/maps/documentation/services.html#StreetviewClientQuerys
Google Maps API Reference
http://code.google.com/apis/maps/documentation/reference.html#GMarker
Rotating Canvas Marker
http://econym.org.uk/gmap/example_canvas.htm
Street View Map Sync (directional marker)
http://www.adamzastawski.com/samples/GoogleMapsStreetViewEvents.html
...