Update Database with submit button

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
tri
Forum Newbie
Posts: 1
Joined: Sat Sep 26, 2009 1:34 pm

Update Database with submit button

Post by tri »

Hi, I've been having trouble updating my database with a submit button. I've done a lot of searching and I have no idea why it isn't working. I can pass the values past the submit button but it will not store in the database.

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>
Any help would be great! Thanks
User avatar
deejay
Forum Contributor
Posts: 201
Joined: Wed Jan 22, 2003 3:33 am
Location: Cornwall

Re: Update Database with submit button

Post by deejay »

if you write lines 35-38 like this

Code: Select all

 
<?php
$query = "UPDATE song SET name='$name', musicartistid='$musicartistid', tracknumber='$tracknumber', musicgenreid='$musicgenreid', albumid='$albumid' WHERE songid='$songid' ";
 
echo $query."<br><br>";
 
mysql_query($query); 
}
 ?>
you can at least have a look at what's query is being passed to the db.
Post Reply