Learn VBA & Macros in 1 Week!

PHP - Can't Get Delete Function To Work

Full Excel VBA Course - Beginner to Expert

Can't Get Delete Function To Work	View Content

Hello Everyone,

I am writing a simple CMS system for someone. I am having trouble getting the delete function to work. I pick the user that I want to remove from the system. I verify that this is the right person to remove. Then the record is deleted from the database.

The part that picks the person and verifies that it is the right person to remove from the database work fine. It is the part that actually deletes the record. It takes me back to the pick_user.php.

If someone could help me with this I would appreciate it

This is the code from the show_user_del.php

<?php

if (!$_POST[id]) {
header ("LOCATION: pick_user.php");
exit;
}

if ($_COOKIE[auth] != "ok") {
header("Location: ../login.php");
}

require('../includes/auth_user.php');

//build and issue query
$sql = "SELECT * FROM $table WHERE id = '$_POST[id]'";
$result = mysql_query($sql, $connection) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {
$f_name = $row['f_name'];
$l_name = $row['l_name'];
$username = $row['username'];
$password = $row['password'];
}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Add Classified Ad</title>
</head>
<body>
<h2><em>Delete user from Database</em></h2>
<h3>User being deleted <?php echo "$f_name $l_name"; ?></h3>
<form method="POST" action="do_delete_user.php">
<input type="hidden" name="id" value="<?php echo "$_POST[id]"; ?>" />
<input type="hidden" name="f_name" value="<?php echo "$f_name"; ?>" />
<input type="hidden" name="l_name" value="<?php echo "$l_name"; ?>" />
<p> <strong>Name:</strong> <?php echo "$f_name $l_name"; ?>
   </p>
   <p> <strong>Username:</strong> <?php echo "$username"; ?>
   </p>
   <p> <strong>Password:</strong> <?php echo "$password"; ?>
   </p>
   <p>
      <input type="submit" name="submit" id="name" value="Delete User" />
   </p>
</form>
<p><a href="../admin_menu.php">Return to Administration Menu</a></p>
</body>
</html>

When the submit button is clicked in the above code. It is supposed to bring you to the page below saying that the record was deleted. When the submit button is clicked it sends you back to the pick user page.

<?php
if ((!$_POST[f_name]) || (!$_POST[l_name])) {
header ("LOCATION: show_user_del.php");
exit;
}

if ($_COOKIE[auth] != "ok") {
header("Location: ../login.php");
}

require('../includes/auth_user.php');

$sql = "DELETE FROM $table WHERE id = '$_POST[id]'";
$result = mysql_query($sql, $connection) or die(mysql_error());
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<h1>User has been removed</h1>
<h2><em>User <?php echo "$_POST[f_name] $_POST[l_name]"; ?> has been deleted
      from the <?php echo "$table"; ?> table</em></h2>
<p><a href="pick_user.php">Delete another person</a></p>
<p><a href="../admin_menu.php">Administration Menu</a></p>
</body>
</html>

Full Excel VBA Course - Beginner to Expert

Php Sql Delete Function Doesn't Work...

Similar Tutorials

View Content

I am attempting to build an online shopping cart, however I have a problem with the Delete /Remove Item function.
Add New and Update Item work perfectly fine, just the Remove Item doesn't.
It seems to be mirroring the same functionality as Update Item.

http://www.tottonc.co.nz to see my problem in action.

Any help or solutions would be much appreciated...

Require Select And Click Delete Button For Twice To Perform Delete Function

Similar Tutorials

View Content

Hi all.
Here is my scripts which allow user to check multiple rows of data and delete it , but it require select data and click for twice to delete the rows , what should be the error?

Code: [Select]
<form name="frmSearch" method="post" action="insert-add.php">

<table width="600" border="1">
<tr>
<th width="50"> <div align="center">#</div></th>
<th width="91"> <div align="center">ID </div></th>
<th width="198"> <div align="center">First Name </div></th>
<th width="198"> <div align="center">Last Name </div></th>
<th width="250"> <div align="center">Mobile Company </div></th>
<th width="100"> <div align="center">Cell </div></th>
<th width="100"> <div align="center">Workphone </div></th>
<th width="100"> <div align="center">Group </div></th>
</tr>
</form>
<?

echo "<form name='form1' method='post' action=''>";

while($objResult = mysql_fetch_array($objQuery))
{

echo "<tr>";
echo "<td align='center'><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\" value=\"$objResult[addedrec_ID]\"></td>";
echo "<td>$objResult[addedrec_ID] </td>";
echo "<td>$objResult[FirstName]</td>";
echo "<td>$objResult[LastName] </td>";
echo "<td>$objResult[MobileCompany] </td>";
echo "<td>$objResult[Cell] </td>";
echo "<td>$objResult[WorkPhone] </td>";
echo "<td>$objResult[Custgroup] </td>";

echo "</tr>";

}

echo "<td colspan='7' align='center'><input name=\"delete\" type=\"submit\" id=\"delete\" value=\"Delete\">";

if (isset($_POST['delete']) && isset($_POST['checkbox'])) // from button name="delete"
{
$checkbox = ($_POST['checkbox']); //from name="checkbox[]"
$countCheck = count($_POST['checkbox']);

for($d=0;$d<$countCheck;$d++)
{
$del_id = $checkbox[$d];

$sql = "DELETE from UserAddedRecord where addedrec_ID = $del_id";

$result2=mysql_query($sql) or trigger_error(mysql_error());;;

}
if($result2)
{
$fgmembersite->GetSelfScript();
}
else
{
echo "Error: ".mysql_error();
}
}
echo "</form>";

Thanks for every reply.

Delete Don't Work

Similar Tutorials

View Content

Hi,
I dont know what doing wrong
Code: [Select]
<form ...

<?php

if($_POST['DeleteActor']) {
mysql_query( 'DELETE FROM `n_dramaact`
WHERE `n_dramaact_id` = "' . $_POST['n_dramaact_id'] . '"');
}

// Reload from dBase
$QueryDramActReturn = mysql_query( 'SELECT
`n_dramaact`.`n_dramaact_id`,
`n_dramaact`.`n_dramaact_dramid`,
`n_dramaact`.`n_dramaact_dramact`,
`n_actor`.`n_actor_id`,
`n_actor`.`n_actor_fname`,
`n_actor`.`n_actor_name`,
`n_drama`.`n_drama_id`,
`n_drama`.`n_drama_title`
FROM
`n_dramaact`
Inner Join `n_actor` ON `n_actor`.`n_actor_id` = `n_dramaact`.`n_dramaact_dramact`
Inner Join `n_drama` ON `n_drama`.`n_drama_id` = `n_dramaact`.`n_dramaact_dramid`
WHERE `n_drama`.`n_drama_id` = "' . $REQUEST['n_drama_id'] . '"
ORDER BY `n_actor_fname` ASC
');

// Check query
if(!$QueryDramActReturn) { echo mysql_error(); exit; }

// Request query
while($REQUESTDR = mysql_fetch_array ($QueryDramActReturn)) {

?>
<div style="display: block; float: left; margin-left: 5px; margin-bottom: 5px;">
<?php echo $REQUESTDR['n_actor_fname'] . ' ' . $REQUESTDR['n_actor_name'];?>
<input type="submit" name="DeleteActor" value="<-X" class="SubmitDelActor" />
<input type="hidden" name="n_dramaact_id" value="<?php echo $REQUESTDR['n_dramaact_id'];?>" />
</div>
<?php }?>

....</form>
I dont understand why when a push one of the listed DeleteActor submit button delete the last n_dramaact_id from table - every listed Submit button have the own (hidden) n_dramaact_id?

thanx in advanced

T

Delete From Does, But Doesn't, Work

Similar Tutorials

View Content

I have some code which deletes a record from my database (which has been selected from the previous page). Only problem is, it comes up with error code, but still deletes from the database?

Error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/110mb.com/t/h/e/b/l/a/c/k/theblackwatch/htdocs/150749deleted.php on line 28

Code:
Code: [Select]
<?php
$id = $_GET[id];
// Start the connection to the database
$conn = mysql_pconnect("***", "***", "***");
// Select the database to use
mysql_select_db("***", $conn);
// Create the MySQL command to retrieve all records
$sql = "DELETE FROM **** WHERE id ='$id'";
$result = mysql_query($sql, $conn);
$array = mysql_fetch_array($result);
// Echo each entry as the value of the text boxes. This brings in the current info in the database
echo "<p>Entry has been deleted.</p>";
?>
Any way round it?

Why Delete Doesnt Work? Help Please

Similar Tutorials

View Content

Hi, Im using a button to delete each entry from my database, however it doesnt. I have tried it with linking to a delete page and works fine with the same mysql query, but i need to hve the button to delete and not a URL.

Can someone please help me to see what is wrong?

thanks in advance guys

<?php

include ("../include/global.php");
include ("../include/function.php");

if (loggedin()==FALSE)
{
Header("Location: ../login.php");
exit();
}

$_SESSION['username']=='$username';
$username=$_SESSION['username'];

$getid=mysql_query("SELECT id FROM users WHERE username='$username'");
while($row=mysql_fetch_array($getid))
{
$usersid=$row['id'];
}

if (isset($_POST['add']) && $_POST['add'])
    {

$subject = addslashes(strip_tags($_POST['subject']));
$text = addslashes(strip_tags($_POST['text']));

$update=mysql_query("INSERT INTO users_notes (user_id, subject, note) VALUES ('$usersid','$subject','$text')");
}

if (isset($_POST['remove']) && $_POST['remove'])
    {

$delete=mysql_query("DELETE FROM users_notes WHERE user_id='$usersid' AND  AND id='$id'");
}
?>

<html>
<head>
<script type="text/javascript" src="/js/jquery.js"></script>
<script type="text/javascript" src="/js/jquery.validate.js"></script>

<script type="text/javascript">
$(document).ready(function(){

$("#form").validate();

});
</script>
</head>
<body>

<p>You are logged in! <a href="logout.php">Log out</a>

</p>
<p> </p>
<p><td><? $getmsg=mysql_query("SELECT * FROM users_notes WHERE user_id='$usersid'");
while($row=mysql_fetch_array($getmsg))
{
$id=$row['id'];
$msgsubject=$row['subject'];
$msgnotes=$row['note'];

echo"<table width='800' border='1'>";
echo" <tr>

    <td width='50'>".$msgsubject."</td>
    <td width='50'>".$msgnotes."</td>

    <td width='40'><form id='form' method='post' action=''>

      <input type='submit' name='remove' value='remove' />

      </form></td>
  <td>

  </td>
  </tr>
  ";

}

echo "</table>";
?>
</td>
</p>
<p> </p>
<form action="" method="POST" id="form">
  <p>
  Subject: <br/>
    <input type="text" name="subject" class="required">
  </p>
  <p>
Your Note: <br/>
    <textarea name="text" id="text" cols="45" rows="15" class="required"></textarea>
  </p>
  <p>
    <input type="submit" name="add" value="Add" >
  </p>
</form>
</body>

Can't Get Delete Query To Work :/

Similar Tutorials

View Content

Hi guys can any one see hy tis won't work

<?php

require_once 'login.php';
$db_server = mysql_connect($db_hostname, $db_username, $db_password);

if (!$db_server)
{
  die ("Unabl to connect to MySQL" . mysql_error());
}

mysql_select_db($db_database, $db_server) or die("Unable to connect to database: " . mysql_error());

if (isset($_POST['author'])&& isset($_POST['title'])&& isset($_POST['category'])&& isset($_POST['year'])&& isset($_POST['isbn']))
{
$author = get_post('author');
$title = get_post('title');
$category = get_post('category');
$year = get_post('year');
$isbn = get_post('isbn');

  if (isset($_POST['delete']) && $isbn != "")
  {
$query = "DELETE FROM tblCLassics WHERE isbn='$isbn'";

if (!mysql_query($query, $db_server))
{
  echo "DELETE failed: $query<br />" . mysql_error() . "<br /><br />";
}
  }
  else
  {
$query = "INSERT INTO tblClassics VALUES" .
"('$author','$title','$category','$year','$isbn')";

if (!mysql_query($query, $db_server))
{
  echo "INSERT Failed: $query<br />" .
  mysql_error() . "<br /><br />";
}
  }

}
echo <<<_END
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome to the Book Club</title>
</head>

<body>
<form action="connectionTest.php" method="post"><pre>
Author: <input type="text" name="author" />
Title: <input type="text" name="title" />
Category: <input type="text" name="category" />
Year: <input type="text" name="year" />
ISBN: <input type="text" name="isbn" />
<input type="submit" value="ADD RECORD" /></pre>
</form>
_END;

$query = "SELECT * FROM tblClassics";
$results = mysql_query($query);

if (!$results)
{
die("Database access failed: " . mysql_error());
}

$rows = mysql_num_rows($results);

for ($j = 0; $j < $rows ; ++$j)
{
$row = mysql_fetch_row($results);
echo <<<_END
<pre>
Author: $row[0]
Title: $row[1]
Category: $row[2]
Year: $row[3]
ISBN: $row[4]
</pre>
<form action="connectionTest.php" method="post">
<input type="hidden" name="delete" value="yes" />
<input type="hidden" name="isbn" value="$row[4]" />
<input type="submit" value="DELETE RECORD" />
</form>
_END;
}

echo "</body>";
echo "</html>";

mysql_close($db_server);

function get_post($var)
{
return mysql_real_escape_string($_POST[$var]);
}

?>
cheers.

Delete A File Using Unlink Does Not Work

Similar Tutorials

View Content

I want to delete a file, I'm using Windows XP, however, it gives me Permission Denied:

Code: [Select]
$file =$row['img'] ;
$filedel = "mages/".$file;
unlink ($filedel);
Is the code wrong? I tried setting permission to the folder but in vain...

Getting The Id Param To Work So I Can Delete And Edit Posts.

Similar Tutorials

View Content

Not sure how to go about making it so that I can delete and edit a post..

So I am stumped on how to make it to delete and edit post. The key factor for getting the information is the id field. And I am able to get it and display it, but how can I get it to work between all my functions?

This is what I have so far.

<?php
include 'test.php';
function connection()
{

$connection = @mysql_connect('localhost','root','') or die('could not connect to mysql');

$select_db = @mysql_select_db('tutorials') or die('could not connect to database');
}

function delete_post($id)
{

connection();

$query = "DELETE FROM `posts` WHERE `id` = '$id'";

$result = mysql_query($query);
}

function find_posts()
{

connection();

$query = 'SELECT `posts`.`title`, `posts`.`body`, `posts`.`id`, `users`.`username` FROM `posts`, `users` WHERE `posts`.`user_id` = `users`.`id`';

$result = mysql_query($query);

while ($row = mysql_fetch_array($result))

{

$id = $row['id'];

echo '<b>' . $row['title'] . '</b>' .'<a href=/practice/model/posts.php?action=delete>[delete]</a> <a href=/practice/model/posts.php?action=edit>[edit]</a>' . '<br/>';

echo $row['body'] . '<br/>';

echo $row['username'] . '<p>';

}

}

function find_post($id)
{

connection();

$query = "SELECT `posts`.`title`, `posts`.`body`, `posts`.`id`, `users`.`username` FROM `posts`, `users` WHERE `posts`.`user_id` = `users`.`id` AND `posts`.`id` = '$id'";

$result = mysql_query($query);

$row = mysql_fetch_array($result);

echo '<b>' . $row['title'] . '</b>' . '<br/>';

echo $row['body'] . '<br/>';

echo $row['username'] . '<p>';
}

function create_post()
{

connection();

$title = $_POST['title'];

$body = $_POST['body'];

$query = "INSERT INTO `posts` SET `title` = '$title', `body` = '$body', `created_at` = NOW(), `user_id` = 53";

$result = mysql_query($query);

if(!$result)

{

echo mysql_error();

}
}

delete_post(7);
find_posts();

?>

<?php
$action = $_GET['action'];

switch ($action)
{

case 'create':

echo 'created' . '<br/>';

create_post();

break;

case 'delete':

echo 'deleted' . '<br/>';

delete_post($id);

break;
}

?>

<form action="/practice/model/posts.php?action=create" method="POST">

<input type="submit" name="submit" />
</form>

So yea, I am not sure how to get the 'id' parameters linked between everything that needs it. Sorry for the vague description, but its kind of hard to put it into words. If you need a more detailed description please let me know and I will try to. Pretty much want to be able to delete and edit my posts.

Thank you!

Make Approve Deny And Delete Queries Work

Similar Tutorials

View Content

I can't seem to figure this out. The queries seem to need to be in the foreach loop. The queries will then work but they update every blog post in my table. I only want it to update the 1 that has the button associated with it. So for instance... only delete the blog post where post_id = ${post['id']}

Do I make the queries be outside of the foreach? If I do that then MySQL fails because my foreach is using the $post variable.

Code: [Select]
<?php

if (isset($_POST['approve']))
{
$sql = "
UPDATE `blog_posts` SET
`approved` = 1
WHERE `post_id` = '${post['id']}'
";

mysql_query($sql) or die(mysql_error());
}
else if (isset($_POST['deny']))
{
$sql = "
UPDATE `blog_posts` SET
`approved` = -1
WHERE `post_id` = '${post['id']}'
";
}
else if (isset($_POST['delete']))
{
mysql_query("DELETE FROM `blog_posts` WHERE `post_id` = {$post['id']}") or die(mysql_error());
}

foreach ($posts as $post)
{
?>
<div class="post" id="post<?php echo $post['id']; ?>">
<form action="blog.php" method="post" id="blogform" class="man">
<fieldset class="mvs buttonfield">
<span class="button">
<label>
<input type="submit" id="starttop" name="approve" class="invis dark_grey" value="Approve" />
</label>
</span>
<span id="smarktop" class="button disabled">
<label>
<input type="button" id="marktop" name="deny" class="invis dark_grey" value="Deny" disabled="disabled" />
</label>
</span>
<span id="sdeletetop" class="button disabled">
<label>
<input type="submit" id="deletetop" name="delete" class="invis dark_grey" value="Delete" disabled="disabled" />
</label>
</span>
</fieldset>
</form>
</div>
<?php
}

?>

Delete All Function

Similar Tutorials

View Content

I made a private messaging system. There is a select all checkbox, but how do I create a function that says delete all of the selected messages?

I'm just looking for some logic on this.

A Delete Script Wont Work For Me Wont Work For Me Need Help.

Similar Tutorials

View Content

i need help trying to get this delete feature to work its not deleting from the database (by the way i took out my database names and passwords at the top of the file)

is it possible someone could help me, ive been working on this for like a week and cant figure out the problem. thanks! you can email me at spr_spng@yahoo.com

picture 2.png is showing what it looks like

Code: [Select]
<?php
$host="localhost"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="database_name"; // Database name
$tbl_name="table_name"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

?>
<style>
/*table affects look of the whole table look */
table {
margin-left: auto;
margin-right: auto;
border: 1px solid #330000;
border-collapse:collapse;
width:70%;

border-width: 5px 5px 5px 5px;
border-spacing: 1px;
border-style: outset outset outset outset;
border-color: #330000 #330000 #330000 #330000;
border-collapse: separate;
background-color: #330000;

#800517

f535aa

#330000 school color
#9A0000 school color2
#991B1E school color3
#CCCC99 school color4
#9A0000

}
/*th is table header */
th {
text-align: left;
height: 2.5em;
background-color: #330000;
color: #FC0;
font-size:1.5em;
}
/*td is table data or the cells below the header*/
td {
text-align: left;
height:1.0em;
font-size:1.0em;
vertical-align:bottom;
padding:10px;

border-width: 5px 5px 5px 5px;
padding: 8px 8px 8px 8px;
border-style: outset outset outset outset;
border-color: #9A0000 #9A0000 #9A0000 #9A0000;
background-color: #CCCC99;
-moz-border-radius: 0px 0px 0px 0px;

}
</style>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Pick Which Rows you want to delete, Then press delete.</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF">delete</td></tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this // edited
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

New/edit/delete Function

Similar Tutorials

View Content

Hey i created a page to add/edit/remove job's i've posted.
I got everything running smoothly except for the edit function?
any help would be really appreciated

<?php

$action = $_GET["action"];
if ($action == "delete"){
$delid = $_GET['delid'];
$query = "DELETE FROM jobs WHERE id=".$delid." LIMIT 1";
$sql = mysql_query($query);
echo("Job succesfully deleted! [ <a href='add_jobs.php'>Back</a> ]");
}
if ($action == "edit"){
print("<strong>Editing a Job:</strong>");
$editid = $_GET['editid'];
$sql = mysql_query("SELECT * FROM jobs WHERE id = ".$editid." ") or die ('Error: '.mysql_error ());
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$job_title = $row['job_title'];
$job_description = $row['job_description'];
$job_type = $row['job_type'];
$job_area = $row['job_area'];
$query2 = "UPDATE jobs SET (job_title, job_description, job_type, job_area, hot_job) VALUES ('$job_title', '$job_description', '$job_type', '$job_area', '$hot') WHERE id=$id";
echo("<form name='add' method='post' action='?action=edit'>");
echo("<input type='hidden' name='?action=edit'>");
echo("<table class=main cellspacing=0 cellpadding=5 width=50%>");
echo("<tr><td>Job Title: </td><td align='right'><input type='text' size=50 name='job_title' value='$job_title'></td></tr>");
echo("<tr><td>Job Description: </td><td align='right'><textarea size=50 name='job_description'>$job_description</textarea></td></tr>");
echo("<tr><td>Job Type: </td><td align='center'><select name='job_type'><option>Permanent</option><option>Locum or Contract</option></SELECT></td></tr>");
echo("<tr><td>Hot Job? </td><td align='center'>Yes <input type='radio' name='hot' value='Yes'> No <input type='radio' name='hot' value='no'></td></tr>");
echo("<tr><td>Job Area: </td><td align='center'><select name='job_area'><option>East Anglia</option><option>London / South East</option><option>Midlands</option><option>North West</option><option>Northern Ireland</option><option>Scotland</option><option>South</option><option>South West</option><option>Southern Ireland</option><option>Wales</option><option>Yorkshire / North East</option></SELECT></td></tr>");
echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>");
echo("</table>");
}
}
if ($action == "add"){
$add = $_POST['add'];
$job_title = $_POST['job_title'];
$job_description = $_POST['job_description'];
$job_type = $_POST['job_type'];
$job_area = $_POST['job_area'];
$hot = $_POST['hot'];
$id = mysql_insert_id();
$query = "INSERT INTO jobs (id, job_title, job_description, job_type, job_area, hot_job) VALUES ('$id', '$job_title', '$job_description', '$job_type', '$job_area', '$hot')";
$sql = mysql_query($query) or die (mysql_error());
}
print("<strong>Add A New Job!</strong>");
print("<br />");
print("<br />");
echo("<form name='add' method='post' action='?action=add'>");
echo("<input type='hidden' name='?action=add'>");

echo("<table class=main cellspacing=0 cellpadding=5 width=50%>");
echo("<tr><td>Job Title: </td><td align='right'><input type='text' size=50 name='job_title'></td></tr>");
echo("<tr><td>Job Description: </td><td align='right'><textarea size=50 name='job_description'></textarea></td></tr>");
echo("<tr><td>Job Type: </td><td align='center'><select name='job_type'><option>Permanent</option><option>Locum or Contract</option></SELECT></td></tr>");
echo("<tr><td>Hot Job? </td><td align='center'>Yes <input type='radio' name='hot' value='Yes'> No <input type='radio' name='hot' value='no' checked></td></tr>");
echo("<tr><td>Job Area: </td><td align='center'><select name='job_area'><option>East Anglia</option><option>London / South East</option><option>Midlands</option><option>North West</option><option>Northern Ireland</option><option>Scotland</option><option>South</option><option>South West</option><option>Southern Ireland</option><option>Wales</option><option>Yorkshire / North East</option></SELECT></td></tr>");
echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>");
echo("</table>");
if($success == TRUE) {
print("<strong>Success!</strong>");
}
echo("<br>");
echo("</form>");
print("<strong>Existing Jobs:</strong>");
print("<br />");
print("<br />");
echo("<table class=main cellspacing=0 cellpadding=5>");
echo("<td>ID:</td><td>Title:</td><td>Description:</td><td>Type:</td><td>Area:</td><td>Edit (DO NOT USE YET):</td><td>Delete:</td>");
$query = "SELECT * FROM jobs WHERE 1=1";
$sql = mysql_query($query);
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$job_title = $row['job_title'];
$job_description = $row['job_description'];
$job_type = $row['job_type'];
$job_area = $row['job_area'];
$position=18;
$job_description2 = substr($job_description, 0, $position);
echo("<tr><td><strong>$id</strong></td><td><strong>$job_title</strong></td><td><strong>$job_description2...</strong></td><td><strong>$job_type</strong></td><td><strong>$job_area</strong></td><td><a href='add_jobs.php?action=edit&editid=$id'>Edit</a></td><td><a href='add_jobs.php?action=delete&delid=$id'>Delete</a></td></tr>");
}

[help] Fwrite And Delete Function

Similar Tutorials

View Content

hello there..
im planning to create a simple Online Users that is integrated to Facebook sdk.

So far, i have the ff codes:

index.php (this is where the online users listed)
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Online Users</title>
<link type="text/css" rel="stylesheet" href="style.css" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/ouser.js"></script>
</head>
<body>

<table id="online">

</table>

</body>
</html>
javascript file:
Code: [Select]
$(document).ready(
function() {
setInterval (loadLog, 2500);
});

function loadLog(){
$.ajax({
url: "onlineusers.html",
cache: false,
success: function(html){
$("#online").html(html);
},
});
}
test.php (This is my temporary file to test the Login authentication for FB.. THIS IS WORKING)
Code: [Select]
<?php
  session_start();
  require_once("src/facebook.php");
  $config = array(
    'appId' => '285873338131549',
    'secret' => '56b9f71b9fd307a033aeeb725893fc89',
   );

  $facebook = new Facebook($config);
  $user_id = $facebook->getUser();
?>
<?php
    if($user_id) {
      try {
        $user_profile = $facebook->api('/me','GET');
$profile = $user_profile['name'];
$_SESSION['user'] = $profile; //PUT USER TO SESSION
$_SESSION['user_id'] = $user_id;

$line = file_get_contents("onlineusers.html");
$line = trim($line); // removes leading/trailing blank lines
$line = explode("\n", $line);
$line[] = '<tr><td><img src="https://graph.facebook.com/' . $_SESSION['user_id'] . '/picture"width="25"height="25"/></td><td>' . $_SESSION['user'] . '</td><td><a href="http://www.fb.com/' . $_SESSION['user_id'] . '" target="_blank">View Profile</a></td></tr>';
$line = array_unique($line);
$line = implode("\n", $line);
file_put_contents("onlineusers.html", $line);
echo 'OK';

} catch(FacebookApiException $e) {
        $login_url = $facebook->getLoginUrl();
echo '<a href="' . $login_url . '">LOGIN</a>';
        error_log($e->getType());
        error_log($e->getMessage());
      }
    } else {
      $login_url = $facebook->getLoginUrl();
echo '<a href="' . $login_url . '">LOGIN</a>';
    }
echo "<a href='logout.php'>Logout</a>";
  ?>
What it does is, it simple insert the picture and name of the user in a flat html file..
http://www.barkadafm.org/onlineusers/index.php

Now, my problem is,.
I dont know how to delete the pic and name if a user logs out or disconnect..

Example, my name is Name5 and i will connect / login using http://www.barkadafm.org/onlineusers/test.php
for the first connect, my name and picture will be inserted to my flat html file..
Let's assume that there'are already 4 users online.. and the 5th data will be mine.

Pic1 Name1
Pic2 Name2
Pic3 Name3
Pic4 Name4
Pic5 Name5

what i want is,
if i click Logout, i want my picture and name be deleted from the flat file (onlineusers.html)
and destroy my 2 variables set at test.php

Please help me..
Thank you!

Problem With Delete Sql Function

Similar Tutorials

View Content

Hi, ppl, my problem is that whenever the DELETE link is clicked, a javascript confirm box pops up and it should only delete the record with the ID from the $_GET global array if the user clicks the OK button, otherwise it should just redirect to the table of entries WITHOUT DELETION, but somehow it IS DELETING even when CANCEL button of javascript confirm box clicked. Here's my code below:
<html>

<head><title>
</title>

</head>
<body>

<?php

require "bellConnect.inc.php";

$ID=$_GET['ID'];
$result=mysql_query("SELECT * FROM bellProducts WHERE ID=$ID");
$row=mysql_fetch_assoc($result);
$name=$row['Name'];
$manufacturer=$row['Manufacturer'];
print "Value of ID is $ID";

?>

<script type='text/javascript'>
var confirmDelete=confirm("Are you sure you want to delete <?php echo "$name $manufacturer"?> ?");
if(confirmDelete)
{
<?php $deletedResult=mysql_query("DELETE FROM bellProducts WHERE ID=$ID"); ?>
alert("<?php echo "$name $manufacturer" ?> has been deleted successfully.");
window.location="http://localhost/index.php";
}
else if(!confirmDelete)
{
window.location="http://localhost/index.php";
}

</script>

</body>

</html>

**please help me someone!!! thanks

Moved: Delete Function

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=328704.0

Recursive Delete Function

Similar Tutorials

View Content

i have the below script but it doesn't work it just refreshes the page anyone know what is wrong

Code: [Select]
<?php
$path = "../../gallery/gallery_files/gallery/";
if(isset($_POST['file']) && is_array($_POST['file']))
{
foreach($_POST['file'] as $file)
{

$dirname = $path;

//Recursive Delete Function

function DELETE_RECURSIVE_DIRS($dirname)
{ // recursive function to delete
  // all subdirectories and contents:
  if(is_dir($dirname))$dir_handle=opendir($dirname);
  while($file=readdir($dir_handle))
  {
    if($file!="." && $file!="..")
    {
      if(!is_dir($dirname."/".$file))unlink ($dirname."/".$file);
      else DELETE_RECURSIVE_DIRS($dirname."/".$file);
    }
  }
  closedir($dir_handle);
  rmdir($dirname);
  return true;
}

}
}
?>

Need A Delete Row With Checkbox Function Onclick Event Button--dom

Similar Tutorials

View Content

I have a dynamic script and need to create a click event function with JavaScript to delete the row which has a checkbox checked when the delete button is pressed.

This is being implemented with PHP and as now serves as light code for this matter at hand. I was only able to delete all rows. I have my efforts with the js functions too. <script type="text/javascript">
   var counter = 1;
   var limit = 6;
   function addTextArea() {
    if (counter == limit-1) {
    alert("Maximum limit " + counter + " sorry");
    return false;
    }
    else {
    

    var newdiv = document.createElement('div');
    newdiv.innerHTML = "" + (counter + 1) + " <br><textarea name='fav_det[]' id=counter rows='3' cols='20'>";
    document.getElementById('div6').appendChild(newdiv);

    var newdiv = document.createElement('div');
    newdiv.innerHTML = "" + (counter + 1) + " <br><textarea name='fav_col' id=counter rows='3' cols='20'>";
    document.getElementById('div5').appendChild(newdiv);

    var newdiv = document.createElement('div');
    newdiv.innerHTML = "" + (counter + 1) + " <br><textarea name='fav_mod[]' id=counter rows='3' cols='20'>";
    document.getElementById('div4').appendChild(newdiv);

    var newdiv = document.createElement('div');
    newdiv.innerHTML = " " + (counter + 1) + " <br><input type='text' name='truck[]' id=counter>";
    document.getElementById('div3').appendChild(newdiv);

    var newdiv = document.createElement('div');
    newdiv.innerHTML = " " + (counter + 1) + " <br><input type='text' name='car[]' id=counter>";
    document.getElementById('div2').appendChild(newdiv);

    var newdiv = document.createElement('div');
    newdiv.innerHTML = "" + (counter + 1) + " <br><input type='checkbox' name='chk[]' id=counter>";
    document.getElementById('div1').appendChild(newdiv);

    counter++
    return true;
    }
   }
   </script>


   <script type="text/javascript">
   function deleteRowS(dataTable) {
    for (var rowi= table.rows.length; rowi-->0;) {
     var row= table.rows[rowi];
     var inputs= row.getElementsByTagName('dataTable');
     for (var inputi= inputs.length; inputi-->0;) {
      var input= inputs[inputi];

      if (input.type==='checkbox' && input.checked) {
       row.parentNode.removeChild(row);
       break;
      }
     }
    }
   }
   </script>



   <script type="text/javascript">
   function deleteRow() {
     var table = document.getElementById(tableID).tBodies[0];
     var rowCount = table.rows.length;

     // var i=1 to start after header
     for(var i=1; i<rowCount; i++) {
      var row = table.rows[i];
      // index of td contain checkbox is 8
      var chkbox = row.cells[6].getElementsByTagName('input')[0];
      if('checkbox' == chkbox.type && true == chkbox.checked) {
       table.deleteRow(i);
       }
     }
   }</script>

   </head>
   <table>
   <tr><td valign='top'><b>NEED DELETE ROW WITH CHECKBOX FUNCTION:</td></tr>
   </table>
   <table id="dataTable" width="auto" style="margin:-4px 0 0 0; padding:14px 0 0 0;" cellspacing="10px"><tbody id="dataTable"></tbody>
   <tr>
   <td valign='Top'>
   ✗
   <div id="div1">
   <input type="checkbox" name="chk[]" autocomplete="off" id="1" >
   </div>
   </td>

   <td valign='Top'>
   cars
   <div id="div2">
   <input type="text" name="car[]" id="2" >
   </div>
   </td>

   <td valign='Top'>
   trucks
   <div id="div3">
   <input type="text" name="truck[]" id="3" >
   </div>
   </td>

   <td valign='Top'>
   your favorite model
   <div id="div4">
   <textarea name="mod[]" id="4" rows="3" cols="20"></textarea>
   </div>
   <br><br>
   </td>

   <td valign='Top'>
   your favorite add-ons
   <div id="div5">
   <textarea name="fav_col" id="5" rows="3" cols="20"></textarea>
   </div>
   </td>

   <td valign='Top'>
   explain vehicle overall
   <div id="div6">
   <textarea name="fav_det" id="6" rows="3" cols="20"></textarea>
   </div>
   </td>
   </tr>
   </table>
   <input type="button" value="Add another" onClick="addTextArea();" /> 
   <input type="button" value="Delete row" onclick="deleteRow('dataTable');deleteRowS('dataTable')" />

Global In A Function Inside A Function Does Not Work?

Similar Tutorials

View Content

When I put this chunk of code into it's own function:

function fetch_all ($dbc, $query) {

include ('knuffix_list_func.php');

pagination_start ($dbc, $query);

$offset = $pag_array[0];

$rows_per_page = $pag_array[1];

$query = $query . " LIMIT $offset, $rows_per_page";

echo "test query: " . $query;

knuffix_list ($query, $dbc);

pagination_end ($pag_array);
}

And when I echo out the query as you can see in the example, then I notice that the variables $offset and $rows_per_page never get appended.
I set the variable $pag_array to a global inside the function pagination_start(). It usually works when I DON'T wrap a function around this chunk of code, but if I do wrap a function around everything then the global suddenly won't work anymore.

Btw, this also won't work if I wrap a function around the function DECLARATIONS.

Any ideas, how I could make it work?

Problems With My While Loop And Also Cant Delete Its Corresponding Rows On A Click Of The Buttton Delete

Similar Tutorials

View Content

<body>

<?php

 
       include 'sql.php';
       $query = "SELECT * FROM validation";
       $result = mysqli_query($con , $query);  
       $rows = mysqli_fetch_assoc($result) ;
       $totals = mysqli_num_rows($result) ;
   
      
      
          ?>
            <div id="css">
    <form >
       <table width="80%" border="0" cellpadding="2" cellspacing="2" >
          <caption><h2>Personal Details of Customers</h2></caption>
          <tr class="white">
              <td bgcolor="#330033"> &nbsp; </td>
              <td bgcolor="#330033"> Id Number </td>
              <td bgcolor="#330033"> Full Name </td>
              <td bgcolor="#330033"> Email Address </td>
              <td bgcolor="#330033"> Website </td>
              <td bgcolor="#330033"> Comment </td>
              <td bgcolor="#330033"> Time </td>   
     
</tr>
       <?php while($rows=mysqli_fetch_assoc($result)
       {
       <tr>
      
      <input type="raido" name="ID" value="<?php echo $rows['ID']; ?>"  />
      <td bgcolor="#FFFFCC"><?php  echo $rows['ID'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Name'];?> </td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Email'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo  $rows['Website'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Comment'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Time'];?></td>  
      
       <td>&nbsp;</td>
     
       <td> <a href="delete.php? ID= "$rows[ID]" /"> <input type="submit" name="del" value="Delete" /> </a> &nbsp;                                                     <input type="button" name=   "edit" value="Edit"  /> </td>
       </tr>
              }

?>

</table>
</form>
</div>

</body>

Need Help Getting My Mail Function To Work

Similar Tutorials

View Content

I am having an issue with a support ticket program. I have added a feature to this program that allows my staff members to add multiple users to a ticket. The problem I am having because I am new to PHP is how do I email the users when they have been added to the ticket. Below is the code I am using for add user. If someone could look at it and help me figure out how to get this to email the user when they are added to the support ticket that would be great. I have been struggling with this for alot of nights and just cant figure it out.

Code: [Select]
<?php

require "../conf/conn.php";
require "../conf/conf.php";
require "session.php";
?>

<html>
<head>
<title><?php echo "$c_title - Add User"; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<STYLE type="text/css">
<?php include('../style.php'); ?>
</STYLE>

<SCRIPT LANGUAGE="JavaScript">

</script>
</head>
<body>
<?php
        $ticket_id = $_GET['ticket_id'];

        if(isset($_GET['action'])) {
            if($_GET['action']=='delete'){
                if(isset($_GET['ticid'])) {
                    $tid = $_GET['ticid'];
                    $query_user ="DELETE FROM support_users WHERE id='$tid'";
                    $result=mysql_query($query_user);
                    echo $_SESSION['successMsg'] = "<b>User Deleted From the ticket '$ticket_id'</b>";
                }
            }
        }

        if(!empty($_POST)) {
            $date = date('Y-m-d H:i:s');
            $puid = $_POST['username'];
            if($puid!='') {
                mysql_query("INSERT INTO support_users (id,user_id,ticket_id,assign_date) VALUES ('','$puid','$ticket_id','$date')") or die("<B>Error ".mysql_errno()." :</B> ".mysql_error()."");
                $_SESSION['successMsg'] = "User Added !";
            }
        }

        $query_user ="SELECT SU.id,SU.user_id,SU.ticket_id,SU.assign_date,U.user,U.name,U.email FROM support_users AS SU LEFT JOIN users AS U ON SU.user_id=U.id WHERE ticket_id='$ticket_id';";
        $result1=mysql_query($query_user);
        $user_arr = array();
        while($userrow1 = mysql_fetch_array($result1)) {
            $user_arr[] = $userrow1['user_id'];
        }
        $result=mysql_query($query_user);

        $query_user ="SELECT * FROM support WHERE Ticket='$ticket_id';";
        $support_result=mysql_query($query_user);
        $support = mysql_fetch_array($support_result);
/*
        $query_user ="SELECT * FROM users WHERE Ticket='$ticket_id';";
        $support_result=mysql_query($query_user);
        $support = mysql_fetch_array($support_result);*/



        if(isset($_SESSION['successMsg'])) {
            if($_SESSION['successMsg']=="") {
                echo $_SESSION['successMsg'];
                $_SESSION['successMsg'] = "";
            }
        }

    ?>

<form method="post" action="">
<table width="400" border="0" align="center" cellspacing="1">
<tr>
<td colspan="4" class="submenu">
Ticket ID <?=$ticket_id?>
</td>
</tr>
<tr align="center">
<td colspan="4" class="submenu">
Add Users
</td>
</tr>

<tr align="center">
<td class="">
Select User
</td>
<td>
<select name="username">
<option value="">[--Select User--]</option>
<?php
                          $query_user1 ="SELECT * FROM users WHERE level = '3' AND active <> '0' AND validated ='1' order by name";
                          $result1=mysql_query($query_user1);
                          while($userrow1 = mysql_fetch_array($result1)) {
                              if(!in_array($userrow1["id"],$user_arr)) {
                                $tempuser=$userrow1["user"]; ?>
<option value="<?php echo $userrow1["id"];?>"<?php if($row_user[user]==$tempuser){echo " selected ";}?>><?php echo "$userrow1[user] ($userrow1[name] )"; ?></option>
<?php }
                            } ?>
</select>
<input type='submit' value='Add'>
</td>
</tr>
</table>
</form>

<table width="400" border="0" cellspacing="0" cellpadding="0" align="center" class="border">
<tr>
<td>
<table width="400" border="0" align="center" cellspacing="1">
<tr align="center">
<td colspan="4" class="submenu">
Assigned Users
<input type='hidden' id='assigned_user' name='assigned_user' value="<?=$support['user_id']?>">
</td>
</tr>
<tr>
<td class="descrip">User</td>
<td class="descrip">Name</td>
<td class="descrip">Email</td>
<td class="descrip">Actions</td>
</tr>
<?php
    while($row = mysql_fetch_array($result)) {
    ?>
<tr>
<td class="dat"><a href="#" onClick="sendValue(<?php echo "'".$row[user]."'"; ?>);"><?php echo $row[user]; ?></a><?php if ($row["active"] == 2) echo "<font size=1 color=#FF0000> (Suspended)</font>"; ?></td>
<td class="dat"><?php echo $row["name"]; ?></td>
<td class="dat"><?php echo $row["email"]; ?></td>
<td class="dat"><img src="../images/delete3.gif" /> <a href="javascript:dele('<?=$row["user_id"]?>','<?=$row["user"]?>','<?=$row["ticket_id"]?>','<?=$row["id"]?>');">Delete </a></td>
</tr>
<?php
    }
    ?>
<tr align="center">
<td colspan="4" class="submenu">
<?php if ($numpage>1) {
                    pagenav();
                } else {
                    echo " ";
                } ?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br><table align="center"><tr><td><a href="javascript:window.close();">Close Window</a></td></tr></table>
</body>
</html>

Thanks in advance for any help...