Ajax PHP upload script

Question

Where do i put my PHP SQL query, to insert image information to my database? I tried just before the echo "success"; however it had no effect.

<!-- Upload Button-->
<div id="upload" >Upload File</div><span id="status" ></span>
<!--List Files-->
<ul id="files" ></ul>

PHP handling

<?php
$uploaddir = './uploads/';
$file = $uploaddir . basename($_FILES['uploadfile']['name']); 

if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) {
echo "success";
} else {
echo "error";
}
?>

Javascript section

$(function () {
    var btnUpload = $('#upload');
    var status = $('#status');
    new AjaxUpload(btnUpload, {
        action: 'upload-file.php',
        //Name of the file input box
        name: 'uploadfile',
        onSubmit: function (file, ext) {
            if (!(ext && /^(jpg|png|jpeg|gif)$/.test(ext))) {
                // check for valid file extension
                status.text('Only JPG, PNG or GIF files are allowed');
                return false;
            }
            status.text('Uploading...');
        },
        onComplete: function (file, response) {
            //On completion clear the status
            status.text('');
            //Add uploaded file to list
            if (response === "success") {
                $('<li></li>').appendTo('#files').html('<img src="./uploads/' + file + '" alt="" /><br />' + file).addClass('success');
            } else {
                $('<li></li>').appendTo('#files').text(file).addClass('error');
            }
        }
    });
});

Mihai Matei · Accepted Answer · 2012-07-23 10:52:08Z

1

The query should be right before success echo, so you have to verify what is returning to you the move_uploaded_file method.

Verify if ./upload/ is the right path and if you have read/write access (0777) on this directory.

Also make sure that you're connected to database:

<?php 

    $conn = mysql_connect("HOST","USER","PASSWORD");
    $db = mysql_select_db("DB_NAME");

    $uploaddir = './uploads/'; 
    $file = $uploaddir . basename($_FILES['uploadfile']['name']);  

    if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) { 
        mysql_query("INSERT INTO photos VALUES ('your_values')");
        echo "success"; 
    } else { 
        echo "error"; 
    } 
 ?>

edited Jul 23, 2012 at 10:52

answered Jul 23, 2012 at 10:47

Mihai Matei

24.3k5 gold badges34 silver badges50 bronze badges

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

5 Comments

Patrick Reck Over a year ago

I am connected to the database. I suppose this is what you mean: pastebin.com/niBAeyiW And that is what i tried and it doesn't work out.

Mihai Matei Over a year ago

If you're connected to database, and the path of the uploaded files is correct and you have write access on it and also if the query is correct then everything must be ok.. you can verify if the query is successfull like this: mysql_query(...your query...) or die(mysql_error());

Patrick Reck Over a year ago

It is uploading the files correctly, the only problem is the database insertion. The query does not generate any output (tried with the mysql_error), it's like it never sees it

Patrick Reck Over a year ago

I tried echoing a javascript popup where you've put in the SQL query, and it doesn't show either

Mihai Matei Over a year ago

Ok than try to put the query into a condition statement: if(mysql_query(...query...)) echo "success";

Collectives™ on Stack Overflow

Ajax PHP upload script

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related