Interbase 6.01 (dialect 3), PHP4 and DATE
| From: | Francisco Puentes | Date: | Tue, 27 Mar 2001 18:55:38 +0000 |
| Subject: | Interbase 6.01 (dialect 3), PHP4 and DATE | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7902@lists.php.net to get a copy of this message | ||
How can I manage DATE fieldtype in PHP4 with Interbase?
The problem is that i manage DATEs in format DDMMYYYY (spain) but Interbase
manage it in MMDDYYYY format; so queries expected data in that format while
i need it in other format.
<%
if(isset($action))
{
ibase_timefmt("%d/%m/%Y",IBASE_DATE);
$ibh=ibase_pconnect("localhost:/usr/interbase/databases/dbsite.gdb","SYSDBA"
,"masterkey");
if($action=="edit" && isset($CONTEXT) && isset($DATE))
{
$sth=ibase_query($ibh,"SELECT newstext FROM news WHERE
context='$CONTEXT' AND newsdate='$DATE';");
if(($row=ibase_fetch_row($sth)))
{
}
}
}
%>
Would you send me examples (small && smart) of that?