Display SQL data in PHP

Question

Hi users of Stack Overflow,

I am facing a issue where my SQL data won't display properly and I am not sure on how to fix this problem. I only see the print section with no appropriate data.

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
 <link rel="stylesheet" href="css/default.css" type="text/css" />
 <link rel="stylesheet" href="css/timetable.css" type="text/css" />
<title>Timetable Information</title>
</head>
<body>


<div id="header"></div>


<ul id="NavigationList">
<li><a href="Index.php">Index</a></li>
<li><a href="ModuleInfo.php">Module Info</a></li>
<li><a href="ModuleSearch.php">Module Search</a></li>
<li><a href="Timetable.php">Timetable Search</a></li>

</ul>
<p>
<p>Please select a school from the drop-down list.</p>

   <?php
require('json.php');
error_reporting(E_ALL);
$connection = mysql_connect('localhost', 'root','') or
    die("Could not connect: " . mysql_error());
mysql_select_db("timetable") or die("No such database");
$sql = sprintf("
  SELECT id,day,start,module
    FROM event JOIN teaches ON (event.id=teaches.event)
   WHERE staff='%s'", mysql_real_escape_string($_REQUEST['staff']));
$result = mysql_query($sql)
  or die(mysql_error());
while ($row = mysql_fetch_array($result)){
    print "<div>$row[id] $row[module] $row[day] $row[start]</div>\n";
}
?>
</p>
<div id="Footer">
            <p id="FooterText">Copyright &copy; 2012 .<br     />All     rights reserved.</p>    
            </div>
</body>
</html>

Please remove error reporting and post the error you will get. So that we can able to debug it more accurately. — Rohit Choudhary
– Rohit Choudhary, Commented Apr 23, 2012 at 11:28
@RohitKumarChoudhary I am recieving no error, All I get displayed is {$row['id']} {$row['module']} {$row['day']} {$row['start']}\n"; } ?> — user1028145
– user1028145, Commented Apr 23, 2012 at 11:32
Try to print just the SQL query and run it to see if it even shows any data there — skos
– skos, Commented Apr 23, 2012 at 11:33

A.N.M. Saiful Islam · Accepted Answer · 2012-04-23 11:29:11Z

1

Use:

print "<div>{$row['id']} {$row['module']} {$row['day']} {$row['start']}</div>\n";

Instead of:

print "<div>$row[id] $row[module] $row[day] $row[start]</div>\n";

answered Apr 23, 2012 at 11:29

A.N.M. Saiful Islam

2,1387 gold badges28 silver badges35 bronze badges

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

2 Comments

user1028145 Over a year ago

I have changed it, but it only displays the line and not the data within the table.

A.N.M. Saiful Islam Over a year ago

Are you sure that mysql_num_rows($result) returns a value more than 0?

William Booth · Accepted Answer · 2016-09-28 14:33:36Z

1

while ($row = mysql_fetch_assoc($result)) { 
    $symbol= $row['Symbol'];
    $date= $row['Date']; 
    $avgprice= $row['avg_price']; 
    $var4 = $row['field4']
    ."<br>";


    echo "<tr>
        <td >".$symbol."</td>
        <td >".$date."</td>
        <td >".$avgprice."</td>
        <td >".$var4."</td>

    </tr>";

edited Sep 28, 2016 at 14:33

answered Mar 7, 2014 at 18:00

William Booth

1,2161 gold badge9 silver badges9 bronze badges

Comments

vicky · Accepted Answer · 2012-04-23 11:43:24Z

0

Try This

while ($row = mysql_fetch_array($result)){
echo "<div>".$row['id'];
echo $row['module'];
echo $row['day'];
echo $row['start'];
echo "</div>";
}

Instead of: print "$row[id] $row[module] $row[day] $row[start]\n";

answered Apr 23, 2012 at 11:43

vicky

7055 silver badges15 bronze badges

2 Comments

user1028145 Over a year ago

Displays this - ".$row['id']; echo $row['module']; echo $row['day']; echo $row['start']; echo ""; } ?>

vicky Over a year ago

try this$sql = "SELECT id,day,start,module FROM event JOIN teaches ON (event.id=teaches.event) WHERE staff='%s'", mysql_real_escape_string($_REQUEST['staff']); $result = mysql_query($sql)

srini · Accepted Answer · 2012-04-23 12:00:16Z

0

try something like this

print "<div>".$row[id]. $row[module]. $row[day]. $row[start]."</div>\n";

answered Apr 23, 2012 at 12:00

srini

8843 gold badges13 silver badges23 bronze badges

Collectives™ on Stack Overflow

Display SQL data in PHP

4 Answers 4

2 Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related