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:
: 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. The details in a BLOB field
is viewable easy enough
]
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. The details in a BLOB field
is viewable easy enough. Please read about BLOB on
the mysql
+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 encryted password in
the database but i
do
not want
[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 database, use md5($password). It will convert the password to a
encrypted form using one way
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
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,
snip
Hi ;)
snip
with blob, i can't see the encoded password easily and
thus there is
'maximum security'. haha.. but i'm still open to any
form
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
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
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 set is empty.. how come?
how do i search
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 =
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:
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:
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 input type=file
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 open the
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
, 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
Nato
--
PHP Database Mailing List (http://www.php.net
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
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
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 if
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, 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 webservers.
]
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 fields while I used to save them
to file. It seams to me
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
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 accessing the
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
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
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
30 matches
Mail list logo