How to upload image and save url in database?

Question

I want to upload an image through form and save url in database, in 'pic' column. It has been showing errors though it is saving the image name and the image is saving any where in my DB. Your kind answer is highly appreciated. Here is the code:

<?php /* Template Name: Dark Knight*/?>
<div id="main-content" class="main-content">
  <div class="main-content-inner">
        <form method="post" enctype='multipart/form-data'>
        <p>
            <div>
                <input name="nametxt" id="nametxt" type="text"><br>
            </div>
        </p>

        <p>
            <div>
                <input name="fileToUpload" id="fileToUpload" type="file">
            </div>
        </p>
            <input id="submitbtn" type='submit' name='Submit' value='Add Member' /><br><br>
        </form>
    </div>
 </div>
<?php 
    if(isset($_POST['Submit']))
    {
        if( isset($_POST['nametxt']) || isset($_FILES['fileToUpload']))
        {
            global $wpdb;
            $target_dir = "uploads/";
            $target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]. $_POST['fileToUpload']);
            $data = array('name' => $_POST['nametxt'], 
                          'pic' => $target_file);
            $table = $wpdb->prefix.'tboxteam';
            $format = array('%s','%s');
            $wpdb->insert($table,$data,$format);
        }
    }
?>

Notice: Undefined index: fileToUpload in C:\xampp\htdocs\wordpress\wp-content\themes\twentyfifteen-child\custompage7.php on line 39

score 1 · Answer 1 · answered Aug 26 '19 at 11:09

1

You need to use

enctype='multipart/form-data'

in form when dealing with file upload

answered Aug 26 '19 at 11:09

Muhammed Shihabudeen Labba A

481
3
17

I am already using it. It's not working fine. – STBox Aug 26 '19 at 11:13
In the provided code, it is not there. – Muhammed Shihabudeen Labba A Aug 26 '19 at 11:14
Thanku Sir I have edited my code, but the error is still the same. – STBox Aug 26 '19 at 11:20
I tried your code, and it is working fine in my system. – Muhammed Shihabudeen Labba A Aug 26 '19 at 11:32

score 0 · Accepted Answer · answered Aug 26 '19 at 11:21

0

Try, to work out this w3schools tutorial step by step. Take your time and don't rush things. Take a brake, if you feel overwhelmed and try again later. I did it in 30 minutes, when i cleared my brain.

answered Aug 26 '19 at 11:21

era-net

332
1
8

How to upload image and save url in database?

2 Answers2