Advertisement
Guest User

Soos

a guest
Feb 25th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.63 KB | None | 0 0
  1. if($msg == '/setup') {
  2.   $servername = "localhost";
  3.   $username = "root";
  4.   $password = "databasebot";
  5.   $dbname = "bots";
  6.   try {
  7.       $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  8.       $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  9.       $sql = "CREATE TABLE chatdata (
  10.    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  11.    chatid VARCHAR(30) NOT NULL,
  12.    username VARCHAR(30) NOT NULL
  13.    )";
  14.       $conn->exec($sql);
  15.       sm($chatID, "Fatto! Ho Creato La Tabella");
  16.       }
  17.   catch(PDOException $e){
  18.       echo $sql . "<br>" . $e->getMessage();
  19.       }
  20. $conn = null;
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement