I have never done it but have seen posts on this topic. From what I
understand you need to create a BLOB field in your DB (MySQL) then upload
file to your server, read it with fopen (or ...) into a variable then
insert that variable into the BLOB field you have in your DB.
Hope I am right here?
Regards
Ajdin
On Wed, 3 Oct 2001, Sandeep Murthy wrote:
> hi all,
>
> I have been trying to insert images into my mysql database thru PHP for the
> past 2 days without any luck.. After having tried various combinations of
> queries, I gave up..
>
> Wud be grateful if anyone can post a query for inserting images in to my
> database..
>
> TIA,
> Sandeep
>
>
> This is what i hv tried:
>
> <HTML>
> <HEAD>
> <TITLE>Binary Data Insert Form</TITLE>
> </HEAD>
>
> <BODY>
> <H1>Upload a File:</H1>
>
> <FORM enctype="multipart/form-data"
> method="post" action="do_insert.php">
> <INPUT type="file" name="img1" size="30">
> <INPUT type="submit" name="submit"
> value="Use this File">
>
> </FORM>
> </BODY>
> </HTML>
>
> __________________________________________________________
> <?
> if (!isset($img1)) {
> header("Location: insert_file.html");
> exit;
> }
>
> $db = @mysql_connect("localhost","root","sandeep") or
> die("Can't connect to server.");
> @mysql_select_db("yourDB", $db) or
> die("Can't select database.");
>
> $binary_junk = addslashes (fread(fopen($img1, "r"), filesize($img1)));
> $insert_data = "INSERT INTO
> images (img_id, binary_junk, filename, filesize, filetype)
> VALUES ('1', '$binary_junk', '$img1_name', '$img1_size', '$img1_type')";
>
> @mysql_query($insert_data) or
>
> The error is occuring here , am getting a "couldnt insert data error"
>
> die("Couldn't insert data.");
>
> ?>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
