PHP - Auto Delete Database

i trying to delete messages out of my message database but im not sure if i'm using this code right
or there stuff missing to it :S

delete.php
<?php 
require_once('settings.php');
checkLogin('1 2');

$id=$_GET["msgs"];
mysql_query("DELETE messages FROM messages WHERE message_id='$id'");
?>

link usages to delete
<a href="delete.php?msgs=<? echo $row['message_id']  ?>">[X]</a>

Hello
i have a text box and a button on my webpage and want to get the text box to find the username i type into it from the database and when it does it will then go to number and delete any text that is under usernames number field as you can see i have no idea how.

Code: [Select]
$result = mysql_query("DELETE FROM mytable WHERE username='$username1' AND number='$number1'" );
Code: [Select]
<form name="form1" method="post" action="p.php">
<p><input type="submit" value="Enter" /></p>
<input name="username" type="text" id="username" size="15" maxlength="35" value="<?php echo $username1; ?>" />
</form>

I am trying to find a way of deleting entries from a database after a certain time, and also when there is another field in the database set to 0.

i have got so far with the code (will delete when other field is at 0) but nothing happens when i try to add in the time. my code im trying to use is below

mysql_query("DELETE FROM temp_users WHERE book_stage='0' and WHERE time() > [creation+60]");

creation being the name of the field in the database that holds the unix time stamp of when the entry was created.

i need the entry to be deleted one hour after it was created if the book_stage hasnt been changed to 1 during this hour.

many thanks,
gavin

I'm working on an old cms I built a few years ago and for some reason my Delete page isn't working.  It has to be something simple I'm overlooking.  The database connection is made just above this code and is pulling the thumb and title listed by id.  When I push delete I'm getting the cmd=delete&id=2 passed on so something is up with my last if statement (I think).  Here is the code:

if(!isset($cmd)) 
{
   //display all the news
   $result = mysql_query("select * from verizon order by id"); 
   

   
   //run the while loop that grabs all the news scripts
   while($r=mysql_fetch_array($result)) 
   { 
      //grab the title and the ID of the enws
      $title=$r["title"];//take out the title
      $id=$r["id"];//take out the id
      $thumb=$r["thumb"];
      
      echo "<div id='delete'>
            <table>
<tr>
  <td width='350px'><strong>$title</strong></td><td><a href='verizondelete.php?cmd=delete&id=$id'>  Delete</a></td>
</tr>
<td colspan='2' align='center'><img src='../upload/verizon/$thumb'></td>
    </table>
         
          </div><br />";
    }
}

if($cmd=="delete")
{
    $sql = "DELETE FROM verizon WHERE id='$id'";
    $result = mysql_query($sql);
    echo "<h1 style='text-align:center;'>deleted!</h1>";
} 

}
?>

Hi,
   I have created a table named multipath with database name "mydatabase".. I have created a table to store the data in the tables. Check boxes are created to select one row each to delete. But I am unable to delete the rows. Why??

Here's my PHP code

 
 
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="mydatabase"; // Database name
$tbl_name="multipath"; // 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);

?>
<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">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">#</td>
<td align="center" bgcolor="#FFFFFF"><strong>Path ID</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Path</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><?php echo $rows['path_id']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $rows['path']; ?></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
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.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

   
Please u can reply me at sawyerford007ATgmail DOTcom

No errors come up when I run this but it just doesn't delete the entry.



<?
$rec = $_POST['stock'];
if (!$rec){ 
die ('Please eneter a stock number');
}

$link = mysql_connect("xxxx","xxx","xxx");
mysql_select_db('wadkin', $link) or die( "Unable to select database");

mysql_query("DELETE FROM 'wadkin'.'stocklist' WHERE 'stocklist'.'Stock Number' = $rec")
or die ('Query failed');

mysql_close($link);

?>


Can someone please correct,

(btw I have also tried... "DELETE FROM stocklist WHERE 'Stock Number' = $rec")

Hey everyone i having some trouble updating records in my databse using checkbox from a form.

I can update the records, but i can't figure out how to remove records at the same time.

I've posted the code that i'm using to update below

foreach($_POST['tag'] as $k=>$l){
$tag = mysql_real_escape_string($_POST['tag'][$k]);

$check_tags = mysql_query("SELECT * FROM file_cats WHERE category='$tag'") or die(mysql_error());
$num_tags = mysql_num_rows($check_tags);

if($num_tags==0){
$add_tag = mysql_query("INSERT into file_cats (fileID, category) VALUES('$fileID', '$tag')") or die(mysql_error());
}
}


This code inserts new records based on what the user checked. If it exist it won't add a new row, if it doesn't exist then it will add a new row. but like i said how can remove a row if the box is no longer checked?

I've tried using

foreach(empty($_POST['tag'] as $k => $l){
       $tag = empty($_POST['tag']['$k'];
}


But that didn't work basically nothing was deleted.

Has anyone done something like this before? if so i would appreciate any help you could give

I have a PHP CRUD application and when i delete a row i need it to delete from the MySQL and the image from the uploads folder as well. I have researched and tried dozens of ways with the unlink option but nothing works. If i take out the unlink from my code it will delete fine from the DB. I am new to coding and PHP so any help would be awesome.

The file_path is correct. The uploads is the name of the folder where the image is stored and the $_POST["image"] is the column name in MySQL where the image name is stored.

delete.php

<?php

	//start PHP session
	session_start();

if (!isset($_SESSION['success']))
{
    header("Location: login_page.php");
    die();
}

// check if value was posted
if($_POST){
 
    // include database and object file
    include_once 'config/database.php';

    $file_path = 'uploads/' . $_POST["image"];
    if(unlink($file_path))
 {
	// delete query
	$query = "DELETE FROM myDBname WHERE id = ?";
	$stmt = $con->prepare($query);
	$stmt->bindParam(1, $_POST['object_id']);
 }
	if($stmt->execute()){
		// redirect to read records page and 
		// tell the user record was deleted
		echo "Record was deleted.";
	}else{
		echo "Unable to delete record.";
    }
}

?>

this is the delete button code

					echo "<a delete-id='{$id}' class='btn btn-danger delete-object'>";
					echo "<span class='glyphicon glyphicon-remove'></span> Delete";
					echo "</a>";

This is the javascript for the delete button as well.

	// delete record
	$(document).on('click', '.delete-object', function(){

		var id = $(this).attr('delete-id');

		bootbox.confirm({
		    message: "<h4>Are you sure?</h4>",
		    buttons: {
		        confirm: {
		            label: '<span class="glyphicon glyphicon-ok"></span> Yes',
		            className: 'btn-danger'
		        },
		        cancel: {
		            label: '<span class="glyphicon glyphicon-remove"></span> No',
		            className: 'btn-primary'
		        }
		    },
		    callback: function (result) {

		        if(result==true){
					$.post('delete.php', {
						object_id: id
					}, function(data){
						location.reload();
					}).fail(function() {
						alert('Unable to delete.');
					});
		    	}
			}
		});

		return false;
	});

 

If you need any other info that would help you help me just let me know and i will get that in here ASAP. Thanks again for any help on this.

Hello everyone I need code for this question    would you help me please..?

Maybe some of the great coders here can help this noob out.
So here is what I have so far:

Code: [Select]
//set age criteria for deletion
$age = 60;

//get current date
$datenow  = date("Y-m-d");

//set the range we want to delete
$delete_range = $datenow - $age;

//get old user_id from users table
$oldusers_users = mysql_query ("SELECT user_id FROM users WHERE lastvisit < $delete_range ");

//get user_id from images table that correspond to users table
$oldusers_images = mysql_query ("SELECT user_id FROM images WHERE $oldusers_users=user_id.images ");

//find folders that correspond to the usernames and delete
$oldusers_files = mysql_query ("SELECT username FROM users WHERE lastvisit < $delete_range ");
//print out username
//$result = mysql_($oldusers_files);
$foldername = mysql_result($oldusers_files, 0);

$sigspath = "sigs/";
unlink($sigspath . $foldername . ".gif/index.php");
rmdir($sigspath . $foldername . ".gif");
//now delete user_id's from database
mysql_query("DELETE * FROM users WHERE user_id=$oldusers_users");
mysql_query("DELETE * FROM images WHERE user_id=$oldusers_images");
unset($oldusers_users, $oldusers_images, $oldusers_files, $foldername, $sigspath );
mysql_close($link);
Right now it is only returning the first entry, not the entire list that meets the criteria.  It does delete that one file though but does not remover the rows from the database.

I am sure the database stuff is jacked up I am really new to that part.  What am I doing wrong here or is there a better way to do this perhaps

Hi, I'm trying to get a php webform to log onto the database automatically before it loads on the website page. In other words I don't want the customer having log onto the database or be a guest. I think I need the code below to do that. Question is, can I just add this code into the php file that is the webform or add the <?php            ?> to it and have it above the webform php code.
Also do I need to alter any other dbconnect php pages as well?
Also do I need to edit the htaccess file also.



function verify_code()
{


$connection = mysql_connect ("localhost", "fred", "kool3401") or die ('Error: ' . mysql_error());
$db = mysql_select_db ("october");

  {
    echo "Authenticated";
  }


Many Thanks

Hello all,

I have three text fields ( hosteladmissionnumber,branch & Semester) and three text boxes in a form. When i provide the hostel admission number , the corresponding branch semester must be acquired from the registrationtable in DB and fill it in text boxes. How can i do it? any help would be appreciated. Thanks. I have pasted the code below.
[syntax=php]
<?php
session_start();
  $hostad=$_POST['hosteladmissionno'];
   $sem=$_POST['student_name'];
   $sem=$_POST['semester'];
$con=mysql_connect('localhost','root','');

if(!$con)
{
die('Unable to connect'.mysql_error());
}
mysql_select_db('hostel',$con);
//i have to insert the hosteladmission in payment too..but no need to insert semester and branch
$r1="INSERT INTO payment(hosteladmissionno) values ('$hostad')";
mysql_close($con);
?>
/HTML PART

<form action='payment.php' method='POST' name='form1'>
    <center>
 <table>
<tr><td><b>Admission No:</b></td><td><input type='text'  name='hosteladmissionno'></td></tr>
<tr><td><b>Student Name:</b></td><td><input type='text'  name='student_name'></td></tr>
<tr><td><b>Semester:</b></td><td><input type='text'  name='semester'></td></tr>

[/syntax]

This topic has been moved to Ajax Help.

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

Hi all, I am wondering what the best way to do this is...

Take GoDaddy for example, if your domain is about to expire you will get an automatic email.

I am wanting to do something similar, If someone orders a Soap Dispenser, I want to send an email (if they accept to receiving emails on the order) each month asking/reminding them to top up on soap.

I have been reading but cant find anything adequate, I have seen something about Cron Jobs, but never heard of this before, please could you point me in the right direction.

Thanks in advance.

Peter