wow! this fixed it..
$dbc = mysqli_connect('127.0.0.1','admin',secret','trek_db')
or die ('Could not connect to database');
used to be...
$dbc = mysqli_conect('127.0.0.1','admin','Duk30fZh0u','trek_db')
or die ('Could not connect to database');
d'oh!! spelling counts!!! :)
On Sun, Jun 10, 2012 at 1:15 AM, Tim Dunphy <[email protected]> wrote:
> 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
--
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
