I need help with a PHP script to display editable databse content. help!!?

M

Mac-C

New member
Hi guys, I have the following script that echos content from a database. It works fine but I need to Action (Edit / Delete) to actually delete and edit content that is in the database... how do I go about doing that???

<html>
<head>
<title>Home </title>
</head>
<body>
<div align="center">
<p>
| <a href="index.php">Home</a>
| <a href="registration.php">Register</a>
| <a href="login.php">Login</a>
| <a href="insert.php">Insert</a>
| <a href="list.php">List</a>
| <a href="learner.php">About learner</a> | </p>
<p> </p>
<hr />
<h1>List Artist Data</h1>

<?php
$username="root";
$password="";
$database="cd_data";
$host = "localhost";

mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM artists_db";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Artist Id</font></th>
<th><font face="Arial, Helvetica, sans-serif">Artist Name</font></th>
<th><font face="Arial, Helvetica, sans-serif">Genre</font></th>
<th><font face="Arial, Helvetica, sans-serif">Venue</font></th>
<th><font face="Arial, Helvetica, sans-serif">Contact Number</font></th>
<th><font face="Arial, Helvetica, sans-serif">Rate</font></th>
<th><font face="Arial, Helvetica, sans-serif">Action</font></th>
</tr>

<?php
$i=0;
while ($i < $num)
{
$f1=mysql_result($result,$i,"artist_id");
$f2=mysql_result($result,$i,"artist_name");
$f3=mysql_result($result,$i,"genre");
$f4=mysql_result($result,$i,"venue");
$f5=mysql_result($result,$i,"contact_number");
$f6=mysql_result($result,$i,"rate");
$f7=mysql_result($result,$i,"rate" );
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo 'edit |'; echo ' delete' ?></font></td>
</tr>

<?php
//this loop will continue to print the rest of the table...
$i++;
}
?>
</table>
</div>
</body>
</html>
 
Back
Top