Anonymní profil peter – Programujte.com

Pokud mas mysql a v mysql umis zalozit db bez pouziti php-my-admina, cili jenom prikazy, tak by totez melo fungovat pro oracle ve tvem programu. Jinak teda o tom nic nevim, jen to pouzivam uz hotove.

V php se k tomu pripojuji zhruba takto... Ve tvem pripade bych asi skoncil portem a pak zkusil vytvorit prikazem db.

$CFG['oracle'] = array(
'server'   => "nasserver.nasedomena.cz",	// Oracle server host
'port'     => "1234",		// Oracle server port
'db'       => "nasedb",	// Oracle db Stag
'bindName' => "naselogin",		// Oracle bind user name
'bindPsw'  => "naseheslo"		// Oracle bind password
);
$CFG['oracle']['dbstring'] = "//".$CFG['oracle']['server'].":".$CFG['oracle']['port']."/".$CFG['oracle']['db'].".nasedomena.cz";

function myOracleConnect()
{
global $ORACLE,$CFG;
myOracleDisConnect();
$ORACLE['connect'] = ocilogon($CFG['oracle']['bindName'],$CFG['oracle']['bindPsw'],$CFG['oracle']['dbstring']); // pripoj se na bind uzivatele
if (!$ORACLE['connect']) {
	$str  = '<div class="no_print">';
	$str .= '<p style="color:#dd1111;font-size:150%">Neplatne prihlaseni k oracle db!</p>';
	$str .=	'login = '.strtolower($CFG['oracle']['bindName'][0]).'.../heslo'; //.'.../'.strtolower($CFG['oracle']['bindPsw'][0]).'...'
	$str .= '</div>';
	echo $str;
	}
}

function myOracleDisConnect()
{
global $ORACLE;
if (isset($ORACLE['connect']))
	{
	oci_close($ORACLE['connect']);
	//unset($ORACLE['connect']);
	}
}