i have simple webpage , database upload , show image on webpage.however, image cannot downloaded , shown correctly on webpage, images show well. have checked database, each image can inserted database correctly.
my php code below:
<?php ini_set('mysql.connect_timeout',10); ini_set('default_socket_timeout',5); include_once 'dbconnect.php'; ?> <?php if(isset($_post['btn_upload_image'])) { if(getimagesize($_files['image']['tmp_name']) == false) { // echo "please select image."; ?> <script>alert('please select image.');</script> <?php } else { $image= addslashes($_files['image']['tmp_name']); $name= addslashes($_files['image']['name']); $image= file_get_contents($image); $image= base64_encode($image); saveimage($name,$image); } } //displayimage(); function saveimage($name,$image) { $qry="insert clothing (picture_name,picture_storage) values ( '$name','$image')"; // echo "$qry" ."</br>"; $result=mysql_query($qry); if($result) { ?> <script>alert('image uploaded.');</script> <?php } else { ?> <script>alert('image not uploaded.');</script> <?php } } function displayimage() { $qry = "select * clothing"; $result=mysql_query($qry); while($row = mysql_fetch_array($result)) { echo '<img height="200" width="200" src="data:image;base64,'.$row[picture_storage].' "> '; } } ?> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>hello peekabuy</title> <link rel="stylesheet" href="style.css" type="text/css" /> </head> <body> <div id="header"> <div id="left"> <label>cropped images </label> </div> </div> <div id="body"> <div id="hotel-infoform"> <form method="post" enctype="multipart/form-data"> <center> <table align="center" width="40%" border="0"> <tr> <td> <input type="file" name="image" /> <br/> <br/> <input type="submit" name="btn_upload_image" value="upload" /> </td> </tr> <center> </table> <br> <br> <br> <br> <br> <br> </form> <?php displayimage(); ?> <br> <br> <br> <br> <hr> </div> </div> </body> </html> 1:how webpage looks like; 2: datatype of database; 3: inserting status
thanks lot!
Comments
Post a Comment