<?PHP//connecting to a database $conn[Email protected]mysql_connect("localhost", "root", "") or die(Mysql_error()); @mysql_select_db(' Water ',$conn) or die(Mysql_error()); //Judging Action $action=isset($_request[' Action ']?$_request[' Action ']: '; //Upload Imageif($action= = ' Add '){ $image=mysql_escape_string(file_get_contents($_files[' Photo '] [' Tmp_name '])); $type=$_files[' Photo '] [' Type ']; $sqlstr= "INSERT into photo (Type,binarydata) VALUES ('".$type."‘,‘".$image."‘)"; @mysql_query($sqlstr) or die(Mysql_error()); Header(' location:upload_image_todb.php '); Exit(); //Show Pictures}ElseIf($action= = ' Show '){ $id=isset($_get[' ID '])?intval($_get[' ID ']) : 0; $sqlstr= "SELECT * from photo where id=$id"; $query=mysql_query($sqlstr) or die(Mysql_error()); $thread=Mysql_fetch_assoc($query); if($thread){ Header(' Content-type: '.$thread[' Type ']); Echo $thread[' BinaryData ']; Exit(); } }Else{ //display a list of pictures and upload a form?> <! DOCTYPE HTML Public"-//w3c//dtd HTML 4.01 transitional//en" "Http://www.w3.org/TR/html4/loose.dtd" > PHP$sqlstr= "SELECT * from photo order BY id DESC"; $query=mysql_query($sqlstr) or die(Mysql_error()); $result=Array(); while($thread=Mysql_fetch_assoc($query)){ $result[] =$thread; } foreach($result as $val){ Echo' <p>$val[' ID ']. ' &t= '. Time(). ' "Width=" ></p> "; } ?> </body> php}?>
PHP Image upload Code