MYSQL php database insert including image upload

Question

Im trying insert user input into my databases. I want to add title and description into the advert table and an image to to the pictures table. this is what i have come up with so far but it doesnt work at all. this is a posthandler.php page which will be called when the user presses submit. Variable at the top are assigned input names from the html page. I have both path name and blob in my pictures database at the moment to see which option will work best.

please help

<?php

session_start();
echo "You are signed in as ". $_SESSION['username'];

 include 'mysql.php'; 

 $title='title';
 $des='des';
 $image='image';

if(isset($_POST['submit'])) {
   $error = "";
     if (!empty($_POST['title'])) {
             $title= $_POST['title'];
        } else {
             $error = "Please enter a title for your Ad. <br />";
        }
        if (!empty($_POST['des'])) {
             $des = $_POST['des'];
        } else {
             $error = "Please describe your item <br />";
        }
        if (!empty($_POST['image'])) {

           $image=addslashes($_FILES['image']['tmp_name']);
           $name=addslashes($_FILES['image']['name']);
           $image=file_get_contents($image);
           $image=base64_encode($image);
           $filepath = "images/".$filename;
           move_uploaded_file($filetmp,$filepath);
           $image = $_POST['image'];

        } else {

        }

        if (empty($error)) {

        $conn= mysql_connect("localhost","km","data");
        if (!$conn){
            die ("Failed to connect to MySQL: " . mysql_error());

        mysql_select_db("mdb_km283",$conn);

        $sql = "INSERT INTO Advert (title, description) VALUES ('$_POST[title]','$_POST[des]')";
        $sql2 = "INSERT INTO Pictures(image, Path) VALUES ('$_POST[image]' $filepath)";

        mysql_query( $sql,$sql2, $conn );
        //mysql_query( $sql2,$conn );
        mysql_close($conn); 


            echo 'Upload successfull';
        }

        }
}


  ?>

  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
    "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html version="-//W3C//DTD XHTML 1.1//EN"
      xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="http://www.w3.org/1999/xhtml
                          http://www.w3.org/MarkUp/SCHEMA/xhtml11.xsd"
>

<head>
<link rel="stylesheet" type=text/css" href="stylesheet.css">
<a href="signout.php">Logout</a>

<h1>ERROR - Please go back and fix the below:</h1>
</head>
<body>


<?php 
    if (!empty($error)) {
        echo'<p class="error"><strong>Upload failed. Please go back and fix the below <br/> The following error(s) returned:</strong><br/>' . $error . '</p>';
    } else {

    echo '<meta http-equiv="refresh" content="0; URL=user.php">';


    }


?>


</body>
</html>

Sudip Das · Accepted Answer · 2015-11-29 05:52:35Z

2

$filename = $_FILES['image']['name'];
$filepath = 'image/' . $filename;
$filetmp = $_FILES['image']['temp_name'];
$result = move_uploaded_file($filetmp,$filepath);
if(!$result)
         echo "Photo field was blank";
else 
         echo "uploaded";

then write ur mysql code here ....

answered Nov 29, 2015 at 5:52

Sudip Das

1,2081 gold badge10 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MYSQL php database insert including image upload

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related