Update coloums at certain time

Nixon

Hi All,

I want to update some coloums in my mysql table at a certain time. This can be done through PHP code. Here is an example:

+-------------+-------------+
| Name | Advert |
+-------------+-------------+
| Jack | Y |
| John | N |
| Tom | N |
|______|______|

Now I want to update the advert coloum so that all the values equal 'N' at 12:00pm everyday. Is there any way of doing this?

Thanks, Nixon

Nixon

Sorry about the table:

Jack - N
John - N
Tom - Y

jayant

This be achieved using a 'cron job' in unix/linux or task scheduler in windows. set them up to call ur php script @ 12pm daily. code the php script to update the db the way u want.

if ur doesnt support cron job's / scheduler either change the host or try using http://www.webcron.org/ ( in french)

mystrymaster

make sure you protect that page that has the script other wise some curious folks could get to it and cause the db to update at an inoprotune time.

Nixon

Is there no other simple way to do this through php?

alanzhao

Is there no other simple way to do this through php?

I don't think so, because script have to run manually. but some database allows you to do that, the schedule thing, I am not sure what is it.

but if you're running a busy site that visitors visit the page every second(for precise sake), then you can have the script check the time and update the value.

Nixon

How would I do this? Check the time every time a visitor comes because it doesn't need to change precisly at 12:00. It just needs to be changed once a day.

Thanks, nixon.

Yamakazi

You can make a table that keeps the dates that allready have been changed.

[Table Date]

-ExeDate-

In this table we're going to keep all days the script was executed.
First we look of the the script has been executed today.

$date = date ("Ymd");
$query = Select * Date where ExeDate = $date;
$Result = mysql_query($query);

Now you have to check if your query has a result. If it has a result you do nothing because the script 's allready been executed if doesn't return a value you run your script.

If(mysql_fetch_array($Result)){
//Do nothing
}else
{
//This way your date is written
mysql_query("insert into Date (Date) values ($date);
//Then you can write the things you want to do here.
}

Nixon

Hey, the script is working but not how it should. All it does is adds the date to my database and then changes all the values here is my code and what colums I have in my database.

Database - Table (date)

exedate | advert1 | date

null | N | 20030505
null | N | 20030505
null | N | 20030505
null | N | 20030506 *
null | N | 20030505

Code:


<? session_start(); 

// MySql Login

$mysqluser=nacd7152;
$domain=localhost;
$mysqlpass=mitchell;

$conn=@mysql_connect($domain, $mysqluser, $mysqlpass)
or die("Sorry Please Press The Back Button On Your Brwoser & Try Again");

//Select database

$database=DB_nacd7152;

$selectdb=@mysql_select_db($database, $conn)
or die("Sorry Please Press The Back Button On Your Brwoser & Try Again");

$date = date ("Ymd"); 
$query = "Select * Date where ExeDate = $date"; 
$Result = mysql_query($query); 

If (mysql_fetch_array ($Result) ) {}

else 
{ 

//This way your date is written 
mysql_query("insert into Date (Date) values ($date)"); 
mysql_query("update date set advert1=\"N\" ");
}

?>

Where the databse has a star next to it is where I changed the date to see if it made a difference. I dont think it is validating it properly. Any help?

Thanks, Nixon.