Get the date on PHP and insert it into SQL

poeta_boy · 11-24-2003, 07:33 PM

Hello:

I'm creating a little database in a store. I need that when someone "sells" something, it stays in a table , the name of the guy who sold it, what was sold etc.... I have all that, but I don't know how to save the date it all happened.

I have the table with the following atributes (or columns)

Vendor, Article, Date, Quantity.

Vendor article and quantity are int (just id's) and Date is a DATE type.
how can I get it from the computer? afterwords, if I want to make a search based on the date, will I have to write all of it ( as 12-3-200)?

Thanks

BlackT · 11-25-2003, 05:16 AM

It's simple...when you insert into db, use this for date:

"INSERT INTO .... SET Vendor = "...", ...., Date = NOW()

When you want to search for records by date, use something like:

"SELECT ... FROM ... WHERE ..... AND TO_DAYS(Date) - TO_DAYS('[your search date here]') = 0"

HTH

poeta_boy · 11-25-2003, 06:37 PM

thanks a lot!!!!! by the way, would you happen to know how to load a page with php, lets say. I receive a name in a text field and if that name is "poeta" php checks it and send me to poeta.html, else it will send me to other.html.

Thanks

BlackT · 11-26-2003, 03:23 AM

PHP Code:



if($name == "poeta") 
   header("location:poeta.html"); 
else 
   header("location:other.html");

This is a simple redirect conditioned by the variable $name...

HTH

BlackT · 11-26-2003, 03:25 AM

Well, it's:

header("Location : poeta.html");

and

header("Location : other.html");

Just don't use space between "Location", ":" and "poeta..." or "other..."