Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2016
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.93 KB | None | 0 0
  1. <script src="http://code.jquery.com/jquery-1.10.2.js"></script>
  2. <script>
  3. function showEdit(editableObj) {
  4. $(editableObj).css("background","#FFF");
  5. }
  6.  
  7. function saveToDatabase(editableObj,column,id) {
  8. $(editableObj).css("background","#FFF url(loaderIcon.gif) no-repeat right");
  9. $.ajax({
  10. url: "saveedit.php",
  11. type: "POST",
  12. data:'column='+column+'&editval='+editableObj.innerHTML+'&id='+id,
  13. success: function(data){
  14. $(editableObj).css("background","#FDFDFD");
  15. }
  16. });
  17. }
  18. </script>
  19.  
  20. <table class="tabletheme" width="100%" border="0" cellspacing="0" cellpadding="0">
  21. <tr>
  22. <th scope="col">Name</th>
  23. </tr>
  24. <tr>
  25. <td align="left" valign="top" contenteditable="true">
  26. <p>John Doe<br>
  27. 555 West Ave<br>
  28. Mt Olive, CA 04053
  29. </p></td>
  30. </tr>
  31. </table>
  32.  
  33. <?php
  34. require_once("dbcontroller.php");
  35. $db_handle = new DBController();
  36. $result = mysql_query("UPDATE tbl_employee set " . $_POST["column"] . " = '".$_POST["editval"]."' WHERE id=".$_POST["id"]);
  37. ?>
  38.  
  39. <?php
  40. class DBController {
  41. private $host = "localhost";
  42. private $user = "dbuser";
  43. private $password = "abc12345";
  44. private $database = "mydatabase";
  45.  
  46. function __construct() {
  47. $conn = $this->connectDB();
  48. if(!empty($conn)) {
  49. $this->selectDB($conn);
  50. }
  51. }
  52.  
  53. function connectDB() {
  54. $conn = mysql_connect($this->host,$this->user,$this->password);
  55. return $conn;
  56. }
  57.  
  58. function selectDB($conn) {
  59. mysql_select_db($this->database,$conn);
  60. }
  61.  
  62. function runQuery($query) {
  63. $result = mysql_query($query);
  64. while($row=mysql_fetch_assoc($result)) {
  65. $resultset[] = $row;
  66. }
  67. if(!empty($resultset))
  68. return $resultset;
  69. }
  70.  
  71. function numRows($query) {
  72. $result = mysql_query($query);
  73. $rowcount = mysql_num_rows($result);
  74. return $rowcount;
  75. }
  76. }
  77. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement