JesuisEva

on select write to database

Jun 21st, 2016
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <!-- HTML -->
  2. <form method="post">
  3. <select name="priority" class="field80" onChange="updatePriority('<?=$item['exception_id']?>')" style="margin:0;" <?=$disabled?>>
  4. <option value="high">high</option>
  5. <option value="medium">medium</option>
  6. <option value="low">low</option>
  7. </select>
  8. </form>
  9.  
  10. <!-- jQuery -->
  11. <script type="text/javascript">
  12. function updatePriority(exception_id){
  13. $.ajax({
  14. data: data,
  15. type: 'post',
  16. url: 'ajax.php?page=ajx_exception_priority',
  17. success: function(data){
  18. alert("Data save: "+ data)
  19. }
  20. });
  21. }
  22. </script>
  23.  
  24. <!-- PHP -->
  25. <?php
  26. if (isset($_POST['priority'])) {
  27. query("
  28. UPDATE
  29. `exceptions` (
  30. `priority`)
  31. VALUES (
  32. ". $_POST['priority'] .")
  33. WHERE
  34. `exception_id` = ". $exception_id ."
  35. ");
  36. }
  37. ?>
Advertisement
Add Comment
Please, Sign In to add comment