PHP MYSQL database connection and showing data is not working

Question

im new to php mysql, need help. Im unable to show data from mysql database through below codes. It shows a blank page :(. can anyone help me please?. below is my config file and index file codes.

config.php

<?php
class DB {

    protected $db_name = 'drive';
    protected $db_user = 'root';
    protected $db_pass = '';
    protected $db_host = 'localhost';


    public function connect() {
        $connection = mysql_connect($this->db_host, $this->db_user, $this->db_pass);
        mysql_select_db($this->db_name);
        return true;
    }


class showClass{
    //USER LIST SHOW function
public function showUser($table){

        $query=mysql_query("SELECT * FROM $table WHERE type='user'") or die(mysql_error()); 
        $data=NULL;
        if(mysql_num_rows($query)>0){
            while($rows=mysql_fetch_assoc($query)){
            $data[]=$rows;
            }
            return $data;
        }else{
            echo '<span class="text-info success">No Account Found.</span>';
        exit();
        }

    }

}

index.php

<?php
require_once 'conf/config.php';


$db = new DB();
$db->connect();
$obj_show = new showClass();
?>
<html>
<head>
<title>Drive</title>
</head>
<body>

<table class="table table-bordered table-hover" cellpadding="5">

<tr>
<th scope="col"><b>User ID</b></th>
<th scope="col"><b>Name</b></th>
</tr>


<?php

  $allData=$obj_show->showUser("user");
  foreach($allData as $data){
      extract($data);
        echo <<<show

<tr>
  <td>$id</td>
  <td >$username</td>  
</tr>

show;
  }
  ?>

</table>

</body>

I'm not sure... But why your first "new" keyword" starts with a capital letter? Plus, did you try to make a var_dump() of $db and $obj_show variables after creating them? — Cruel_Crow
– Cruel_Crow, Commented Apr 10, 2014 at 5:43
if its a blank page, can you check what what is the error display level and add ini_set('display_errors', 1); at the top of your script and check the output again — opensource-developer
– opensource-developer, Commented Apr 10, 2014 at 5:47
@opensource-ios i just added ini_set('display_errors', 1); and the page is whoing this Parse error: syntax error, unexpected T_CLASS, expecting T_FUNCTION in C:\wamp\www\connection\conf\config.php on line 20 — Sahed
– Sahed, Commented Apr 10, 2014 at 5:50

Cruel_Crow · Accepted Answer · 2014-04-10 05:53:40Z

2

As I said in comments already, you're missing } after the end of class DB.

answered Apr 10, 2014 at 5:53

Cruel_Crow

3493 silver badges15 bronze badges

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

Comments

Rakesh Sharma · Accepted Answer · 2014-04-10 06:00:26Z

2

as @Cruel answer you are missing } at the end of class DB try to change

class DB {

    protected $db_name = 'drive';
    protected $db_user = 'root';
    protected $db_pass = '';
    protected $db_host = 'localhost';


    public function connect() {
        $connection = mysql_connect($this->db_host, $this->db_user, $this->db_pass);
        mysql_select_db($this->db_name);
        return true;
    }
}

answered Apr 10, 2014 at 6:00

Rakesh Sharma

13.7k5 gold badges41 silver badges44 bronze badges

Comments

opensource-developer · Accepted Answer · 2014-04-10 05:59:47Z

You have a syntax error as shown by your output which got displayed when you added ini_set function

The correct code is as below, you need to add a closing bracket after the class DB

<?php
class DB {

    protected $db_name = 'drive';
    protected $db_user = 'root';
    protected $db_pass = '';
    protected $db_host = 'localhost';


    public function connect() {
        $connection = mysql_connect($this->db_host, $this->db_user, $this->db_pass);
        mysql_select_db($this->db_name);
        return true;
    }

}// MISSING CLOSING BRACKET
class showClass{
    //USER LIST SHOW function
public function showUser($table){

        $query=mysql_query("SELECT * FROM $table WHERE type='user'") or die(mysql_error()); 
        $data=NULL;
        if(mysql_num_rows($query)>0){
            while($rows=mysql_fetch_assoc($query)){
            $data[]=$rows;
            }
            return $data;
        }else{
            echo '<span class="text-info success">No Account Found.</span>';
        exit();
        }

    }

}

Collectives™ on Stack Overflow

PHP MYSQL database connection and showing data is not working

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related