|
Last change
on this file since 68 was
68,
checked in by cbipsl, 14 years ago
|
|
commit v1 eccad
|
-
Property svn:executable set to
*
|
|
File size:
810 bytes
|
| Line | |
|---|
| 1 | <? |
|---|
| 2 | // |
|---|
| 3 | // This function returns the period, the begin date & the end date of the data, |
|---|
| 4 | // |
|---|
| 5 | // Input : id_produit: Id of the product |
|---|
| 6 | // Output : Period>BeginDate>EndDate |
|---|
| 7 | // ex: 1 day>1998-11-01>1998-11-30 |
|---|
| 8 | // |
|---|
| 9 | |
|---|
| 10 | |
|---|
| 11 | |
|---|
| 12 | // CONNECION SQL |
|---|
| 13 | require('adodb/adodb.inc.php'); |
|---|
| 14 | $DB = ADONewConnection('postgres'); |
|---|
| 15 | // $DB->Connect('shiva', 'wwwadm', 'adm001', 'ECCAD'); |
|---|
| 16 | $DB->Connect('eccad', 'eccad', 'adm001', 'ECCADTEST'); |
|---|
| 17 | $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; |
|---|
| 18 | |
|---|
| 19 | $rs = $DB->Execute("select distinct deltaDate_grille from grille where id_produit =".$_GET["id_produit"]); |
|---|
| 20 | echo($rs->fields[deltadate_grille]); |
|---|
| 21 | echo(">"); |
|---|
| 22 | $rs = $DB->Execute("select * from produit where id_produit=".$_GET["id_produit"]); |
|---|
| 23 | echo($rs->fields[begintime_produit]); |
|---|
| 24 | echo(">"); |
|---|
| 25 | echo($rs->fields[endtime_produit]); |
|---|
| 26 | ?> |
|---|
Note: See
TracBrowser
for help on using the repository browser.
