Advertisement
Guest User

Untitled

a guest
Aug 9th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. <?php
  2. $field = $_POST["id"];
  3. $column = $_POST["column"];
  4. $value = $_POST["value"];
  5. // make our connection
  6. $connection = pg_connect("host=74.121.80.40 port=5432 dbname=opensips_orig user=opensips password=dfwtdbs!");
  7.  
  8. // let me know if the connection fails
  9. if (!$connection) print("Connection Failed.");
  10.  
  11. //Group Change
  12. if ($column = '1') {
  13. $query = "UPDATE address_test set grp = $value WHERE id = $field";
  14. }
  15. //IP Changes
  16. elseif ($column = '2') {
  17. $query = "UPDATE address_test set ip = '$value' WHERE id = $field";
  18. }
  19. //Mask Change
  20. elseif ($column = '3') {
  21. $query = "UPDATE address_test set mask = $value WHERE id = $field";
  22. }
  23. //Port Change
  24. elseif ($column = '4') {
  25. $query = "UPDATE address_test set port = $value WHERE id = $field";
  26. }
  27. //Prefix Change
  28. elseif ($column = '5') {
  29. $query = "UPDATE address_test set prefix = '$value' WHERE id = $field";
  30. }
  31. //Description Change
  32. elseif ($column = '6') {
  33. $query = "UPDATE address_test set description = '$value' WHERE id = $field";
  34. }
  35. $result = pg_query($connection, $query) or die(pg_last_error());
  36. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement