Delete button... Need help PLEASE.

Peredy

Okay I know that sounded like begging, but since I dont realy want to take a bat to my pc yet (haha) I thought i better ask for some help.
This is what I have so far.... I figured out how to get the data to show up, even seperate the years for the past shows, and how to use a form to add the data... but I dont know how to get my delete and edit buttons to work. I have tried hundreds of examples and tried to learn from some others that i downloaded, but I cant seem to get anything to work for this. Please help me get the buttons to work.. this is what I have for the edit page. All can be seen at (What I have so far) http://www.blyster.com/bschedule/bsadmin/index3.php

This is the script I have so far:

<html>
<head>
</head>
<body link="#990000" vlink="#990000" alink="#990000">
<style type="text/css"> body {background-color: transparent} </style>
<?php
echo "<br><br><br><form method=\"post\" action=\"bsdataprocessor.php\">";
$getswitch = $_GET['switch'];

if($getswitch == 1) {
$db = mysql_connect("localhost","blysterc_b21","test");
mysql_select_db('blysterc_bschedule') or die("Could not get db. Reason why: ".mysql_error());
$query = "select * from schedule";
$result = mysql_query($query) or die("Could not do a mysql query. Reason why: ".mysql_error());
echo "<table border=1 cellpsdding=2 cellspacing=2 width=100%>";
while($queryarray = mysql_fetch_array($result)) {

$timestamp = strtotime($queryarray['bsdate']);
$new_formatted = date ("F jS Y", $timestamp);
$newtime = str_replace(" ", '<br>',$new_formatted);

echo "<tr>";
echo "<td align=\"center\" >".$newtime."</td>";
echo "<td align=\"center\" >".$queryarray['bsvenue']."<br>".$rows['bslocation']."</td>";
echo "<td align=\"center\" >".$queryarray['bsbandlistings']."</td>";
echo "<td align=\"center\" >".$queryarray['bsdetails']."</td>";
echo "<td align=\"center\" ><input type=\"BUTTON\" value=\"Edit\"></td>";
echo "<td align=\"center\" ><input type=\"BUTTON\" value=\"Delete\"></td>";
echo "</tr>";

}
echo"</table>";
mysql_close($db);
}
else {
echo "  Year: <select name=\"year\">";
for($i=04; $i<51; $i++)
{
if($i <=9) {
echo"
<option value=200".$i."->200".$i."</option>";
}
else {

echo "
<option value=20".$i."->20".$i."</option>";

}
}

echo "</select>";

echo "  Month: <select name=\"month\";>";
for($i=1; $i<13; $i++)
{
if($i <=9) {
echo"
<option value=0".$i."->0".$i."</option>";
}
else {

echo "
<option value=".$i."->".$i."</option>";

}
}

echo "</select>";

echo "  Day: <select name=\"day\">";
for($i=1; $i<32; $i++)
{
if($i <=9) {
echo"
<option value=0".$i.">0".$i."</option>";
}
else {

echo "
<option value=".$i.">".$i."</option>";

}
}

echo "</select><br>";

echo "
Venue: <input type=\"text\" name=\"venue\" size=15>
Location: <input type=\"text\" name=\"location\" size=15>
Band Listing: <input type=\"text\" name=\"bandlisting\" size=20><br><br>
<center>
Details:<br> <textarea cols=50 rows=8 name=\"details\" ></textarea>
<br><br>
<input type=\"Submit\" value=\"Add to Schedule\"></center>

</form>

<a href=\"http://www.blyster.com/bschedule/bsadmin/index2.php?switch=1\">Edit Band Schedule</a>

}

</body>
</html>

Thanks to all that can help... It's GREATLY appreciated.

Peredy

leatherback

Hi,

You now have:

echo "<td align=\"center\" ><input type=\"BUTTON\" value=\"Edit\"></td>";

I would place the delete button in a completely seperate form. In it you could place a hidden input:
<input type="hidden" name="delete" value="$recordID">

In the page to which you submit:

if(isset($GET[delete]))
{
$record_to_delete = $get[delete];
$query = "delete from TABLE where IDENTIFIER = $record_to_delete";
}

Hope this helps

Peredy

Thank you for the help, but unfortunately I think I did something wrong. This is what I have now. (getting an error).

<html>
<head>
</head>
<body link="#990000" vlink="#990000" alink="#990000">
<style type="text/css"> body {background-color: transparent} </style>

<?php


if(isset($_GET[delete])) 
{ 
$record_to_delete = $_get[delete]; 
$query = "delete from schedule where bsdate = $record_to_delete"; 
} 



echo "<br><br><br><form  method=\"post\" action=\"bsdataprocessor.php\">";
$getswitch = $_GET['switch'];

if($getswitch == 1) {
$db = mysql_connect("localhost","blysterc_b21","test");
mysql_select_db('blysterc_bschedule') or die("Could not get db. Reason why: ".mysql_error());
$query = "select * from schedule";
$result = mysql_query($query) or die("Could not do a mysql query. Reason why: ".mysql_error());
echo "<table border=1 cellpsdding=2 cellspacing=2 width=100%>";
while($queryarray = mysql_fetch_array($result)) {

$timestamp = strtotime($queryarray['bsdate']);
$new_formatted = date ("F jS Y", $timestamp);
$newtime = str_replace(" ", '<br>',$new_formatted);


echo "<tr>";
echo "<td align=\"center\" >".$newtime."</td>";
echo "<td align=\"center\"  >".$queryarray['bsvenue']."<br>".$rows['bslocation']."</td>";
echo "<td align=\"center\" >".$queryarray['bsbandlistings']."</td>";
echo "<td align=\"center\" >".$queryarray['bsdetails']."</td>";
echo "<td align=\"center\" ><input type=\"BUTTON\" value=\"Edit\"></td>";
echo "<td align=\"center\" ><input type="hidden" name="delete" value="$recordID"></td>";
echo "</tr>";






}
echo"</table>";
mysql_close($db);
}
else {
echo "&nbsp;&nbsp;Year: <select name=\"year\">";
for($i=04; $i<51; $i++)
{
 if($i <=9) {
  echo"
 <option value=200".$i."->200".$i."</option>";
 }
else {

 echo "
 <option value=20".$i."->20".$i."</option>";

}
}

echo "</select>";



echo "&nbsp;&nbsp;Month: <select name=\"month\";>";
for($i=1; $i<13; $i++)
{
 if($i <=9) {
  echo"
 <option value=0".$i."->0".$i."</option>";
 }
else {

 echo "
 <option value=".$i."->".$i."</option>";

}
}

echo "</select>";





echo "&nbsp;&nbsp;Day: <select name=\"day\">";
for($i=1; $i<32; $i++)
{
 if($i <=9) {
  echo"
 <option value=0".$i.">0".$i."</option>";
 }
else {

 echo "
 <option value=".$i.">".$i."</option>";

}
}

echo "</select><br>";

echo "
Venue:&nbsp;<input type=\"text\" name=\"venue\" size=15>
Location:&nbsp;<input type=\"text\" name=\"location\" size=15>
Band Listing:&nbsp;<input type=\"text\" name=\"bandlisting\" size=20><br><br>
<center>
Details:<br>&nbsp;<textarea cols=50 rows=8 name=\"details\" ></textarea>
<br><br>
<input type=\"Submit\" value=\"Add to Schedule\"></center>

</form>

<a href=\"http://www.blyster.com/bschedule/bsadmin/index2.php?switch=1\">Edit Band Schedule</a>


";

}

?>

</body>
</html>

Much thanks.

Peredy

leatherback

what is the error? and please edit the previous code, and place php tags around them

Peredy

Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in /home/blysterc/public_html/bschedule/bsadmin/index3.php on line 40

is the error....

The page is at: http://www.blyster.com/bschedule/bsadmin/index3.php

you can also see the script at: http://pastebin.com/320670

Much thanks

Peredy

notaloser

did you even look at line 40 to see if you could see what was wrong? you forgot your slashes before the quotes..

and

value="$recordID"

has to be

value=".$recordID."

Peredy

Okay, thanks for the heads up. I have this now, but the button isnt doing anything.

<html>
<head>
</head>
<body link="#990000" vlink="#990000" alink="#990000">
<style type="text/css"> body {background-color: transparent} </style>

<?php



echo "<br><br><br><form  method=\"post\" action=\"bsdataprocessor.php\">";
$getswitch = $_GET['switch'];

if($getswitch == 1) {
$db = mysql_connect("localhost","blysterc_b21","test");
mysql_select_db('blysterc_bschedule') or die("Could not get db. Reason why: ".mysql_error());
$query = "select * from schedule";
$result = mysql_query($query) or die("Could not do a mysql query. Reason why: ".mysql_error());
echo "<table border=1 cellpsdding=2 cellspacing=2 width=100%>";
while($queryarray = mysql_fetch_array($result)) {

$timestamp = strtotime($queryarray['bsdate']);
$new_formatted = date ("F jS Y", $timestamp);
$newtime = str_replace(" ", '<br>',$new_formatted);

if(isset($_GET[delete])) 
{ 
$record_to_delete = $_get[delete]; 
$query = "delete from schedule where bsdate = $record_to_delete"; 
} 



echo "<tr>";
echo "<td align=\"center\" >".$newtime."</td>";
echo "<td align=\"center\"  >".$queryarray['bsvenue']."<br>".$rows['bslocation']."</td>";
echo "<td align=\"center\" >".$queryarray['bsbandlistings']."</td>";
echo "<td align=\"center\" >".$queryarray['bsdetails']."</td>";
echo "<td align=\"center\" ><input type=\"BUTTON\" value=\"Edit\"></td>";
echo "<td align=\"center\" ><input type=\"BUTTON\" value=\"Delete\" input type=\"hidden\" name=\"delete\" value=\".$recordID.\"></td>";
echo "</tr>";






}
echo"</table>";
mysql_close($db);
}
else {
echo "&nbsp;&nbsp;Year: <select name=\"year\">";
for($i=04; $i<51; $i++)
{
 if($i <=9) {
  echo"
 <option value=200".$i."->200".$i."</option>";
 }
else {

 echo "
 <option value=20".$i."->20".$i."</option>";

}
}

echo "</select>";



echo "&nbsp;&nbsp;Month: <select name=\"month\";>";
for($i=1; $i<13; $i++)
{
 if($i <=9) {
  echo"
 <option value=0".$i."->0".$i."</option>";
 }
else {

 echo "
 <option value=".$i."->".$i."</option>";

}
}

echo "</select>";





echo "&nbsp;&nbsp;Day: <select name=\"day\">";
for($i=1; $i<32; $i++)
{
 if($i <=9) {
  echo"
 <option value=0".$i.">0".$i."</option>";
 }
else {

 echo "
 <option value=".$i.">".$i."</option>";

}
}

echo "</select><br>";

echo "
Venue:&nbsp;<input type=\"text\" name=\"venue\" size=15>
Location:&nbsp;<input type=\"text\" name=\"location\" size=15>
Band Listing:&nbsp;<input type=\"text\" name=\"bandlisting\" size=20><br><br>
<center>
Details:<br>&nbsp;<textarea cols=50 rows=8 name=\"details\" ></textarea>
<br><br>
<input type=\"Submit\" value=\"Add to Schedule\"></center>

</form>

<a href=\"http://www.blyster.com/bschedule/bsadmin/index2.php?switch=1\">Edit Band Schedule</a>


";

}

?>

</body>
</html>

Again... many thanks for the help.

Peredy

notaloser

skimming through it all quickly.. it looks like your form method is POST while all your code uses GETs?.. personally i would use post instead.. there doesnt seem to be any information that would be vital to be kept hidden by GETs

leatherback

And you have to use the delete query of course. Only defining a query isn't deleting the record.