Viewing a particular record in a database

[fmsguy06]

Hello to all!

I have made a database allowing others to enter information about themselves (create.php):

<?php

require_once("database.php");
if (isset($_POST['submit'])) 
{

   $firstname = mysql_real_escape_string( $_POST['firstname'] );
   $lastname = mysql_real_escape_string( $_POST['lastname'] );
   $bio = mysql_real_escape_string( $_POST['bio'] );
   $gender = mysql_real_escape_string( $_POST['gender'] );

   $sql = "INSERT INTO profiles VALUES(null, '".$firstname."','".$lastname."','".$bio."','".$gender."')";
   $run = mysql_query($sql);

   if ($run)
      {
         echo "Your Project Was Created Successfully";
   }
      else
         {
            echo "There was an error".mysql_error();
         }

}
else
{


?>

<form action="create.php" method="post">
   First Name:<input type="text" name="firstname" /><br />
   Last Name:<input type="text" name="lastname" /><br />
   BIO:<br />
   <textarea name="bio" cols="50" rows="4"></textarea><br />
   Female:<input type="radio" name="gender" value="female">
   Male:<input type="radio" name="gender" value="male"><br />
   <input type="submit" name="submit" value="Create Profile" />
</form>

<?php
}
?>

which is stored in index.php:

<?php
//list out records in our table

require_once('database.php');

$sql = "SELECT id, firstname, lastname FROM profiles";
$run = mysql_query($sql);

echo "<table border=\"1\">";
echo "<tr>";
echo "<th>ID</th>";

echo "<th>First Name</th>";
echo "<th>Last Name</th>";

echo "<th>Actions</th>";
echo "</tr>";


while ($row = mysql_fetch_array($run))
   {
   echo "Another ";

  echo "<tr>";
  echo "<td>".$row['id']."</td>";
  echo "<td>".$row['firstname']."</td>";
  echo "<td>".$row['lastname']."</td>";
  echo "<td>";
  echo "<a href=\"view.php?id=".$row['id']."\">View |<a/>";
  echo "<a href=\"edit.php?id=".$row['id']."\">Edit |<a/>";
  echo "<a href=\"delete.php?id=".$row['id']."\">Delete<a/>";
  echo "</td>";
  echo "</tr>";
   }

echo "</table>";

?>

And here is the main database.php:

<?php

$db_server = "localhost";
$db_name = "project";
$db_user = "root";
$db_password = "";

$dbc = mysql_connect( $db_server, $db_user, $db_password )
               or die("Could not connect to Database. ");

$dbs = mysql_select_db( $db_name )
               or die("Could not select database. ");



?>

Everything works, except for view.php (which is used in index.php.) I'm not sure how to make it do what I am trying to do.

This:

  echo "<a href=\"delete.php?id=".$row['id']."\">Delete<a/>";

Allows deletion in database.

This:

  echo "<a href=\"edit.php?id=".$row['id']."\">Edit |<a/>";

Allows editing of information already stored.

And This:

  echo "<a href=\"view.php?id=".$row['id']."\">View |<a/>";

I'm trying to get this to show all information that was entered about a person. I'm not sure how to do this... I thank you all in advance!

[dagon]

what's in view.php?

[fmsguy06]

That's what I don't understand. Edit information, delete information, and add / remove someone from database, working well. I just can't figure out how to just view it, that information, firstname / lastname / bio and gender that gets input via create.php. If I can input it per person, I should be able to spit it out, per person. I am guessing it is like edit.php? As edit shows you what you have interred in first / last and allows editing of such...but I'm not sure...

[dagon]

does look like you should know this from what you have posted above

<?php
require_once('database.php');

$id=mysql_real_escape_string($_GET['id']);

$sql = "SELECT id, firstname, lastname FROM profiles where id=$id "; 

//run query
//output data in what ever format you like
?>

[fmsguy06]

That makes sense...

Using pieces from the other php files together and what you suggested, I am able to spit out the given information from input.

<?php
require_once('database.php');

$id=mysql_real_escape_string($_GET['id']);

$sql = "SELECT id, firstname, lastname, bio FROM profiles where id=$id ";

//run query

$results = mysql_query( $sql );
$row = mysql_fetch_array($results);



//output data in what ever format you like

echo "<form action=\"edit.php\" method=\"post\">";
echo "first name: <input type=\"text\" name=\"firstname\" value=\"".$row['firstname']."\" /><br />";
echo "last name: <input type=\"text\" name=\"lastname\" value=\"".$row['lastname']."\" /><br />";
echo "bio: <textarea name=\"bio\">".$row['bio']."</textarea><br />";
?> 

]

The results return in editable boxes:

Is there a way I can make these boxes un-editable?

[dagon]

If you don't want them editable, don't put them in a form.