Advertisement
Guest User

Untitled

a guest
Jul 30th, 2015
170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.39 KB | None | 0 0
  1. $query = "UPDATE products
  2. SET products_reference='$varenummer', products_price='$pris'
  3. WHERE products_id='$id';";
  4.  
  5. for ($x = 1; $x <= $amountOfLanguages; $x++) {
  6. $varenavn = $_POST["varenavn-" . $x];
  7. $korttekst = $_POST["korttekst-" . $x];
  8. $langtekst = $_POST["langtekst-" . $x];
  9.  
  10. $query .= "IF EXISTS (SELECT * FROM products_description WHERE products_id='$id' AND languages_id='$x')
  11. UPDATE products_description
  12. SET products_description_name='$varenavn', products_description_short_description='$korttekst', products_description_description='$langtekst'
  13. WHERE products_id='$id'
  14. AND languages_id='$x'
  15. ELSE
  16. INSERT INTO products_description (products_id, languages_id, products_description_name, products_description_short_description, products_description_description)
  17. VALUES ('$id', '$x', '$varenavn', '$korttekst', '$langtekst');";
  18. }
  19.  
  20. if ($conn->multi_query($query) === TRUE) {
  21. //header("Location: ./");
  22. //die();
  23. echo "done";
  24. } else {
  25. echo "Error: " . $query . "<br>" . $conn->error;
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement