JK Web Studio

Specializing in efficient and user friendly web design solutions

info@jkwebstudio.com

Archive for the ‘mysql’ Category

Responsive Web Design

Tuesday, May 25th, 2010

http://www.alistapart.com/articles/responsive-web-design/

IE9 and SVG?

Thursday, January 14th, 2010

Hopefully 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, 2009

CREATE 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, 2009

alter table table_name add new_field_name int(2) default 0;

Changing ENUM values

Wednesday, September 30th, 2009

ALTER 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, 2009

Download 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, 2007

When installing Apache, MySQL and PHP on Windows Vista, remember to disable User Account Control:

  1. Run MSCONFIG from the run/search menu.
  2. Select the Tools tab.
  3. Select Disable UAC and press Launch
  4. 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.