Advertisement
Guest User

Untitled

a guest
Nov 6th, 2013
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.67 KB | None | 0 0
  1. <?php
  2.  
  3. if (isset($_POST['submit1'])) {
  4. $tablename=$_POST['createtable'];
  5. include('../../../php/db_connect.php');
  6. $sql = "CREATE TABLE `domain_com_db`.`".$tablename."` (`id` INT(4) NOT NULL AUTO_INCREMENT, `fornavn` VARCHAR(20) NOT NULL,
  7.  
  8. `efternavn` VARCHAR(30) NOT NULL, `email`
  9. VARCHAR(50) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM";
  10. mysql_query($sql);
  11. }
  12. if (isset($_POST['submit2'])) {
  13. $tablename=$_POST['deletetable'];
  14. include('../../../php/db_connect.php');
  15. $sql = "DROP TABLE `".$tablename."`";
  16. mysql_query($sql);
  17. mysql_close();
  18. }
  19. ?>
  20. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
  21. "http://www.w3.org/TR/html4/loose.dtd">
  22. <html>
  23. <head>
  24. <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
  25. <title>SQL administrations side der opretter og sletter tabeller på domain.com</title>
  26. </head>
  27. <body>
  28. <?php
  29. if (isset($_POST['submit1']) or ($_POST['submit2'])){}else{
  30. ?>
  31. <form action="test10sql.php" method="post">
  32.   Indtast navnet på den tabel du vil oprette her:&nbsp;<input type="text" name="createtable" id="createtable">
  33.   <input type="submit" name="submit1" id="submit" value="Opret tabel"><br>
  34.   eller indtast navnet på den tabel du vil slette her:&nbsp;<input type="text" name="deletetable" id="deletetable">
  35.   <input type="submit" name="submit2" id="submit" value="Slet tabel">
  36. </form>
  37. <?php
  38. } if(isset($_POST['submit1'])) {
  39. ?>
  40. <p>Tabellen er hermed oprettet, god fornøjelse :-)<br>
  41. <a href="test10sql.php">Opret/slet tabel igen</a></p>
  42. <?php
  43. }  if(isset($_POST['submit2'])) {
  44. ?>
  45. <p>Tabellen er hermed slettet, god fornøjelse :-)<br>
  46. <a href="test10sql.php">Opret/slet tabel igen</a></p>
  47. <?
  48. }
  49. ?>
  50. </body>
  51. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement