PHP - Why Do My Page Display Half Way Down The Page

Quesion: Show each movie in the database on its own page, and give the user links in a "page 1, Page 2, Page 3" - type navigation system. Hint: Use LIMIT to control which movie is on which page. I have provided 3 files: 1st: configure DB, 2nd: insert data, 3rd: my code for the question. I would appreciate the help. I am a noob by the way.

First set up everything for DB:

<?php
//connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//create the main database if it doesn't already exist
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query, $db) or die(mysql_error($db));

//make sure our recently created database is the active one
mysql_select_db('moviesite', $db) or die(mysql_error($db));

//create the movie table
$query = 'CREATE TABLE movie (
        movie_id        INTEGER UNSIGNED  NOT NULL AUTO_INCREMENT,
        movie_name      VARCHAR(255)      NOT NULL,
        movie_type      TINYINT           NOT NULL DEFAULT 0,
        movie_year      SMALLINT UNSIGNED NOT NULL DEFAULT 0,
        movie_leadactor INTEGER UNSIGNED  NOT NULL DEFAULT 0,
        movie_director  INTEGER UNSIGNED  NOT NULL DEFAULT 0,

        PRIMARY KEY (movie_id),
        KEY movie_type (movie_type, movie_year)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die (mysql_error($db));

//create the movietype table
$query = 'CREATE TABLE movietype (
        movietype_id    TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
        movietype_label VARCHAR(100)     NOT NULL,
        PRIMARY KEY (movietype_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

//create the people table
$query = 'CREATE TABLE people (
        people_id         INTEGER UNSIGNED    NOT NULL AUTO_INCREMENT,
        people_fullname   VARCHAR(255)        NOT NULL,
        people_isactor    TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
        people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

        PRIMARY KEY (people_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Movie database successfully created!';
?>



********************************************************************
***********************************************************************

second file to load info into DB:



<?php
// connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//make sure you're using the correct database
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// insert data into the movie table
$query = 'INSERT INTO movie
        (movie_id, movie_name, movie_type, movie_year, movie_leadactor,
        movie_director)
    VALUES
        (1, "Bruce Almighty", 5, 2003, 1, 2),
        (2, "Office Space", 5, 1999, 5, 6),
        (3, "Grand Canyon", 2, 1991, 4, 3)';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the movietype table
$query = 'INSERT INTO movietype
        (movietype_id, movietype_label)
    VALUES
        (1,"Sci Fi"),
        (2, "Drama"),
        (3, "Adventure"),
        (4, "War"),
        (5, "Comedy"),
        (6, "Horror"),
        (7, "Action"),
        (8, "Kids")';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the people table
$query  = 'INSERT INTO people
        (people_id, people_fullname, people_isactor, people_isdirector)
    VALUES
        (1, "Jim Carrey", 1, 0),
        (2, "Tom Shadyac", 0, 1),
        (3, "Lawrence Kasdan", 0, 1),
        (4, "Kevin Kline", 1, 0),
        (5, "Ron Livingston", 1, 0),
        (6, "Mike Judge", 0, 1)';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Data inserted successfully!';
?>



**************************************************************
****************************************************************

MY CODE FOR THE QUESTION:


<?php
$db = mysql_connect('localhost', 'root', '000') or
die ('Unable to connect. Check your connection parameters.');

mysql_select_db('moviesite', $db) or die(mysql_error($db));

//get our starting point for the query from the URL
if (isset($_GET['offset'])) {
   $offset = $_GET['offset'];
} else {
   $offset = 0;
}

//get the movie
$query  = 'SELECT
   movie_name, movie_year
FROM
   movie
ORDER BY
   movie_name
LIMIT ' . $offset . ' , 1';
$result = mysql_query($query, $db) or die(mysql_error($db));
$row = mysql_fetch_assoc($result);
?>
<html>
<head>
<title><?php echo $row['movie_name']; ?></title>
</head>
<body>
<table border = "1">
<tr>
<th>Movie Name</th>
<th>Year</th>
</tr><tr>
<td><?php echo $row['movie_name']; ?></td>
<td><?php echo $row['movie_year']; ?></td>
</tr>
</table>
<p>
<a href="page.php?offset=0">Page 1</a>,
<a href="page.php?offset=1">Page 2</a>,
<a href="page.php?offset=2">Page 3</a>
</p>
</body>
</html>

Some code from my pages ,   Page1 ( Redirecting page )

<html>
<title>login_redirect.</title>
body>

<form name="redirect" action="http://mysite/page2.php" method="post">
<input type="hidden" name="mac" value="$(mac)">
</form>

<script language="JavaScript">
<!--
document.redirect.submit();
//-->
</script>
</body>
</html>

Page 2 ( select product )

<?php


session_start();

ini_set('display_errors',1);
error_reporting(E_ALL); 

include '../lib/config.php';
include '../lib/opendb.php';

// get user mac adres from redirect post page1
$_SESSION['macid'] = $_POST['mac'];
// set $macid for other use ( maybe not needed, am learning )
$macid = $_SESSION['macid'];

// echo $macid does show mac adress, so variable is not empty here


if (!empty($_POST["submit"]))

{
$product_choice = $_POST['accounttype'];
$query= "SELECT AccountIndex, AccountCost, AccountName FROM AccountTypes WHERE AccountIndex='$product_choice'";
$result = mysql_query($query) or die('Query failed. ' . mysql_error()); 
while($row = mysql_fetch_array($result))
{
$_SESSION['AccountIndex'] = $row['AccountIndex'];
$_SESSION['AccountCost'] = $row['AccountCost'];
$_SESSION['AccountName'] = $row['AccountName'];
}


header('Location: page3.php');

}

// did leave out the other/html/form stuff here

Page 3 ( show Session variables )

<?php


ini_set('display_errors',1);
error_reporting(E_ALL); 

session_start();

print_r($_SESSION);

?>

Now, on page 3 i do see the right session varables, only the "macid" is empty.   why ?    

Hey,

I'm having problems displaying data from a mysql database properly.

Problem page: here

It's a bit like a cms, a user fills out a form asking for a page title and the page content, thats then stored in the database and the finished result should be the page title added to the navigation and when clicked displaying the relevant page.

I don't know if its possible but I'd like it to be done all on the one page.

As you can see on the link I provided, when you click more than one link it displays it on the same page, rather than replacing itself. Can you help with this?

Code:
<html>
<head>
<script>

function show_content(id){
    document.getElementById(id).style.display='block';
}


</script>
</head>
<body>
<font face=verdana size=1>
<?php
include 'dbwire.php'; 

$query = mysql_query('SELECT * FROM content');

while($results = mysql_fetch_array($query,MYSQL_ASSOC)){
    $title = $results['title'];
    $id = $results['id'];
    $content = $results['content'];
    echo "| <a href=\"javascript:void(0);\" onclick=\"show_content($id)\">$title</a> ";
    echo "<div id=\"$id\" style=\"display:none\">$content</div>";
}


?>
<hr>

</body>
</html>

Also, any idea how I should do the navigation? As you can see the more pages added the longer the navigation will get...eventually extending beyond the page width and creating problems.

I understand I have problems explaining, if you need more just let me know!

Thanks,
Drew.

Hi,

So I am currently making a real estate site for my class at school but I am having a tiny issue with the listing display page.

So what I want to do is show a bunch of listing that the agent owns on their dashboard which I have already done. Now I have two links one to update the listing and one to view the listing. Now what I am trying to do is when the view listing link is clicked it will take the user to the listing-display page and then I want it to display all the information for the listing that the link was clicked under. But i cannot for the life of me figure out how to do that!

 

This is currently the code for the dashboard where you only view the listing headline

<?php

// If the session was never set with a user id
$output = '';
$conn = db_connect();
if($_SESSION['userType'] != AGENT)
{
    $_SESSION['RedirectError'] = "You were not logged in as an Agent<br/>";
    header("Location:login.php");
}
if (isset($_GET["page"])) {
    $page  = $_GET["page"];
    $index = ($page -1) * IMAGE_LIMIT;
}
else {
    $page=1;
    $index = 0;
 }


?>
  <!-- start of main page content -->
  <div class="container" style="margin-top: 2em;">
    <h2>Dashboard</h2>

      <p>Welcome back <?php echo $_SESSION['userId']; ?> you last logged in on <?php echo $_SESSION['last_access']; ?></p>
      <h4>Your Listings</h4>
      <?php
          $sql = "SELECT listing_id FROM listings WHERE user_id = '".$_SESSION['userId']."' AND status = 'o' ORDER BY listing_id";
          $result = pg_query($conn, $sql);
          $listings = pg_fetch_all($result);
          for($index; $index < pg_num_rows($result); $index++)
          {
              $sql = "SELECT * FROM listings WHERE listing_id = '".$listings[$index]['listing_id']."'";
              $listing_result = pg_query($conn, $sql);
              $arrayRow = pg_fetch_assoc($listing_result);
              echo (build_listing_card($arrayRow));
              if($index !=0 && ($index +1) % IMAGE_LIMIT ==0){
                  break;
              }
          }
      ?>
          </div>
          <br/>
          <?php
          $total_pages = ceil(count($listings) / IMAGE_LIMIT);
          $pageLink = "<div class='pagination'>";
          for ($i=1; $i<=$total_pages; $i++) {
                       if($i == $page)
                       {
                          $pageLink .= "<a class='active' href='dashboard.php?page=".$i."'>".$i."</a>";
                       }
                       else {
                           $pageLink .= "<a href='dashboard.php?page=".$i."'>".$i."</a>";
                       }
          };
           ?>
       </div>
       <br/>

and this is the code for the listing-display page where I want all the listing information to be displayed
 

<?php

if (isset($_GET['listing_id']))
    {
        $_SESSION['listing_id'] = $_GET['listing_id'];
    }
    else
    {
        $_SESSION['listing_id'] = 0;
        echo "ERROR: listing information was not find";
    }

    $sql = 'SELECT * FROM listings WHERE listing_id = ' . $_SESSION['listing_id'];
    echo "<BR>".$sql;
    $result = pg_query(db_connect(), $sql);
    $records = pg_num_rows($result);

    echo "<BR>".pg_fetch_result($result, 0, "listing_id");
    echo "<BR>".pg_fetch_result($result, 0, "user_id");
    echo "<BR>".pg_fetch_result($result, 0, "status");
    echo "<BR>".pg_fetch_result($result, 0, "price");
    echo "<BR>".pg_fetch_result($result, 0, "headline");
    echo "<BR>".pg_fetch_result($result, 0, "description");
    echo "<BR>".pg_fetch_result($result, 0, "postal_code");
    echo "<BR>".pg_fetch_result($result, 0, "images");
    echo "<BR>".pg_fetch_result($result, 0, "city");
    echo "<BR>".pg_fetch_result($result, 0, "property_options");
    echo "<BR>".pg_fetch_result($result, 0, "bedrooms");
    echo "<BR>".pg_fetch_result($result, 0, "bathrooms");
    echo "<BR>".pg_fetch_result($result, 0, "garage");
    echo "<BR>".pg_fetch_result($result, 0, "purchase_type");
    echo "<BR>".pg_fetch_result($result, 0, "property_type");
    echo "<BR>".pg_fetch_result($result, 0, "finished_basement");
    echo "<BR>".pg_fetch_result($result, 0, "open_house");
    echo "<BR>".pg_fetch_result($result, 0, "schools");
?>
<h1> Listing Display </h1>
<hr/>
<table style="width:50%" border="1px solid black">
    <tr>
        <th>Listing Image</th>
        <th>Listing Description</th>
    </tr>
    <tr>
        <th rowspan="2">
            <img src="" alt="Oshawa House" width="300px" height="200px"/>
        </th>

        <td align="left" valign="top">
        <h3><?php echo pg_fetch_result($result, 0, "headline")  ?></h3>
        <ul>
        <li>Open house?: <?php echo get_property('open_house', pg_fetch_result($result, 0, "open_house"))?> </li>
        <li>Finished Basement?: <?php echo get_property('finished_basement', pg_fetch_result($result, 0, "finished_basement"))?></li>
        <li><?php echo get_property('purchase_type', pg_fetch_result($result, 0, "purchase_type"))?></li>
        <li>Garage Type: <?php echo get_property('garage_type', pg_fetch_result($result, 0, "garage"))?></li>
        <li>Near school?: <?php echo get_property('schools', pg_fetch_result($result, 0, "schools"))?></li>
        <li>Status: <?php echo get_property('listing_status', strtolower(pg_fetch_result($result, 0, "status"))) ?></li>
        <li>Washrooms: <?php echo get_property('washrooms',pg_fetch_result($result, 0, "bathrooms"))  ?></li>
        <li>Bedrooms: <?php echo get_property('bedrooms',pg_fetch_result($result, 0, "bedrooms"))  ?></li>
        <li>Description: <?php echo pg_fetch_result($result, 0, "description")  ?></li>
        </ul>
        </td>

    </tr>
    <tr>
        <td align="left" valign="top"><ul>
            <li>Location: <?php echo get_property('cities',pg_fetch_result($result, 0, "city"))  ?></li>
            <li>Postal Code: <?php echo pg_fetch_result($result, 0, "postal_code") ?></li>
            <li>Price: <?php echo pg_fetch_result($result, 0, "price") ?></li>
            </ul>
        </td>
    </tr>

</table>
<form action="listing-matches.php">
<p>
<input type="submit" name="submit" value="Back"/></p>
</form>

 

 

it cant display the page i cant find the page i tryed to see whats wrong but it thing all brace and semicolos are were there suppose to be at

it gives me a Server error

Code: [Select]
<?php
if(isset($_POST['submitbtn'])){

//will open up the db connection
include "../includes/connect.php";

$errors = "";
$welcometitle = mysql_real_escape_string($_POST['welcometitle']);
$welcomesection = mysql_real_escape_string($_POST['welcomesection']);
$infotitle = mysql_real_escape_string($_POST['infotitle']);
$infosection = mysql_real_escape_string($_POST['infosection']);
$videotitle = mysql_real_escape_string($_POST['videotitle']);
$videosection = mysql_real_escape_string($_POST['videosection']);

if(isset($welcometitle && $welcomesection)) && !empty($welcometitle && $welcomesection)){
if(isset($infotitle && $infosection)) && !empty($infotitle && $infosection)){
if(isset($videotitle && $videosection)) && !empty($videotitle && $videosection)){

//adding them to the db
$query = mysql_query("UPDATE home SET `welcometitle`=`$welcometitle`,`welcomesection`=`$welcomesection`,`infotitle`=`$infotitle`,
`infosection`=`$infosection`,`videotitle`=`$videosection`");

header("location: http://www.website.org/control/edithome");

}else{
$errors = "Please fill in the Video Section";
}
}else{
$errors = "Please fill in the Info Section";
}
}else{
$errors = "Please fill in the Welcome Section";
}

mysql_close();//will close the inlcude db connection
}
?>