Guest User

Untitled

a guest
Dec 23rd, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.73 KB | None | 0 0
  1. <?PHP
  2.  
  3. $MysqlHost = "localhost";
  4. $MysqlUsername = "root";
  5. $MysqlPassword = "";
  6.  
  7. mysql_connect($Mysqlhost, $MysqlUsername, $MysqlPassword) or die(mysql_error());
  8. mysql_select_db("socialking") or die(mysql_error());
  9.  
  10. $Query = "CREATE TABLE sitestats(
  11. id INT NOT NULL AUTO_INCREMENT,
  12. PRIMARY KEY(id)
  13. )";
  14.  
  15. mysql_query($Query) or die(mysql_error());
  16.  
  17. echo "Site stats table created!";
  18.  
  19. // Not even sure if a dedicated user table is going to be necessary -
  20. // there mig
  21. $Query = "CREATE TABLE users(
  22. id INT NOT NULL AUTO_INCREMENT,
  23. PRIMARY KEY(id)
  24. )";
  25.  
  26. mysql_query($Query) or die (mysql_error());
  27.  
  28. echo "Users table created!";
  29.  
  30. $Query = "CREATE TABLE pastkings(
  31. id INT NOT NULL AUTO_INCREMENT,
  32. name VARCHAR(40)
  33. )";
  34.  
  35. ?>
Add Comment
Please, Sign In to add comment