Server error while trying to display data from mysql db in php

Question

I have a database, db_db which I want to display data from in my browser. I have put this php code (display.php) under /var/www/ and trying to access localhost/display.php. Though everytime I come across "Server Error" The website encountered an error while retrieving http://localhost/display.php. It may be down for maintenance or configured incorrectly.

The code is below:

<?php
 //make conn
 $link = mysql_connect('localhost', 'root', '');

 //select db
 mysql_select_db('db_db') or die( "Unable to select db");
 $sql =  "SELECT * FROM results WHERE jobid = 'abc'";
 $records = mysql_query($sql);
?>


<html>
<head>
 <title> Result Info </title>
</head>

<body>
<table width="600" border = "1" cellpadding = "1" cellspacing= "1">
<tr>
 <th>id</th>
 <th>name</th>
<tr>

<?php
 while($result = mysql_fetch_assoc($records)){
   echo "<tr>";
   echo "<td>.$result['id'].</td>";
   echo "<td>.$result['name'].</td>";
   echo "</tr>";
 }//end while
?>

</table>
</body>
</html>

Not sure where am I going wrong.

This sounds more like an apache issue. Can you retrieve a simple html page? — Robbert
– Robbert, Commented May 14, 2014 at 4:50
Yes I have a info.php (phpinfo() ) in the same path i.e. /var/www/ which returns me the value as expected on localhost/info.php — Quick Silver
– Quick Silver, Commented May 14, 2014 at 4:52
the mysql_* functions are deprecated. You should look into using PDO or mysqli. I also see an error in the code that generates the table cells. echo "<td>.$result['id'].</td>"; should be echo "<td>" . $result['id'] . "</td>"; — Robbert
– Robbert, Commented May 14, 2014 at 4:56
This clearly doesn't seem to be programming related problem. — asprin
– asprin, Commented May 14, 2014 at 5:01
@learning, These are access logs, They only gave information about request. Their would be also error logs which would have error information. On Ubuntu their path should be /var/log/apache2/error.log — kuldeep.kamboj
– kuldeep.kamboj, Commented May 14, 2014 at 6:15

user3575290 · Accepted Answer · 2014-05-14 05:23:31Z

1

There might be the problem with your database select and query syntax. Modify your code

<?php
 //make conn
 $link = mysql_connect('localhost', 'root', '');

 //select db
 mysql_select_db('db_db', $link) or die( "Unable to select db");
 $sql =  "SELECT * FROM results WHERE jobid = 'abc'";
 records = mysql_query($sql);
?>

Check if it works. Good luck

answered May 14, 2014 at 5:23

user3575290

113 bronze badges

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

2 Comments

Quick Silver Over a year ago

How is this different from above code? apart from assigning a variable to mysql_connect

user3575290 Over a year ago

its not just assigning the variable, Check the sixth line. It sets the current active database on the server that's associated with the specified link identifier. Please check php.net/manual/en/function.mysql-select-db.php

Collectives™ on Stack Overflow

Server error while trying to display data from mysql db in php

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related