<div>
Standard &quot;good practices&quot; would not put an image into the database. &nbsp;Instead, store the image file in the server file system and store the URL (or similar location pointer) in the database.
</div>

<div>
@Ray that is exactly what i'm trying to do.
</div>

<div>
Good. &nbsp;So what seems to be going wrong?
</div>

<div>
On being clicked on submit is says a error &quot;Undefined index fileToUpload&quot;
</div>

<div>
Here's a complete example of a PHP file upload script. &nbsp;It allows for multiple file uploads, tests for errors and produces sensible error messages, etc. &nbsp;You may not need all of it, and you can just carve out the parts you need. &nbsp;It also has links to the relevant man pages. 

<pre><code class="code-100 nolinks" id="code-20-42043451-1">&lt;?php // demo/upload_example.php
/**
 * Demonstrate how to upload one or more files, using HTML5 and PHP
 *
 * REQUIRED: Man Page References
 * http://www.w3schools.com/tags/att_input_multiple.asp
 *
 * http://php.net/manual/en/reserved.variables.files.php
 * http://php.net/manual/en/features.file-upload.php
 * http://php.net/manual/en/features.file-upload.post-method.php
 * http://php.net/manual/en/features.file-upload.common-pitfalls.php
 * http://php.net/manual/en/features.file-upload.errors.php
 * http://php.net/manual/en/features.file-upload.multiple.php
 *
 * http://php.net/manual/en/function.move-uploaded-file.php
 *
 * IMPORTANT: If dealing with large files
 * http://php.net/manual/en/ini.core.php#ini.upload-max-filesize
 * http://php.net/manual/en/ini.core.php#ini.post-max-size
 * http://php.net/manual/en/info.configuration.php#ini.max-input-time
 */
error_reporting(E_ALL);

// MAY NOT BE NEEDED - CHECK PHP_INI PARAMETERS FOR YOUR TIMEZONE
date_default_timezone_set('America/Chicago');

// ESTABLISH THE NAME OF THE DESTINATION FOLDER ('storage' DIRECTORY)
$storage = 'storage';
if (!is_dir($storage))
{
 mkdir($storage);
}

// ESTABLISH THE BIGGEST FILE SIZE WE WILL ACCEPT - ABOUT 8 MB
$max_file_size = 8 * 1024 * 1024;

// ESTABLISH THE KINDS OF FILE EXTENSIONS WE WILL ACCEPT
$file_exts = array
( 'jpg'
, 'gif'
, 'png'
, 'txt'
, 'pdf'
, 'doc'
, 'docx'
)
;

// ARRAY OF ERRORS THAT MAY BE REPORTED IN $_FILES[][&quot;error&quot;] (THERE IS NO #5)
$errors = array
( UPLOAD_ERR_OK =&gt; &quot;Success!&quot;
, UPLOAD_ERR_INI_SIZE =&gt; &quot;The uploaded file exceeds the upload_max_filesize directive in php.ini&quot;
, UPLOAD_ERR_FORM_SIZE =&gt; &quot;The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form&quot;
, UPLOAD_ERR_PARTIAL =&gt; &quot;The uploaded file was only partially uploaded&quot;
, UPLOAD_ERR_NO_FILE =&gt; &quot;No file was uploaded&quot;
, 5 =&gt; &quot;UNDEFINED ERROR #5&quot;
, UPLOAD_ERR_NO_TMP_DIR =&gt; &quot;Missing a temporary folder&quot;
, UPLOAD_ERR_CANT_WRITE =&gt; &quot;Cannot write file to disk&quot;
, UPLOAD_ERR_EXTENSION =&gt; &quot;A PHP extension stopped the file upload&quot;
)
;


// IF WE HAVE GOT SOMETHING IN $_POST - RUN THE ACTION SCRIPT
if (!empty($_POST))
{
 echo &quot;&lt;h2&gt;Results: File Upload&lt;/h2&gt;&quot; . PHP_EOL;

 // ACTIVATE THIS TO SEE WHAT IS COMING THROUGH IN THE REQUEST
 // echo &quot;&lt;pre&gt;&quot;; var_dump($_FILES); var_dump($_POST); echo &quot;&lt;/pre&gt;&quot;;

 // REORGANIZE THE CONTENTS OF $_FILES SO WE CAN USE AN ITERATOR MORE SENSIBLY
 $nf = count($_FILES['userfile']['name']);
 while ($nf)
 {
 $nf--;
 $my_uploaded_files[$nf]['name'] = $_FILES['userfile']['name'][$nf];
 $my_uploaded_files[$nf]['type'] = $_FILES['userfile']['type'][$nf];
 $my_uploaded_files[$nf]['tmp_name'] = $_FILES['userfile']['tmp_name'][$nf];
 $my_uploaded_files[$nf]['error'] = $_FILES['userfile']['error'][$nf];
 $my_uploaded_files[$nf]['size'] = $_FILES['userfile']['size'][$nf];
 }

 // ITERATE OVER THE COLLECTION OF UPLOADED FILES
 foreach ($my_uploaded_files as $my_uploaded_file)
 {
 // SKIP OVER EMPTY SPOTS - NOTHING UPLOADED
 $error_code = $my_uploaded_file[&quot;error&quot;];
 if ($error_code == UPLOAD_ERR_NO_FILE) continue;

 // IF THERE ARE ERRORS
 if ($error_code != UPLOAD_ERR_OK)
 {
 $error_message = $errors[$error_code];
 trigger_error(&quot;Upload error code: $error_code: $error_message&quot;, E_USER_WARNING);
 continue;
 }

 // SYNTHESIZE THE NEW FILE NAME
 $f_type = explode('.', basename($my_uploaded_file['name']));
 $f_type = end($f_type);
 $f_type = trim(strtolower($f_type));

 $f_name = explode('.', basename($my_uploaded_file['name']));
 $f_name = current($f_name);
 $f_name = trim(strtolower($f_name));

 // SERVER PATH TO THE NEW FILE
 $my_file_path
 = getcwd()
 . DIRECTORY_SEPARATOR
 . $storage
 . DIRECTORY_SEPARATOR
 . $f_name
 . '.'
 . $f_type
 ;

 // URL PATH TO THE NEW FILE
 $my_file_url
 = $storage
 . DIRECTORY_SEPARATOR
 . $f_name
 . '.'
 . $f_type
 ;

 // OPTIONAL TEST FOR ALLOWABLE EXTENSIONS
 if (!in_array($f_type, $file_exts))
 {
 trigger_error(&quot;$f_type Not allowed&quot;, E_USER_WARNING);
 continue;
 }

 // GET THE FILE SIZE
 $file_size = number_format($my_uploaded_file[&quot;size&quot;]);

 // IF THE FILE IS NEW (DOES NOT EXIST)
 if (!file_exists($my_file_path))
 {
 // IF THE MOVE FUNCTION WORKED CORRECTLY
 if (move_uploaded_file($my_uploaded_file['tmp_name'], $my_file_path))
 {
 $upload_success = 1;
 }
 // IF THE MOVE FUNCTION FAILED
 else
 {
 $upload_success = -1;
 }
 }

 // IF THE FILE ALREADY EXISTS
 else
 {
 echo &quot;&lt;br/&gt;&lt;b&gt;&lt;i&gt;$my_file_url&lt;/i&gt;&lt;/b&gt; already exists.&quot; . PHP_EOL;

 // SHOULD WE OVERWRITE THE FILE? IF NOT
 if (empty($_POST[&quot;overwrite&quot;]))
 {
 $upload_success = 0;
 }
 // IF WE SHOULD OVERWRITE THE FILE, TRY TO MAKE A BACKUP
 else
 {
 $now = date('Y-m-d\THis');
 $my_bak = $my_file_path . '.' . $now . '.bak';
 if (!copy($my_file_path, $my_bak))
 {
 trigger_error(&quot;Backup Failed for $my_file_url&quot;, E_USER_WARNING);
 }
 if (move_uploaded_file($my_uploaded_file['tmp_name'], $my_file_path))
 {
 $upload_success = 2;
 }
 else
 {
 $upload_success = -1;
 }
 }
 }

 // REPORT OUR SUCCESS OR FAILURE
 if ($upload_success == 2) { echo &quot;&lt;br/&gt;It has been overwritten.&quot; . PHP_EOL; }
 if ($upload_success == 1) { echo &quot;&lt;br/&gt;&lt;b&gt;$my_file_url&lt;/b&gt; has been saved.&quot; . PHP_EOL; }
 if ($upload_success == 0) { echo &quot;&lt;br/&gt;&lt;b&gt;It was NOT overwritten.&lt;/b&gt;&quot; . PHP_EOL; }
 if ($upload_success &lt; 0) { echo &quot;&lt;br/&gt;&lt;b&gt;ERROR: $my_file_url NOT SAVED - SEE WARNING FROM &lt;i&gt;move_uploaded_file()&lt;/i&gt;&lt;/b&gt;&quot; . PHP_EOL; }
 if ($upload_success &gt; 0)
 {
 echo &quot;$file_size bytes uploaded.&quot; . PHP_EOL;
 if (!chmod ($my_file_path, 0644))
 {
 echo '&lt;br/&gt;chmod(0644) FAILED: fileperms() = ';
 echo substr(sprintf('%o', fileperms($my_file_path)), -4);
 }
 echo '&lt;br/&gt;See the file: &lt;a target=&quot;_blank&quot; href=&quot;' . $my_file_url . '&quot;&gt;' . $my_file_url . '&lt;/a&gt;&lt;br/&gt;' . PHP_EOL;
 }
 } // END FOREACH ITERATOR - EACH ITERATION PROCESSES ONE FILE
} // END ACTION SCRIPT


// CREATE THE HTML FORM USING HEREDOC NOTATION
$form = &lt;&lt;&lt;EOF
&lt;h2&gt;Upload file(s)&lt;/h2&gt;
&lt;!--
 SOME IMPORTANT THINGS TO NOTE ABOUT THIS FORM...
 REQUIRES THE HTML5 DOCTYPE
 ENCTYPE= ATTRIBUTE IN THE HTML &lt;FORM&gt; TAG
 MAX_FILE_SIZE HIDDEN CONTROL MUST PRECEDE THE FILE INPUT CONTROLS
 INPUT NAME= IN TYPE=FILE DETERMINES THE NAME YOU FIND IN _FILES ARRAY
 ABSENCE OF ACTION= ATTRIBUTE IN &lt;FORM&gt; TAG CAUSES POST TO SAME URL
--&gt;
&lt;form name=&quot;UploadForm&quot; enctype=&quot;multipart/form-data&quot; method=&quot;post&quot;&gt;
&lt;input type=&quot;hidden&quot; name=&quot;MAX_FILE_SIZE&quot; value=&quot;$max_file_size&quot; /&gt;
&lt;p&gt;
Find the file(s) you want to upload and click the &quot;Upload&quot; button below.
&lt;/p&gt;

&lt;input type=&quot;file&quot; multiple name=&quot;userfile[]&quot; size=&quot;80&quot; /&gt;

&lt;br/&gt;Check this box &lt;input autocomplete=&quot;off&quot; type=&quot;checkbox&quot; name=&quot;overwrite&quot; /&gt; to &lt;b&gt;overwrite&lt;/b&gt; existing files.
&lt;input type=&quot;submit&quot; value=&quot;Upload&quot; /&gt;
&lt;/form&gt;
EOF;

echo $form;
</code></pre>
</div>

<div>
@ImranAli it worked! 
 
i want to fetch image too. how to do that?
</div>

<div>
<blockquote>
to fetch image
</blockquote>
Use a <a href="https://www.w3schools.com/tags/tag_a.asp" rel="ugc">hyperlink</a>.
</div>

<div>
If you want to fetch from database &amp;&nbsp;display it. 

<pre><code class="code-10 nolinks" id="code-20-42044121-1">&lt;?php

/*
	To Fetch image from DB
*/
 $selectUserImage = DB::query(&quot;SELECT FROM links WHERE userid = '&quot;.$userid.&quot;'&quot;);
 $userImagePath = $selectUserImage['fileToUpload'];
 $fileTitle = $selectUserImage['title']; 
 ?&gt;
 &lt;img src=&quot;&lt;?=$userImagePath?&gt;&quot; alt=&quot;&lt;?=$fileTitle?&gt;&quot; height=&quot;auto&quot; &gt;
</code></pre>
</div>

<div>
it says undefined index for title and filetoupload
</div>

<div>
@sanchit 
The code I posted was to give you idea on how you can fetch image record. 
I can help you with code if you let me know what Database library you are using? 
 
Thanks.
</div>

<div>
<a href="https://filedb.experts-exchange.com/incoming/2017/03_w10/1150262/vcvc.PNG" target="_blank" title="here is a snip from phpmyadmin (18 KB)"><img alt="here is a snip from phpmyadmin" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/03_w10/800_1150262/vcvc.PNG" /></a>in image it is stored like &quot;image.jpg&quot; unable to include it in photo
</div>

vcvc.PNG

<div>
I am still not sure which CMS or library you are working with? 
 
You can check this code in native PHP as a reference. 
 

<pre><code class="code-10 nolinks" id="code-20-42044431-1">&lt;?php
$servername = &quot;localhost&quot;;
$username = &quot;username&quot;;
$password = &quot;password&quot;;
$dbname = &quot;myDB&quot;;

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn-&gt;connect_error) {
 die(&quot;Connection failed: &quot; . $conn-&gt;connect_error);
} 

$selectUserImage = &quot;SELECT image,title FROM links WHERE user_id = '&quot;.$userid.&quot;'&quot;;
$result = $conn-&gt;query($sql);
$rowImage = $result-&gt;fetch_assoc();

$userImagePath = $rowImage['image'];
$fileTitle = $rowImage['title']; 

?&gt;
&lt;img src=&quot;&lt;?=$userImagePath?&gt;&quot; alt=&quot;&lt;?=$fileTitle?&gt;&quot; height=&quot;auto&quot; &gt;
</code></pre>
</div>

<div>
@Ray I agree with your comment. 
 
Moreover, the code I posted was to give idea &amp;&nbsp;is not the production code. 
 
Thanks.
</div>

<div>
<div class="content wysiwyg-content">
I have created a very basic form for inserting data in database PDO. I'm done with the url, name and title but got stucked with the image. How to get image inserted into database through the &quot;folder&quot;. I also want to fetch all the details onto some another page. 
Any help in styling up these would also be highly appreciated. 

<pre><code class="code-10 nolinks" id="code-10-29008217-1">&lt;?php
ob_start();
include (&quot;./inc/header.inc.php&quot;);
$fileToUpload=&quot;&quot;;
if(isset($_POST['newpost'])) {
 $urlInput=$_POST['urlInput'];
 $fileToUpload=$_FILES['fileToUpload']['name'];
 $title=$_POST['title'];
 $userid = Login::isLoggedin();
 $filename = $_FILES['fileToUpload']['name'];
 $filetemp = $_FILES['fileToUpload']['tmp_name'];
 $filesize = $_FILES['fileToUpload']['size'];
 $filebasename = basename($_FILES['fileToUpload']['name']);
 $dir=&quot;userdata/folder/&quot;;
 $finaldir=$dir.$filebasename;
 move_uploaded_file($filetemp,$finaldir);
 DB::query('INSERT INTO links VALUES (\'\', :urlInput, :fileToUpload, :title, NOW(), :userid, 0)', array(':urlInput'=&gt;$urlInput, ':fileToUpload'=&gt;$fileToUpload, ':title'=&gt;$title, ':userid'=&gt;$userid));
}

?&gt;

&lt;form action=&quot;submit.php&quot; method=&quot;post&quot;&gt;
 &lt;p&gt;&lt;label&gt;&lt;b&gt;URL&lt;/b&gt;&lt;/label&gt;&lt;br&gt;
&lt;input type=&quot;url&quot; name=&quot;urlInput&quot; value=&quot;&quot; placeholder=&quot;&quot; required&gt;&lt;p /&gt;
 &lt;p&gt;&lt;label&gt;&lt;b&gt;Image&lt;/b&gt;&lt;/label&gt;&lt;br&gt;
&lt;input type=&quot;file&quot; name=&quot;fileToUpload&quot; value=&quot;&quot; placeholder=&quot;&quot; accept=&quot;image/*&quot; required&gt;&lt;p /&gt;
 &lt;p&gt;&lt;label&gt;&lt;b&gt;Title&lt;/b&gt;&lt;/label&gt;&lt;br&gt;
&lt;input type=&quot;text&quot; name=&quot;title&quot; value=&quot;&quot; placeholder=&quot;&quot; required&gt;&lt;p /&gt;
&lt;input type = &quot;submit&quot; name=&quot;newpost&quot; value=&quot;Submit&quot;/&gt;
&lt;/form&gt;
</code></pre>
</div>
</div>

I have created a very basic form for inserting data in database PDO. I'm done with the url, name and title but got stucked with the image. How to get image inserted into database through the "folder". I also want to fetch all the details onto some another page. 
Any help in styling up these would also be highly appreciated.
(CODE)

Inserting images in database PDO

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.