Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if (isset($_POST['submit1'])) {
- $tablename=$_POST['createtable'];
- include('../../../php/db_connect.php');
- $sql = "CREATE TABLE `domain_com_db`.`".$tablename."` (`id` INT(4) NOT NULL AUTO_INCREMENT, `fornavn` VARCHAR(20) NOT NULL,
- `efternavn` VARCHAR(30) NOT NULL, `email`
- VARCHAR(50) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM";
- mysql_query($sql);
- }
- if (isset($_POST['submit2'])) {
- $tablename=$_POST['deletetable'];
- include('../../../php/db_connect.php');
- $sql = "DROP TABLE `".$tablename."`";
- mysql_query($sql);
- mysql_close();
- }
- ?>
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
- "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
- <title>SQL administrations side der opretter og sletter tabeller på domain.com</title>
- </head>
- <body>
- <?php
- if (isset($_POST['submit1']) or ($_POST['submit2'])){}else{
- ?>
- <form action="test10sql.php" method="post">
- Indtast navnet på den tabel du vil oprette her: <input type="text" name="createtable" id="createtable">
- <input type="submit" name="submit1" id="submit" value="Opret tabel"><br>
- eller indtast navnet på den tabel du vil slette her: <input type="text" name="deletetable" id="deletetable">
- <input type="submit" name="submit2" id="submit" value="Slet tabel">
- </form>
- <?php
- } if(isset($_POST['submit1'])) {
- ?>
- <p>Tabellen er hermed oprettet, god fornøjelse :-)<br>
- <a href="test10sql.php">Opret/slet tabel igen</a></p>
- <?php
- } if(isset($_POST['submit2'])) {
- ?>
- <p>Tabellen er hermed slettet, god fornøjelse :-)<br>
- <a href="test10sql.php">Opret/slet tabel igen</a></p>
- <?
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement