Using Php mysql query do not get data from php class, though there are data

Question

class book {

function __construct() {
$conn = mysql_connect('localhost', 'root', '') or die('can nit connect to DB');
mysql_select_db('atomic_project', $conn) or die('can not connect to db');
}

public function listView() {
    $allData = array();
    $query = "SELECT * FROM `book`";
    $result = mysql_query($query);
    while ($row = mysql_fetch_assoc($result)) {
        print_r($row);
        $allData [] = $row;
    }
    return $allData;
}

}

My index page

    $listViewObj = new book();
    $allData = $listViewObj->listView();

    echo "<pre>";
    print_r($allData);
    echo "<pre>";

Here is my code and the table here is my table data , i can insert data into table but no row is found i can't understand why no data is shown, please help me

Where is your class object and where is you calling this function. Please share your full code? — Domain
– Domain, Commented Mar 12, 2016 at 11:42
$book_show=new book(); and then $book_show->listView(); use this after your code. — Domain
– Domain, Commented Mar 12, 2016 at 11:44
and y r u asking for db password, OP using localhost. @WisdmLabs — devpro
– devpro, Commented Mar 12, 2016 at 11:55

Aman Kumar · Accepted Answer · 2016-03-12 12:55:19Z

1

    <?php
class book {

public function listView() {
    $conn = mysql_connect('localhost', 'root', '') or die('can nit connect to DB');
    mysql_select_db('atomic_project', $conn) or die('can not connect to db');

    $allData = array();
    $query = "SELECT * FROM `book`";
    $result = mysql_query($query);
    while ($row = mysql_fetch_assoc($result)) {
        //echo "<pre>";
        //print_r($row);
        $allData [] = $row;
    }
   return $allData;
}
}
book::listView(); //scope resolution operator 
?>

or calling function by object

$obj = new book();
$obj->listView();

edited Mar 12, 2016 at 12:55

answered Mar 12, 2016 at 11:59

Aman Kumar

4,5573 gold badges21 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Php mysql query do not get data from php class, though there are data

1 Answer 1

or calling function by object

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

or calling function by object

Comments

Your Answer

Sign up or log in

Post as a guest

Related