upload image with other fileds into db

Question

I want to store my values to db. Also I want to upload one image. My insert query is below. It's not working.

$query = mysql_query("insert into designingoption set name='$name1',positionCode='$pos',assetType='$ass',price='$price',createdOn='$createdon',lastModifiedOn='$laston',lastModifiedBy='$lastby')",$con);

Here name=$name is my image upload field..

$pos=$_POST['position']; $ass=$_POST['asset']; $price=$_POST['price']; $createdon=$_POST['createdon']; $laston=$_POST['laston']; $lastby=$_POST['lastby']; — manoranjani, Dec 29 '12 at 09:22
This is my fields..values are not stored in the database..thats my problem. — manoranjani, Dec 29 '12 at 09:22
Would you please edit your question to include more of your current code, the precise problem you ran into and where you need help - thanks. — SaschaM78, Dec 29 '12 at 09:23
give us what mysql spit out to you, are yout trying to store ur image name of binary of it? — slier, Dec 29 '12 at 09:25

score 0 · Answer 1 · answered Dec 29 '12 at 09:22

0

Not sure whats not working, but, i gotta a pretty good idea the values are not inserted since you used ' (single quote) around $variables.

Try like this.

 $query=mysql_query("insert into designingoption set name='".$name1."',positionCode='".$pos."',assetType='".$ass."',price='".$price."',createdOn='".$createdon."',lastModifiedOn='".$laston."',lastModifiedBy='".$lastby."')",$con);

answered Dec 29 '12 at 09:22

sk8terboi87 ツ

3,396
3
34
45

he use double quote for query, should be no problem.he use single quote to signal mysql that it is a string – slier Dec 29 '12 at 09:24
I see. Thx slier. It'd be great if 'manoranjani' posted lil more details! :0 – sk8terboi87 ツ Dec 29 '12 at 09:29

score 0 · Answer 2 · edited May 23 '17 at 10:24

You have mixed the syntax for the UPDATE and INSERT statements.

Correct syntax:

INSERT INTO designingoption ('name', 'positionCode', 'assetType', 'price', 'createdOn', 'lastModifiedOn', 'lastModifiedBy') VALUES ($pos, $ass, $price, $createdon, $laston, $lastby)

While you're at it, you might also want to consider switching to the mysqli-functions. The mysql-functions are deprecated.

Also be careful of SQL-injection. More information on the subject can be found here.

score 0 · Answer 3 · answered Dec 29 '12 at 10:21

Update your query structure.

INSERT INTO designingoption (name,positionCode,assetType,price,createdOn,lastModifiedOn,lastModifiedBy) VALUES ('$name1','$pos','$ass','$price','$createdon','$laston','$lastby')

Also, make sure that all variables are populated, otherwise you get a PHP notice. It wouldn't hurt to enclose table rows with `, like this:

INSERT INTO `designingoption` (`name`,`positionCode`,`assetType`,`price`,`createdOn`,`lastModifiedOn`,`lastModifiedBy`) VALUES ('$name1','$pos','$ass','$price','$createdon','$laston','$lastby')

Some words are reserved by the system and must be used properly, otherwise you just receive error.

A little research as revealed (even to my surprise) that your syntax is correct. http://dev.mysql.com/doc/refman/5.5/en/insert.html

Would you please edit your question with exact error you're getting?

upload image with other fileds into db

3 Answers3