Advertisement
Guest User

Untitled

a guest
Mar 15th, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.02 KB | None | 0 0
  1. .makeEditable({
  2. sUpdateURL: "php/upduser.php",
  3.  
  4. sAddURL: "php/adduser.php",
  5. sAddHttpMethod: "POST",
  6. sDeleteHttpMethod: "POST",
  7. sDeleteURL: "DeleteData.php",
  8. "aoColumns": [
  9. { cssclass: "required"},
  10.  
  11. { cssclass: "required" },
  12.  
  13. null,
  14.  
  15. null,
  16. { indicator: 'Saving access level...',
  17. tooltip: 'Click to select access level',
  18. loadtext: 'loading...',
  19. type: 'select',
  20. onblur: 'submit',
  21. data: "{'':'Please select...', 'admin':'admin','TL':'TL','user':'user','trainer':'trainer'}"
  22. },
  23.  
  24. ],
  25. oAddNewRowButtonOptions: {label: "Add...",
  26. icons: {primary:'ui-icon-plus'}
  27. },
  28. oDeleteRowButtonOptions: {label: "Remove",
  29. icons: {primary:'ui-icon-trash'}
  30. },
  31.  
  32. oAddNewRowFormOptions: {
  33. title: 'Add a new user',
  34. show: "blind",
  35. hide: "slide",
  36. modal: true
  37. } ,
  38. sAddDeleteToolbarSelector: .dataTables_length"
  39.  
  40. });
  41.  
  42. <form id="formAddNewRow" action="#" title="Add a new user" style="width:600px;min-width:600px">
  43. <label for="member_id">Member ID</label><br />
  44. <input type="text" name="member_id" id="member_id" class="required" rel="0" />
  45. <br />
  46. <label for="login">Username</label><br />
  47. <input type="text" name="login" id="login" rel="1" />
  48. <input type="hidden" name="name" rel="2" />
  49. <input type="hidden" name="surname" rel="3" />
  50.  
  51. <br />
  52. <label for="security">Access Level</label><br />
  53. <select name="security" id="security" rel="4">
  54. <option>admin</option>
  55. <option>TL</option>
  56. <option>user</option>
  57. <option>trainer</option>
  58. </select>
  59. <br />
  60.  
  61. </form>
  62.  
  63. <?php
  64.  
  65. $database="***";
  66. $host="***";
  67. $user="****";
  68. $password="***";
  69. $table="members";
  70.  
  71. mysql_connect($host,$user,$password);
  72. mysql_select_db($database) or die( "Unable to select database");
  73.  
  74.  
  75.  
  76.  
  77. $member = $_POST['member_id'];
  78. $username = $_POST['login'];
  79. $security = $_POST['security'];
  80.  
  81.  
  82. $query = "insert into $table (member_id, login, security) values ("$member", "$username", "$security")";
  83.  
  84. $result = mysql_query($query);
  85.  
  86.  
  87. if (!$result) { echo "Insert failed"; }
  88. else { echo "ok"; }
  89.  
  90. mysql_close();
  91. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement