Cultivate Web Design Melbourne – Development Blog

scp ./logs.csv chris@bk1.cultivatewebdesign.com.au:~/logs_2008-04.csv

du -ks ./* | sort -n -r

Using username "serveradmin@cultivatewebdesign.com.au".
Using keyboard-interactive authentication.
Password:

The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
cultivatewebdesign.com.au@n11:~$ ls
backups  data  domains  images  includes  index.html  services.html
cultivatewebdesign.com.au@n11:~$ cd backups/
cultivatewebdesign.com.au@n11:~/backups$ ls
cultivatewebdesign.com.au  db50477_jewel.sql      le-jewel.com
daybydaydream.com          languagetutors.com.au  s50477.gridserver.com
cultivatewebdesign.com.au@n11:~/backups$ cd daybydaydream.com/
cultivatewebdesign.com.au@n11:~/backups/daybydaydream.com$ ls
cgi-bin  html
cultivatewebdesign.com.au@n11:~/backups/daybydaydream.com$ cd ht
-bash: cd: ht: No such file or directory
cultivatewebdesign.com.au@n11:~/backups/daybydaydream.com$ cd html/
cultivatewebdesign.com.au@n11:~/backups/daybydaydream.com/html$ ls
cultivatewebdesign.com.au@n11:~/backups/daybydaydream.com/html$ ls
cultivatewebdesign.com.au@n11:~/backups/daybydaydream.com/html$ ls
cultivatewebdesign.com.au@n11:~/backups/daybydaydream.com/html$ ****!

This is what the form should look like.

<form action="uploader.php" enctype="multipart/form-data" method="post">
<input name="uploadfile" type="file" />
<input type="submit" value="Upload file" />
</form>

Then we create a table in the database to hold the file.

CREATE TABLE  `cms`.`images` (
  `image_id` int(10) unsigned NOT NULL auto_increment,
  `image` blob,
  `name` varchar(45) default NULL,
  `type` varchar(45) default NULL,
  `size` varchar(45) default NULL,
  `title` varchar(45) default NULL,
  PRIMARY KEY  (`image_id`)
) ENGINE=MyISAM AUTO_INCREMENT=88 DEFAULT CHARSET=latin1;

Finally we have the uploader.php to insert the file into the database.

mysql_connect('localhost','cms_user','******') or die(mysql_error());
mysql_select_db('cms') or die(mysql_error());

$image_fp = fopen($_FILES['uploadfile']['tmp_name'], 'r');
$image = addslashes(fread($image_fp, $_FILES['uploadfile']['size']));
$name = $_FILES['uploadfile']['name'];
$type = $_FILES['uploadfile']['type'];
$size = $_FILES['uploadfile']['size'];
fclose($image_fp);

mysql_query("INSERT INTO images (image,name,type,size) VALUES ('$image','$name','$type','$size')") or die(mysql_error());
echo mysql_insert_id();

The include to go on the header, replace the abcdef key with your google API key.

<script type="text/javascript" src="http://maps.google.com/maps?file=api&v=2&key=abcdefg&sensor=true">

The

window.addEvent('domready',function()
{	new GClientGeocoder().getLatLng('',function(pt)
{	if (pt)
{	var map = new GMap2(document.getElementById('map'));
map.setCenter(pt, 13);
map.addOverlay(new GStreetviewOverlay());
map.addOverlay(new GMarker(pt));
map.addControl(new GSmallMapControl());
map.addControl(new GMapTypeControl());

myPano = new GStreetviewPanorama(document.getElementById('street-view'), { latlng:pt });
GEvent.addListener(map,'click', function(overlay,latlng)
{	myPano.setLocationAndPOV(latlng);
});
}
});

});
window.onunload = GUnload;

Get a list of column names for a table.

SHOW COLUMNS FROM TableName

Load a comma separated (csv) data into a MySQL table.

LOAD DATA LOCAL INFILE '/tmp/members.csv' INTO TABLE members FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n' (lastname, firstname, dob);

Rename a MySQL table.

ALTER TABLE access_log RENAME TO access_log_old;

Create a new user and give them access to a MySQL database.

GRANT ALL ON cms.* TO cms_user@'localhost' IDENTIFIED BY '******';

Join fields in a MySQL query.

SELECT CONCAT('Name: ' , members.first_name ,' ', members.last_name) AS name FROM members

MySQL search and replace.

UPDATE pages SET footer_text = REPLACE(footer,'Copyright 2007','Copyright 2008');