Formaterade koden lite åt dig. Jag missade tom. att det var en klass...så rörig var den ;)
Kod:
<?php
class mysql
{
var $mysql_address = "HOST";
var $mysql_user = "USER";
var $mysql_password = "PASSWORD";
var $mysql_con;
var $mysql_result;
var $mysql_NrOfRows;
function mysql($address = '', $user = '', $password = '')
{
$this->setInfo($address, $user, $password);
}
function setInfo($address = '', $user = '', $password = '')
{
$this->mysql_address = ($address != '') ? $address : $this->mysql_address;
$this->mysql_user = ($user != '') ? $user : $this->mysql_user;
$this->mysql_password = ($password != '') ? $password : $this->mysql_password;
}
function connect()
{
$this->mysql_con = mysql_connect($this->mysql_address, $this->mysql_user, $this->mysql_password) or die(mysql_errno() . ': ' . mysql_error());
}
function disconnect()
{
mysql_close($this->mysql_con);
}
function free()
{
mysql_free_result($this->mysql_result);
}
function select_db($database_name)
{
mysql_select_db($database_name, $this->mysql_con) or die(mysql_errno() . ': ' . mysql_error());
}
function query($sql_query)
{
$this->mysql_result = mysql_query($sql_query, $this->mysql_con) or die(mysql_errno() . ': ' . mysql_error());
}
}
?>
Sen bör du göra som tidigare sagt.
Kod:
<?php
include "din_klass.php";
$conn = new mysql("host", "user", "psw");
$conn->connect();
$conn->select_db("namn");
?>
Meeen....det verkar ju vara något galet med behörighet/ditt användarnamn så :)
Scriptet är för övrigt skrivet för PHP4 tror jag. |
