PHP :: How To Delete All Database Entires Older Than 30 Days?

Delete Entries 1 Week Old Or Older.
I have a query that's supposed to remove bulletin entries that are a week old and over, but its not working, and the "date" column is filled with "time();"

<?php mysql_query("DELETE FROM `bulletins` WHERE `date` > (time() + (3600*24*7))");?>

Delete Record If Older Than 5 Minutes?
Can someone help me in writing a query command, to delete a record, if the last_update field on a record is older than 5 minutes?

My table has a last_update field, which holds a value as this for example: 2007-04-08 01:33:12

I need a query that when I access a php file, if a record is older than 5 minutes, it will delete it.

Validating TEXT Field Entires
Because I have several TEXT fields in my MySQL database, I need to know how to validate that only alphanumeric characters have been entered -- as this data will be echoed back to the user upon completion of the form.

Therefore, I need to prevent any malicious text from being entered into the form (SSIs, HTML formatting, etc.)

Is there any way to do this?

So far, I've only been referred to addslashes(). I've managed to use the following function:

function validate_text($text) {
$text = addslashes($text);
return ($text); }
$input_text = validate_text($input text);

But this only escapes single and double quotes with the slash. URLs, SSI statements, etc. remain untouched.

Sort Results By Date/time, Limit 5 Database Entries Of Today &/or Upcoming Days
I'm designing a website for my fraternity and in the database I have entries which contain past events, todays events, and upcoming events. My problem is that I can not figure out how to sort the query results to display:

1) only past events based on the CURRENT DATE
2) only the events which fall on the CURRENT DATE or after, limiting the results to 5 entries
3) all events that fall on CURRENT DATE or afterwards

Example:
Today is September 15, 2007

Problem 1) Displaying all events that happened before September 15, 2007
Problem 2) Displaying only 5 results that fall on September 15, 2007 or after
Problem 3) Displaying all events that are happening on or after September 15, 2007

And obviously I would like the CURRENT DATE to change depending on what date it is, currently.

Ok so now I've been very redundant in my explanation of my problem here is the code and a link to what that particular page looks like. Code:

Delete From Database
I have code that does not delete from a database. The same code (cut an
paste in the same file, but different function and having a different query)
works. So, of course, I tested the query interactively. I echoed the query
and did a cut and paste when interactively connect to the database. That
one worked so it isn't the query since interactively it is seeing exactly
the same thing as the code produces.

Here is the code:

function deleteCatalog($catalog) {
$query = "DELETE FROM CatalogNames WHERE sCatalogID='" . $catalog . "'";
mssql_select_db($database_Login, $_SESSION['Login']);
$result = mssql_query($query, $Login);
...
}

The $query echos:
DELETE FROM CatalogNames WHERE sCatalogID='CMP'

As an example of code that works (in the same file)
function addToCatalog($cat_id, $cat_name) {
$query = "INSERT INTO CatalogNames (sCatalogID, sCatalogName) " .
"VALUES ('" . $cat_id . "', '" . $cat_name . "')";
mssql_select_db($database_Login, $_SESSION['Login']);
$result = mssql_query($query, $_SESSION['Login']);
...
}

The second and third lines are identical (cut and pasted) as in other places
in the same code. In fact, it is only in this file that I do all the
database work. Every other function works. This is the only delete,
however.

Recursive Database Delete
I have two tables in my database, one for the folders, where each folder has a parent id and an id itself, and one for the files where each file has a parent id for the folder its in. Now If the user deletes a folder, every file and folder within it, no matter how many there are, should be deleted. Can anyone give me the idea?

Delete Item From Database
I still can't figure out how to delete an item from my shoppingcart. I have tried different ways to do this, but its impossible.

-a button or link that deletes a item from my database
-the php script that deletes it

here is a suggestion:

$slett = "DELETE ID, VARE, MODELL, STR, ANTALL, PRIS,
TOTALPRIS FROM USER_TRACK
WHERE USER_ID = "$user_id"";

But how can i assign this to a button?

Delete Row In Database By A Selectbox?
I'm having a world of trouble with this. I have a selectbox of names....when they selectone and hit delete I want it to delete it from the database. I dont think i'm getting any value from the select box. Here is the code I have : PHP Code:

Delete A Row From A Database Table
I'm trying to delete a row from a database table. I've made a connection yet it's not working. Is there something wrong with the following code?

mysql_query("DELETE * from `contactinfo` WHERE Submission_Number = 1 ");

Database Auto Count What About Delete?
I have a table that give a unique ID to certain Articles.
To give the ID i simply use the Auto count of the DB.

But what happens when i delete a record? i am now missing an ID.
How can i insert a row and give it the first available number?

For example ID 1, 2, 4, 5, 6

i would Insert and set the ID number to 3.

Delete Data From MySQL Database
I am new to PHP and MySQL but I have setup a MySQL database. I can view the information in an HTML table using PHP scripts and can delete an entry form the database table, but what i need to do is to be able to delete an entry by selecting a radio button next to the relevent information however when i try to add a form in the PHP script i get an error.

How To Delete A MySQL Database Table Without System()
I want to delete a MySQL table without using functions of the OS, so
that my php script can run on any webserver. Can I use a command like

$sql = "DELETE FROM tablename";

or are there better ways to do the job?

Simplify Insert-update-delete From Database
I'm looking for some functions or objects allowing to
select-insert-update-delete from any table in a mysql database without the
need to create a new query every time. Example:

selectdatas(array('field1','field2','fieldn'),arra y('table1','tablen'),array('left
join,idy','inner join, idx'))

then the function build the query, execute it and then return an object with
the query result.

I must build a database driven site that is 90% of the time spent on
building queries. If I may avoid build them manually it will help me a lot
and let me gain some days of programming.

Automatic Delete From MySQL Database Table Expired Records?
I have a question . . .

how can i delete from MySQL database table automatic expired records ?
?

One think is to make a service that deleting the expired records . . .

Any other method ?

Older PHP Manuals?
I'm trying to use the DOM XML functions, but because they're in development and my hosting provider only has 4.0.4 installed, I don't have the proper documentation. Does anyone know where I can locate an older version of the php manual?

Clearing Up Older Files
Wonder if you bunch can help me (again!)... i'm looking for a way to read the filenames and dates in a directory, and delete everything which is more than 24 hours old.

It's gonna be part of a garbage cleaning routine for old temporary downloaded files.

Php Compatable With Older Browsers
are all the functions of php compatable with older browsers? if not what functions don't work?

Show Older Entries
I have a MySql table with the field "sentdate". How could I set up a query that selects only entries that have a sentdate that is for example 30 days old?

Deleteing MySQL Rows Older Than 1 Hour
Hi, as the title says, I have a mysql table which logs data, I have a timestamp field which collects what time the record was added, I really need to know howto setup a WHERE clause which will tell mysql to delete rows that are older than one hour, can anyone help?

Older GD Lib And Jpeg Photo Thumbnail Generation
I'm using a server which only has GD version 1.6.2, with jpeg support
enabled. I'm trying to use it to make thumbnails of jpeg photos as they are
uploaded from a webform, but moving from my development server (which has GD
2.x) to the real server I noticed the lower GD lib version, and that it
doesn't support imagecreatetruecolor. Without this, using imagecreate, the
converted image always come out almost always a single colour, or with very
little variation in the colour. Using some images I found in XP as a test,
one has green plants with a few bright red flowers - if i just use
imagecreate, the bright red flowers are green too. I'm using
imagecopyresampled to do the copy. Is there another way to do this without
getting newer libraries installed on the server?

MYSQL PHP Code Works With Older Version.
I am having issue with they way that my PHP MYSQL code works with the MYSQL version 5.0.45 Here is the Code that inserts the data into the database. The thing is the tables that have a int in MYSQl error when there is no value present. Code:

MySQL Dont Show Older Than Today
I'm making a database for upcoming shows. so, what I wonder now, is there a way to show only upcoming shows, and just exclude the shows older than todays date? what I've got atm is: Code:

Migrating Existing Site From Older Version Of PHP & MySQL
There's an existing website (on a single box running Linux, Apache, PHP 4.1.2, MySQL 3.23.58) that I need to migrate over to another setup (2 boxes, the web/app server running MS 2003 Server, IIS6, PHP 5.2.4 and a DB box running on SuSE, MySQL 5.0.26). I've gotten the connection between the two new boxes to work, but a lot of the code from the original website doesn't seem to work.

Is there anything obvious I should know about migrating code from the older setup to the newer one, which is running different versions of PHP and MySQL. I've attached 2 php files (both renamed to txt). When I bring up the dir_master.php file, the only thing that comes up is the Name, Affiliation, and Department headers from the contents.php file.... nothing gets displayed from the MySQL database. Like I said, I have been able to pull stuff out of the DB using code I wrote myself to test it, so I'm sure the PHP to MySQL connection is working.

I think the issue might be with the PHP code and how the HTML is embedded in it, but like I said, this isn't my field of expertise. I'm hoping there's a quick syntax fix that I can use without having to completly rewrite everything.... especially since there's a number of PHP files that will need to get changed.

How Do You Add 7 Days To Now()?
How do you add 7 days to the now() function stored in database as 00-00-00 00:00:00

Days In A Calender
I am trying to write a calender display that shows the days of the month accross the top of a table, and people's names down the side. One of the things I would like to do is to change the colour when the days are Saturday or Sunday. PHP Code:

Get The Birthdays For The Next 14 Days
I have a table of members and I have their dob. Now I want to show the members which have their birthday in the next two weeks. PHP Code:

Dates Of $day In The Next $n Days
how would I go about working out the dates (timestamps) of the day $day (e.g. Monday, Tuesday, &c) in the next $n days. So if $day was Monday and $n 28 I would want to find out the dates in the next 28 days that are a Monday.

The problem is that I am not sure about the logic side of the problem. A crude solution that I can think up is doing something like PHP Code:

Add Days To Date
I have a date assigned to a variable $firstPay and another variable $totalDaysTo which has the number of that I want to add to the variable $firstPay to get some future date. I'm not sure how to wright the code for this one.

Days Calculation
i can't seem to get this what im trying to do is work out the elapsed time in DAYS from 2 dates code is:

$time_now = time();
$d2 = date('Y-m-d H:i:s', $time_now);
$d1 = date('Y-m-d H:i:s', strtotime($ng_date));
$days = ceil(($d1 - $d2) / (60 * 60 * 24));
when echoing out it produces:

2007-06-02 16:53:24
2007-08-27 18:00:51
which is right, but $days echoes out as 0.

How Do You Print A Date 7 Days Ago Please?
I have this code:

$today = getdate();
$month = $today['mon'];
$mday = $today['mday'];
$year = $today['year'];

echo $year-$month-$mday

which prints out the date today (2001-10-26).

How do I get it to print out what the date was 7 days ago?

Number Of Days Interval?
I need to calculate the number of days between two unix timestamps. I.e., if they are from the same day, the interval is 0, if $then is tomorrow (where $now is today), the interval is -1, if $then is yesterday, the interval is 1, and so on. Here's my code:

How To Add X Number Of Days To A Date
I have been scratching my head over this one. I want to add a number of days to a date and end up with a date.

The only way I've thought of doing this so far is converting to a time stamp, adding the days (in milliseconds) and then converting back.
I'm sure there must be an easier way!

Calculate Days Worked
I have a set date in my MySQL database that records when a Sales Lead
is established and I echo that date as $row_rsLead['lead_date'];

I need to be able to calculate how many days that lead has existed.
$row_rsLead['lead_date']; outputs as 2007-06-14.

I have made numerous attempts to create a function that will calculate
the days between the lead_date and today's date, but have made
absolutely no headway. I am either stuck working between differing
date formats or really strange numerical outputs.

If there is a script someone is willing to share or point me in a
direction that is good for a relative newcomer to PHP,

Marking Calendar Days
I did a very basic calendar in php, and know I want to mark some days.
For example: -exam days, semesters, etc.
What is the best way to do this?
I want to click a link, button, checkbox,etc and marking days to a
database, either single or start and end days.

Subtracting Days From Date
I have a date format written in Y-m-d and I need to be able to subtract a set number of days and then display the result. I know a lot has been written about this but it has beaten me.

// get todays date
$mydate = date("Y m d");

// split into individual y,m,d
$datearr = split("-",$mydate);

// make timestamp
$timestamp = mktime(0,0,0,$datearr[1],$datearr[2],$datearr[0]);

// increment date, you can alter the number of days obviously
$newtimestamp = strtotime("-2 days",$timestamp);

// change to readable date
$mynewdate = strftime("%Y-%m-%d",$newtimestamp);

echo $mydate; // outputs 2003 09 30
echo $mynewdate; // outputs 2002-11-28

This code subtracts 2 days which is fine, but then it also subtracts a year and adds two months..

How Do I Display The Last 14 Days On A Page?
Does anyone know how to display the last 14 days including the current day
on a page in php? I don't know where to start with this myself.

Date Interval 7 Days
I currently have a view_jobs page, and it shows jobs booked on the current day and 7 days either side. I want to be able to only show jobs for the current day, and 7 days in the future. This all works around my date field.

My current code is:
$query = "SELECT *, DATE_FORMAT(date, '%W (%d/%m/%y)') as dateFormatted
FROM jobs
WHERE date > DATE_SUB(CURDATE(), INTERVAL 8 DAY)";

Displaying Records After 2 Days
I trying to display only records that are 2 days old so the owner of the site can preview new records before they are available to others, this is what I've got so far...
$sqlquery = "SELECT headline, news, date_format(date,'%M %D %Y') as time FROM $table WHERE date < NOW() ORDER BY date DESC";

is there a way to extend it by 1 or 2 days, i've tried the TO_DAY function but couldn't get it to work either.

45 Days Prior To Date
Been assigned a project to list entries
that have been entered within the last
45 days.

My database has the date column with the
date format as YYYYMMDD (ex: 20070423)

Been trying to write code for an SQL query
to list entries that are less than 45 days
from the date that is in the column

I have used the dateadd() function but does the
date have to be in the format as MMDDYYYY
(ex: 04232007) in order for the dateadd()
function to work properly.

Number Of Days In 1/1/2000
I am looking for a script that can report the number of days since
2000. It should handle leap years but I am not worried about accuracy
to the hour/minute or seconds. I am writing a calendar program and need
a reference point to base all my dates from. So I picked 1/1/2000.

COUNT Only Within Last X Amount Of Days
The script should grab only last 7 days of database entries which it does. Also it also needs to count to see how many times a CD was played, which it also does, but gives overall total and not just within that 7 days. Code:

Days Based On Months
I am trying to modify some code so that the days dropdown has the correct amount of days for each month( Jan - 31 days, Feb 28, etc). I managed to get it so the correct days appear however it lists all the days. Code:

Number Of Days In Month
is the only way to find out the number of days in a month is using this functions?

cal_days_in_month

Display Records 30 Days From Now
I am trying to display records that are 30 days from the current time. Someone suggested the following:

select * from table WHERE date_column BETWEEN CURDATE() and DATE_SUB(CURDATE(),INTERVAL 30 DAY)

Calculating Days Between Two Dates
I need to calculate the numbers of days (only the number of days) between two days, one a variable $row['user_cp_name'] in the format MM/DD/YY, and another, the current time. I've tried a bunch of tutorials on the internet and none seem to work properly.

Constraint Using The Days Of The Week?
I am developing a property application where I have 5 members and only want 1 member a day to choose their property for the "property of week" section.

So I want to assign a day to each member.

Mem1 - Mondays
Mem2 - Tues
Mem3 - Wed etc..

Each member will have there own unique logon so if Mem1 logs in on Monday, they will have the "property of week" option avaliable to them. Mem2 will have it Tuesday and so on.