Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.52 KB | None | 0 0
  1. $templatesf = $DB->query('SELECT * FROM templates WHERE category="something"');
  2.  
  3. function changesomething(selse){
  4. if (selse == '1'){
  5. something = 'this'
  6. }else{
  7. something = 'that'
  8. }
  9. }
  10.  
  11. <html>
  12. <head>
  13. <script language="javascript" type="text/javascript">
  14.  
  15. //Browser Support Code
  16. function ajaxFunction(){
  17. var ajaxRequest; // The variable that makes Ajax possible!
  18.  
  19. try{
  20. // Opera 8.0+, Firefox, Safari
  21. ajaxRequest = new XMLHttpRequest();
  22. }
  23. catch (e){
  24. // Internet Explorer Browsers
  25. try{
  26. ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
  27. }
  28. catch (e) {
  29. try{
  30. ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
  31. }
  32. catch (e){
  33. // Something went wrong
  34. alert("Your browser broke!");
  35. return false;
  36. }
  37. }
  38. }
  39. // Create a function that will receive data
  40. // sent from the server and will update
  41. // div section in the same page.
  42. ajaxRequest.onreadystatechange = function(){
  43. if(ajaxRequest.readyState == 4){
  44. var ajaxDisplay = document.getElementById('ajaxDiv');
  45. ajaxDisplay.innerHTML = ajaxRequest.responseText;
  46. }
  47. }
  48. // Now get the value from user and pass it to
  49. // server script.
  50. var somedata = document.getElementById('something').value;
  51. var queryString = "?something=" + somedata ;
  52. ajaxRequest.open("GET", "ajax-example.php" +
  53. queryString, true);
  54. ajaxRequest.send(null);
  55. }
  56. </script>
  57. </head>
  58. <body>
  59. <form name='myForm'>
  60. Something: <input type='text' id='something' /> <br />
  61.  
  62. <input type='button' onclick='ajaxFunction()'
  63. value='Query MySQL'/>
  64. </form>
  65. <div id='ajaxDiv'>Your result will display here</div>
  66. </body>
  67. </html>
  68.  
  69. <?php
  70. $dbhost = "localhost";
  71. $dbuser = "dbusername";
  72. $dbpass = "dbpassword";
  73. $dbname = "dbname";
  74. //Connect to MySQL Server
  75. mysql_connect($dbhost, $dbuser, $dbpass);
  76. //Select Database
  77. mysql_select_db($dbname) or die(mysql_error());
  78. // Retrieve data from Query String
  79. $something = $_GET['something'];
  80.  
  81. // Escape User Input to help prevent SQL Injection
  82. $something = mysql_real_escape_string($something);
  83. //build query
  84. $query = "SELECT * FROM ajax_example WHERE something = '$something'";
  85. $qry_result = mysql_query($query) or die(mysql_error());
  86.  
  87. //Build Result String
  88. $display_string = "<table>";
  89. $display_string .= "<tr>";
  90. $display_string .= "<th>Name</th>";
  91. $display_string .= "<th>something</th>";
  92. $display_string .= "<th>other</th>";
  93. $display_string .= "<th>blahblah</th>";
  94. $display_string .= "</tr>";
  95.  
  96. // Insert a new row in the table for each person returned
  97. while($row = mysql_fetch_array($qry_result)){
  98. $display_string .= "<tr>";
  99. $display_string .= "<td>$row[name]</td>";
  100. $display_string .= "<td>$row[something]</td>";
  101. $display_string .= "<td>$row[other]</td>";
  102. $display_string .= "<td>$row[blahblah]</td>";
  103. $display_string .= "</tr>";
  104.  
  105. }
  106. echo "Query: " . $query . "<br />";
  107. $display_string .= "</table>";
  108. echo $display_string;
  109. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement