[PHP-DB] OCIBindByName pass-by-reference

2003-09-17 Thread Laurent Drouet
Hi, My Php Version is 4.3.1 When I use ocibindbyname like below OCIBindByName($stmt,:nb_lines_matched, $nblignes, 32) I receive the following message : [Tue Sep 16 13:43:01 2003] [error] PHP Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would

[PHP-DB] Re: Why varying functionality across php db apis for db metadata?

2003-09-17 Thread pete M
Mike Klein wrote: For example, php mysql library supports list_dbs and list_tables commands as well as getting table metadata. MySQL sql also 'natively' supports these commands (show databases, show tables, describe tableName). Why not similar commands for Oracle, SQLServer, etc.? These are simply

[PHP-DB] Re: ADO Connection Problems

2003-09-17 Thread pete M
Why are you using COM - haveyou looked at PEAR DB - this is class that makes conencting ot various DB's easy in php http://pear.php.net/manual/en/package.database.php Joe Mack wrote: I am having problems making things happen in a Microsoft Access Database that I am connecting to through an ADO

[PHP-DB] 'while' not picking up on first DB record

2003-09-17 Thread Roger Spears
Hello, Can anyone from the lists please tell me why this bit of code is not picking up on the first record in the database? If the 'id' I'm looking for is '1' it doesn't populate the _SESSION variables. Any 'id' greater then '1' will populate the _SESSION variables. $q = SELECT * FROM

[PHP-DB] Re: [PHP] 'while' not picking up on first DB record

2003-09-17 Thread Miles Thompson
Please don't cross-post. See below - M. At 10:17 AM 9/17/2003 -0400, Roger Spears wrote: Hello, Can anyone from the lists please tell me why this bit of code is not picking up on the first record in the database? If the 'id' I'm looking for is '1' it doesn't populate the _SESSION variables.

[PHP-DB] SOLVED= 'while' not picking up on first DB record

2003-09-17 Thread Roger Spears
I'm sorry for the double post. Other then letting both lists know this was solved, it won't happen again. Sorry. Thank you for the solution! I new it was simple. I've been staring at it too long. Fresh eyes always helps! Thanks again, Roger You are making the fetch twice, and not using

[PHP-DB] Passing variables between html forms and updating sql table

2003-09-17 Thread David
Dear all I am putting together some pages where I will be able to update mysql database using php pages. I am having a problem with updating. I put a record into textboxes and when I press submit it passes the values to the next page. The problem I am having is updating the values. Here is my

[PHP-DB] Re: Help connecting with oracle

2003-09-17 Thread Philippe Saladin
Sergio Barreira [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Hi: I have a Oracle 7.3.3 on Unix, but in my computer (client) Windows 2000 i have a php source code that try to connect with this database. I test with TNSPING and SQLPLUS commands line, and connect

Re: [PHP-DB] Re: Connect to Oracle DB

2003-09-17 Thread Philippe Saladin
Roy A Jones [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] I just wanted to add my two cents ... (snip) I have compiled php with BOTH --with-oracle and --with-oci8. It is usually preferred to have your architectures/systems separate to prevent some performance issues. As a

Re: [PHP-DB] Passing variables between html forms and updating sql table

2003-09-17 Thread Jason Wong
On Wednesday 17 September 2003 22:34, David wrote: I am putting together some pages where I will be able to update mysql database using php pages. I am having a problem with updating. I put a record into textboxes and when I press submit it passes the values to the next page. The problem I am

Re: [PHP-DB] Re: Why varying functionality across php db apis for db metadata?

2003-09-17 Thread Jason Wong
On Wednesday 17 September 2003 18:46, pete M wrote: Mike Klein wrote: For example, php mysql library supports list_dbs and list_tables commands as well as getting table metadata. MySQL sql also 'natively' supports these commands (show databases, show tables, describe tableName). Why not

Re: [PHP-DB] Passing variables between html forms and updating sql table

2003-09-17 Thread David
Dear Jason Here is my original problem below as I am treated as spam. When it reaches the next page, when the update query is run, it does not update the database. Regards David Anagram Systems http://www.anagram-sys.co.uk/ http://www.web-planets.com/davec/techsitedb/ Dear all I am putting

Re: [PHP-DB] Passing variables between html forms and updating sql table

2003-09-17 Thread Jason Wong
On Wednesday 17 September 2003 23:42, David wrote: Here is my original problem below as I am treated as spam. When it reaches the next page, when the update query is run, it does not update the database. *sigh* Could you please describe *exactly* what happens. Eg does your error messages

Re: [PHP-DB] Passing variables between html forms and updating sql table

2003-09-17 Thread David
Dear Jason I need a secure way of updating mysql on the website, phpadmin is not secure enough So I have created these pages in order: A page to choose the databases Next a page to choose the table Next a list of the records in the table Next to edit the page using textboxes and textareas I pass

Re: [PHP-DB] Passing variables between html forms and updating sql table

2003-09-17 Thread Jason Wong
On Thursday 18 September 2003 01:03, David wrote: I need a secure way of updating mysql on the website, phpadmin is not secure enough Why is phpadmin not secure enough? Or to put it another way, what are you doing differently that makes it more secure than php admin? So I have created

RE: [PHP-DB] Passing variables between html forms and updating sql table

2003-09-17 Thread Jennifer Goodie
I need a secure way of updating mysql on the website, phpadmin is not secure enough [snip] $MySQLLink = mysql_pconnect (davecp4, root, ) or die(Could not attach to database. Please try later or contact [EMAIL PROTECTED]); Please tell me you just took the password out of that for

Re: [PHP-DB] Re: Why varying functionality across php db apis for db metadata?

2003-09-17 Thread Mike Klein
Jason Wong wrote: On Wednesday 17 September 2003 18:46, pete M wrote: Mike Klein wrote: For example, php mysql library supports list_dbs and list_tables commands as well as getting table metadata. MySQL sql also 'natively' supports these commands (show databases, show tables, describe

[PHP-DB] Cannot open any more tables error

2003-09-17 Thread Joe Mack
I am gettting this error using ADO to work on a MS Access 2000 DB using PHP. My code is attached. The thing that is confusing me -- I am getting the error on the very first recordset I try to open (line 13). Any assistance would be greatly appreciated. Thanks in advance. Joe begin 666

[PHP-DB] Free php-based mysql browser/query tool available for download...

2003-09-17 Thread Mike Klein
Sorry it's for mysql only...but this merely reflects the current state of php's database support...especially regarding functions for retrieving database metadata. Current support is for pointclick browsing and simple queries. I will be adding support for joins, calculated columns, and more in