Chapter 4 "Populating the Table"

Chudz · December 16th, 2006, 09:14 PM

Table2.php

Code:

<?php

$link = mysql_connect("localhost", "chudz_moviesite", "moviesite")
  or die("Hey loser, check your server connection.");

mysql_select_db("chudz_moviesite");

$query = "SELECT movie_name, movie_director, movie_leadactor " .
     "FROM movie ";

$result = mysql_query($query, $link)
  or die(mysql_error());

$num_movies = mysql_num_rows($result);

$movie_header =<<<EOD
<h2><center>Movie Review Database</center></h2>
<table width="70%" border="1" cellpadding="2" cellspacing="2" align="center">
  <tr>
    <th>Movie Title</th>
    <th>Movie Director</th>
    <th>Movies Lead Actor</th>
  </tr>
</table>
EOD;

$movie_details = '';
while ($row = mysql_fetch_array($result)) {
  $movie_name = $row['movie_name'];
  $movie_director = $row['movie_director'];
  $movie_leadactor = $row['movie_leadactor'];

$movie_details .=<<<EOD
<tr>
  <td>$movie_name</td>
  <td>$movie_director</td>
  <td>$movie_leadactor</td>
</tr>
EOD;
}

$movie_details .=<<<EOD
 <tr>
  <td> </td>
 </tr>
 <tr>
  <td>Total :$num_movies Movies</td>
 </tr>
EOD;

$movie_footer ="</table>";

$movie =<<<MOVIE
          $movie_header
          $movie_details
          $movie_footer
MOVIE;

    echo "There are $num_movies movies in our database";
    echo $movie;

?>

This is what it turned out like http://www.chudz.com/animenzb/table2.php

What have I missed or done I check out the code about 5 times now still cant see whats wrong. Why is half of the table missing :(

tbrown · December 18th, 2006, 02:21 PM

Hello Chudz. Try these "tips" (mine is working fine - but i know this can be tedious):
1.) mysql_select_db("chudz_moviesite")
  or die (mysql_error()); //you dont have an "or die"
2.) Try this also (insated of whta you had.
movie_details .="<tr>
        <td>$movie_name</td>
        <td>$director</td>
        <td>$leadactor</td>
        </tr>";
}

$movie_details .="
        <tr>
        <td>Total :$num_movies Movies</td>
        </tr>
        ";

3.) $movie ="$movie_header $movie_details $movie_footer "; // instead of
$movie =<<<MOVIE
          $movie_header
          $movie_details
          $movie_footer
MOVIE

Let me know how that works out - i will check the forum again - and hang in there.

mobyme · April 16th, 2007, 06:58 PM

Double check to make sure there is no whitespace. Even the source code does not work for this because of whitespace here:$movie_details .=<<<EOD<whitespace> I only found this out by accident.

elmono001 · August 24th, 2007, 01:30 PM

HELPP!!!! PLEASE
i just got starting with this book...and now im stuck at same point as you are(hope were)....same code..but this message

Parse error: parse error, unexpected $end in C:\wamp\www\libro\table1.php on line 52

this is my code

<?php
//la conexion
$link = mysql_connect("localhost", "user", "user") or die (mysql_error());

//la base de datos
mysql_select_db ("moviesite") or die (mysql_error());

//la seleccion
$query = "SELECT movie_name, movie_director, movie_leadactor FROM movie";

$result = mysql_query($query, $link) or die (mysql_error());
$num_movies = mysql_num_rows($result);

$movie_header=<<<EOD
<h2><center>Movie Review Database</center></h2>
<table width="70%" border="1" cellpadding="2" cellspacing="2" align="center">
<tr>
<th>Movie Title</th>
<th>Year of Release</th>
<th>Movie Director</th>
<th>Movie Lead Actor</th>
<th>Movie Type</th>
</tr>
</table>
EOD;
echo $movie_header;

$movie_details=' ';
while ($row=mysql_fetch_array($result))
{
    $movie_name = $row['movie_name'];
    $movie_director = $row['movie_director'];
    $movie_leadactor = $row['movie_leadactor'];

    $movie_details.=<<<EOD
    <tr>
    <td>$movie_name</td>
    <td>$movie_director</td>
    <td>$movie_leadactor</td>
    </tr>
    EOD;
}

$movie_details.=<<<EOD
<tr>
<td> </td>
</tr>
<tr>
<td>Total :$num_movies Movies</td>
</tr>
EOD;
?>

IF ANYONE CAN TAKE ME OUT OF THIS #@**&(# --- THNKS A LOT :)

elmono001 · August 24th, 2007, 01:31 PM

HELPP!!!! PLEASE
i just got starting with this book...and now im stuck at same point as you are(hope were)....same code..but this message

Parse error: parse error, unexpected $end in C:\wamp\www\libro\table1.php on line 52

this is my code

<?php
//la conexion
$link = mysql_connect("localhost", "user", "user") or die (mysql_error());

//la base de datos
mysql_select_db ("moviesite") or die (mysql_error());

//la seleccion
$query = "SELECT movie_name, movie_director, movie_leadactor FROM movie";

$result = mysql_query($query, $link) or die (mysql_error());
$num_movies = mysql_num_rows($result);

$movie_header=<<<EOD
<h2><center>Movie Review Database</center></h2>
<table width="70%" border="1" cellpadding="2" cellspacing="2" align="center">
<tr>
<th>Movie Title</th>
<th>Year of Release</th>
<th>Movie Director</th>
<th>Movie Lead Actor</th>
<th>Movie Type</th>
</tr>
</table>
EOD;
echo $movie_header;

$movie_details=' ';
while ($row=mysql_fetch_array($result))
{
    $movie_name = $row['movie_name'];
    $movie_director = $row['movie_director'];
    $movie_leadactor = $row['movie_leadactor'];

    $movie_details.=<<<EOD
    <tr>
    <td>$movie_name</td>
    <td>$movie_director</td>
    <td>$movie_leadactor</td>
    </tr>
    EOD;
}

$movie_details.=<<<EOD
<tr>
<td> </td>
</tr>
<tr>
<td>Total :$num_movies Movies</td>
</tr>
EOD;
?>

IF ANYONE CAN TAKE ME OUT OF THIS #@**&(# --- THNKS A LOT :)