WebMe - Website Design & Development

To access a MySQL database in ASP you can use the following script:

Function getDBConn()

Set conDB=Server.CreateObject("ADODB.Connection")
 conDB.Open "Driver={MySQL ODBC 3.51 Driver};" & _ 
      "Server=mysql.myserver.net;" & _
      "Port=3306;" & _
      "Option=131072;" & _
      "Stmt=;" & _
      "Database=mydatabase;" & _
      "Uid=myname;" & _
      "Pwd=mypassword"
End Function

Remember to change the Server address to the address of your MySQL database; also you will need to change the Database, Uid and Pwd parameters as appropriate.

Labels: asp, mysql, source code

To access a MySQL database in PHP you can use the following script:

<?php
$dbhost = 'mysql.myserver.net';
$dbuser = 'myname';
$dbpass = 'mypassword';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die 
('Error connecting to mysql');

$dbname = 'mydatabase';
mysql_select_db($dbname);
?>

Remember to change the Host address to the address of your MySQL database; also you will need to change the dbname, dbuser and dbpass parameters as appropriate.

Labels: mysql, php, source code

We have decided to remove our Resources section in order to keep all useful code snippets and tips in our blog so we will post some of the content of those pages here.
The first one is the ASP Server Variables table:

The table below shows the Server Variables available in ASP and example values.

To access Server Variables in ASP we use:

Request.ServerVariables (server_variable)

Labels: asp, source code

function validateParam($param, $default = "") {
if (!isset($param) || $param=="") {
 return $default;
}
return $param;
}

function doGet($param, $default = "") {
if (array_key_exists($param, $_GET)) {
 return validateParam($_GET[$param], $default);
}
return $default;
}
function doPost($param, $default = "") {
if (array_key_exists($param, $_POST)) {
 return validateParam($_POST[$param], $default);
}
return $default;
}