mysql选择oop php

Question

This is my oop php code for connection for my database. But how can i do the SELECT function. i wanna show data in my page from database. help me with this

class createConnection //create a class for make connection
{
    var $host = "localhost";
    var $username = "root"; // specify the sever details for mysql
    var $password = "";
    var $database = "akpGroup";
    var $myconn;

    function connectToDatabase() // create a function for connect database
    {
        $conn = mysql_connect($this->host, $this->username, $this->password);
        if (!$conn) // testing the connection
        {
            die ("Cannot connect to the database");
        } else {
            $this->myconn = $conn;
            echo "Connection established";
        }

        return $this->myconn;
    }

    function selectDatabase() // selecting the database.
    {
        mysql_select_db($this->database); //use php inbuild functions for select database
        if (mysql_error()) // if error occured display the error message
        {
            echo "Cannot find the database " . $this->database;
        }
        echo "Database selected..";
    }

    function closeConnection() // close the connection
    {
        mysql_close($this->myconn);
        echo "Connection closed";
    }

Answer 1

May be something like this

$link = mysql_connect('localhost','root','yourPassword')
mysql_select_db('database_name', $link);
$sql = 'SELECT column FROM tablename';
$result = mysql_query($sql, $link) or die(mysql_error());
$row = mysql_fetch_assoc($result);
print_r($row);