I installed redahat 6.2,Apache 1.3.12 and php4.0 compiled with OCI8 in
my machine.
I can successfully connect to one remote Oracle8i database using php4.0.
But when I wanted to connect to two separat remote Oracle8i DB,I found
a problem to do that.The problem is that: when I successfully connect
Kirk,
When you upgraded the distribution did it also upgrade PHP?
If so, the PHP upgrade may not have been built with postgres support.
You may have to rebuild PHP from source letting configure know where postgres
is.
Wayne
On Wed, 31 Jan 2001 23:48, Kirk Reiser wrote:
> Hi Folks: I use php3 a
The way you have it now, ur just storing the path to
the gif. from the form field, use
then in the insert area use:
$result = mysql_query("insert into (filename) VALUES
('$file')")
James
--- Yui Hiroaki <[EMAIL PROTECTED]> wrote:
> HI!
>
> I am using PHP in mySQL. I create table in datab
check this out:
http://www.hotscripts.com/Detailed/3903.html
It does what you're asking for...
why write the code when you can copy and paste? :)
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 31, 2001 1:22 PM
To: [EMAIL PROTECTED]; [EMAIL PRO
Fabrice,
You may need to rebuild PHP to get it to look at the newer version of MySQL.
When it was originally built the 3.23.22-beta version of MySQL was probably
what PHP was built against.
If you go into the PHP source directory and do a configure, make and make
install (letting the configure
Good Day all,
A question about persistent connections.
I am using Oracle8i and want to make a little php script that will be run a
huge amount of times (i hope ). PHP has the OCIPLogon for persistent
connections and am wondering the details of how it works.
I want the php script to run a simpl
the way i have attacked a similar situation in the past was to create my
own formatting system - kind of a pseudo-html set-up, which made use of
conventions like;
**bold**
%%italic%%
__underline__
!!titlefont!!
etc etc
then you can save the article directly into the DB, as a text or whatever,
In a database with no more than 100 rows, is it better to have several (a
dozen or so) large column sizes (200-300 bytes), or to have TEXT fields; as
many of the columns can be from null to full-use ... I'm not worried about
diskimprint; only speed ... All look-ups are done on the primarykey, whic
Why bother with pseudo ?
Just only have , , and allowed in the database. Also, storing the
and tags may be important. Be sure not to do things like allowing
font color or face; although relative size might be ok (FONT SIZE="-1") etc.
Siggy
- Original Message -
From: "Beau Lebens" <[E
Hi Netlanders
I have just undertaken a web site construction project. It is a devshed like
site that serves articles on various topics. I am using LAMP -
Linux/Apache/MySQL/PHP 4. I have a table that contains info about each
article. I think I have three options...(or do I have more that I don
He!
It's very simple! When you've a , and want
per example to insert it into the database, use the PHP function nl2br() at
the moment after select and print the data.
So, it will be:
- first insert the $text into the database
- SELECT text FROM XXX et. etc.
- $text = nl2br($text); (PHP inserts
Is there a way that when a user signs up for a
user/pass on a site, to automatically update the
.htpasswd on the site? Right now I'm running a Win2k
Pro, with Apache installed and MySQL/PHP.
Thanks,
James
__
Get personalized email addresses fro
Yes, you can, just write a script to call "htpasswd -b yourUserFile userID
passwd".
:)
David
>From: James Smith <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>Subject: [PHP] .htpasswd?
>Date: Wed, 31 Jan 2001 13:21:35 -0800 (PST)
>
>Is there a way that when a user signs up for
Use nl2br (new line to ).
Mick
On Wed, 31 Jan 2001, James Smith wrote:
> Alright, on my site, I have a news section, whenever i
> goto insert new news in the Admin area, I have to
> insert or /n in it, while typing in the news.
> How do I make this a automated process I know it can
> be done
for the second one you can do a subquery:
select specific_p from where specific_p like '%68030% and
specific_p in (select distinct specific_p from );
this finds all the distinct specific_p fields and then does a query on
them -- that table (remember SQL ONLY returns tables) -- for the like
'%68
I think you could do this.
Load all the data.
Then "delete from table where name != extension"
At 08:01 PM 1/30/01 -0500, Mark @ 10base-t wrote:
>Hey there,
>Can you use the load data infile command to load stuff in only if certain
>fields match? Or would I have to do this via some php loop?
>
Does anybody know how to get sybase-ct support
to work under windows?
I added the extension dll in the php.ini. Then
the libct.dll was missing. The only place
I found it was in an "Open Client" update
at www.sybase.com.
Doesn't Sybase provide the client libs or
do I just don't find them?
--
Tors
add DISTINCT to your query
select distinct specific_p, qty from database where specific_p = 68030 and
qty > 0
For you second requirement, get them all, and just use the first one ...
can't remember exact syntax but something like
select specific_p from database where specific_p like %6803
I meant to say:
There may be other parts that are close too I want to search for %68030% to
get all of them but show only one of each different specific_p.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PRO
I have a database with several fields...
I only want certain fields to show in my results
Some of the searched fields have the same value
example: searched field is specific_p
specific_p comment qty
68030 9845 0
68030 9844 100
68030 9
I am glad to see others working on alternatives to the highly cost Zend products. I
came across PHPub, a PHP IDE/Debugger which I've never seen mentioned on this list.
Even though it is still not ready for final release, it's seems pretty stable. Great
Features. One of it's cool features is a b
Hello, "Tyson Lloyd Thwaites"!
You wrote:
> Is it better to retrieve the whole table up-front and
> store it in a session
> array, or to run the queries seperately each time the
> data is needed and
> specify the column targets?
>
First read all the short columns from the row in your base
cl
Hi Folks: I use php3 as an interface to a postgres database under an
apache server. I have been using this configuration for about a year
and a half. A few weeks ago I had to update my distribution because
of another package I needed to install, and now I get an error in my
php3 scripts. The er
As far as I know this is the latest version of thie client.
Best regards,
Fábio Ottolini
> -Original Message-
> From: Fabrice Houvet [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 31, 2001 6:24 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] How to upgrade MySQL PHP Client
> Impor
Yes sir, you are correct. Thank you for correcting me. In practice, a
NULL in a foreign key almost always means an orphan record. In most
applications the designer will want to use the NOT NULL constraint.
Bob Hall
>A foreign key value can be null, if it suits the data application - or that
>i
A foreign key value can be null, if it suits the data application - or that
is what I've always been taught.
Here is a text book definition of Referential Integrity which was spoon fed
to me by the Open University when studying their RDBMS course:
"Referential Integrity - If a relation (table),
Hello,
I use the latest version of PHP (4.0.4pl1) and the latest stable version of
MySQL (3.23.32) for my Apache Web Site.
I see PHP use the 3.23.22-beta version of MySQL Client API.
Can you explain me how i can upgrade the PHP MySQL Client ? A new PHP
module version does exist ? May be only an
27 matches
Mail list logo