[PHP-DB] Re: [PHP] PHP and Oracle

On Mon, Mar 25, 2002 at 02:49:07PM -0500, Scarbrough, Jeb (ISS Atlanta) wrote: Is it possible to create a transaction the involves multiple pages using PHP and oracle. For example, can I log onto oracle using OCIPLogon on one page named master, insert information, go to the next page

[PHP-DB] variation on(Speed Up Code?)

Hi all, One of the pages in my site takes up to 10 seconds to display (depending on number of records (30 records takes 10 secs). The cause of the problem is the amount of information I am displaying for each record. I do multiple queries for each record to find out different things such as its

Re: [PHP-DB] variation on(Speed Up Code?)

Do some profiling. Use PEAR's Timer class or just add here and there some echo microtime(). Find where is spent most of the time. If it is in the queries than look at your db and find out whether you missed to add some index. If indexes are ok, try to make joined queries (for mysql - LEFT JOIN

[PHP-DB] Re: If else Question

Maybe I am missing something but it seems you are doing things in a potentially unreliable way. Firstly... your sql statement in create.php $query_update = INSERT INTO pets (uid) SELECT uid FROM users WHERE uid={$session[uid]}; could simply be mysql_query(INSERT INTO pets SET uid = .

[PHP-DB] mssql cursor fetching

Is it possible to fetch the scroll cursor from microsoft sql server 2000 to the PHP installed at Linux box? I tried even enclosing the cursor to the stored procedure with no effect. My setup is: apache 1.3.19, mod_php 4.0.6, freetds 0.53 without configuration, glibc 2.2.4, kernel 2.4.17 Thanks a

[PHP-DB] ODBC and images

Hi, I'm working with PHP and ODBC to get images stored in a database (Blob fields). But I experiment little problems to display these pics. Has anyone any information about PHP/ODBC/images ? Thanks, Bilbo

[PHP-DB] Re: Mssql trusted connections ?

On Mon, 11 Mar 2002 13:36:33 +1100, Terry Kearns [EMAIL PROTECTED] wrote: How does one use trusted connections with mssql_connect() ? Also, the manual says something about an interfaces file. Where do I find this? Where is this interfaces file documented? seems like 'interfaces' mentioned is

[PHP-DB] PHP/Access problem

Hi, I'm working on a small Access 2000-based project and I'm getting a SQL Error . This is the query (built in PHP): SELECT * FROM 'Documents'WHERE (CourseRef='4712' AND Valid_From=#26/03/2002# AND Valid_Until=#26/03/2002#) Order by Author,Title Any clues or pointers? George -- PHP

RE: [PHP-DB] procedures?

I suggest subscribing to the mysql mailing list and asking the question. [EMAIL PROTECTED] -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 7:47 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] procedures? Hi there, Where can I find information

[PHP-DB] Re: ODBC and images

Although this article is more geared towards MySQL, the principles should apply to ODBC, and you should be able to translate the MySQL functions to ODBC functions rather easily. http://www.phpbuilder.com/columns/florian19991014.php3 David Juras wrote: Hi, I'm working with PHP and ODBC

RE: [PHP-DB] Re: ODBC and images

Bilbo, Also, if you could provide your code that might help. I'd guess you are having some problem with the data types and your driver as well; that info would be helpful to assist. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm

[PHP-DB] Build problem oci8

I have a problem building php with oci8. My environment: AIX 4.3 / PHP 4.1.2 / Oracle 8.1.6 Using standard AIX cc compiler Building cgi version of php Configure: ./configure \ --enable-force-cgi-redirect \ --enable-discard-path \

[PHP-DB] ANN :: QuB :: DHTML/PHP Visual Query Builder Released

InterAKT released the 1.0 version of QuB, the visual query builder for Ultradev (with PHAkt or ImpAKT). QuB is also available as a PHP/DHTML standalone version. QuB is an DHTML Query Builder designed to improve the way web developers create and use queries when creating dynamic PHP websites.

[PHP-DB] Newbie? - help inserting into firebird1.0

hi. i'm running: php4, firebird 1.0, and IIS all on win2k. i'm just getting started with php and firebird, so please forgive me if the error is obvious. i hunted around for examples, the best of which i've found btw is at http://www.ibphoenix.com/ibp_howto1.html - thought i did this right, i

Re: [PHP-DB] ODBC -- Setting ApplicationID

I think that work-around may work for me. Since I can declare a different environment variable for the PHP script, with a new alias, that should work fine. Thanks for the suggestion. - Bruce Andrew Hill wrote: Bruce, It looks like you were on the right track initially, the problem is

[PHP-DB] Re: Newbie? - help inserting into firebird1.0

Hi Jon-David, not sure that this is the only problem, but rewrite your query like this (single quotes araound the values): $query=insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, EXPECTED,

RE: [PHP-DB] Re: Newbie? - help inserting into firebird1.0

you're right Lutz, that is not my only problem- turns out this statement is wrought with errors :| i should not have been referring to those values as variables...stupid lamer mistake, just the name works...also, changed the double quotes to single quotes, per Lutz's suggestion, and that worked

Re: [PHP-DB] Re: Newbie? - help inserting into firebird1.0

if APP_VERSION is defined as decimal you can not insert a string. So leaving away the quotes around $numVersion should bring you closer. Lutz [EMAIL PROTECTED] (Jon-David Schlough) writes: you're right Lutz, that is not my only problem- turns out this statement is wrought with errors :| i

[PHP-DB] Re: PHP/Access problem

SELECT * FROM 'Documents'WHERE (CourseRef='4712' AND Valid_From=#26/03/2002# AND Valid_Until=#26/03/2002#) Order by Author,Title should be SELECT * FROM Documents WHERE (CourseRef='4712' AND Valid_From=#26/03/2002# AND Valid_Until=#26/03/2002#) Order by Author,Title your table name should

[PHP-DB] how to get consistent UTC from gmmktime (w/o dst-offset) ????

hi. i'm storing events in a mysql-db, using epoch timestamps to pinpoint the exact date/time for an event. so far, I have been using localtime, being aware that there are inconsistencies in the number of epoch-seconds, when DST flips on and off. nevertheless, that works fine as long as you

Re: [PHP-DB] how to get consistent UTC from gmmktime (w/o dst-offset) ????

BTW for all who are following this, Patrick has cleverly illustrated that most of the northern hemisphere locations where summer time is observed will 'spring forward' this weekend. Most of the southern hemisphere locations that were in summer time did their 'fall back' last weekend! NB the two

[PHP-DB] Contact Database php_mysql

I am contemplating a Historical Database I barely can spel redundant let alone normalize so I am handicapped. The aim is to enter a name only once. I am studying linking tables. In the [Contact] idContact First_Name,Last_Name,Middle,Suffix,Full_Name,idCity,idState,City_State,i dZip_Code,

[PHP-DB] Re: Contact Database php_mysql

Normalization depends on how the data will be used. For instance in the contacts database you want to enter a name only once. What you have looks fine but it makes an assumption: Each address has only one contact and each contact only one address. I'm not sure why you want City, State and Zip

Re: [PHP-DB] procedures?

From MySQL.com documentation: Our aim is to have stored procedures implemented in MySQL Server 4.1. I think it's in beta but not sure if that feature is implemented now. I'm using stable versions 3.x.x. Glenn Rick Emery [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL

Re: [PHP-DB] Contact Database php_mysql

Not so sure you need to go to that much detail in the linking of your tables. It's a good idea for the states, but the zip is usually just an integer anyway, so you can just store that with the record. Next, do you really need Full_Name??? You can extract that from the other two fields. As