Advertisement
Guest User

table.php

a guest
Apr 5th, 2020
198
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.62 KB | None | 0 0
  1. <?php
  2.     require_once 'login.php';
  3.     require_once 'error.php';
  4.  
  5.     function create_table() {
  6.         global $hn, $un, $pw, $db;
  7.         $conn = new mysqli($hn, $un, $pw, $db);
  8.         if($conn->connect_error) die(mysqli_fatal_error());
  9.  
  10.         $query = "CREATE TABLE info (
  11.            Id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
  12.            Name VARCHAR(32) NOT NULL,
  13.            Content TEXT NOT NULL,
  14.            PRIMARY KEY (Id)
  15.    )";
  16.  
  17.         $result = $conn->query($query);
  18.         if (!$result) die(mysqli_fatal_error());
  19.  
  20.         if (!$result) $result->close();
  21.         $conn->close();
  22.     }
  23.  
  24.     $flag = false;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement