|
|
Posted by mpar612 on 10/14/68 11:55
J.O. Aho wrote:
> mpar612 wrote:
> > J.O. Aho wrote:
> >> mpar612 wrote:
> >>
> >>> Thanks! I should have mentioned that the following is required because
> >>> they are being pulled form the url
> >>> www.domain.com/delete_record.php?isbn=123456789&artist_name=Mike&album_title=:
> >> When looking at your example you don't provide this data at all and to make
> >> things a lot easier I would include them into the form as hidden input-tags.
> >> Things gets a lot easier if you keep on sending data in the same way and not
> >> try to mix.
> >>
> >>
> >> //Aho
> >
> > Thanks! Could you please elaborate a little bit more, I'm a beginner
> > and I don't really understand what you are saying. I don't see how I
> > am trying to mix the way that I am sending data.
> >
> > Thanks!
> >
>
> You claim you are trying to use data sent as POST and GET at the same time,
> thats a try in mixing, in your example you don't send anything that could be
> fetched with $_GET.
>
>
> --- send all as post ---
> <form method="POST" action="">
> <table>
>
> <tr><td colspan="2" align="center">Yes <?php
> input_radiocheck('radio','yes_no', $defaults, 'yes'); ?> No <?php
> input_radiocheck('radio','yes_no', $defaults, 'no'); ?>
> </td></tr>
>
> <tr><td colspan="2" align="center"><?php input_submit('save','Add'); ?>
> </td></tr>
>
> </table>
> <input type="hidden" name="isbn" value="<?PHP echo $isbn; ?>" />
> <input type="hidden" name="artist_name" value="<?PHP echo $artist_name; ?>" />
> <input type="hidden" name="album_title" value="<?PHP echo $album_title; ?>" />
> <input type="hidden" name="_submit_check" value="1"/>
> </form>
> --- end of example ---
>
> There you get all the data you needed to send, all sent as post.
>
>
> //Aho
Thanks, but I'm afraid that I don't understand why this needs to be
done. I have variables, $isbn = $_GET['isbn'], $artist_name =
$_GET['artist_name'] and $album_title = $_GET['album_title'] that are
pulling information from the url:
"www.domain.com/delete_record.php?isbn=1234567689&artist_name=&album_title=."
I want to run the delete query "DELETE FROM lounge WHERE isbn = $isbn
AND artist_name=\'$artist_name\' AND album_title=\'$album_title\'.
The $_GET values work when I do a print $isbn etc... The delete query
works in phpmyadmin when I specify hard values for isbn, artist_name
and album_title. For example the following query works: DELETE FROM
lounge WHERE isbn = 123456789.
These things will not work together and I'm not sure why. I believe it
is an issue with $isbn = $_GET['isbn'], $artist_name =
$_GET['artist_name'] and $album_title = $_GET['album_title'] and
inserting the variable names in the SQL query, but I'm not sure how
this works. My books don't cover this specific problem in detail.
Thank you very much for all of your help. I apologize if I'm asking
too many questions.
Navigation:
[Reply to this message]
|