to retrieve a mysql data in php and echo the retrieved data

Question

    <?php
    $username = "root";
    $password = "password";
    $database = "xxxxxx";
    $link = mysql_connect("localhost", $username, $password);    
     $query = "SELECT rollno FROM users where username = '".$_SESSION['MM_Username']."'";
    mysql_select_db('xxxxxx', $link);
     $result = mysql_query($query) or die(mysql_error($link));
     $num = mysql_num_rows($result);
     mysql_close();

  $rows = array();

  $result = mysql_query($query) or die(mysql_error());
  $rows = array();
  while($r = mysql_fetch_row($result))
  {
   $rows[] = $r[0];
   }
   print_r($rows); 
   ?>

This is my code i want to display the roll number of the currently logged in user and when i run this code i get no database selected.

user2774977 · Accepted Answer · 2014-03-26 17:50:22Z

1

First of all, you should code properly, means database connection and database selection should be on top:

<?php
    $username = "root";
    $password = "password";
    $database = "xxxx";
    $link = mysql_connect("localhost", $username, $password);
    mysql_select_db('xxxx', $link);

    $query = "SELECT rollno FROM users where username = '".$_SESSION['MM_Username']."'";
    $result = mysql_query($query) or die(mysql_error($link));
    $num = mysql_num_rows($result);

    $rows = array();
    $result = mysql_query($query) or die(mysql_error());
    $rows = array();
    while($r = mysql_fetch_row($result))
    {
        $rows[] = $r[0];
    }

    print_r($rows);
    mysql_close();
   ?>

Also moved mysql_close(); on last
One other main point was, now mysql_ is deprecated, please use mysqli_

edited Mar 26, 2014 at 17:50

user2774977

892 gold badges3 silver badges11 bronze badges

answered Sep 13, 2013 at 9:57

Shreyas

2571 silver badge14 bronze badges

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

Comments

Kalpit · Accepted Answer · 2013-09-13 09:54:56Z

1

Remove this statement from line number 10

 mysql_close();

answered Sep 13, 2013 at 9:54

Kalpit

4,9365 gold badges27 silver badges45 bronze badges

Comments

Neophile · Accepted Answer · 2013-09-13 09:57:14Z

0

just remove these two lines before while that will solve ur problem

 $result = mysql_query($query) or die(mysql_error());
  $rows = array();

answered Sep 13, 2013 at 9:57

Neophile

1,51912 silver badges15 bronze badges

Comments

user2774977 · Accepted Answer · 2014-03-26 17:53:40Z

0

Use this code and use mysql_close function in the last.

<?php
    $username = "root";
    $password = "password";
    $database = "xxxxxx";
    $link = mysql_connect("localhost", $username, $password);    
     $query = "SELECT rollno FROM users where username = '".$_SESSION['MM_Username']."'";
    mysql_select_db($database, $link);
     $result = mysql_query($query) or die(mysql_error($link));
     $num = mysql_num_rows($result);

  $rows = array();

  $result = mysql_query($query) or die(mysql_error());
  $rows = array();
  while($r = mysql_fetch_row($result))
  {
   $rows[] = $r[0];
   }
   print_r($rows); 
   mysql_close();
   ?>

edited Mar 26, 2014 at 17:53

user2774977

892 gold badges3 silver badges11 bronze badges

answered Sep 13, 2013 at 10:13

Pankaj Singh Sugara

11 bronze badge

Comments

Zoe - Save the data dump · Accepted Answer · 2019-05-25 14:18:30Z

You have closed the connection from MySQL before the mysql_query mysql_close(); try this

    <?php
    $username = "root";
    $password = "password";
    $database = "dfsdftwsdgdfgdfsgsdf";
    $link = mysql_connect("localhost", $username, $password);    
     $query = "SELECT rollno FROM users where username = '".$_SESSION['MM_Username']."'";
    mysql_select_db('xxxxxxx', $link);
     $result = mysql_query($query) or die(mysql_error($link));
     $num = mysql_num_rows($result);


  $rows = array();

  $result = mysql_query($query) or die(mysql_error());
  $rows = array();
  while($r = mysql_fetch_row($result))
  {
   $rows[] = $r[0];
   }
  mysql_close();
   print_r($rows); 
   ?>

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO, or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

M Khalid Junaid · Accepted Answer · 2013-09-13 09:58:37Z

-1

The order should be like this

 mysql_select_db('meipolytechnic', $link); 


$query = "SELECT rollno FROM users where username = '".$_SESSION['MM_Username']."'";
    mysql_select_db('meipolytechnic', $link);

edited Sep 13, 2013 at 9:58

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

answered Sep 13, 2013 at 9:55

Nithin Dev

42111 silver badges29 bronze badges

Collectives™ on Stack Overflow

to retrieve a mysql data in php and echo the retrieved data

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related