Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
$statement = $conn->prepare("INSERT INTO products (title, cost, price, rrp, sku, weight, main_image, manufacturer_id, ean, enabled, mpn, product_url, forwho) VALUES (:title, :cost, :price, :rrp, :sku, :weight, :main_image, :manufacturer_id, :ean, 2, :mpn, :product_url, :forwho) ON DUPLICATE KEY UPDATE cost=values(cost), price=values(price), rrp=values(rrp), weight=values(weight), main_image=values(main_image), ean=values(ean)");
$statement->execute(array( ':title' => $product->NAME, ':cost' =>$cost, ':price' =>$price, ':rrp' => $product->RRP, ':sku' => $product['ITEM'], ':weight' => $product->WEIGHT, ':main_image' => "/".substr($product->IMAGE,0,1)."/".substr($product->IMAGE,1,1)."/".$product->IMAGE, ':manufacturer_id' => $product->MANUFACTURER_ID, ':ean' => $product->EAN, ':mpn' => $product->MODEL, ':product_url' => $product_url, ':forwho' => $product->FORWHO ));
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!