Re: Re: PHP Oracle connection across page.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Here is how I do it ...

[REF PHP PAGE]
<?php
  $conn=include("conn.php");
?>

..... HTMl CODE HERE .....

<?php
    $qry="SELECT lower(instance) instance FROM  all_databases ORDER BY 
instance";
    $cursor=ora_open($conn);
    ora_parse($cursor,$qry,0);
    ora_exec($cursor);
    while(ora_fetch($cursor)){
          $instance=ora_getcolumn($cursor,0);
          echo "<option value = 
\"index.php?tns=".$instance."\">".$instance."\n";
    }
?>

..... HTMl CODE HERE .....


[conn.php]
<?php
  if ($conn=ora_logon($username."@".$tns_alias,$password)) {
        $qry="select to_char(sysdate, 'Month DD, YYYY HH:MI AM') 
\"SYSDATE\" from dual";
        $cursor=ora_open($conn);
        ora_parse($cursor,$qry,0);
        ora_exec($cursor);
        while(ora_fetch($cursor)){
              $sysdate=ora_getcolumn($cursor,0);
        }
        ora_close($cursor);
        return $conn;
  }
  else {
        echo "Unable to connect to " .$_GET["tns"];
        return -1;
  };
?>

----------------------------------------------------------------------
Hope that helps ...


Roy A. Jones 
US Pharma Database Administration 
GlaxoSmithKline Inc. US Pharma IT, Shared Services 
External: (919) 483-0266 
Internal: 703-0266 
Fax: (919) 315-6842 
Office: RC2 - 2005 
Email: roy.a.jones@gsk.com 
USPHARMA Database Site 



"Muhammed Mamedov" <mm@ytm.com.tr> 
10-Sep-2003 18:31
 
To
php-db@lists.php.net
cc

Subject
 Re: PHP Oracle connection across page.






eventhough I've never used Oracle with PHP here is my suggestion:

create a file that will have your DB connection strings and include it in
every PHP file which uses Oracle connection.

EXAMPLE:
------------------------

[dbCon.php] file
$o_connection=@OCIlogon($o_conn_vars["username"], 
$o_conn_vars["password"],
$o_conn_vars["db"]);

[myPhpFile.php]

include_once("dbCon.php");
//Write youe queries now.
-- 

Muhammed Mamedov
Software Engineer
YTM.com.tr

"Syho" <syho@hkuspace.hku.hk> wrote in message
20030906030032.2355.qmail@pb1.pair.com">news:20030906030032.2355.qmail@pb1.pair.com...
> I have the following problem, please help me.  Many thanks.
>
> Script 1:
> <?php
>
> $o_connection=@OCIlogon($o_conn_vars["username"],
$o_conn_vars["password"],
> $o_conn_vars["db"]);
>
> //Parse sql statement
> //Execute sql statement.
> ..
> ...
>
> require('2.inc');
>
> ?>
>
____________________________________________________________________________
> ___________
>
> 2.inc:
>
> // This script will switch the brower to script2.php
>
> <html>
>
> <form name="s_form" action="script2.php"  method ="POST">
>
>
> </html>
>
>
____________________________________________________________________________
> ____________
>
> script2.php:
>
>
> <?php
>
> My problem is, how to get back the Oracle database connection in this
> script?  Please advise.
>
> ?>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux