Jump to content

Archived

This topic is now archived and is closed to further replies.

seran128

PHP Classes

Recommended Posts

OK what I want to do is create a class that I can include on my other pages, call function from that class and return those resluts to the calling page. Any references to online materials on php classes would be great!

My code should be something like;


class_db.php

  class db(){

//Top level db connection

var $db_name="db_name";
var $db_host="localhost";
var $db_user="db_user";
var $db_password="db_password";


$connection=mysql_connect($db_host,$db_user,$db_password) or die("I Couldn't connect");
$db=mysql_select_db($db_name,$connection) or die("I Couldn't select your database");

function getlist($inTable){

$sql="select * from $inTable order by ID";
$result=mysql_query($sql,$connection) or die(mysql_error());

//I need to return my $result here but don't know how

}

function updatelist($inTable,$description,$id){

            $sql="update $inTable set description='$description' where regionId='$id'";
$result=mysql_query($sql,$connection) or die(mysql_error());


//I need to return my $result here but don't know how

}

function deletelist($inTable,$id){

            $sql="delete from $inTable where regionId='$id'";
$result=mysql_query($sql,$connection) or die(mysql_error());


//I need to return my $result here but don't know how

}


//also need to close any dbconnection but don't know how
//end the class
}


page.php

include("class_db.php");
.......
<?

getlist(my_table)
$i = 0;

//Need to return the output from the function so the following line can use it.

while($row=mysql_fetch_array($result)) {
$i++;
echo "<tr class=\"d".($i & 1)."\">";
?>

....other HTML code Is Here........

<? } ?>


Share this post


Link to post
Share on other sites
My question is how do I get this to work using classes?

I would like to learn how to use classes in PHP but I have no clue on how to get data back from a function in a class.

Share this post


Link to post
Share on other sites
Access the variables and functions within the class using "->".

Example:
[code]
//myClass.inc
class myClass{
  var $testVar;
  function testFunc(){
    return $this->testVar;
  }
}

//test.php

include("myClass.inc");
$mc = new myClass;
$mc->testVar = "Hello there!";

echo $mc->testFunc();  //this will output "Hello there" to the screen
[/code]

Some further reading:
[url=http://us3.php.net/class]http://us3.php.net/class[/url]
[url=http://codewalkers.com/tutorials/54/1.html]http://codewalkers.com/tutorials/54/1.html[/url]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.