Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- .makeEditable({
- sUpdateURL: "php/upduser.php",
- sAddURL: "php/adduser.php",
- sAddHttpMethod: "POST",
- sDeleteHttpMethod: "POST",
- sDeleteURL: "DeleteData.php",
- "aoColumns": [
- { cssclass: "required"},
- { cssclass: "required" },
- null,
- null,
- { indicator: 'Saving access level...',
- tooltip: 'Click to select access level',
- loadtext: 'loading...',
- type: 'select',
- onblur: 'submit',
- data: "{'':'Please select...', 'admin':'admin','TL':'TL','user':'user','trainer':'trainer'}"
- },
- ],
- oAddNewRowButtonOptions: {label: "Add...",
- icons: {primary:'ui-icon-plus'}
- },
- oDeleteRowButtonOptions: {label: "Remove",
- icons: {primary:'ui-icon-trash'}
- },
- oAddNewRowFormOptions: {
- title: 'Add a new user',
- show: "blind",
- hide: "slide",
- modal: true
- } ,
- sAddDeleteToolbarSelector: .dataTables_length"
- });
- <form id="formAddNewRow" action="#" title="Add a new user" style="width:600px;min-width:600px">
- <label for="member_id">Member ID</label><br />
- <input type="text" name="member_id" id="member_id" class="required" rel="0" />
- <br />
- <label for="login">Username</label><br />
- <input type="text" name="login" id="login" rel="1" />
- <input type="hidden" name="name" rel="2" />
- <input type="hidden" name="surname" rel="3" />
- <br />
- <label for="security">Access Level</label><br />
- <select name="security" id="security" rel="4">
- <option>admin</option>
- <option>TL</option>
- <option>user</option>
- <option>trainer</option>
- </select>
- <br />
- </form>
- <?php
- $database="***";
- $host="***";
- $user="****";
- $password="***";
- $table="members";
- mysql_connect($host,$user,$password);
- mysql_select_db($database) or die( "Unable to select database");
- $member = $_POST['member_id'];
- $username = $_POST['login'];
- $security = $_POST['security'];
- $query = "insert into $table (member_id, login, security) values ("$member", "$username", "$security")";
- $result = mysql_query($query);
- if (!$result) { echo "Insert failed"; }
- else { echo "ok"; }
- mysql_close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement