SHARE
TWEET

Untitled

a guest Aug 12th, 2016 112 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <html>
  2. <head>
  3. <script>
  4. function showUser(str) {
  5.     if (str == "") {
  6.         document.getElementById("txtHint").innerHTML = "";
  7.         return;
  8.     } else {
  9.         if (window.XMLHttpRequest) {
  10.             // code for IE7+, Firefox, Chrome, Opera, Safari
  11.             xmlhttp = new XMLHttpRequest();
  12.         } else {
  13.             // code for IE6, IE5
  14.             xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
  15.         }
  16.         xmlhttp.onreadystatechange = function() {
  17.             if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
  18.                 document.getElementById("txtHint").innerHTML = xmlhttp.responseText;
  19.             }
  20.         };
  21.         xmlhttp.open("GET","testmysql.php?q="+str,true);
  22.         xmlhttp.send();
  23.     }
  24. }
  25. </script>
  26. </head>
  27. </html>
  28.    
  29. <html>
  30. <head>
  31. <script type="text/javascript" src="show.js"></script>
  32. <style>
  33. table {
  34.     width: 100%;
  35.     border-collapse: collapse;
  36. }
  37.  
  38. table, td, th {
  39.     border: 1px solid black;
  40.     padding: 5px;
  41. }
  42.  
  43. th {text-align: left;}
  44. </style>
  45. </head>
  46. <body>
  47.  
  48.  
  49. <?php
  50.  
  51. //Sample Database Connection Script
  52.  
  53. //Setup connection variables, such as database username
  54. //and password
  55. $hostname="localhost";
  56. $username="root";
  57. $password="";
  58. $dbname="grocery";
  59. $usertable="grocery";
  60. $yourfield = "NAME";
  61. $q = intval($_GET['q']);
  62. //Connect to the database
  63. $connection = mysqli_connect($hostname, $username, $password);
  64. mysqli_select_db($connection, $dbname);
  65. $query="SELECT * FROM user WHERE id = '".$q."'";
  66. $result = mysqli_query($connection,$query);
  67.  
  68. echo "<table>
  69. <tr>
  70. <th>Name</th>
  71. <th>Price</th>
  72. <th>Amount</th>
  73. </tr>";
  74. if($result){
  75. while($row = mysqli_fetch_array($result)) {
  76.     echo "<tr>";
  77.     echo "<td>" . $row['NAME'] . "</td>";
  78.     echo "<td>" . $row['PRICE'] . "</td>";
  79.     echo "<td>" . $row['AMOUNT'] . "</td>";
  80.     echo "</tr>";
  81.     }
  82. }
  83. echo "</table>";
  84. mysqli_close($connection);
  85. /*
  86. //Setup our query
  87. //$query = "SELECT * FROM $usertable";
  88.  
  89. Run the Query
  90. $result = mysqli_query($connection,$query);
  91.  
  92. //If the query returned results, loop through
  93. // each result
  94. if($result)
  95. {
  96.   while($row = mysqli_fetch_array($result))
  97.   {
  98.     $name = $row["$yourfield"];
  99.     echo "Name: " . $name;
  100.  
  101.   }
  102. }
  103. */
  104. ?>
  105. </body>
  106. </html>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top