Customer Support

You would actually need to add the following line after the shebang:

use DBI;

Here's how to connect using PHP

<?

//set local variables
$dbhost = "db.modwest.com"; 
$dbuser = "user"; 
$dbpass = "pass"; 
$dbname = "database"; 

//connect 
$db = mysql_pconnect($dbhost,$dbuser,$dbpass); 
mysql_select_db("$dbname",$db); 

?>

Once the connection is made you can run whatever query you want on the
database.

I made the following class. Enjoy it!
-------------------------
<?
class db
{
//Propiedades
	var $Host = DB_HOST;			// Hostname del servidor de MySQL
	var $Database = DB_NAME;		// Nombre Logico de la base de datos en el
servidor
	var $User = DB_USER;			// Usuario de Base de Datos
	var $Password = DB_PASS;		// Clave del usuario
	var $Link_ID = 0;			// Resultado de mysql_connect()
	var $Query_ID = 0;			// Resultado del ultimo mysql_query()
	var $Record = array();		        // Actual mysql_fetch_array()-result
	var $Row;				// Actual numero de fila
	var $Errno = 0;				// Estado de error del query
	var $Error = "";
	
//Metodos
	function halt($msg)
	{
		echo("<B>Error en Base de Datos:</B> $msg<BR>\n");
		echo("<B>Error en MySQL</B>: $this->Errno ($this->Error)<BR>\n");
		die("Session Abortada.");
	}

	function connect()
	{
		if($this->Link_ID == 0)
		{
			$this->Link_ID = mysql_connect($this->Host, $this->User,
$this->Password);
			if (!$this->Link_ID)
			{
				$this->halt("Link_ID == false, connect failed");
			}
			$SelectResult = mysql_select_db($this->Database, $this->Link_ID);
			if(!$SelectResult)
			{
				$this->Errno = mysql_errno($this->Link_ID);
				$this->Error = mysql_error($this->Link_ID);
				$this->halt("No se puede seleccionar la Base de datos
<I>".$this->Database."</I>");
			}
		}
	}

	function query($Query_String)
	{
		$this->connect();
		$this->Query_ID = mysql_query($Query_String,$this->Link_ID);
		$this->Row = 0;
		$this->Errno = mysql_errno();
		$this->Error = mysql_error();
		if (!$this->Query_ID)
		{
			$this->halt("SQL Invalida: ".$Query_String);
		}
		return $this->Query_ID;
	}

	function next_record()
	{
		$this->Record = mysql_fetch_array($this->Query_ID);
		$this->Row += 1;
		$this->Errno = mysql_errno();
		$this->Error = mysql_error();
		$stat = is_array($this->Record);
		if (!$stat)
                //if (!$this->Record)//annadida por mi
		{
			mysql_free_result($this->Query_ID);
			$this->Query_ID = 0;
		}
		return $this->Record;
	}

	function num_rows()
	{
		return mysql_num_rows($this->Query_ID);
	}

	function affected_rows()
	{
		return mysql_affected_rows($this->Link_ID);
	}

	function optimize($tbl_name)
	{
		$this->connect();
		$this->Query_ID = @mysql_query("OPTIMIZE TABLE
$tbl_name",$this->Link_ID);
	}

	function clean_results()
	{
		if($this->Query_ID != 0) mysql_freeresult($this->Query_ID);
	}

	function close()
	{
		if($this->Link_ID != 0) mysql_close($this->Link_ID);
	}
}
?>

 

Besides connecting to MySQL with PHPs generic MySQL extension, it is
preferred to use PDO with prepared statements. This reduces the
vulnerability of SQL injection. Example:

<?php

$car_make = 'Ford';
$car_model = 'Mustang';

try {
    $dbh = new PDO("mysql:host=$host;dbname=carsdb", $user, $pass);

    $stmt = $dbg->prepare('SELECT * FROM cars'
                        . ' WHERE car_make = :car_make'
                        . ' AND car_model = :car_model');
    $stmt->bindParam(':car_make', $car_make, PDO::PARAM_STR, 25);
    $stmt->bindParam(':car_model', $car_model, PDO::PARAM_STR, 25);
    $stmt->execute();

    $rows = $stmt->fetchAll();
    foreach ($rows as $row) {
        echo $row['car_make'] . '<br/>';
        echo $row['car_model'] . '<br/>';
    }

    /* close connection */
    $dbh = null;
} catch(PDOException $e) {
    echo $e->getMessage();
}