API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 21st, 2019
196
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 5.88 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE html>
  2. <script language="javascript">
  3. function sucesso(){
  4.     setTimeout("window.location='index.php'", 3000);
  5. }
  6. </script>
  7.  
  8. <?php
  9.  
  10. $servername = "localhost";
  11. $username = "root";
  12. $password = "";
  13.  
  14. // Create connection
  15. $conn = mysqli_connect($servername, $username, $password);
  16. // Check connection
  17. if (!$conn) {
  18.     echo "deu ruim<br>";
  19.     die("Connection failed: " . mysqli_connect_error());
  20. }
  21. mysqli_select_db($conn, "myDB");
  22.  
  23. // Create database
  24. $sql = "CREATE DATABASE IF NOT EXISTS myDB";
  25. if (mysqli_query($conn, $sql)) {
  26.     // echo "Database created successfully<br>";
  27. } else {
  28.     // echo "Error creating database: " . mysqli_error($conn);
  29. }
  30. mysqli_query($conn, "USE myDB");
  31. mysqli_query($conn, "DROP TABLE IF EXISTS usuarios");
  32. if (mysqli_query($conn, "CREATE TABLE IF NOT EXISTS usuarios(
  33. id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  34.   nome VARCHAR(100) NOT NULL,
  35.   idade VARCHAR(100) NOT NULL,
  36.   senha VARCHAR(100) NOT NULL,
  37.   email VARCHAR(100) NOT NULL,
  38.   telefone VARCHAR(100) NOT NULL,
  39.   p01 VARCHAR(100) NOT NULL,
  40.   p02 VARCHAR(100) NOT NULL,
  41.   p03 VARCHAR(100) NOT NULL,
  42.   p04 VARCHAR(100) NOT NULL,
  43.   p05 VARCHAR(100) NOT NULL,
  44.   p06 VARCHAR(100) NOT NULL,
  45.   p07 VARCHAR(100) NOT NULL,
  46.   p08 VARCHAR(100) NOT NULL,
  47.   p09 VARCHAR(100) NOT NULL,
  48.   p10 VARCHAR(100) NOT NULL,
  49.   p11 VARCHAR(100) NOT NULL,
  50.   p12 VARCHAR(100) NOT NULL,
  51.   p13 VARCHAR(100) NOT NULL
  52.   )")) {
  53.    // echo "Criou tabela usuario<br>";
  54.    } else {
  55.        // echo "Nao criou tabela: " . mysqli_error($conn);
  56.    }
  57.  
  58. if (mysqli_query($conn, "CREATE TABLE IF NOT EXISTS grupos(
  59. id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
  60. )")) {
  61. // echo "Criou tabela grupos<br>";
  62. } else {
  63.     // echo "Nao criou tabela: " . mysqli_error($conn);
  64. }
  65.  
  66. mysqli_query($conn, "DROP TABLE IF EXISTS usuario_grupo");
  67. if (mysqli_query($conn, "CREATE TABLE IF NOT EXISTS usuario_grupo(
  68. id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  69.   usuario VARCHAR(100) NOT NULL,
  70.   grupo VARCHAR(100) NOT NULL
  71.   )")) {
  72.    // echo "Criou tabela usuario - grupos<br>";
  73.    } else {
  74.        // echo "Nao criou tabela: " . mysqli_error($conn);
  75.    }
  76.  
  77. mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
  78.     p01,
  79.     p02,
  80.     p03,
  81.     p04,
  82.     p05,
  83.     p06,
  84.     p07,
  85.     p08,
  86.     p09,
  87.     p10,
  88.     p11,
  89.     p12,
  90.     p13
  91.     ) VALUES (NULL, 'thais', '42', 'senha123', 'email123', '123',
  92.     '3',
  93.     '2',
  94.     '3',
  95.     '2',
  96.     '5',
  97.     '1',
  98.     '1',
  99.     '1',
  100.     '1',
  101.     '7',
  102.     '3',
  103.     '2',
  104.     '1')
  105. ");
  106.  
  107. mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
  108.     p01,
  109.     p02,
  110.     p03,
  111.     p04,
  112.     p05,
  113.     p06,
  114.     p07,
  115.     p08,
  116.     p09,
  117.     p10,
  118.     p11,
  119.     p12,
  120.     p13
  121.     ) VALUES (NULL, 'brunonog', '47', 'senha123', 'nubro', '987654868',
  122.     '1',
  123.     '3',
  124.     '1',
  125.     '5',
  126.     '3',
  127.     '3',
  128.     '2',
  129.     '2',
  130.     '1',
  131.     '4',
  132.     '1',
  133.     '1',
  134.     '2')
  135. ");
  136.  
  137. mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
  138.     p01,
  139.     p02,
  140.     p03,
  141.     p04,
  142.     p05,
  143.     p06,
  144.     p07,
  145.     p08,
  146.     p09,
  147.     p10,
  148.     p11,
  149.     p12,
  150.     p13
  151.     ) VALUES (NULL, 'breno', '64', 'senha123', 'brenosocial', '5465113',
  152.     '2',
  153.     '2',
  154.     '3',
  155.     '2',
  156.     '1',
  157.     '1',
  158.     '1',
  159.     '1',
  160.     '2',
  161.     '4',
  162.     '3',
  163.     '1',
  164.     '1')
  165. ");
  166.  
  167. mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
  168.     p01,
  169.     p02,
  170.     p03,
  171.     p04,
  172.     p05,
  173.     p06,
  174.     p07,
  175.     p08,
  176.     p09,
  177.     p10,
  178.     p11,
  179.     p12,
  180.     p13
  181.     ) VALUES (NULL, 'brunomont', '18', 'senha123', 'cabrinha', '666',
  182.     '4',
  183.     '5',
  184.     '5',
  185.     '5',
  186.     '3',
  187.     '2',
  188.     '2',
  189.     '2',
  190.     '1',
  191.     '3',
  192.     '3',
  193.     '2',
  194.     '2')
  195. ");
  196.  
  197. mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
  198.     p01,
  199.     p02,
  200.     p03,
  201.     p04,
  202.     p05,
  203.     p06,
  204.     p07,
  205.     p08,
  206.     p09,
  207.     p10,
  208.     p11,
  209.     p12,
  210.     p13
  211.     ) VALUES (NULL, 'fifi', '25', 'senha123', 'fifififi', '6563115',
  212.     '1',
  213.     '5',
  214.     '5',
  215.     '3',
  216.     '4',
  217.     '2',
  218.     '2',
  219.     '4',
  220.     '1',
  221.     '3',
  222.     '3',
  223.     '2',
  224.     '3')
  225. ");
  226.  
  227. mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
  228.     p01,
  229.     p02,
  230.     p03,
  231.     p04,
  232.     p05,
  233.     p06,
  234.     p07,
  235.     p08,
  236.     p09,
  237.     p10,
  238.     p11,
  239.     p12,
  240.     p13
  241.     ) VALUES (NULL, 'chico', '52', 'senha123', 'froma', '6969',
  242.     '2',
  243.     '1',
  244.     '1',
  245.     '3',
  246.     '2',
  247.     '2',
  248.     '1',
  249.     '1',
  250.     '2',
  251.     '3',
  252.     '1',
  253.     '1',
  254.     '5')
  255. ");
  256.  
  257. mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
  258.     p01,
  259.     p02,
  260.     p03,
  261.     p04,
  262.     p05,
  263.     p06,
  264.     p07,
  265.     p08,
  266.     p09,
  267.     p10,
  268.     p11,
  269.     p12,
  270.     p13
  271.     ) VALUES (NULL, 'rennan', '19', 'senha123', 'renao', '6545651',
  272.     '2',
  273.     '1',
  274.     '2',
  275.     '3',
  276.     '2',
  277.     '3',
  278.     '1',
  279.     '1',
  280.     '1',
  281.     '2',
  282.     '2',
  283.     '1',
  284.     '3')
  285. ");
  286.  
  287. mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
  288.     p01,
  289.     p02,
  290.     p03,
  291.     p04,
  292.     p05,
  293.     p06,
  294.     p07,
  295.     p08,
  296.     p09,
  297.     p10,
  298.     p11,
  299.     p12,
  300.     p13
  301.     ) VALUES (NULL, 'isadora', '30', 'senha123', 'izabella', '5645955',
  302.     '1',
  303.     '1',
  304.     '2',
  305.     '5',
  306.     '5',
  307.     '3',
  308.     '2',
  309.     '1',
  310.     '1',
  311.     '4',
  312.     '2',
  313.     '1',
  314.     '4')
  315. ");
  316.  
  317. mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
  318.     p01,
  319.     p02,
  320.     p03,
  321.     p04,
  322.     p05,
  323.     p06,
  324.     p07,
  325.     p08,
  326.     p09,
  327.     p10,
  328.     p11,
  329.     p12,
  330.     p13
  331.     ) VALUES (NULL, 'anaflavia', '25', 'senha123', 'ana', '84865555',
  332.     '1',
  333.     '2',
  334.     '4',
  335.     '1',
  336.     '3',
  337.     '4',
  338.     '1',
  339.     '1',
  340.     '2',
  341.     '2',
  342.     '1',
  343.     '1',
  344.     '1')
  345. ");
  346.  
  347. mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
  348.     p01,
  349.     p02,
  350.     p03,
  351.     p04,
  352.     p05,
  353.     p06,
  354.     p07,
  355.     p08,
  356.     p09,
  357.     p10,
  358.     p11,
  359.     p12,
  360.     p13
  361.     ) VALUES (NULL, 'laura', '37', 'senha123', 'lauritadoida', '1564654',
  362.     '3',
  363.     '3',
  364.     '4',
  365.     '4',
  366.     '1',
  367.     '1',
  368.     '2',
  369.     '1',
  370.     '1',
  371.     '3',
  372.     '3',
  373.     '3',
  374.     '3')
  375. ");
  376.  
  377. mysqli_query($conn, "INSERT INTO usuarios (id, nome, idade, senha, email, telefone,
  378.     p01,
  379.     p02,
  380.     p03,
  381.     p04,
  382.     p05,
  383.     p06,
  384.     p07,
  385.     p08,
  386.     p09,
  387.     p10,
  388.     p11,
  389.     p12,
  390.     p13
  391.     ) VALUES (NULL, 'juliana', '24', 'senha123', 'jujubinha', '5163142',
  392.     '4',
  393.     '5',
  394.     '1',
  395.     '5',
  396.     '5',
  397.     '3',
  398.     '3',
  399.     '1',
  400.     '1',
  401.     '6',
  402.     '4',
  403.     '2',
  404.     '5')
  405. ");
  406.  
  407.  
  408. echo "Colocou<br>";
  409. echo"<script language='javascript'>sucesso()</script";
  410.  
  411. mysqli_close($conn);
  412.  
  413. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!