Delete Script

[mpar612]

Hi everyone,

I appreciate all of your help with me and the problems I have been
having. I'm new to PHP and MySQL and I'm having some problems getting
this script to work. I can't get this to work and I don't understand
why. I don't get an error or anything, it almost seems like the page
refreshes. I went to the phpmyadmin and the row is still in the
database. The $_GET parts work perfectly in another script and the SQL
statement works when I insert hard values in it. Any thoughts would be
greatly appreciated. Thanks in advance.

<form method="POST" action="<?php print $_SERVER['PHP_SELF']; ?>">
<table>

<tr><td colspan="2" align="center"> Yes <?php
input_radiochec k('radio','yes_ no', $defaults, 'yes'); ?No <?php
input_radiochec k('radio','yes_ no', $defaults, 'no'); ?>
</td></tr>

<tr><td colspan="2" align="center"> <?php input_submit('s ave','Add'); ?>
</td></tr>

</table>
<input type="hidden" name="_submit_c heck" value="1"/>
</form>

<?php

function process_form() {

// Access the global variable $db inside this function
global $db;

$isbn = $_GET['isbn'];
$artist_name = $_GET['artist_name'];
$album_title = $_GET['album_title'];

if ($_POST['yes_no'] == 'yes') {

$delete_sql = "DELETE FROM lounge WHERE isbn = $isbn AND artist_name =
\'$artist_name\ ' AND album_title = \'$album_title\ '";
// Delete the record
$db->query($delete_ sql);
print "The record was deleted";
} else {
print "The record was not deleted";
}
}

?>

[J.O. Aho]

mp*****@gmail.c om wrote:

Hi everyone,

I appreciate all of your help with me and the problems I have been
having. I'm new to PHP and MySQL and I'm having some problems getting
this script to work. I can't get this to work and I don't understand
why. I don't get an error or anything, it almost seems like the page
refreshes. I went to the phpmyadmin and the row is still in the
database. The $_GET parts work perfectly in another script and the SQL
statement works when I insert hard values in it. Any thoughts would be
greatly appreciated. Thanks in advance.

<form method="POST" action="<?php print $_SERVER['PHP_SELF']; ?>">
$isbn = $_GET['isbn'];
$artist_name = $_GET['artist_name'];
$album_title = $_GET['album_title'];

The form method is POST, then
$_GET['isbn']=$_GET['artist_name']=$_GET['album_title']=NULL
use $_POST['isbn'], $_POST['artist_name'] and $_POST['album_title'].

You can simplify your form tag, action="" is the same as calling itself, less
code and less work for PHP if you use:

<form method="POST" action="">

$delete_sql = "DELETE FROM lounge WHERE isbn = $isbn AND artist_name =
\'$artist_name\ ' AND album_title = \'$album_title\ '";

$delete_sql = "DELETE FROM lounge WHERE isbn = $isbn AND artist_name =
'$artist_name' AND album_title = '$album_title'" ;

Remember that the column isbn has to be INT.

//Aho

[mpar612]

J.O. Aho wrote:

mp*****@gmail.c om wrote:

Hi everyone,

I appreciate all of your help with me and the problems I have been
having. I'm new to PHP and MySQL and I'm having some problems getting
this script to work. I can't get this to work and I don't understand
why. I don't get an error or anything, it almost seems like the page
refreshes. I went to the phpmyadmin and the row is still in the
database. The $_GET parts work perfectly in another script and the SQL
statement works when I insert hard values in it. Any thoughts would be
greatly appreciated. Thanks in advance.

<form method="POST" action="<?php print $_SERVER['PHP_SELF']; ?>">
$isbn = $_GET['isbn'];
$artist_name = $_GET['artist_name'];
$album_title = $_GET['album_title'];

The form method is POST, then
$_GET['isbn']=$_GET['artist_name']=$_GET['album_title']=NULL
use $_POST['isbn'], $_POST['artist_name'] and $_POST['album_title'].

You can simplify your form tag, action="" is the same as calling itself, less
code and less work for PHP if you use:

<form method="POST" action="">

$delete_sql = "DELETE FROM lounge WHERE isbn = $isbn AND artist_name =
\'$artist_name\ ' AND album_title = \'$album_title\ '";

$delete_sql = "DELETE FROM lounge WHERE isbn = $isbn AND artist_name =
'$artist_name' AND album_title = '$album_title'" ;

Remember that the column isbn has to be INT.

//Aho

Thanks! I should have mentioned that the following is required because
they are being pulled form the url
http://www.domain.com/delete_record....&album_title=:

$isbn = $_GET['isbn'];
$artist_name = $_GET['artist_name'];
$album_title = $_GET['album_title'];

I shouldn't use $_POST should I?

Thanks!

[J.O. Aho]

mpar612 wrote:

Thanks! I should have mentioned that the following is required because
they are being pulled form the url
http://www.domain.com/delete_record....&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

[mpar612]

J.O. Aho wrote:

mpar612 wrote:

Thanks! I should have mentioned that the following is required because
they are being pulled form the url
http://www.domain.com/delete_record....&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!

[J.O. Aho]

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
http://www.domain.com/delete_record....&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_radiochec k('radio','yes_ no', $defaults, 'yes'); ?No <?php
input_radiochec k('radio','yes_ no', $defaults, 'no'); ?>
</td></tr>

<tr><td colspan="2" align="center"> <?php input_submit('s ave','Add'); ?>
</td></tr>

</table>
<input type="hidden" name="isbn" value="<?PHP echo $isbn; ?>" />
<input type="hidden" name="artist_na me" value="<?PHP echo $artist_name; ?>" />
<input type="hidden" name="album_tit le" value="<?PHP echo $album_title; ?>" />
<input type="hidden" name="_submit_c heck" value="1"/>
</form>
--- end of example ---

There you get all the data you needed to send, all sent as post.
//Aho

[Webwasp]

You need to start paying people here buddy. Or just give up on PHP SQL!!!
<mp*****@gmail. comwrote in message
news:11******** **************@ 74g2000cwt.goog legroups.com...

Hi everyone,

I appreciate all of your help with me and the problems I have been
having. I'm new to PHP and MySQL and I'm having some problems getting
this script to work. I can't get this to work and I don't understand
why. I don't get an error or anything, it almost seems like the page
refreshes. I went to the phpmyadmin and the row is still in the
database. The $_GET parts work perfectly in another script and the SQL
statement works when I insert hard values in it. Any thoughts would be
greatly appreciated. Thanks in advance.

<form method="POST" action="<?php print $_SERVER['PHP_SELF']; ?>">
<table>

<tr><td colspan="2" align="center"> Yes <?php
input_radiochec k('radio','yes_ no', $defaults, 'yes'); ?No <?php
input_radiochec k('radio','yes_ no', $defaults, 'no'); ?>
</td></tr>

<tr><td colspan="2" align="center"> <?php input_submit('s ave','Add'); ?>
</td></tr>

</table>
<input type="hidden" name="_submit_c heck" value="1"/>
</form>

<?php

function process_form() {

// Access the global variable $db inside this function
global $db;

$isbn = $_GET['isbn'];
$artist_name = $_GET['artist_name'];
$album_title = $_GET['album_title'];

if ($_POST['yes_no'] == 'yes') {

$delete_sql = "DELETE FROM lounge WHERE isbn = $isbn AND artist_name =
\'$artist_name\ ' AND album_title = \'$album_title\ '";
// Delete the record
$db->query($delete_ sql);
print "The record was deleted";
} else {
print "The record was not deleted";
}
}

?>

[mpar612]

Webwasp wrote:

You need to start paying people here buddy. Or just give up on PHP SQL!!!

These are forums and responses are voluntary. If you don't want to
respond, then don't. Responding with comments like yours is not only
unnecessary, but also a waste of resources and everyone's time.

[Markus Ernst]

Webwasp schrieb:

You need to start paying people here buddy. Or just give up on PHP SQL!!!

Before teaching people how to behave in usenet you might want to learn
it yourself:
http://www.google.com/search?q=top-posting
http://www.google.com/search?q=netiquette

--
Markus

[Shelly]

"Markus Ernst" <derernst@NO#SP #AMgmx.chwrote in message
news:44******** **@news.cyberci ty.ch...

Webwasp schrieb:

>You need to start paying people here buddy. Or just give up on PHP SQL!!!

Before teaching people how to behave in usenet you might want to learn it
yourself:

I agree. The original question was so basic that it was obvious that the
writer had done no homework and didn't even know SQL. However, Markus'
reply was somewhat over the top. A simple, "You need to learn the basics of
SQL first. It is common to all relational databases. Google 'SQL tutorial'
online or pick up a book." would have been much more polite.

Shelly