Archives for the 'ASP' Category

Separate Instances of MySQL 4.0 and MySQL 4.1 on Windows

Assuming you already have MySQL 4.0 running on its default port (3306), install MySQL 4.1 and set its service name to MySQL41 and its port to 3307.
The ASP connection string is as follows:
“driver={MYSQL ODBC 3.51 Driver};” & _
“server=localhost;port=3307;” & _
“uid=user1;pwd=a_password;database=db1″
The PHP connection method is as follows:
$c = mysql_connect(”localhost:3307″, “user1″, “a_password”);
mysql_select_db(”db1″, $c);

28 March 2007 | MySQL, ASP, PHP | 1 Comment

Encode Your URL Parameters

If you wish to query a URL using the HTTP GET method, problems will arise if your parameters contain characters such as ? and &.
The solution is to use encodeURIComponent (client-side Javascript) or Server.URLEncode (ASP) or urlencode (PHP).
There is no need to do any extra work at the server side for Request.QueryString(”…”) or $_GET[”…”].
encodeURIComponent example:
location.href […]

21 October 2006 | Software engineering, HTTP, Javascript, ASP, PHP | No Comments