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
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
i think this is the right sintax:
SELECT * FROM `MEMBER` WHERE ISNULL(`PASSWD`)
Passwd is a blob, that is an interesting name for a blob field, what are you
planing to do?
- Original Message -
From: "Ng Hwee Hwee" <[EMAIL PROTECTED]>
To: "DBList" <[EMAIL PROTECTED]>
Sent: Friday, March 1
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
> 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
Keep in mind that BLOB is up to 64k thus you may need larger BLOB.
Look at the mysql's documenations for more information
http://www.mysql.com/doc/en/
Andrey
P.S.
Have a nice night.
- Original Message -
From: "Natividad Castro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday,
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
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
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
20 matches
Mail list logo