...

View Full Version : deleting a row



nathanmaxsonadi
07-31-2007, 11:02 PM
I was wondering how to have an link near the mysql row that allows you to delete it?
This is my code


<?php include 'header.php'; // Works.


?>
<div id="content">
<div id="columnsC">

<img style="border:0;" src="siteimg/stixy.jpg" alt="stixy"/><Br/>
<p>Stixy helps users organize their world on flexible, shareable Web-based bulletin boards called Stixyboards. Unlike most personal productivity or project management software, Stixy doesn't dictate how users should organize their information. Users can create tasks, appointments, files, photos, notes, and bookmarks on their Stixyboards, organized in whatever way makes sense to them. Then they can share Stixyboards with friends, family, and colleagues.</p>
</div>
<div id="columnsD">
<?
/**
* User has already logged in, so display relavent links
*/
echo '
';
if($session->logged_in){
$dbh=mysql_connect ("localhost", "my_user", "my_pass") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("my_db");
if(isset($_GET['remove']) && $_GET['remove'] == '1'){
$sql = "DELETE FROM emailists WHERE stixy=('" . $session->userinfo['email'] . "')";
if($sqlres = mysql_query($sql)){
echo '<div id="mes"><ul><li>email address removed</li></ul></div>';
}else{
echo mysql_error();
}
}
//break
if(isset($_GET['insert']) && $_GET['insert'] == 1) {
$sql = "SELECT stixy FROM emailists WHERE stixy = '{$session->userinfo['email']}'";
if ($result = mysql_query($sql)) {
if (!mysql_num_rows($result)) {
$sql = "INSERT INTO emailists (stixy) VALUES ('" . $session->userinfo['email'] . "')";
if ($sqlres = mysql_query($sql)){
echo '<div id="mes"><ul><li>email address added</li></ul></div>';
} else {
echo mysql_error();
}
} else {
echo "<div id='mes'><ul><li>email address already exists</li></ul></div>";
}
} else {
echo mysql_error();
}
}
$query = mysql_query("SELECT stixy FROM emailists WHERE stixy = '{$session->userinfo['email']}'");

$result = mysql_num_rows($query);

if($result !== 0){

echo "<ul><li><a href='stixy.php?remove=1'>Remove yourself from the list[/url]</li></ul>";

} else {

echo "<ul><li><a href='stixy.php?insert=1'>Add yourself to the list[/url]</li></ul>";

}

echo "<ul>";
$sql = "SELECT stixy FROM emailists";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
while ($row = mysql_fetch_assoc($result)) {
echo "<li>"; echo $row['stixy'] . "</li>";

}
}
}
echo "</ul>";

}
else{
?>


<p style="border-style: solid;
border-width: 3px;">some text here</p>

<?
}
?>

</div>



<?php include 'sidebar.php'; ?>
<div style="clear: both;">&nbsp;</div>
</div>
<?php include 'footer.php'; // Works.

?>

timgolding
08-01-2007, 12:03 AM
what are you trying to delete exactly? And what does your code do?
There are some variables that I am unclear of.

P.S how does this session class work? Are you writing all of your session to a class or something. I'm only asking in case the problem is that the session arn't being maintained with session_start()?

nathanmaxsonadi
08-01-2007, 12:13 AM
I would like a link next to each row that deletes that row from the mysql database

nathanmaxsonadi
08-01-2007, 01:07 AM
Help!

timgolding
08-01-2007, 01:14 AM
I presume what you mean is you have a list of items (extracted from DB data) on your page and you would like a delete button next to each item. So you can delete that item?
if so you can have a button next to it that send its ID through the GET request.



item 1<a href="delete.php?remove=1&ID=".$ID >Delete</a>';


just make sure you validate the users session date before you delete dont rely on the GET request data alone or you'll be asking from trouble

nathanmaxsonadi
08-01-2007, 08:14 PM
What would delete.php be then?

timgolding
08-02-2007, 12:13 AM
the page with the code that processes the form data and deletes that row item. So replace that for the name of the scripts file



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum