I wrote code to connect to the database but it is showing in browser like this

[mmr315]

this is the code i had written in php to connect to mysql
=============== =============== ==========


<? php
class Database
{
var $database_name;
var $database_user;
var $database_pass;
var $database_host;
var $database_link;

function Database()
{
$this->database_use r = "admin";
$this->database_pas s = "admin";
$this->database_hos t = "192.168.1. 50";
$this->database_nam e = "onlineauction" ;
}



function changeUser($use r)
{
$this->database_use r = $user;
}

function changePass($pas s)
{
$this->database_pas s = $pass;
}

function changeHost($hos t)
{
$this->database_hos t = $host;
}

function changeName($nam e)
{
$this->databse_name = $name;
}

function changeAll($user , $pass, $host, $name)
{
$this->database_use r = $user;
$this->database_pas s = $pass;
$this->database_hos t = $host;
$this->database_nam e = $name;
}


function connect()
{
$this->database_lin k = mysql_connect($ this->database_hos t, $this->database_use r, $this->database_pas s) or die("Could not make connection to MySQL");
mysql_select_db ($this->database_nam e) or die ("Could not open database: ". $this->database_name) ;
}



function disconnect()
{
if(isset($this->database_link) ) mysql_close($th is->database_link) ;
else mysql_close();
}



function iquery($qry)
{
if(!isset($this->database_link) ) $this->connect();
$temp = mysql_query($qr y, $this->database_lin k) or die("Error: ". mysql_error());
}



function query($qry)
{
if(!isset($this->database_link) ) $this->connect();
$result = mysql_query($qr y, $this->database_lin k) or die("Error: ". mysql_error());
$returnArray = array();
$i=0;
while ($row = mysql_fetch_arr ay($result, MYSQL_BOTH))
if ($row)
$returnArray[$i++]=$row;
mysql_free_resu lt($result);
return $returnArray;
}
}
?>



in browser it is showing like this
=============== ==========
database_user = "admin"; $this->database_pas s = "admin"; $this->database_hos t = "192.168.1. 50"; $this->database_nam e = "onlineauction" ; } function changeUser($use r) { $this->database_use r = $user; } function changePass($pas s) { $this->database_pas s = $pass; } function changeHost($hos t) { $this->database_hos t = $host; } function changeName($nam e) { $this->databse_name = $name; } function changeAll($user , $pass, $host, $name) { $this->database_use r = $user; $this->database_pas s = $pass; $this->database_hos t = $host; $this->database_nam e = $name; } function connect() { $this->database_lin k = mysql_connect($ this->database_hos t, $this->database_use r, $this->database_pas s) or die("Could not make connection to MySQL"); mysql_select_db ($this->database_nam e) or die ("Could not open database: ". $this->database_name) ; } function disconnect() { if(isset($this->database_link) ) mysql_close($th is->database_link) ; else mysql_close(); } function iquery($qry) { if(!isset($this->database_link) ) $this->connect(); $temp = mysql_query($qr y, $this->database_lin k) or die("Error: ". mysql_error()); } function query($qry) { if(!isset($this->database_link) ) $this->connect(); $result = mysql_query($qr y, $this->database_lin k) or die("Error: ". mysql_error()); $returnArray = array(); $i=0; while ($row = mysql_fetch_arr ay($result, MYSQL_BOTH)) if ($row) $returnArray[$i++]=$row; mysql_free_resu lt($result); return $returnArray; } } ?>

[nathj]

Hi,

I see you have read the article on the forum about data abstraction layers. Excellent - it'll really help out.

Where is the code that uses this data abstraction layer? The that priduces the display on screen that you are not happy with?

If you could post that then that may help us get to the bottom of the problem.

Cheers
nathj

[ak1dnar]

in browser it is showing like this
=============== ==========
database_user = "admin"; $this->database_pas s = "admin"; $this->database_hos t = "192.168.1. 50"; $this->database_nam e = "onlineauction" ; } function changeUser($use r) { $this->database_use r = $user; } function changePass($pas s) { $this->database_pas s = $pass; } function changeHost($hos t) { $this->database_hos t = $host; } function changeName($nam e) { $this->databse_name = $name; } function changeAll($user , $pass, $host, $name) { $this->database_use r = $user; $this->database_pas s = $pass; $this->database_hos t = $host; $this->database_nam e = $name; } function connect() { $this->database_lin k = mysql_connect($ this->database_hos t, $this->database_use r, $this->database_pas s) or die("Could not make connection to MySQL"); mysql_select_db ($this->database_nam e) or die ("Could not open database: ". $this->database_name) ; } function disconnect() { if(isset($this->database_link) ) mysql_close($th is->database_link) ; else mysql_close(); } function iquery($qry) { if(!isset($this->database_link) ) $this->connect(); $temp = mysql_query($qr y, $this->database_lin k) or die("Error: ". mysql_error()); } function query($qry) { if(!isset($this->database_link) ) $this->connect(); $result = mysql_query($qr y, $this->database_lin k) or die("Error: ". mysql_error()); $returnArray = array(); $i=0; while ($row = mysql_fetch_arr ay($result, MYSQL_BOTH)) if ($row) $returnArray[$i++]=$row; mysql_free_resu lt($result); return $returnArray; } } ?>

Did You create a [dot] php file Or anyother extention.