Delete history with PHP

**Angelica Maria** · 02-04-2010

Hello,
As several of us have access to our space management, I must absolutely know that to remove what and when. In my table I select 1, I assume id # 1 with delete.php? Id = 1 and at the same time I want to get under id 1, and store it in my table "archive_sup-prime" function everything perfectly, but unfortunately to get the title. How can I do this, if you have any idea regarding this then please let me know. Thanks in advance.

**GlassFish** · 02-04-2010

Hello,
Have you tried to insert a selection from a line in your # id = 1 in the base archive

Code:

VALUES INSERT INTO SELECT * FROM my_table

the * is provided that the two tables have exactly the same structure and if this integration has gone well so we remove the ID? I do not think this is hard to find, just try the above statement and if you have any more problem then post back with the error you get.

**Linux-Us** · 02-04-2010

Hello,
Before removing the field, will re-search for the title in the table, made 3 requests.

Code:

delete.php? id = 1

I think you can use the following code

Code:

SELECT title FROM table1 WHERE id = 1;
INSERT INTO Archive (title, id_table1) VALUES (row ['title'], row ['id']);
DELETE FROM table1 WHERE id = 1;

**NetWorkInG** · 02-04-2010

Hello,
I think this is very easy and you can do this by using the following. Your title, it is this

Code:

variable -> $ title_sup = "$ title"?

And

Code:

variable $ id_sup = "$ id";

it is registered or not? And why do not you do your "DELETE" before sending the message rather than the beginning of your code? I hope you are understanding what I am trying to say here.

**HardWeaR** · 02-04-2010

Hello,
Try the following code

Code:

<Php
$ Basename="Diary";/ / Name of the table.
$ Topic="Event Calendar";/ / Name of item
$ Period="4";/ / Redirect automatically after X seconds.
$ Return="Admin.php";/ / Redirect page.
$ Date=date("D / m / Y"); 
$ Time=date("H: i: s"); 
$ Id_sup="$ Id"; 
$ Titre_sup="$ Title"; 
From $=$ _SERVER['HTTP_REFERER'];/ / Used to determine the source of the user
$ Ip=$ _SERVER["REMOTE_ADDR"]; 
$ Domain=gethostbyaddr($ Ip); 
$ Browser=$ _SERVER["HTTP_USER_AGENT"]; 

?>