try this
<?php
class base
{
#### SQL ####
//In this part of the Base class are located all sql related
functions
var $connected = false;
function sql_connect() //In this function u make a sql connection
{
############# FILL THIS IN: #############
$mysqlhost = 'localhost'; // Database
provider URL
$mysqluser = 'tobegood_test'; // Database
gebruiker
$mysqlpassword = 'test'; // Database wachtwoord
$mysqldb = 'tobegood_test1'; // Database
naam
############# That was all thnx ###########
if(!$this->connected)
{
$conn =
mysql_connect($mysqlhost,$mysqluser,$mysqlpassword ) or die("Could not
connect to database!");
$select = mysql_select_db($mysqldb,$conn) or
die("Could not select the database!");
$connected = true;
}
}
function sql_query($query) //With this function u do a sql query
{
if(!$this->connected)
{
$this->sql_connect();
}
$result = mysql_query($query) or die("MySQL error :
".mysql_error());
return ($result);
}
#### End SQL ####
}
class test extends base
{
function test()
{
$sql = $this->sql_query("SELECT * FROM wine");
$count = 0;
while($info = mysql_fetch_array($sql))
{
echo $info[$count];
$count++;
}
}
}
$test = new test();
?>
Haven't tested it because my php server is down but it should work
good luck
On 12 Oct 2003 03:15:28 -0700,
just_out_for_fun@hotmail.com (James)
wrote:
[color=blue]
>Please help - getting very desperate! Sun, 12 October 2003 05:39
>
>I have PHPDEV 4.2.3 from Firepages.com.au as the upgrade to 4.3.0 did
>not work. I also had an abortive download from PHP.NET as I could not
>configure Apache myself.
>
>The REAL problem is that PHPmyAdmin works and sees my test database
>Wines....
>But my PHP program does not!
>
>The code I have used is:
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML>
><TITLE> Getting PHP & MY SQL to work </TITLE>
><head>Wines PHP Tester<BR></head>
><body>
><?php
>echo "This is PHP here....<BR>\n";
>
>
>$link_id = @msql_pconnect("localhost");
>if (!$link_id) {
>echo ("Failed to connect to MySQL!");
>exit;
>}
>else;
>{
>echo "Connected OK!";
>}
>
>if (!mysql_select_db("Wines")) {
>echo ("Failed to select database cms!");
>exit;
>
>}
>echo ("Connected to Database");
>$resultset = mysql_query("SELECT * FROM wine");
>while ($row = mysql_fetch_row ($resultset)) {
>echo "Date $row[0]: $row[1]\n";
>}
>echo ("end");
>?>
></html>
></BODY>
></HTML>
>
>And I have also tried:
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML>
><HEAD>
><TITLE> Getting PHP & MY SQL to work </TITLE>
></HEAD>
>
><BODY>
><html>
><head>Wines PHP Tester<BR></head>
><body>
>
>
><?php
>echo "This is PHP here....<BR>\n";
>$connection = mysql_connect("localhost");
>
>$db = mysql_select_db("Wines",$connection);
>$query = "SELECT * FROM Wine";
>echo "Select...";
>$result = mysql_query($query,$connection);
>echo "result...";
>
>?>
></body>
></html>
></BODY>
></HTML>
>But I get no results. It works fine in PHPmyAdmin though.
>
>I did have a different Mysql on my XPHome box which I have
>subsequently deleted as it could not connect to the server once PHP
>was installed.
>
>I am falling further behind in my degree as I can even get the db up
>and running so I cant even get coding!
>
>Please please help.[/color]
