Search DaniWeb - ocilogon

Wampserver: OCILogon Error from command line 10 Years Ago by dippy78 Hi Team, Please hekp me with the OCILogon error. Im using WampServer Version 2.2. I have a …. While executing script it gives "Call to undefined function OCILogon() in c:\wamp\www\cps_auto\testauto.php on line 6… Re: Wampserver: OCILogon Error from command line 10 Years Ago by cereal …. Also by using `oci_connect()` do you get the same error? Ocilogon is an alias of oci_connect and the alias is deprecated… PHP Fatal error warning 10 Years Ago by sk8ergirl …run out of solutions please HELP! *Warning: ocilogon(): ORA-12537: TNS:connection closed Fatal error…this error *Fatal error: Call to undefined function OCILogon()* this is my php file <?php …= xxxx)))(CONNECT_DATA=(SID=orcl)))" ; if($c = OCILogon("student", "student", $db)) {… Re: PHP Fatal error warning 10 Years Ago by diafol Use oci_connect() instead of OCILogon (deprecated anyway). http://www.php.net/manual/en/function.ocilogon.php I'm assuming that your local copy of php doesn't have oci. Perhaps you need to enable it: http://stackoverflow.com/questions/21249858/how-to-enable-extensions-for-oci8-oracle-in-php-ini-php-warning-php-startup PHP Oracle AdoDB 17 Years Ago by mmondragon …;(CONNECT_DATA = (SID = XE))\n"; $db .= ")\n"; $conn = ocilogon($User,$Password,$db); $sql = "select signature from approvers where… php delete 17 Years Ago by dansmit …("TNS_ADMIN=/u1/oracle/Products/shu10g/network/admin"); $conn = OCILogon("wkagonye","maniki", "shu10g"); $query… ideas 17 Years Ago by dansmit …("TNS_ADMIN=/u1/oracle/Products/shu10g/network/admin"); $conn = OCILogon("wkagonye","maniki", "shu10g"); $receiptno… Prevent duplicate entry 16 Years Ago by chicago1985 … even if not a duplicate: [code=php] <?php $c=OCILogon("scott", "tiger", "orcl"); if… Re: Prevent duplicate entry 16 Years Ago by hielo Try this: [CODE] <?php $c=OCILogon("scott", "tiger", "orcl"); if ( ! $… php4 - problem with foreach 11 Years Ago by PHPuss … C:\Apache\test.php on line 28 <?php $conn =OCILogon("xxxx", "yyyy", "localhost/xe"… How to improve code and performance 11 Years Ago by PHPuss <?php $db_conn = ocilogon("root", "admin", "//localhost/xe"); $… Having Trouble Understanding Why This PHP Function Is Not Working 11 Years Ago by Navlag … = OCIPlogon($user,$password,$db_name, 'AMERICAN_AMERICA.AL32UTF8'); } else { $this->db_handle = OCIlogon($user,$password,$db_name, 'AMERICAN_AMERICA.AL32UTF8'); } if ( !$this->db_handle ) { $this… Re: combo box 19 Years Ago by DanceInstructor …on this [URL=http://us3.php.net/manual/en/function.ocilogon.php]page[/URL] to work on your server. […;?php // script from http://us3.php.net/manual/en/function.ocilogon.php echo "<pre>"; $db = …""; $c1 = ocilogon("scott", "tiger", $db); $c2 = ocilogon("scott", "tiger"… Re: combo box 19 Years Ago by Facey …]; // connect to database putenv("ORACLE_SID=area"); if ($Connection = ocilogon("u2o30", "u2o30")) { // assemble query $Sql = "… Re: combo box 19 Years Ago by DanceInstructor … // connect to database putenv("ORACLE_SID=area"); if ($Connection = ocilogon("u2o30", "u2o30")) { // assemble query $Sql = "… Re: Wampserver: OCILogon Error from command line 10 Years Ago by dippy78 Hi cereal, You are right, we need to decomment in php.INI file in phpx.x.x folder also. Bit confusing the need to have 2 files for config.. It worked finally.. Thanks a lot Cheers Deepak Re: php delete 17 Years Ago by w_3rabi you should set the value of the [code=php]<option>[/code] and it should be equal to $row[0]; somthing like this ... [code] print "<option value='".$row[0]."'>"; print $row[0]; print "</option>"; [/code] Re: php delete 17 Years Ago by dansmit dosnt work mate tried it i am starting to lose patience with it i still get the same error message Re: php delete 17 Years Ago by shivamsoftware Delete the value through in array Re: Prevent duplicate entry 16 Years Ago by hielo The best approach is to have the DB enforce Referenctial Integrity. Basically you instruct the database at design time NOT to allow duplicates for certain records ever. IF such an attempt is made, the db server will not carry out the operation. Look at these: [url]http://www.google.com/search?hl=en&client=firefox-a&rls=org.mozilla:en-US:… Re: Prevent duplicate entry 16 Years Ago by hielo The "hard" (and wrong) approach would be to first query the database to check for the existence of the record and insert it only if no record exists. But the right way to approach this is through referential integrity. Re: Prevent duplicate entry 16 Years Ago by nav33n [QUOTE=chicago1985;495619]I have my PHP inserting into Oracle 9i. But how do I prevent duplicate record entries? I only have 3 fields in the insert in the action page and my below attempt doesnt output anything or insert anything even if not a duplicate: [/quote] There are some errors in your script. [inlinecode]$mydupcheck = "select … Re: php4 - problem with foreach 11 Years Ago by cereal The problem is that **$results** is not an array. With **ocifetch()** you get *the next row from a query into internal buffers* so, you get a single part of the *result set*, try **ocifetchinto()**, you can read an example here: * http://www.php.net/manual/en/function.ocifetchinto.php#58115 Or try to use **ocifetchstatement()** which is the alias… Re: php4 - problem with foreach 11 Years Ago by PHPuss > ocifetchstatement it works ! thanx cereal ! :) Re: How to improve code and performance 11 Years Ago by pritaeas A `like` condition is very slow to execute. From what I can see in your queries, they are identical, except for the `SYSTEM_` part. So why don't you change the query to: SELECT * FROM TESTS WHERE TEST_TIME BETWEEN TO_DATE('2012-01-01','YYYY-MM-DD') AND TO_DATE('2012-02-02','YYYY-MM-DD')+1 and SYSTEM_NAME like '%SYSTEM_%' and do the … Re: Having Trouble Understanding Why This PHP Function Is Not Working 11 Years Ago by veedeoo Hi, This class is a DB connector class.. you still have to provide the query for it to work.. I just want to let you know that **OCIPlogon** alias has been [deprecated](http://php.net/manual/en/function.ociplogon.php). Use oci_pconnect instead. Re: Having Trouble Understanding Why This PHP Function Is Not Working 11 Years Ago by veedeoo Here is an [example ](http://php.net/manual/en/function.oci-pconnect.php)of an oracle connector with persistent connection and with query included .