Add as favorite

[doddsey_65]

Im trying to set up an add as favorite link on my tutorials. When the link is clicked it sends the name of the tutorial and the users username to a database table called favorites. The only problem is that its not sending anything to the database. Here is the insert query:

 

 if (isset($_POST['fav'])) {

$qry = "INSERT INTO favorites (username, tutorialid, tutorialname, tutorialauthor)
				VALUES ('".$loiginusername."', '".$row->id."', '".$row->name."', '".$row->fullname."')";

$add_fav = mysql_query($qry);
}

 

And here is the form:

 

echo '<form name="addfavorite" action="' . $_SERVER['PHP_SELF'] . '?id=' . $id . '" method="POST">';
		echo '<input type="image" src ="images/icons/fav.png" name="fav" />';
		echo '</form>';

 

How can i get this to work?

[siric]

try this

$qry = "INSERT INTO favorites (username, tutorialid, tutorialname, tutorialauthor)
				VALUES ('$loiginusername', '$row->id', '$row->name', '$row->fullname')";

 

Might I also assume that you have spelt $loiginusername incorrectly?

[doddsey_65]

i have done what you said, and yes it was spelled incorectly so i have changed it but still nothing is giong into the database.

[doddsey_65]

Okay i have changed it a little but its still not working. Heres the form:

 

echo '<table><tr><td style="padding: 5px;">';
		echo '<form name="fav" action="' . $_SERVER['PHP_SELF'] . '?id=' . $id . '" method="post">';
		echo '<input type="hidden" name="id" value="'.$id.'">';
		echo '<input type="hidden" name="name" value="'.$row->name.'">';
		echo '<input type="hidden" name="fullname" value="'.$row->fullname.'">';
		echo '<input type="image" src ="images/icons/fav.png" name="fav" />';
		echo '</form>';

And heres the php:

 

 if (isset($_POST['fav'])) {

$qry = "INSERT INTO favorites (username, tutorialid, tutorialname, tutorialauthor)					
VALUES ('$loginusername', '".$_POST['id']."', '".$_POST['name']."', '".$_POST['fullname']."')";

$add_fav = mysql_query($qry);

}

[cs.punk]

Check for errors on mysql. Or echo your query.

 

$add_fav = mysql_query($qry) or die("$qry" . mysql($con))
;

 

[doddsey_65]

i get no errors and when i echo the query everything is as it should be. I even copied the echoed query and used it in phpmyadmin and it added the data. Could it be because i dont have any inputs in the form because they are all just hidden?

[cs.punk]

What does your query echo?

 

And do you have error reporting on?

 

Your saying the query works in phpmyadmin but not in your script?

[doddsey_65]

how do i activate error reporting?

 

the query echos the right values and when i insert the echoed query into phpmyadmin it inserts the values correctly, however the query in the script doesnt work. No values get added to the database.

[doddsey_65]

Okay i figured out the problem but i dont know why its a problem. Its this bit:

 

<input type="image" src ="images/icons/fav.png" name="fav" />

 

If i just use the standard submit button it works fine.

 

<input type="submit" value=Favorite" name="fav" />

 

So how is this not working with an image?

[doddsey_65]

from what i have seen the name attribute is not used when using an image as the submit button. The codes i have seen divert you to a different page via form action. But i want to stay on the same page. I just dont know how to work around this. Any ideas?