Victor Subervi schrieb:
Hi;
The python code works properly, so I assume this is a strictly MySQL
question now :)
If I grab an image in the database thus:
sql = select pic1 from products where id=' + str(id) + ';
cursor.execute(sql)
pic1 = cursor.fetchall()[0][0].tostring()
#
Victor,
Please give us an example with the python removed and include the
actual syntax error.
-Eric
On Fri, Apr 18, 2008 at 8:41 AM, Victor Subervi [EMAIL PROTECTED] wrote:
Hi;
The python code works properly, so I assume this is a strictly MySQL
question now :)
If I grab an image in
Hi;
The python code works properly, so I assume this is a strictly MySQL
question now :)
If I grab an image in the database thus:
sql = select pic1 from products where id=' + str(id) + ';
cursor.execute(sql)
pic1 = cursor.fetchall()[0][0].tostring()
# pic1 =
Hi;
I´m trying to figure out how to upload images into a MySQL database. (Yes,
that is what I want to do.) I have a form that asks for data, like this:
1ra Foto Pequeña:
input type='file' name='pic1' /
Then I send that form to a python script that processes like this:
cursor.execute('insert
, Mar 28, 2008 at 11:35 AM, Victor Subervi
[EMAIL PROTECTED] wrote:
Hi;
I´m trying to figure out how to upload images into a MySQL database. (Yes,
that is what I want to do.) I have a form that asks for data, like this:
1ra Foto Pequeña:
input type='file' name='pic1' /
Then I send
In the last episode (Mar 28), Victor Subervi said:
Hi;
I'm trying to figure out how to upload images into a MySQL database. (Yes,
that is what I want to do.) I have a form that asks for data, like this:
1ra Foto Pequeña:
input type='file' name='pic1' /
Then I send that form to a python
Hi!
I have seen in this page http://www.blobstreaming.org/ but i think that it´s
quite difficult. I want to put only the url of the image, and as you said
the pictures o images might be in the server folder, but what is the folder?
Thanks.
--
View this message in context:
http
=#{STOCKSOC.imageHyperlink1_action}
binding=#{STOCKSOC.imageHyperlink1} id=imageHyperlink1
imageURL=C:\Documents and
Settings\Ibai
Leizea\Escritorio\gsg\SociedadGastronomica\web\IMAGES\im?imageid=#{currentRow.value['producto.id_prod
://www.nabble.com/file/p13863505/7.jpg
Thank you very much!
*Sorry for my english
--
View this message in context:
http://www.nabble.com/IMAGES-PICTURES-MYSQL-tf4845682.html#a13863505
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives
Hi,
I have read some messages about this topic but i haven´t resolved my
problem
yet. I am using mySQL Query Browser to make de schema. And i have a table
(product) where there are some attributes (producto, precio,
nUds,tipo)(spanish). All are relationated with one product (ex: heineken
beer).
Hello!
I have read that. But i have not idea what i have to do. Because i´m amateur
in this topic.
Thank you
--
View this message in context:
http://www.nabble.com/IMAGES-PICTURES-MYSQL-tf4845682.html#a13865352
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL
.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: puntapari [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 20, 2007 3:38 PM
To: mysql@lists.mysql.com
Subject: Re: IMAGES/PICTURES-MYSQL
Hi
How do I add an image to a database and how do I extract from the
database?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hodren
How are you storing the image in MySQL..I assume longblob?
What format will you use to display the image {jpg|gif|png}?
Here is a script which will load the images to your AS movie
http://www.actionscript.org/forums/showthread.php3?t=76421
HTH/
Martin
This email message and any files
hi to all,
I have a simple question/szenario.
Here are my tables:
1. image (id, name)
2. tag (id, name)
3. images_tags (image_id, tag_id)
At the moment I have the following working query, it selects all images
which have *at least one of the tag ids* (25,30) assigned.
SELECT DISTINCT
Jens Kleikamp schrieb:
hi to all,
I have a simple question/szenario.
Here are my tables:
1. image (id, name)
2. tag (id, name)
3. images_tags (image_id, tag_id)
At the moment I have the following working query, it selects all images
which have *at least one of the tag ids* (25,30) assigned
]
[EMAIL PROTECTED]
#
Rodney Courtis wrote:
Hi
I want to store jpeg images in a mysql database from php in the form of 'blob' types.
Is this possible and can you detail for me the steps to achieve this?
Regards and thanks
Rodney Courtis
--
MySQL General Mailing List
I've stored millions of images/files in mysql with minimal performance
hit, performance loss is mostly based on your storage implementation.
Checkout this article:
http://www.dreamwerx.net/phpforum/?id=1
On 10/11/06, Greg Donald [EMAIL PROTECTED] wrote:
On 10/10/06, Rodney Courtis [EMAIL
Hi
I want to store jpeg images in a mysql database from php in the form of 'blob'
types.
Is this possible and can you detail for me the steps to achieve this?
Regards and thanks
Rodney Courtis
On 10/10/06, Rodney Courtis [EMAIL PROTECTED] wrote:
I want to store jpeg images in a mysql database from php in the form of 'blob'
types.
Is this possible and can you detail for me the steps to achieve this?
For a nice size performance hit, yup:
http://www.zend.com/zend/trick/tricks-sept
I am looking to create a database that holds the location of images on my
server. I was wondering if anyone could help me understand if I am doing it
correctly, and if I either need to add, change or remove something from the
current table code.
img_idINTNOT NULL auto_increment
On Thursday 20 July 2006 07:19 am, Nicholas Vettese wrote:
img_idINTNOT NULL auto_increment PRIMARY KEY,
user_id INTNOT NULL,
location VARCHAR(255) NOT NULL,
imgtype VARCHAR(20) NOT NULL,
img_tag VARCHAR(50) NOT NULL,
img_rate VARCHAR(20) NOT NULL,
good
img_comments
Hello.
A lot of depends on the type of your queries. Find out which of them
make the maximum load on the server and then tune your configuration.
ESV Media GmbH wrote:
Hey,
what do you think is the best configuration ( my.cnf ) for running a
database,
which many users access at the same
Hey,
what do you think is the best configuration ( my.cnf ) for running a
database,
which many users access at the same time ( Website - Portal ).
We´ve also saved our Pictures ( nearly 3.500 rows ) in our database.
Every coloumn is round about 60-70 Kbyte, so i had to use mediumblob
columns.
Hey,
what do you think is the best configuration ( my.cnf ) for running a
database,
which many users access at the same time ( Website - Portal ).
We´ve also saved our Pictures ( nearly 3.500 rows ) in our database.
Every coloumn is round about 60-70 Kbyte, so i had to use mediumblob
columns.
For an PHP example of how to import data getting around
max_packet_size, performance, etc. issues.. Be sure to read this
article.
Also linked from: http://dev.mysql.com/doc/refman/4.1/en/blob.html
Article @ http://php.dreamwerx.net/forums/viewtopic.php?t=6
--
MySQL General Mailing List
For list
Dan Buettner wrote:
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts digital
artwork) stored in SQL databases. Granted we are using Sybase for that
and not MySQL but there are a lot of advantages to it - access
hi ,
I have crerated a mysql database to store images , mp3 , video files..etc. In
my first stage i stored images as jpg , gif .
But when i try to store little but huge gif files it wont store . I used the
script as follows to upload images,
html
head
titleUpload File To MySQL Database
Kane Wilson wrote:
But when i try to store little but huge gif files it wont store .
First of all, use the method described at
http://www.php.net/manual/en/features.file-upload.php for a safe way to
handle file uploads. It could be that you run into a server limit which
will show up if you
thanx for the reply , usually , i uploading jpg and gif files into mysql
database , there is no any issue. we can display them correctly.
when i try to upload such huge mp3 files and some .jar files into the databse ,
i used mysqlcc GUI and SQLYOG GUI , from those interfaces also giving
AS JIGAL SAID :
make sure you are not creating an INSERT statement bigger than the
max_allowed_packet setting for both your destination server and your
client library (whichever ones you are using). If you attempt to create a
packet that is too large, the server will _ignore_ it. Because the
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts digital
artwork) stored in SQL databases. Granted we are using Sybase for
that and not MySQL but there are a lot of advantages to it - access
control, change control
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sir ,
Iam working on Mysql5.0 version.
Can I store .jpeg or .png or .gif etc imagefiles
in database.
If so where can I get the tutorials or sample code
to insert and retrive the images from mysql
database.
Any help is welcome.
Thanking you ,
Sreedhar
I store .jpeg or .png or .gif etc imagefiles
in database.
If so where can I get the tutorials or sample code
to insert and retrive the images from mysql
database.
Any help is welcome.
Thanking you ,
Sreedhar
__
Do You Yahoo!?
Tired
Title: Inserting Other Binary data into DB (NOT IMAGES)
Good afternoon all,
I have a db (gasp!) that is holding images in a BLOB field already. I can upload and retrieve on the fly - no problems.
Now I am looking at inserting binary data such as M$Word Documents (.doc and .rtf), XML
Inserting Other Binary data into DB (NOT IMAGES)Inserting images in no
different compared to inserting PDFs.
What is your problem? What have you tried so far?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server
Upscene Productions
http
]
Sent: Tuesday, March 01, 2005 5:09 PM
To: [EMAIL PROTECTED]; mysql
Subject: Re: Inserting Other Binary data into DB (NOT IMAGES)
Inserting Other Binary data into DB (NOT IMAGES)Inserting images in no
different compared to inserting PDFs.
What is your problem? What have you tried so far
Hi,
Have you try google ?
http://www.google.fr/search?hl=frq=storing+image+in+mysqlbtnG=Recherche+Googlemeta=
I see pretty much a lot of stuff there ;)
btw, storing image in a table in considering a bad practice, let the
filesystem handle it it does it more efficiently. I would suggesdt to
write
Hello list-
I am programing both in Java and PHP. Can anyone point me to sample
code for either on saving an image to a table?
Thanks,
-Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear member,you can visit:
http://dev.mysql.com/doc/connector/j/en/index.html
http://dev.mysql.com/doc/mysql/en/php.html
Hello list-
I am programing both in Java and PHP. Can anyone point me to sample
code for either on saving an image to a table?
Thanks,
-Chris
--
MySQL General Mailing
Hello.
[mysqldump]
default_character_set = latin1
[EMAIL PROTECTED] wrote:
amazing.. I failed to see that in the last msg - but that seemed to do the
trick - The images appear correctly now.. is there anyway in my.cnf to tell
it to always use the command?? Thanks much
msg - but that seemed to do the
trick - The images appear correctly now.. is there anyway in my.cnf to
tell it to always use the command?? Thanks much for the help!
In a message dated 1/11/2005 4:48:27 AM Eastern Standard Time, Gleb
Paharenko [EMAIL PROTECTED] writes
Hello.
Have you tried to perform the dump using --default-character-set=latin1
option and then restore data from it?
[EMAIL PROTECTED] wrote:
Hello, thanks for helping! Here is the output of the requested statements on
live database:
SHOW CREATE TABLE avatardata;
|
amazing.. I failed to see that in the last msg - but that seemed to do the
trick - The images appear correctly now.. is there anyway in my.cnf to tell
it to always use the command?? Thanks much for the help!
In a message dated 1/11/2005 4:48:27 AM Eastern Standard Time, Gleb Paharenko
Hello, thanks for helping! Here is the output of the requested statements on
live database:
SHOW CREATE TABLE avatardata;
| customavatar | CREATE TABLE `customavatar` (
`userid` int(10) unsigned NOT NULL default '0',
`avatardata` mediumtext NOT NULL,
`dateline` int(10) unsigned NOT NULL
Hello.
mysqldump usually produced
SET NAMES utf8
at the begining of the dump file. The clues may be in this. Send us
the output of such statements:
SHOW CREATE TABLE avatardata;
SHOW CREATE DATABASE 'put the name of the avatar database';
SHOW VARIABLES LIKE '%char%';
and your
Hi there,
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote on Thursday, January
06, 2005 7:19 PM:
Thanks for the reply! I show the following information for my DB,
and shows the same for both the 3.23 DB And the 4.18a DB
Field Type Collation
avatardata
Hi,
[EMAIL PROTECTED] schrieb:
Hi Tom,
Thanks for the reply! I show the following information for my DB,
and shows the same for both the 3.23 DB And the 4.18a DB
Field Type Collation
avatardata mediumtext latin1_swedish_ci
I pasted a data table from the
I have reinstalled the v3 RPM again to my system, and used one of my original
backups from that same version. In 3.23 there is no 'collation' field.. I
wonder if that is the problem?? I am going to change it to latein1_bin to see
what happens next..
Thanks! I'll let you know!
In a
Hi Dr.
The avatars still show fine on 4.18a -- but the problem occurs when I
actually do a dump and reimport the dump file. That's when something goes
array.. Kinda weird if you ask me.. I wish that vBulletin wouldn't actually
hard code the binary in a table, lol.. It's got me totally
Sorry, forgot the attachments. These are the same exact two avatars from the
same user, using my 3.23 backup, for the good avatar, then the 4.18 bad avatar
attachment: brokenavatar.jpegattachment: goodavatar.jpeg--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote on Thursday, January
06, 2005 4:57 PM:
Sorry, forgot the attachments. These are the same exact two
avatars from the same user, using my 3.23 backup, for the
good avatar, then the 4.18 bad avatar
Looks like a character set issue - what's the
Hi Tom,
Thanks for the reply! I show the following information for my DB,
and shows the same for both the 3.23 DB And the 4.18a DB
Field Type Collation
avatardata mediumtext latin1_swedish_ci
I pasted a data table from the bad avatar and the good avatar
for 12 units @
US$14 ~ US$16.
Order quantity must be atleast USD$5000++.
IT company to IT company.
*/
Mulley, Nikhil wrote:
Hi Lists ,
My Query is How Can I store Images in the MySQL Database , and how to Index them ,
can anybosy help me on this please
I am starting out a Online Photo
Hi Lists ,
My Query is How Can I store Images in the MySQL Database , and how to Index them ,
can anybosy help me on this please
I am starting out a Online Photo Gallery and want to share them , and I want to
make the search available, Does anybody has already done
Hi Nikhil,
Have a look at www.hotscripts.com for either a script that dose this or a
tutorial to show you how to do it.
But in general you DO NOT store the image in a MySql table you just store
its location name i.e. 'images/image1.png' and then with a select
statement use the result in a 'img
I figured I'd post a follow-up to the discussion earlier this week on issues
relating to storing images in MySQL.
In my opinion.
Whether you store images in MySQL ultimately depends on whether you can
setup a caching accelerator (like Squid) between you and your visitors.
Storing images
From: GH [EMAIL PROTECTED]
I was wondering how to get images into and out of a Mysql database
was told it was possible.
I have mysql 4.0.18
The general opinion is that files should be stored in a file system and not
a database. There are circumstances that you might want to store binary
It's an argument that can go on forever... We have 10's of thousands
of images in mysql databases.. very fast/reliable.. easy to
replicate, stream, etc..
On Tue, 28 Sep 2004 08:42:13 +0200, Jigal van Hemert [EMAIL PROTECTED] wrote:
From: GH [EMAIL PROTECTED]
I was wondering how to get
Is there anything special in your setup that you did to have such good
performance?
On Tue, 28 Sep 2004 11:47:26 -0400, DreamWerx [EMAIL PROTECTED] wrote:
It's an argument that can go on forever... We have 10's of thousands
of images in mysql databases.. very fast/reliable.. easy
Separate/dedicated servers for web/database. All the data was
chunked to allow faster streaming/lower overhead (large
images/files).. If you have more specific questions I can answer
them..
On Tue, 28 Sep 2004 11:49:27 -0400, GH [EMAIL PROTECTED] wrote:
Is there anything special in your
What do you mean chunked?
I figured it would be easier to track about 32,000 images in MySQL than in
files, so I setup a test to see what the performance difference is and if
storing in MySQL would actually work.
Everything is working and it's a lot easier to keep track of the images in
MySQL
to always retrieve the image. Comments?
I am doing some blob storage in Oracle with Cold Fusion. Using some purcha$ed java
code to get the image in and out. Anyone else doing coldfusion with mysql blobs? How
do you retrieve/display the images?
--ja
On Tue, 28 Sep 2004, Ed Lazor wrote:
What do
a non issue.
--
Eric Bergen
[EMAIL PROTECTED]
On Tue, 28 Sep 2004 09:19:47 -0700, Ed Lazor [EMAIL PROTECTED] wrote:
What do you mean chunked?
I figured it would be easier to track about 32,000 images in MySQL than in
files, so I setup a test to see what the performance difference
the metadata and don't want to
always retrieve the image. Comments?
I agree. That's the approach I used. Data on products are stored in a
products table, while images are stored in a table called images. The
images table has the following fields: ID, ProductID, SizeID, Image. There
are 4 images
the images get cached
as actual files? If so, the original method of storage would be a mute
point. That's what I'm trying to find out. What do you think?
-Ed
-Original Message-
From: Eric Bergen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 9:48 AM
To: Ed Lazor
Cc
pretty fast.. Rare day when most internet users can talk to
servers at those speeds.
On Tue, 28 Sep 2004 09:19:47 -0700, Ed Lazor [EMAIL PROTECTED] wrote:
What do you mean chunked?
I figured it would be easier to track about 32,000 images in MySQL than in
files, so I setup a test to see what
It would be quite easy to drop a squid or similar proxy infront to
cache the db images in memory and deliver them for a set cache-time or
something.. That would be 1 way to boost performance..
On Tue, 28 Sep 2004 09:55:54 -0700, Ed Lazor [EMAIL PROTECTED] wrote:
-Original Message-
I
Ok... I have some more test results. After optimizing as much as I can
think of, without using caching, I've gotten things down to a 13x
difference. Using Apache's ab performance test, the image comes from a file
at an average of 2ms and from the database (using PHP4) at an average of
28ms.
I
Thanks for the article. I'll check it out.
Throughput of 4600K/s is great. How's latency?
-Ed
-Original Message-
So if the image was say 200K in size, the metadata for the image would
be 1 row in a table, and the image data would be 4 rows in the data
table. 3 full 64K rows + 1
I thank you all for this discussion... and for the great information
that everyone has provideded. Next question (which is part of my
original) how do I actually get the images into the Blobs...
Additionally, the what are the names and capacities of the datatypes
that I could use? I have been
Great .. I don't have any numbers.. but basically there is quite
little latency using the FTP interface, data is streamed in and out of
mysql on the fly, inserting and selecting blocks of rows.. The FTP
server is written in java using JDBC to talk the database, so it's
quite fast.
On Tue, 28
Getting images/files into blob is quite easy.. examples could be
provided based on what lanaguge/interface way you want to use...
Mysql site has a great list of data types and capacities, etc... do a
search for it..
On Tue, 28 Sep 2004 13:58:16 -0400, GH [EMAIL PROTECTED] wrote:
I thank you
Ed brings up a great point... i would rather not have anyone
'searching' for images in directories and such...
On Tue, 28 Sep 2004 10:53:01 -0700, Ed Lazor [EMAIL PROTECTED] wrote:
Ok... I have some more test results. After optimizing as much as I can
think of, without using caching, I've
the edge and at what
cost. I haven't set up caching, so I'm not sure if it's complicated or not.
It would provide performance boosts to more than just images through, so it
seems worthwhile to explore. That's what I'll be exploring next. =)
-Ed
-Original Message-
Most people make
I was wondering how to get images into and out of a Mysql database
was told it was possible.
I have mysql 4.0.18
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
images into and out of a Mysql database
was told it was possible.
I have mysql 4.0.18
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http
Hi everyone,
I am new to MySQL. I am starting a database project for a medium-sized
medical office. I chose MS-Access (on 10-terminal pre-existing Win2K
intranet) for rapid front-end dev and familiarity to the existing users.
I plan to use MySQL on Linux server for backend for its speed, great
I would recommend storing the images on the filesystem and put the
information about those images (along with the path to the image) in MySQL.
If you plan to have lots of images, implement a nice logical directory
structure to keep them in as in my experience linux ext2/3 is fast
reading/writing
Read this article for it's design on database storage.. I have several
big implementations on this design which are fast, reliable and scalable
(one of them in the medical field aswell)
http://php.dreamwerx.net/forums/viewtopic.php?t=6
On Sun, 1 Feb 2004, Yuri Oleynikov wrote:
Hi everyone,
I have a small single user database into which I wish to insert and extract
images.
From the manual this seems to work to insert the image
insert into images values(LOAD_FILE(/home/richard/scan.tiff));
but how do I get it back again?
I thought this might work but it doesn't
select
You need to select into dumpfile instead of outfile. See the section of the manual on
select syntax:
http://www.mysql.com/doc/en/SELECT.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Richard Bewley wrote:
Yes, you can insert the binary into a table.
Richard
-Original Message-
From: Zenzo [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 29, 2003 1:42 PM
To: MySQL List
Subject: Images in a table
If your application is WWW based I've done some notes for students
I would be pleased.
Thanks
Glenn Stauffer [EMAIL PROTECTED] wrote:
Zenzo wrote:
How can I insert images in a table if I can do it with MySQL?
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
I can send you some simple code to do
default '');
Hopa that helps
On Saturday 29 November 2003 19:41, Zenzo wrote:
How can I insert images in a table if I can do it with MySQL?
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
Mickael Bailly
--
MySQL General
that helps
On Saturday 29 November 2003 19:41, Zenzo wrote:
How can I insert images in a table if I can do it with MySQL?
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
Mickael Bailly
--
MySQL General Mailing List
How can I insert images in a table if I can do it with MySQL?
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Yes, you can insert the binary into a table.
Richard
-Original Message-
From: Zenzo [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 29, 2003 1:42 PM
To: MySQL List
Subject: Images in a table
How can I insert images in a table if I can do it with MySQL
- Original Message -
From: Danny Haworth [EMAIL PROTECTED]
To: Director General: NEFACOMP [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 14:41
Subject: Re: BLOB images in Crystal Reports
I've had no problems with MySQL, crystal reports and blob images. Main
differences here
[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 14:41
Subject: Re: BLOB images in Crystal Reports
I've had no problems with MySQL, crystal reports and blob images. Main
differences here are the following:
Crystal Reports 8.5 (not 7)
Myodbc 2.x (haven't tried 3.x yet with images
the binary data.
Luiz Rafael Culik Guimaraes said:
Dear Friends
I has images saved on an mysql table as an blob field, but i could not
recreate the image as file by selecting an specific record of this field
any ideia
Regards
Luiz
--
If you don't like the news, go out and make some on your
Hi
The most common problem in such cases is that the webserver doesn't know
what MIME Type the file is and so it doesn't know how to send it.
If you are using PHP to upload and later show that image on the web, i
could give you the code for the scripts and the structure of the table
containg
the code for the scripts and the structure of the table
containg the binary data.
Luiz Rafael Culik Guimaraes said:
Dear Friends
I has images saved on an mysql table as an blob field, but i could not
recreate the image as file by selecting an specific record of this field
any ideia
Dear Friends
I has images saved on an mysql table as an blob field, but i could not
recreate the image as file by selecting an specific record of this field
any ideia
Regards
Luiz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hi
I am trying to save bitmap images in a InnoDB table in a field that is
declared a lonblob. I am using the ODBC API of Microsoft Visual Studio 6 and
saving it to MySQL via the MyODBC Driver version 3.51. The MySQL version is
4.0.12-nt. Seems like I can only save four bytes and retrieve bytes
luck,
Jef
-Original Message-
From: Dan Anderson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 4:31 PM
To: Partap Davis
Cc: [EMAIL PROTECTED]
Subject: Re: How can I display images from a mySQL Database in a web
page?
I think there is a way to insert binary image data
Dan Anderson wrote:
I have created a BLOB field to store images. Is there any way to embed
them within HTML with something like:
I've done some notes on this at
http://www.scit.wlv.ac.uk/~jphb/sst/php/extra/images1.html
- assuming of course you're using PHP as a WWW backend to
dig the stuff
image start: jpeg
/image
use this:
echo 'img src='.mysql_result($conn, 0, 0).' alt=';
where 0,0 is the result-set index for your mysql field. you might
use other mysql functions of course, but the place to put the output
in is the same
the html-source code will look like it is
I have created a BLOB field to store images. Is there any way to embed
them within HTML with something like:
image start: jpeg
/image
Thanks in advance,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
1 - 100 of 224 matches
Mail list logo