Starting Point

snipervip

I have entries in my sql database for downloads. Sometimes those need to be edited by people who do not have access to the server. What I want to create is a form that will pull the data out of certain fields, allow the user to update the content and hit submit, updating the database. I know how to update fields, but not how to pull the data out first and place it in a form for editing. An example would be, they go to the update form and there's a textarea that has the description and name from the database. They can read what it says edit the typos, or change it all together, then rewrite it back to the database. Any ideas? Suggestions?

snipervip

I've figured out how to make the fields auto populate from the sql. The problem now is the page keeps reposting the form over and over again. I think it has to do with this line, but when I change it, the fields don't auto populate.

while(list($id, $name, $dis, $icon, $maker, $date) = mysql_fetch_array($result))

What am I missing here?

<head>
<style type="text/css">
a {
	color: #008000;
}
a:visited {
	color: #008000;
}
a:active {
	color: #008000;
}
a:hover {
	color: #008000;
}
</style>
</head>
<html>
<?php
include 'inc/config.php';
include 'inc/opendb.php';

$query  = "SELECT id, name, dis, icon, maker, date FROM upload";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
	echo "Database is empty <br>";
} 
else
{
	while(list($id, $name, $dis, $icon, $maker, $date) = mysql_fetch_array($result))
	{

?>

<center>
<body bgcolor="Black" style="color: #008000">
<input type="hidden" name="id" value="<?=$_REQUEST['id'] ?>">
<strong class="font"><span class="style2">Name:</span></strong><span class="style4"><strong><br />
<input type="text" name="name" size="30" value="<?=$dis;?>"><br>
</strong></span>
<strong class="font"><span class="style2">Icon:</span></strong><span class="style4"><strong><br>
<input type="text" name="icon" size="30" value="<?=$icon;?>"><br>
</strong></span>
<strong class="font"><span class="style2">Maker:</span></strong><span class="style4"><strong><br />
<input type="text" name="maker" size="30" value="<?=$maker;?>"><br>
</strong></span>
<strong class="font"><span class="style2">Date:</span></strong><span class="style4"><strong><br />
<input type="text" name="date" size="30" value="<?=$date;?>"><br>
</strong></span>

<?php		
	}
}
include 'inc/closedb.php';
?>

</body>
</html>

ednark

You need to do some research on "HTML Forms" and "PHP Forms" so that you can figure out how to tell your forms how to submit themselves to the right place. google it.

your code needs several things

a section of code to pull data out from the database (which you have)
a section of code that displays that data (which you have)
a section of code that listens for form submissions
a section of code that writes changes to the database
a section of code that tells the user how the data went

you can do this in several files or all in one. if you do this in several files you will need to know how to tell the form to submit (<form>) how to redirect to a success/fail page (header('Location')).

if you do this all in one file, you need to have if(){} statements with very big sections.

happy hunting