Showing all table entries and being able to update or delete them with a form.

[damanic]

Hello there,

I'm new to this. Currently I am able to create forms to update a mysql table. I can display information from my tables no problem.

I have since been trying to figure out a way I can edit mysql entries for a table on one page. Say I have a table with the headers

'id' 'header' 'url' 'content'

in a table called 'news'

How can I display all the rows from this table in a form that can be edited and re-submited.

I would also like to be able to delete entries by ticking a check box next to that entry. So I could in one go select 2 or 3 for deletion and update others and have it all update the datavase with one submit button at the bottom of the page.

A point in the right direction would help me alot.

Matt

[damanic]

This is what I have at the moment to edit my records. I used this to create an edit.php. Hpwever when I load it up in browser I get a blank page. Nothing happens.

Im stuck.

<?php
$dbuser		= "me"; 
$dbserver	= "localhost"; 
$dbpass		= "me"; 
$dbname		= "database"; 

if ($post == "yes") {

//THEN WE ARE POSTING UPDATES TO A RECORD
//***** BEGIN UPDATE SQL*****
//REPLACE THE FIELD CONTENTS SO THEY DON'T MESS UP YOUR QUERY

$header = addslashes($header);
$header = ereg_replace(  "(\n)", "<BR>", $header );
$link = addslashes($link);
$link = ereg_replace(  "(\n)", "<BR>", $link );
$content = addslashes($content);
$content = ereg_replace(  "(\n)", "<BR>", $content );
//CONNECTION STRING
mysql_connect($dbserver, $dbuser, $dbpass)
or die ("UNABLE TO CONNECT TO DATABASE");
mysql_select_db($dbname)
or die ("UNABLE TO SELECT DATABASE");
//SQL STRING
$sql = "UPDATE cmir_news SET 
	header='$header',
		link='$link',
	  content='$content' 
	WHERE id='$id'";
$result = mysql_query($sql);
if ($result == 1) {
echo "Updated";
} else {
echo "Error Updating Record";
}


//***** END UPDATE SQL *****
} //END IF POST IS YES

if ($post == "") {
//THEN WE ARE EDITING A RECORD
//***** BEGIN EDIT FORM*****
//CONNECTION STRING
mysql_connect($dbserver, $dbuser, $dbpass)
or die ("UNABLE TO CONNECT TO DATABASE");
mysql_select_db($dbname)
or die ("UNABLE TO SELECT DATABASE");

$sql = "SELECT * FROM cmir_news WHERE id = $id";
$result = mysql_query($sql);

if ($myrow = mysql_fetch_array($result)) {
 do
 {
 ?>
  <form method="post" action="<?php echo $SCRIPT_NAME; ?>?post=yes">
  <TABLE>

<tr>
<td>
  <B>HEADER: </B>
</td>
<td>
<? $header = $myrow["header"]; ?>
<input type="text" name="header" value="<?php echo $header; ?>" size="20">

<tr>
<td>
  <B>LINK: </B>
</td>
<td>
<? $link = $myrow["link"]; ?>
<input type="text" name="link" value="<?php echo $link; ?>" size="20">

<tr>
<td>
  <B>CONTENT: </B>
</td>
<td>
<? $content = $myrow["content"]; ?>
<content name="content" rows="2" cols="20"><?php echo $content; ?> 
</textarea>

<tr>
<td>
</td>
<td>
<?
$id = $myrow["id"];
?>
<input type="hidden" value="<?php echo $id; ?>" name="id">
<input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="reset">
</td>
</tr>
</table>
<BR>
</form>
<?
}
while ($myrow = mysql_fetch_array($result));
}
} //END IF POST IS "" (THIS IS THE END OF EDITING A RECORD)

//***** END EDIT FORM*****
?>