Re: [PHP-DB] Re: ORA-01460 error when useing bind sql on oracle from php

Using OCIBindByName($stmt,$bindname,${bindval$ci},-1); probably gives a warning that call-time pass-by-reference has been deprecated. The OCIBindByName manual entry at http://www.php.net/manual/en/function.ocibindbyname.php has a user comment from alexander dot zimmer at gmx dot at that this

[PHP-DB] Problem with PHP_AUTH_USER

Hi! Here is the problem: How can I unset the $PHP_AUTH_USER when the user clicks logout? The authentication works very well except the log out. I tried: session_destroy(); unset($_SERVER['PHP_AUTH_USER']) and in the next line I did: print $PHP_AUTH_USER; and the

[PHP-DB] Re: Dreamweaver as PHP editor

Susi Sloan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I'm just getting into PHP, and have found that as a PHP code editor, Dreamweaver works pretty well (with the extension I installed). My question is this, whenever I save an include file with the .inc extension, all of the

[PHP-DB] Another question

Is there a php function that closes a browser window? I know there is a javascript function (window.close), but I can't use it because it complains that the window is not opened by javascript (window.open). I looked over the function reference but I didn't find anything about this problem. TIA

RE: [PHP-DB] Another question

I think no. IMHO PHP can't have effect on user's programs. If I'm not right correct me. But window.close can close window opened not by javascript. It just ask user is he want to close or no. Mike U. Petrov PHP-programmer. -Original Message- From: Constantin Brinzoi [mailto:[EMAIL

Re: [PHP-DB] Informix - help!

El Dom 14 Dic 2003 19:00, Daniel Crespo escribió: I have red hat linux with Apache web server and PHP. I want to connect, using PHP, to an Informix Database remotely. What is all I have to do on my side? Thanks a lot Install informix client libraries where php will go and compile using

RE: [PHP-DB] Another question

You can avoid the prompt when using javascript to close the window if you use this: function closeit(){ window.opener = top; window.close(); } Now, window will close without prompting. hth, Duane -Original Message- From: Constantin Brinzoi [mailto:[EMAIL PROTECTED]

Re: [PHP-DB] Another question

Really? What is the reason for that?... Muhammed. - Original Message - From: Duane Lakoduk [EMAIL PROTECTED] To: 'Constantin Brinzoi' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, December 15, 2003 3:17 PM Subject: RE: [PHP-DB] Another question You can avoid the prompt when

RE: [PHP-DB] Another question

I've tried to use this function, but it doesn't work on IE 5.0 On Opera 7.21 it works. So on what browser you've tested it? Mike U. Petrov -Original Message- From: Duane Lakoduk [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 4:18 PM To: 'Constantin Brinzoi'; [EMAIL PROTECTED]

RE: [PHP-DB] Another question

In I.E. 5.5 and newer. -Original Message- From: Mike U. Petrov [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 7:32 AM To: [EMAIL PROTECTED]; 'Constantin Brinzoi'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Another question I've tried to use this function, but it doesn't

RE: [PHP-DB] Another question

This works because you have assigned a name to the .opener property which is blank when you open a browser without script. Script is now satisfied that window was opened by script. -Original Message- From: Muhammed Mamedov [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 7:26

Re: [PHP-DB] Another question

Could you provide the code you use for destroying your session? Because if you destroy it session_unregister($session_name) then no need for browser closing. But if you don't destroy it, then it will be destroyed automatically after you close the browser.. this is how PHP works. Regards,

Re: [PHP-DB] Another question

I destroy the session with: session_destroy() The file is deleted from the /tmp directory (which is good) but after that I want to go on another page (public space) and get rid of PHP_AUTH_USER and PHP_AUTH_PW. How can I do it? On Mon, 2003-12-15 at 16:10, Muhammed Mamedov wrote: Could

Re: [PHP-DB] Another question

I see. You use something like this right? header('WWW-Authenticate: Basic realm=My Realm'); header('HTTP/1.0 401 Unauthorized'); and of course want to get rid of PHP_AUTH_USER and PHP_AUTH_PW variables which are then return. Well..this is something different than the session. If you look at

[PHP-DB] Re: php mail() question

Hello, On 12/14/2003 11:51 PM, Jerry wrote: Php mail() question. I use php mail() frequently, dragging data from a mysql database. I am not sure if this is possible but thought I'd throw it on this board. in php mail() function you can set a return_address etc. Is it possible to change this

[PHP-DB] CREATE TABLE LIKE, error

I cannot use this query CREATE TABLE table LIKE other_table; , which is supposed to create an empty clone of the other_table named table. Was it added in some later MySQL version? It's in the manual on mysql.com, bo no version info available. -- Seks,

RE: [PHP-DB] CREATE TABLE LIKE, error

Try: CREATE table new_table SELECT * from old_table limit 1; delete from new_table; This will give you the same structure in both tables, and the deletion will make the new_table empty. -Original Message- From: Adam i Agnieszka Gasiorowski FNORD [mailto:[EMAIL PROTECTED] Sent:

Re: [PHP-DB] CREATE TABLE LIKE, error

From: Adam i Agnieszka Gasiorowski FNORD [EMAIL PROTECTED] I cannot use this query CREATE TABLE table LIKE other_table; , which is supposed to create an empty clone of the other_table named table. Was it added in some later MySQL version? It's in the manual on mysql.com, bo no version

Re: [PHP-DB] CREATE TABLE LIKE, error

From: Gary Every [EMAIL PROTECTED] Try: CREATE table new_table SELECT * from old_table limit 1; delete from new_table; This will give you the same structure in both tables, and the deletion will make the new_table empty. Not quite the same as it will not copy indexes/keys... ---John

Re: [PHP-DB] CREATE TABLE LIKE, error

CPT John W. Holmes wrote: From: Adam i Agnieszka Gasiorowski FNORD [EMAIL PROTECTED] I cannot use this query CREATE TABLE table LIKE other_table; , which is supposed to create an empty clone of the other_table named table. Was it added in some later MySQL version? It's in

[PHP-DB] Finding duplicate values between several tables and appending this to a new table.

Hello, I have a database that has several tables, such as Company Name, Address, Region, Employees. I also have a table that contains similar sort of information as in the first database, but this table has not been properly structured and just contains a a record for each and every employee.

[PHP-DB] sql errors?

I have checked and rechecked my code on these php to mysql statements and for some reason I either get no data (through php, where through a command line I get all the data I need) or errors on the update function. Could someone tell me what I am doing wrong? $sql = mysql_query(SELECT

Re: [PHP-DB] sql errors?

On Mon, Dec 15, 2003 at 03:49:31PM -0700, Jas wrote: $sql = mysql_query(SELECT hostname FROM $table WHERE vlan = $_POST[dhcp_hosts],$db)or die(mysql_error()); Maybe like this? $sql = mysql_query(SELECT hostname FROM $table WHERE vlan = '. $_POST[dhcp_hosts].',$db)or die(mysql_error()); --

[PHP-DB] how to build php_oci8.dll

Hi, I downloaded php binary distribution for windows and installed and made it work with my Apache server. However, after I enabled the php_oci8.dll in php.ini, my Apache server crashed. I guess the library or the header files php_oci8.dll compiled with does not match the ones I have here. May

[PHP-DB] Re: php mail() question

Hi, Thanks for that. That's hitting the nail right on the head. But I need a bit of PHP code to talk to mysql and only read the from part of the email and use a query to check the database if the entry is there. If it is than flag it, if not skip it and delete the email. So would I need to

[PHP-DB] Re: php mail() question

Hello, On 12/15/2003 10:23 PM, Jerry wrote: Thanks for that. That's hitting the nail right on the head. But I need a bit of PHP code to talk to mysql and only read the from part of the email and use a query to check the database if the entry is there. If it is than flag it, if not skip it and

Re: [PHP-DB] Problem with PHP_AUTH_USER

hi, i think $PHP_AUTH_USER will only get unset the next time session_start() is called. try to use a header(location: ...) to direct your logout page to your index page and then print $PHP_AUTH_USER right after session_start().. by right, you should not have any value... i faced the same problem

[PHP-DB] problem: opening a new window, xxx.php

I try to use a button to open a small window, and the small window allows user to insert , change data, which will change the data in the opener too. As the small window requires some access to database(mysql), it takes time and it seems the form in the small window is not created before any

[PHP-DB] Max DB as Database for PHP

Hello, Has anyone tried to connect to MaxDB with PHP ? http://www.mysql.com/products/maxdb/index.html According to what I have read, but not actually tried. PHP can connect to any database, including Microsoft SQL Server and PostgresSQL. However MySQL is not always the right choice.