[PHP-DB] using foreign keys in mysql

hello! could anyone help me out in how to link two tables in mysql on foreign keys or is there any other way to do this in order to check referential integerity. any +ve response would be appreciated. msjamal __ Get personalized email addresses from

Re: [PHP-DB] Remote Oracle Connection

Hi Doug, This works for me.. putenv("ORACLE_SID=MYINSTANCE"); $uid = "MYUSERID"; $pwd = "MYUSERPASSWD"; $inst = "MYINSTANCE"; $conn = ocilogon($uid,$pwd,"$inst"); if(!$conn): echo "unable to connect to database"; ocilogoff($conn); endif; $query= "alter session set NLS_DATE_FORMAT = 'DD-MON-Y

Re: [PHP-DB] db2 with php

> I've installed db2 and created the default instance at /home/db2inst1/. > PHP is compiled with the --with-ibm-db2 option, however when I try to start > apache I get the message: "Cannot load /etc/httpd/modules/libphp4.so into > server: libdb2.so.1: cannot open shared object file: No such file o

[PHP-DB] Installation Problem

Hello, I downloaded the source of php 4.0.4pl1 and compiled it on RH7.0 with mysql server 3.23.32. The compilation was a success. However, the httpd wouldnt start. It says: cannot load libphp4.so: undefined symbol: gss_mech_krb5 I assume that it was the kerberos problem, so I recompiled it with --

[PHP-DB] Pbs with Oracle

Hi everybody, Still with the same configuration (Apache1.3.14 + PHP4.04pl1 + support for Oracle 8.0.5 with OCI, all on HP-UX 11), I manage to connect to my base (ocilogon, ociparse and ociexecute). After that, whenever I try to get the results, it prints well the column name but not the data. I t

[PHP-DB] PHP-Authenticate (again!)

Hi... I have a problem with PHP Authenticate ...if I enter user/pw wrong the first time it stops and I have to close/open browser.! I've tried to unset $PHP_AUTH_USER but then it just loops... if(!isset($PHP_AUTH_USER)) { Header("WWW-Authenticate: Basic realm=\".: Privat område :.\"");

Re: [PHP-DB] mysql to pgsql

create table foobar (todaysdate datetime default now()); jeff On Sun, 4 Feb 2001, phobo wrote: > Never used pgsql; but try DEFAULT NOW() NOT NULL ?? > > Siggy > > - Original Message - > From: "Cameron" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, February 04, 2001 5:

[PHP-DB] Copy table to file inside PHP

Hi PHP Gurus ! Anyone have idea to copy table to file from the web? >From the unix shell we can do : COPY table_name TO '/home/someone/table_name.dat' ; I tried inside PHP $con=pg_connect("","","","",dbname); $result=pg_exec($con,"COPY table_name TO '/home/someone/table_name.dat'"); pg_close($

[PHP-DB] Make good money online! It's easy ....

Please see the bottom of the message for the remove instuctions. What you are about to read is tried, true, proven and effective. Above all, this offer is utterly and ridicously excellent!! Have you ever tried or considered making money using the internet? Are you marketing or promoting a

Re: [PHP-DB] Copy table to file inside PHP

What is the error you get? To do the Copy you need to specify a userid in your pg_connect like $conn = pg_connect ("host=localhost port=5432 user=userid dbname=dbname"); That should take care of it. It did for me! At 12:02 AM 2/6/01 +0900, Achmad Gutomo wrote: >Hi PHP Gurus ! > >Anyone have id

Re: [PHP-DB] Copy table to file inside PHP

The userid needs to be your DB Super User (ie allowed to create db's) At 11:15 AM 2/5/01 -0500, Brian C. Doyle wrote: >What is the error you get? > >To do the Copy you need to specify a userid in your pg_connect like >$conn = pg_connect ("host=localhost port=5432 user=userid dbname=dbname"); > >T

[PHP-DB] Lowercase problem

Hi-- I don't know where the problem resides, but when I call a table or a field name from Postgresql using PHP4, it treats the string ALL LOWERCASE, so I get an error about 'field/table not relational..." do you know where the problem is? P.S. Some tables have upper and lowercase, as well as

[PHP-DB] Re: [PHP] Lowercase problem

You need to put quotes around the upper- or mixed-case table names. SELECT * FROM "MixedCase" Of course within PHP, you need to escape those quotes: $query = "SELECT * FROM \"MixedCase\""; -Dan > Hi-- > > I don't know where the problem resides, but when I call a table or a field > name from P

[PHP-DB] Re: [PHP] Lowercase problem

Try quoting your table names. SELECT * FROM "WHATEVER"; -Mitch - Original Message - From: "Julio Cuz, Jr." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 12:25 PM Subject: [PHP] Lowercase problem > Hi-- > > I don't know where the probl

[PHP-DB] --with-Oracle caused apache to not load

If I compile php using --with-oracle and --with-apxs and try to load that module apache seg faults on loadup. Compiling php without oracle works fine. Compiling php with oracle and as a CGI works fine. I'm running Oracle 8.1.5, php4.0.4pl1 and apache 1.3.14 under RH6.2 Any ideas? Mark -- "Th

Re: [PHP-DB] using foreign keys in mysql

the current production rev of mySQL does not support foreign keys. so, you have to implement it in your application logic. i think they are working on foriegn key support for a future release, but i am not sure. -lucas On Mon, 5 Feb 2001, sajid jamal wrote: > hello! > could anyone help me out i

Re: [PHP-DB] Quickie Question

First, check your indexes.. second, check your queries on your display list to make sure you are only selecting data that is needed. I recently ran across a problem where queries on a long list were taking forever to execute. I was selecting * from the table thinking that I was using all the data

[PHP-DB] How to set up PHP to access Oracle

Fatal error: Call to undefined function: ora_logon() Obviously my server is not set up to use Oracle. Oracle is not installed on this machine. I am trying to access a different machine that has oracle installed. So what steps do I have to take to turn Oracle access on? My problem is that another

[PHP-DB] php to mysql probs.

I'm using PHP (v4.0.4) as a web front end for a MySQL (v3.23.29) database running on Windows 2000 machine. The problem is that I am relatively new (I've been messing with this for only a month) to this and don't really know where to look for information on the connection problems-- the web wil

Re: [PHP-DB] How to set up PHP to access Oracle

On Mon, 5 Feb 2001, Doug Schasteen wrote: > Fatal error: Call to undefined function: ora_logon() > > Obviously my server is not set up to use Oracle. Oracle is not installed on > this machine. I am trying to access a different machine that has oracle > installed. So what steps do I have to take

Re: [PHP-DB] RESEND - php class to C struct interface possible?

Maybe if you build a PHP module... info available at zend.com --Toby Phil Rhoades wrote: > > Hi all, > > Thought I would try sending this again - didn't get a reply last time - > guess I'll give up if this attempt doesn't get a reply . . > > I've just subscribed and haven't even got any mail

[PHP-DB] freeBSD4.2+Interbase6.0+php4.0.4 Possible ??

Hi Is it possible to configure PHP 4.0.4 on FreeBSD serwer ver 4.2. with linux support with command with InterBase 6.0 (any) ./configure --with-interbase=/path/to/ibase --with-apache=/patch/to apache ? /Semko Doktór -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EM

[PHP-DB] PHP, MySQL and XML

Does anyone have a solution for importing data from a RDF-XML file into a MySQL database? I've been racking my brain, as well as looking at tutorials and some xml parsers, but if someone has something like this it would save me tons of time. Thanks! -- PHP Database Mailing List (http://www.ph

[PHP-DB] using ID

When i make a table with four field (id, name, username, and password) what do i do with the i id, how do i make it assign to each password? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

[PHP-DB] pgsql performance

whilst i know that mysql is generally faster than pgsql i just tried to convert another of my mysql projects to pgsql, in mysql the list takes about 1 second (SELECT * FROM email LIMIT 0,300 on 18 records), the same query in pgsql is taking around 5 seconds, i know i have tweaked mysql a littl

Re: [PHP-DB] newbie question

Thanks Victor, I guess I have to change the extension to .html. How about http://www.blablabla.com/blabla ? Can all search engines index it ? Thanks, Lisa E - Original Message - From: Victor Foitzik <[EMAIL PROTECTED]> To: Lisa Elita <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday,