Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. $sql = "INSERT INTO fetss.ocs_extended(ocsID, internalNOTE)
  2. VALUES('" .(int)$_POST['id'] ."', '". $db- >quote($_POST['note_desc']) ."')
  3. ON DUPLICATE KEY UPDATE internalNOTE = VALUES('". $db->quote($_POST['note_desc']) ."')";
  4.  
  5. $sql = "INSERT INTO database.tablename(ID, Description)
  6. VALUES(ID, Description) on Duplicate Key Update Description = VALUES(Description)"
  7.  
  8. $sql = sprintf("INSERT INTO fetss.ocs_extended(`ocsID`, `internalNOTE`)
  9. VALUES(%d, '%s')
  10. ON DUPLICATE KEY UPDATE
  11. `internalNOTE` = VALUES(`internalNOTE`)",
  12. (int)$_POST['id'],
  13. $db->quote($_POST['note_desc']));
  14.  
  15. INSERT INTO foo (id, desc) VALUES(1, 'testing')
  16. ON DUPLICATE KEY UPDATE
  17. desc = 'some other string that is not testing';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement