StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to create a always running PHP background script to clean up particular rows in mySql DB?
primarykey
Id
5025115
data
AcceptedAnswerId
5025144
AnswerCount
3
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-02-17T04:40:40.920
FavoriteCount
2
LastActivityDate
2011-02-17T04:46:05.280
LastEditDate
LastEditorUserId
0
OwnerUserId
395661
ParentId
0
PostTypeId
1
Score
1
ViewCount
1899
LastEditorDisplayName
text
Body
<h2>How to create a always running PHP background script to clean up particular rows in mySql DB?</h2> <p>Hi guys I want to create a PHP script that automatically keeps on running (for example after every hour) and delete some particular rows from database(for example user comments those are atleast 5 days older)for this I am already having the date column in table.</p> <p>Please guide me how to do this as I am new to PHP.</p>
Tags
<php><mysql>
Title
How to create a always running PHP background script to clean up particular rows in mySql DB?
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAbhi
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POHow to create a always running PHP background script to clean up particular rows in mySql DB?
  UserUserId
  USAbhi
  VoteTypeVoteTypeId
  VTFavorite
2. VO
  singulars
  PostPostId
  POHow to create a always running PHP background script to clean up particular rows in mySql DB?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  POHow to create a always running PHP background script to clean up particular rows in mySql DB?
  UserUserId
  USshasi kanth
  VoteTypeVoteTypeId
  VTFavorite
CommentsPostId
1. COIn PHP is there something called background threads , just like we are having in .net. Or Should we do this task by creating triggers in mySql database ?
  singulars
  PostPostId
  POHow to create a always running PHP background script to clean up particular rows in mySql DB?
  UserUserId
  USAbhi
2. COwrite your PHP script and setup cronjob every few minutes which executes you cleanup php script.
  singulars
  PostPostId
  POHow to create a always running PHP background script to clean up particular rows in mySql DB?
  UserUserId
  USbhups

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.