Posted: Mon Dec 04, 2006 4:02 pm
I tested the code that I gave you and it works. So, try again and check that you pass 'id' to the PHP file (?id=1).
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
ok well it dosn't work for me, so here is the EXACT code i'm using (to test it)ok wrote:I tested the code that I gave you and it works. So, try again and check that you pass 'id' to the PHP file (?id=1).
Code: Select all
<?php
$dbhost = 'my host';
$dbuser = 'my user';
$dbpass = 'my pass';
$dbname = 'phptest1';
mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');
mysql_select_db($dbname) or die('Cannot select DB');
if(isset($_GET['id']) and $_GET['id'] != null and is_numeric($_GET['id']))
{
$id = $_GET['id'];
}
else
{
die('No id');
}
$sql_delete = "DELETE FROM `deltest1` WHERE `cmessage`=$id";
$result = mysql_query($sql_delete);
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
?>Code: Select all
<?php
$dbhost =
$dbuser =
$dbpass =
$dbname =
$db = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname);
$query = "SELECT `csubject`, `cmessage` FROM `deltest1`";
$result = mysql_query($query) or die('Error, query failed ##1');
$htmlsubbefore="<div class=\"ts hazardrow\"><div class=\"coltitle_dark tlarge\">";
$htmlsubafter="</div><div style=\"clear:both;padding:0px\"></div></div>";
$htmlbodbefore="<table width=\"100%\" cellpadding=\"1\" cellspacing=\"1\"><tr class=\"hazardrow\"><td width=\"50%\" colspan=\"1\">";
// ID check:
if(isset($_GET['id']) and $_GET['id'] != null and is_numeric($_GET['id']))
{
$id = $_GET['id'];
}
else
{
//die('No id');
}
//end ID check
//deltion check
if(isset($_GET['act']) && $_GET['act'] == 'del'){
$sql_delete = "DELETE FROM `deltest1` WHERE `cmessage`=$id";
mysql_query($sql_delete) or die(mysql_error()); // gives errors
}
// END DELETE CODE
echo "<table>";
while($row = mysql_fetch_row($result))
{
$Subject = $row[0];
$Message = $row[1];
ECHO $row[2];
ECHO $row[3];
echo $htmlsubbefore . $row[0] . $htmlsubafter.
$htmlbodbefore . $row[1] . $htmlbodafter . "</table>";
echo "<a href='delete7.php?act=del&id=" . $id . "' title='Delete'><img src=\"http://image.fpsbanana.com/ico/del.gif\"></a>";
// $MESSAGE_ID $_GET['id'] $id
}
$htmlbodafter="</td>/tr></table>";
?>Code: Select all
//...
$query = "SELECT `cid`, `csubject`, `cmessage` FROM `deltest1`";
$result = mysql_query($query) or die('Error, query failed ##1');
//...
if(isset($_GET['id']) and $_GET['id'] != null and is_numeric($_GET['id']))
{
$id = $_GET['id'];
}
else
{
die('No id');
}
//end ID check
//deltion check
if(isset($_GET['act']) && $_GET['act'] == 'del'){
$sql_delete = "DELETE FROM `deltest1` WHERE `cmessage`=$id";
mysql_query($sql_delete) or die(mysql_error()); // gives errors
}
// END DELETE CODE
echo "<table>";
while($row = mysql_fetch_assoc($result))
{
$Subject = $row["csubject"];
$Message = $row["cmessage"];
//============================
//***********************************
$id = $row["cid"];
//***********************************
//============================
ECHO $row[2];
ECHO $row[3];
echo $htmlsubbefore . $row[0] . $htmlsubafter.
$htmlbodbefore . $row[1] . $htmlbodafter . "</table>";
echo "<a href='delete7.php?act=del&id=" . $id . "' title='Delete'><img src=\"http://image.fpsbanana.com/ico/del.gif\"></a>";
// $MESSAGE_ID $_GET['id'] $id
}
//...Code: Select all
<?php
include 'config.php';
mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');
mysql_select_db($dbname) or die('Cannot select DB');
$query = "SELECT `cid`, `csubject`, `cmessage` FROM `deltest1`";
$result = mysql_query($query) or die('Error, query failed ##1');
if(isset($_GET['id']) and $_GET['id'] != null and is_numeric($_GET['id']))
{
$id = $_GET['id'];
}
else
{
}
if(isset($_GET['act']) && $_GET['act'] == 'del'){
$sql_delete = "DELETE FROM `deltest1` WHERE `cid`=$id";
mysql_query($sql_delete) or die(mysql_error()); // gives errors
}
echo "<table>";
while($row = mysql_fetch_assoc($result))
{
$Subject = $row["csubject"];
$Message = $row["cmessage"];
$id = $row["cid"];
echo $row["csubject"] .
$row["cmessage"];
echo "<a href='delete8.php?act=del&id=" . $id . "' title='Delete'><img src=\"http://image.fpsbanana.com/ico/del.gif\"></a>";
}
?>oh it would have to be done with AJAX? damn. i am trying to avoid learning ajax lol. a little hard.ok wrote:You mean AJAX
Code: Select all
if(isset($_GET['act']) && $_GET['act'] == 'del'){
$sql_delete = "DELETE FROM `deltest1` WHERE `cid`=$id";
mysql_query($sql_delete) or die(mysql_error()); // gives errors
--- REDIRECT CODE HERE ---
}Code: Select all
if(isset($_GET['act']) && $_GET['act'] == 'del'){
$sql_delete = "DELETE FROM `deltest1` WHERE `cid`=$id";
mysql_query($sql_delete) or die(mysql_error()); // gives errors
header("Location: next.php");
}