Saving image to mysql, help needed

ersaurabh101 · June 25, 2013

Hello,

I am trying to save image in mysql table using blob. I am show you my code [form page and backend page for insertion], please let me know where i am wrong ?


<!DOCTYPE html>
<html>
<head>
    <title>Forms</title>
    <link href="css/kendo.metro.min.css"rel="stylesheet"> 
        <link href="css/kendo.common.min.css" rel="stylesheet">
        <script src="js/jquery.min.js"></script>
        <script src="js/kendo.web.min.js"></script>
		<script src="js/kendo.upload.min.js"></script>
		
		
		<script type="text/javascript">
	$(document).ready(function(){
		$('#btnSubmit').click(function(){

			$.ajax({
				type: "POST",
				url: 'data/create_new_property.php',
				data: "buildername=" + $('#buildername').val() + "&projectname=" + $('#projectname').val() +  "&files=" + $('#files').val(),
				success: function(data){
					$('#status').html(data);
					$('#buildername').val('');
					$('#projectname').val('');
					$('#files').val('');
				}
			});
		});
	});
</script>
</head>
<body>
  
    <div id="example" class="k-content">
    <div>
        <ul class="forms">
		
            <li>
                <input type="text" class="k-textbox" id="buildername" value="Builder Name" 
				onblur="if (this.value == '') {this.value = 'Builder Name';}"
 onfocus="if (this.value == 'Builder Name') {this.value = '';}"/>
            </li>
			
			<li>
                <input type="text" class="k-textbox" id="projectname" value="Project Name" 
				onblur="if (this.value == '') {this.value = 'Project Name';}"
 onfocus="if (this.value == 'Project Name') {this.value = '';}"/>
            </li>
			
			<li>
			 <input type="text" class="k-textbox" id="location" value="Location" 
				onblur="if (this.value == '') {this.value = 'Location';}"
 onfocus="if (this.value == 'Location') {this.value = '';}"/>
            </li>
			
			<li>
			 <input type="text" class="k-textbox" id="budget" value="Budget" 
				onblur="if (this.value == '') {this.value = 'Budget';}"
 onfocus="if (this.value == 'Budget') {this.value = '';}"/>
            </li>
			
			<li>
			 <input type="text" class="k-textbox" id="propertytype" value="Property Type" 
				onblur="if (this.value == '') {this.value = 'Property Type';}"
 onfocus="if (this.value == 'Property Type') {this.value = '';}"/>
            </li>
			
			 
			<li>
			<input name="files" id="files" type="file" />
			</li>
			
			
			<li>
			 <input type="text" class="k-textbox" id="area" value="Area" 
				onblur="if (this.value == '') {this.value = 'Area';}"
 onfocus="if (this.value == 'Area') {this.value = '';}"/>
            </li>
			
			
			 <li>
                <button class="k-button" id="btnSubmit">Save Project</button>
            </li>
			
        </ul>
		
        <style scoped>
            .forms {
                float: left;
            }

            .forms li {
                margin-bottom: 5px;
                list-style: none;
            }

            .forms li > * {
                width: 400px;
            }
        </style>
    </div>
</div>

</body>
</html>

php code to Insert data in mysql

<?php
header('Content-Type: application/json');
header('Access-Control-Allow-Origin: *');
header("Access-Control-Allow-Methods: POST, GET");
header("Access-Control-Allow-Headers: x-requested-with");


mysql_connect("localhost", "root", "") or die("Connection Failed");
mysql_select_db("property")or die("Connection Failed");


$bname = $_POST['buildername'];
$pname = $_POST['projectname'];
$uploadfiles = addslashes (file_get_contents($_FILES['files']['tmp_name']));

$image = getimagesize($_FILES['files']['tmp_name']);//to know about image type etc
$imgtype = $image['mime'];
//$query = "UPDATE test SET password = '$password' WHERE name = '$user'";



$query = "INSERT INTO projects (buildername, projectname, img) VALUES('$bname','$pname','$uploadfiles')";
if(mysql_query($query)){
echo "updated";}
else{
echo "fail";}

?>

Please correct me where i am wrong.

Thanks a lot for your time

dodgeitorelse3 · June 25, 2013

you are mostly wrong by not giving us any info as to why you think something is wrong ..... we have better things to do than sit and sift through your code trying to find something that may or may not be correct. If you want an answer then you should follow the posting guidelines.

TOA · June 25, 2013

Also, you should be storing the actual image to your server and just the path to it in the db.

ginerjm · June 25, 2013

As TOA says - you should NOT be posting the image itself to a table. Assign a folder(s) for your image(s) and then store the path/name in the table. Standard procedure.

Sign In

Saving image to mysql, help needed

Recommended Posts

ersaurabh101

Link to comment

Share on other sites

dodgeitorelse3

Link to comment

Share on other sites

TOA

Link to comment

Share on other sites

ginerjm

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information