Here are some things you could try.
Remove all the "@" suppressions and make sure error_reporting = E_ALL
and display_errors = On are set in your php.ini.
Echo the SQL statement inside SQLInsertLob() to make sure it is
constructed OK.
Echo the filename to check it includes the appropriate path. If
hi all,
i have a problem in saving a blob file into oracle database
the system is linux 7.3 oracle 9i apache and php things are working pretty
well in other machine (same php source code) but in my machine it gives this
error
savefile():OCILobWrite : OCI_INVALID_HANDLE.
this is the php:
$oci->
m: "JeRRy" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, March 16, 2004 1:27 PM
> Subject: Re: [PHP-DB] BLOB
>
> > Whoa, watch what your saying here because your well
> > off the ball here. For everyone else who is not aware
> >
From: "JeRRy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 16, 2004 1:27 PM
Subject: Re: [PHP-DB] BLOB
>
> Whoa, watch what your saying here because your well
> off the ball here. For everyone else who is not aware
> BLOB is zilch security
From: "Ng Hwee Hwee" <[EMAIL PROTECTED]>
To: "DBList" <[EMAIL PROTECTED]>
Date: Mon, 15 Mar 2004 17:24:31 +0800
Subject: Re: [PHP-DB] BLOB
hi all,
Hi ;)
with blob, i can't see the encoded password easily and
thus there is
'maximum security&
On Monday 15 March 2004 17:24, Ng Hwee Hwee wrote:
Use md5.
> I can't use md5 because i want to retrieve it and send emails to my users
> if they forgot their password..
If they forget their password shoot them. Or depending on how secure your
application needs to be:
- generate a new passwor
l Message -
From: "Marcjon Louwersheimer" <[EMAIL PROTECTED]>
To: "Ng Hwee Hwee" <[EMAIL PROTECTED]>
Sent: Monday, March 15, 2004 4:38 PM
Subject: Re: [PHP-DB] BLOB
> Store the passwords using the md5() function. When inserting the password
> into the dat
ED]>
Date: Mon, 15 Mar 2004 09:18:50 +0800
Subject: Re: [PHP-DB] BLOB
hi all..
thank you so much for your help!
i tried out the all the different syntax and the
following works
perfectly
SELECT * FROM `MEMBER` WHERE `PASSWD` = ""
thanx, amanda!
btw, i was trying to store the
Why would blob be any more secure than anything else? If encryption isn't
enough, you're not using the right encryption. :)
-Micah
On Sunday 14 March 2004 05:18 pm, Ng Hwee Hwee wrote:
> hi all..
>
> thank you so much for your help!
>
> i tried out the all the different syntax and the following
hi all..
thank you so much for your help!
i tried out the all the different syntax and the following works perfectly
SELECT * FROM `MEMBER` WHERE `PASSWD` = ""
thanx, amanda!
btw, i was trying to store the encryted password in the database but i do
not want anyone who has the right to see the
OTECTED]>
Sent: Friday, March 12, 2004 4:39 AM
Subject: [PHP-DB] BLOB
Hi all,
how do i find out if a BLOB field in my table is NULL?
i tried:
SELECT * FROM `MEMBER` WHERE `PASSWD` is NULL
however, although there is one entry in my table that has nothing in my
PASSWD field, the result se
Hi all,
how do i find out if a BLOB field in my table is NULL?
i tried:
SELECT * FROM `MEMBER` WHERE `PASSWD` is NULL
however, although there is one entry in my table that has nothing in my PASSWD field,
the result set is empty.. how come?
how do i search for entries that has password = [BLOB
Hi,
Using PHP 4.2.2 with Oracle 8. Can someone provide the code for reading a
BLOB from a Oracle database? I cannot find it anywhere in the archives.
Thank you.
Patrick Cossette
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/uns
Thxalot!
I didn't thought it would be that easy *g*
- matthias st.
John W. Holmes <[EMAIL PROTECTED]> [EMAIL PROTECTED] 14:12 Uhr:
>> Does anybody know a good reference, where I can lern how to insert
> binary
>> data (e.g. Images) into a BLOB-Field of a MySQL-Database?
>
> Use fopen() to op
> Does anybody know a good reference, where I can lern how to insert
binary
> data (e.g. Images) into a BLOB-Field of a MySQL-Database?
Use fopen() to open the image, fread() it into a variable, and insert
that variable like you would any other one. If the image is coming from
an element, then yo
Hi everybody out there!
Does anybody know a good reference, where I can lern how to insert binary
data (e.g. Images) into a BLOB-Field of a MySQL-Database?
Any help would be warmely appreciated
- Matthias St.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://ww
Hi everybody out there!
Does anybody know a good reference, where I can lern how to insert binary
data (e.g. Images) into a BLOB-Field of a MySQL-Database?
Any help would be warmely appreciated
- Matthias St.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://ww
> I want to be able to load PDFs into mysql DB, but I'm not very familiar
with
> the blob data type?
> Can someone point me on the right direction how to do this?
Use fopen() in binary mode and fread() to read the file into a string, then
insert it into the
database as you would any other variable
ROTECTED]>
Sent: Tuesday, January 07, 2003 10:17 PM
Subject: [PHP-DB] blob
> Hi to all,
> I want to be able to load PDFs into mysql DB, but I'm not very familiar
with
> the blob data type?
> Can someone point me on the right direction how to do this?
>
> Thanks in advance
Hi to all,
I want to be able to load PDFs into mysql DB, but I'm not very familiar with
the blob data type?
Can someone point me on the right direction how to do this?
Thanks in advance
Nato
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Go to www.php.net and type in the name of your database (mysql,
postgres, oracle, mssql) in the search box. That will give you a list of
all the functions available. Getting a blob is generally the same as
getting any other data type. Here's the paradigm:
1. connect to the database
2. execute
Hi everyone,
I am new to php.
I have searched the net trying to find a basic code snippet that will
demonstrate how to download BLOB's from a database. I am not looking for a
solution exactly, but rather a good starting point. I want to learn this on
my own. Maybe with a little help. :)
Is there a
On Tue, 02 Jul 2002 12:57:56 +0200
Michael Bretterklieber <[EMAIL PROTECTED]> wrote:
> Hi,
>
> one point that you should keeped in mind is, if you have a cluster of
> webservers connecting to the same db-server, then you have to mount the
> filesystems, where you store the images on all webser
Hi,
one point that you should keeped in mind is, if you have a cluster of
webservers connecting to the same db-server, then you have to mount the
filesystems, where you store the images on all webservers.
On the other hand many db's like oracle have many restrictions with
lobs. In oracle you
On Tue, 2 Jul 2002 05:45:40 +0200
"Andy" <[EMAIL PROTECTED]> wrote:
> is the increase of the network traffic noticable? The query is pretty small
> just text. Do u really think this might increase the traffic?
Try to heavely charge a DB with images inside it.
Do the same without DB, that depends
is the increase of the network traffic noticable? The query is pretty small
just text. Do u really think this might increase the traffic?
I also noticed that the image is not cached anymore. Is this true for all
blobs, or do I just access them in a wron way?
(I am requesting a php file in the sc
MAIL PROTECTED]
Subject: Re: [PHP-DB] blob versus file
On Mon, 1 Jul 2002 14:17:53 +0200
"andy" <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I am wondering if anybody has experiance in saving images to blob in mysql.
>
> I do save images with 1 K and 4 KB to blob f
On Mon, 1 Jul 2002 14:17:53 +0200
"andy" <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I am wondering if anybody has experiance in saving images to blob in mysql.
>
> I do save images with 1 K and 4 KB to blob fields while I used to save them
> to file. It seams to me that this is much slower acce
Hi there,
I am wondering if anybody has experiance in saving images to blob in mysql.
I do save images with 1 K and 4 KB to blob fields while I used to save them
to file. It seams to me that this is much slower accessing the files. The
images take a bit (really short but absolutly noticable) to
Blob or link?
Insert just the link is the better way?
Does the security is the same?
Thanks,
Anderson Sone
> No things of all
>
> Only upload the file, move to the right location and insert the file link
> (location path) into the database.
>
> READY!
>
> Bey,
> Daniel Kieviet
> Xsarus Inter
Hi php+postgres users,
How do I define a BLOB data type in postgres? My php
script gets binary data such as image and executables
and I want to store it into the database but I couldnt
find a BLOB data type in postgres. Any hints?
Thanks.
Omar
_
31 matches
Mail list logo
