Archive for the ‘mysql’ Category
Responsive Web Design
Tuesday, May 25th, 2010IE9 and SVG?
Thursday, January 14th, 2010Hopefully this means that IE will soon support SVG. Or even better, support canvas natively…
http://blogs.msdn.com/ie/archive/2010/01/05/microsoft-joins-w3c-svg-working-group.aspx
Create new MySQL table
Thursday, October 15th, 2009CREATE TABLE new_table (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
bool_field tinyint(1) DEFAULT 0,
my_date datetime DEFAULT NULL
);
Adding field to existing MySQL table
Thursday, October 15th, 2009alter table table_name add new_field_name int(2) default 0;
Changing ENUM values
Wednesday, September 30th, 2009ALTER TABLE db.table_name CHANGE COLUMN old_column_name new_column_name ENUM(’first’,’second’,'third’) NOT NULL DEFAULT ‘first’;
WAMP Setup
Tuesday, July 7th, 2009Download and install the WampServer software.
Open up your HOSTS file. A typical place to look for it is in C:\Windows\System32\drivers\etc. If you are using Vista, make sure to open the file as administrator. Add IP address followed by host name. Example:
127.0.0.1 localjkwebstudio.com
Save HOSTS file
Open httpd.conf. Add the following code:
NameVirtualHost *
<Directory “C:/path/to/document/root”>
Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory “C:/path/to/files/outside/root/”>
Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<VirtualHost *>
DocumentRoot “C:\path\to\document\root”
ServerName localjkwebstudio.com
Alias /img/ C:/path/to/files/outside/root/
</VirtualHost>
Restart server
Installing Apache, MySQL and PHP on Windows Vista
Tuesday, July 17th, 2007When installing Apache, MySQL and PHP on Windows Vista, remember to disable User Account Control:
- Run MSCONFIG from the run/search menu.
- Select the Tools tab.
- Select Disable UAC and press Launch
- Restart computer
Instead of installing Apache, MySQL and PHP separately, I ended up installing the WAMP Server, which went very smoothly. You may have to restart your computer one more time before PHP sees your MySQL server.