Modify Records

D_tunisia

I want to be able to display records from my database in a form and then allow the user to edit and save them.

I can display the records and edit them but only separately! Can someone please point me in the right direction?

Thanks!

jannoy

post code here

D_tunisia

This is my code to display the results:

<?php
session_start();

if (!$_SESSION["valid_user"])
	{
	// User not logged in, redirect to login page
	Header("Location: login.php");
	}

// Display Member-only stuff
// ...
// ...
// ...


// Display Member information
echo "<p>User ID: " . $_SESSION["valid_id"];
echo "<p>Username: " . $_SESSION["valid_user"];
echo "<p>Logged in: " . date("m/d/Y", $_SESSION["valid_time"]);
echo "<br><br>";
include ("dbConfig.php");

$query = "SELECT count(*) FROM posts WHERE user_id=$_SESSION[valid_id]"; 
$result = mysql_query($query); 
$query_data = mysql_fetch_row($result); 
$total_posts = $query_data[0]; 

echo $_SESSION[valid_user] . ' posted ' . $total_posts . ' messages.';

// Display logout link
echo "<p><a href=\"logout.php\">Click here to logout!</a></p>";
?>


<?php

include ("dbConfig.php");
$id=$_SESSION["valid_id"];

$result = mysql_query("SELECT * FROM posts WHERE user_id='$id'");

echo "<table border=1>\n";

echo "<tr><td>Title</td><td>Text</tr>\n";

while ($myrow = mysql_fetch_row($result)) {

	printf("<tr><td>%s<br><br><a href=\"viewpost.php?id=%s\">Modify Post</a></td><td>%s</td></tr>\n",
	$myrow[2], $myrow[0], $myrow[3]);

}

echo "</table>\n";

D_tunisia

And this is my input code which I want to use. I want the results (when the user has clicked modify from the previous page) to be displayed in the form (value="" etc.) and then to be able to edit the text, click submit and change the record in the table.

<?php
session_start();
if (!$_SESSION["valid_user"])
	{
	// User not logged in, redirect to login page
	Header("Location: login.php");
	}


include ("dbConfig.php");

if ($submit) {

  $sql = "INSERT INTO posts (user_id,title,text) VALUES ('$user_id','$title','$text')";

  $result = mysql_query($sql);

  echo "Thank you! Information entered.\n";

} else{
?>
<form method="post" action="<?php echo $PHP_SELF?>">

<input type="hidden"  name="user_id" value="<?php print $_SESSION["valid_id"]; ?>">

<br>

  Title: <input type="Text" name="title"><br>

  Text: <textarea rows="10" name="text" cols="40"></textarea><br><br>

  <input type="Submit" name="submit" value="Go!">

  </form>
<?php



} // end if



?><br><br>
<?php
    virtual('menu.htm');
?>
</body>



</html>

jannoy

$sql = "INSERT INTO posts (user_id,title,text) VALUES ('$user_id','$title','$text')";

change to
$TITLE=$POST['TITLE'];
ID=$POST['USER_ID'];
$TITLE=$_POST['TITLE'];
$sql="update posts set title='$TITLE' , text='$TEXT' where user_id='$ID'";