Advertisement
Guest User

Exemple fichier HTML/PHP

a guest
Mar 29th, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.23 KB | None | 0 0
  1. <?php
  2. if(isset($_GET["t"]) && !empty($_GET["t"]))
  3. {
  4.   $serveur = ""; // A renseigner
  5.   $username = ""; // A renseigner
  6.   $password = ""; // A renseigner
  7.  
  8.   $bdd = mysql_connect($serveur, $username, $password)
  9.     or die("Connection error");
  10.  
  11.   $database_name = "";
  12.  
  13.   mysql_select_db($database_name, $bdd)
  14.     or die("Database connection error");
  15.  
  16.   $sql_request = "SELECT * FROM " . $_GET["t"];
  17.  
  18.   $sql_query = mysql_query($sql_request);
  19.  
  20.   $column1 = ""; // A renseigner
  21.   $column2 = ""; // A renseigner
  22.   $column3 = ""; // A renseigner
  23.  
  24.   echo "<table border='1'>";
  25.  
  26.   while($my_table = mysql_fetch_array($sql_query))
  27.   {
  28.     echo "<tr>";
  29.     echo "<td>" . $my_table[$column1] . "</td>";
  30.     echo "<td>" . $my_table[$column2] . "</td>";
  31.     echo "<td>" . $my_table[$column3] . "</td>";
  32.     echo "</tr>";
  33.   }
  34.  
  35.   echo "</table>";
  36.  
  37.   echo "<a href=''>Go forward</a>";
  38. else
  39. {
  40. ?>
  41.   <!DOCTYPE html>
  42.   <html>
  43.     <head>
  44.       <meta charset="utf-8" />
  45.       <title>My website</title>
  46.     </head>
  47.     <body>
  48.       <form method="GET" action="">
  49.         <input type="text" placeholder="Table's name" name="t" />
  50.           <br />
  51.         <input type="submit" />
  52.       </form>
  53.     </body>
  54.   </html>
  55. <?php
  56. }
  57. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement