inputting data from an array into a database

Question

I am trying to get information into my database and am running into a problem that I am sure I am just making a simple mistake. To update the table I am using:

    $conn->query("update webPrice set price= " . $amazonResult['price'] . " where asin = '" . $amazonResult['asin'] . "'");

$conn is my connection. The price is consistently entered as 0. I know there is information there since when I do print_r($amazonResult) I see everything that I want to insert into the DB. Code to get amazon info is:

    foreach($parsed_xml->GetMyPriceForASINResult as $item ) {
 $asin2 =$item->attributes()->ASIN;
$current = $item->Product;

 $status = $item->attributes()->status;

      if (stristr($status, "Success") == true)
{
        $amazonResult = array(
                        'asin' => $asin2,
            'price' => $current->Offers->Offer->BuyingPrice->ListingPrice,//AttributeSets->children('ns2', true)->
                            );

I think the issue is with my update statement, but I an not sure what it is. The asin info is entered correctly. the fields are price = double and asin = varchar.

EDIT: here is the result of print_r($amazonResult);

Array ( [asin] => SimpleXMLElement Object ( [0] => 0176055452 ) [price] => SimpleXMLElement Object ( [CurrencyCode] => USD [Amount] => 10.11 ) )

Teena Thomas · Accepted Answer · 2012-11-06 19:32:17Z

1

Try, adding quotes ' around $amazonResult['price']

$conn->query("update webPrice set price= '" . $amazonResult['price'] . "' where asin = '" . $amazonResult['asin'] . "'");

Edit: As per your edit, as the values are in objects,

$conn->query("update webPrice set price= '" . $amazonResult['price']->Amount . "' where asin = '" . $amazonResult['asin']->0 . "'");

edited Nov 6, 2012 at 19:32

answered Nov 6, 2012 at 19:25

Teena Thomas

5,2091 gold badge15 silver badges17 bronze badges

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

3 Comments

Jim Over a year ago

Thanks I just tried your suggestion, and get the same result.

Teena Thomas Over a year ago

Edited my answer, as per the edit in the question. Take a look.

Jim Over a year ago

I knew it would be something simple. Thanks, that worked perfectly.

ppseprus · Accepted Answer · 2012-11-06 19:33:12Z

1

You have to put the names of the table and the fields in between two of this sign: ` And You have to use the ' sign for values. (like coder1984 said)

$conn->query("update `webPrice` set `price` = '" . $amazonResult['price'] . "' where `asin` = '" . $amazonResult['asin'] . "'");

answered Nov 6, 2012 at 19:33

ppseprus

5571 gold badge9 silver badges29 bronze badges

Collectives™ on Stack Overflow

inputting data from an array into a database

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related