Code: Select all
<?php
$resource = mysqli_connect(*****)
or die('Could not connect: ' . mysqli_error());
$id = $_GET['songid'];
$result = mysqli_query($resource, "SELECT * FROM song WHERE songid='".$id."'");
$song = mysqli_fetch_array($result);
if($_POST['edit']){
$songid = $_POST['songid'];
$name = $_POST['name'];
$musicartistid = $_POST['musicartistid'];
$tracknumber = $_POST['tracknumber'];
$musicgenreid = $_POST['musicgenreid'];
$albumid = $_POST['albumid'];
?>
<TABLE border=1> <!--Passed values-->
<TR><TD>
Artist: </TD><TD><?echo $musicartistid;?></TD></TR>
<TR><TD>
Album: </TD><TD><?echo $albumid;?></TD></TR>
<TR><TD>
Track: </TD><TD><?echo $tracknumber;?></TD></TR>
<TR><TD>
Title: </TD><TD><?echo $name;?></TD></TR>
<TR><TD>
Genre: </TD><TD><?echo $musicgenreid;?></TD></TR>
</TABLE>
<?
$update = mysql_query("update song set name='$name', musicartistid='$musicartistid', tracknumber='$tracknumber', musicgenreid='$musicgenreid', albumid='$albumid' where songid='$songid'");
} ?>
<FORM name=firstEntry action=edit.php?<? echo $PHP_SELF; ?> method=POST>
<input name="songid" type="hidden" value="<?echo $id; ?>"/>
<TABLE border=1>
<TR><TD>
Artist: </TD><TD><INPUT type=text name=musicartistid id=musicartistid value="<?echo $song['musicartistid'];?>"></TD></TR>
<TR><TD>
Album: </TD><TD><INPUT type=text name=albumid id=albumid value="<?echo $song['albumid'];?>"></TD></TR>
<TR><TD>
Track: </TD><TD><INPUT type=text name=tracknumber id=tracknumber value="<?echo $song['tracknumber'];?>"></TD></TR>
<TR><TD>
Title: </TD><TD><INPUT type=text name=name id=name value="<?echo $song['name'];?>"></TD></TR>
<TR><TD>
Genre: </TD><TD><INPUT type=text name=musicgenreid id=musicgenreid value="<?echo $song['musicgenreid'];?>"></TD></TR>
</TABLE>
<INPUT type=submit name=edit value=Submit><BR />
</FORM>