Upload Image to MySQL using PHP<\/p>\n\n\n\n
As a new-bie to php\/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite simple code with two php files one to display and one to upload.<\/p>\n\n\n\n
For Image Upload code, I’ve added code download link upload-image-mysql-demo.zip at the end of the page.<\/p>\n\n\n\n
CREATE TABLE `pix` ( \n `pic_id` int(11) NOT NULL auto_increment,\n `pic_name` varchar(100) NOT NULL,\n `pic_data` longblob NOT NULL,\n PRIMARY KEY\u00a0 (`pic_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;<\/code><\/pre>\n\n\n\n\u00a0<\/p>\n\n\n\n
Save images to MySQL using PHP<\/h2>\n\n\n\n\/* Image.php*\/\n<?php\n $con = mysql_connect(\"127.0.0.1:3306\",\"root\",\"\");\n if (!$con)\n {\n die(\"Could not connect: \" . mysql_error());\n }\n $DB = mysql_select_db(\"test\", $con);\n move_uploaded_file($_FILES[\"uploadedfile\"][\"tmp_name\"],\"latest.img\");\n $instr = fopen(\"latest.img\",\"rb\");\n $image = addslashes(fread(fopen(\"latest.img\",\"r\"),filesize(\"latest.img\")));\n mysql_query (\"insert into pix (pic_name, pic_data) values (\"myImage\", \"'.$image.'\");\");\n?>\n\n<html>\n<form enctype=\"multipart\/form-data\" method=\"POST\">\n<img src=showImage.php?gim=1 width=500 height=150 alt=\"hell\">\n<br><hr>\n<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"100000\" \/>\nChoose a file to upload(<100 KB): <input name=\"uploadedfile\" type=\"file\" \/><br\/>\n<input type=\"submit\" value=\"submit\" name=\"submit\" \/>\n<\/form>\n<html><\/code><\/pre>\n\n\n\n <\/p>\n\n\n\n
Show image in MySQL using PHP<\/h2>\n\n\n\n\/*showImage.php*\/\n<?php\n $con = mysql_connect(\"127.0.0.1:3306\",\"root\",\"\");\n if (!$con)\n {\n die(\"Could not connect: \" . mysql_error());\n }\n $DB = mysql_select_db(\"test\", $con);\n $res = @mysql_query(\"select * from pix order by pic_id desc limit 1\");\n if ($row = @mysql_fetch_assoc($res)) \n {\n $title = htmlspecialchars($row[pic_name]);\n $bytes = $row[pic_data];\n }\n header(\"Content-type: image\/jpg\");\n print $bytes;\n mysql_close();\n?><\/code><\/pre>\n\n\n\n