show info from mysql db

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hello list,

 I tried designing a very basic couple of web pages tonight that was
solely meant to build some php chops. intentionally cheesy. I got half
the way there by designing a page that grabs some info from an html
form and puts that info into a mysql database.

This part works.  You can see that page here:

<html>
<head><title>Starship Crew</title></head>
<body bgcolor="black">
<center><img src="logo.jpg" alt="Star Trek Logo"  /> </center>
<font size="3" color="white">
<style>
        .box{
                font-family:Tahoma, Geneva, sans-serif;
                font-size:16px;
                text-align: center
        }
</style>

  <p>Enter your First Name, Last Name, Rank, Division,Ship and Email
address.</p>
  <form method="post" action="addcrew.php" >

    <tr><td><label for="firstname">First name:</label>
    <input type="text" id="firstname" name="firstname" /></td></tr><br />
    <tr><label for="lastname">Last name:</label>
    <input type="text" id="lastname" name="lastname" /></tr><br />
    <tr><label for="rank">Rank:</label>
    <input type="text" id="rank" name="rank" /><br /></tr>
    <tr><label for="division">Division:</label>
    <input type="text" id="division" name="division" /><br /></tr>
    <tr><label for="ship">Ship:</label>
    <input type="text" id="ship" name="ship" /><br /></tr>
    <tr></tr><label for="email">Email:</label>
    <input type="text" id="email" name="email" /><br /></tr>
    <input type="submit" name="Submit" value="Submit" />
  </form>

   <a href='showcrew.php'>Show crew manifest</a>


<center><img src="enterprise.jpg" alt="Enterprise"  /> </center>
</font>
</body>
</html>

This is the one table in the database:

mysql> describe crew_manifest;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| first_name | varchar(20) | YES  |     | NULL    |       |
| last_name  | varchar(20) | YES  |     | NULL    |       |
| rank       | varchar(10) | YES  |     | NULL    |       |
| division   | varchar(10) | YES  |     | NULL    |       |
| ship       | varchar(20) | YES  |     | NULL    |       |
| email      | varchar(20) | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.06 sec)

and this is the corresponding php page that inputs the info:

<?php

$first_name = $_POST['firstname'];
$last_name = $_POST['lastname'];
$rank = $_POST['rank'];
$division =  $_POST['division'];
$ship = $_POST['ship'];
$email = $_POST['email'];

$dbc = mysqli_connect('127.0.0.1','admin','secret','trek_db')
   or die('Error connecting to MySQL database');


$query = "INSERT INTO crew_manifest VALUES
('$first_name','$last_name','$rank','$division','$ship','$email')";

$result = mysqli_query($dbc,$query)
  or die('Error querying database');

  echo "crew member added";


  mysqli_close($dbc);


?>

But the page that reads the info is the problem:

<html>
<head>
<title>Show Crew</title>
</head>

<body bgcolor="black">
<center><img src="ncc1701.jpg" alt="NCC 1701"  /> </center>
<font size="3" color="white">
<style>
        .box{
                font-family:Tahoma, Geneva, sans-serif;
                font-size:16px;
                text-align: center
        }
</style>
<center>Crew Manifest</center>

<?php

    $dbc = mysqli_conect('127.0.0.1','admin','secret','trek_db')
     or die ('Could not connect to database');

    $query = "SELECT * FROM crew_manifest";

    $result = mysqli_query($dbc,$query);

    while ($row = mysqli_fetch_array($result)) {
    $first_name = $row['first_name'];
    $last_name = $row['last_name'];
    $rank = $row['rank'];
    $division = $row['division'];
    $ship = $row['ship'];
    $email = $row['email'];

    echo  $rank . '<br />';
  }

   mysqli_close($dbc);


?>
</font>
</html>

What I'd like to find out is why the while loop does not display info
from the database? The page does show up, but not any info from the
db.

Thanks in advance.

tim

-- 
GPG me!!

gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux