php - How to insert picture in database? -


so far can upload picture in folder path, don't have idea how can store in database. have tried couple of examples no luck far. can me?

upload.php

<?php //turn on php error reporting error_reporting(e_all); ini_set('display_errors', 1);  if ($_server['request_method'] == 'post') {      $name     = $_files['file']['name'];     $tmpname  = $_files['file']['tmp_name'];     $error    = $_files['file']['error'];     $size     = $_files['file']['size'];     $ext      = strtolower(pathinfo($name, pathinfo_extension));      switch ($error) {         case upload_err_ok:             $valid = true;             //validate file extensions             if ( !in_array($ext, array('jpg','jpeg','png','gif')) ) {                 $valid = false;                 $response = 'invalid file extension.';             }             //validate file size             if ( $size/1024/1024 > 2 ) {                 $valid = false;                 $response = 'file size exceeding maximum allowed size.';             }             //upload file             if ($valid) {                 $targetpath =  dirname( __file__ ) . directory_separator. 'uploads' . directory_separator. $name;                 move_uploaded_file($tmpname,$targetpath);                  header( 'location: index.php' ) ;                 exit;             }             break;         case upload_err_ini_size:             $response = 'the uploaded file exceeds upload_max_filesize directive in php.ini.';             break;         case upload_err_partial:             $response = 'the uploaded file partially uploaded.';             break;         case upload_err_no_file:             $response = 'no file uploaded.';             break;         case upload_err_no_tmp_dir:             $response = 'missing temporary folder. introduced in php 4.3.10 , php 5.0.3.';             break;         case upload_err_cant_write:             $response = 'failed write file disk. introduced in php 5.1.0.';             break;         default:             $response = 'unknown error';         break;     }      echo $response; } ?>

uploadpicture.php

<?php  include_once("login_check.inc"); include_once("database/connection.inc");  ?> <!doctype html> <html lang="en">   <head>     <meta charset="utf-8">     <meta http-equiv="x-ua-compatible" content="ie=edge">     <title>php file uploader</title>      <!-- bootstrap core css -->     <link href="boostrap/css/bootstrap.min.css" rel="stylesheet">    </head>    <body>      <!-- static navbar -->     <div class="navbar navbar-default navbar-static-top">       <div class="container">         <div class="navbar-header">           <a class="navbar-brand" href="index.php">php file uploader</a>         </div>       </div>     </div>       <div class="container">          <div class="row">            <?php              //scan "uploads" folder , display them accordingly            $folder = "uploads";            $results = scandir('uploads');            foreach ($results $result) {             if ($result === '.' or $result === '..') continue;              if (is_file($folder . '/' . $result)) {                 echo '                 <div class="col-md-3">                     <div class="thumbnail">                         <img src="'.$folder . '/' . $result.'" alt="...">                             <div class="caption">                             <p><a href="remove.php?name='.$result.'" class="btn btn-danger btn-xs" role="button">remove</a></p>                         </div>                     </div>                 </div>';             }            }            ?>         </div>            <div class="row">             <div class="col-lg-12">                <form class="well" action="upload.php" method="post" enctype="multipart/form-data">                   <div class="form-group">                     <label for="file">select file upload</label>                     <input type="file" name="file">                     <p class="help-block">only jpg,jpeg,png , gif file maximum size of 1 mb allowed.</p>                   </div>                   <input type="submit" class="btn btn-lg btn-primary" value="upload">                 </form>             </div>           </div>      </div> <!-- /container -->    </body> </html>

and database table want insert picture path

you can save images database in multiple ways. tend base64 encode image , save extension. don't know if practical method though.

// encoding image $images = file_get_cntents('image.jpg'); $encodedimage = base64_encode($image);

Comments

Post a Comment

Popular posts from this blog

asynchronous - C# WinSCP .NET assembly: How to upload multiple files asynchronously -

i using winscp .net assembly uploading files. want upload multiple files asynchronous way. have created method works single upload. public class uploadingdata { private sessionoptions _sessionoptions; private session _session; //connection etc private void onconnected() { foreach (var fileinfo in localfileslist) { var task = task.factory.startnew(() => uploadfilesasync(fileinfo)); } } private async task uploadfilesasync(string file) { string remotefilepath = _session.translatelocalpathtoremote(file, @"/", "/test_data_upload"); var uploading = _session.putfiles(file, remotefilepath, false); //when done await task.run(() => thread.sleep(1000)); } } please suggest me correct way. thanks you can use backgroundworker class this: string[] images = new string[50]; foreach (var path in images) { backgroundworker
Read more

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more