Advertisement
densuz

Warning: mysql_connect

Dec 26th, 2016
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.48 KB | None | 0 0
  1. <?php
  2. $host = "localhost";//server mysql default pada cpanel : localhost
  3. $username = "root"; //user database mysql
  4. $password = ""; //password database mysql
  5. $dbname = "dxxxd"; //nama database mysql
  6. $config = mysql_connect($host,$username,$password) or die(mysql_error());
  7. mysql_select_db($dbname) or die(mysql_error());
  8. mysql_query("SET NAMES utf8");
  9. mysql_query("CREATE TABLE IF NOT EXISTS `api` ( `api` varchar(32) NOT NULL, `author` varchar(32) NOT NULL, `status` varchar(32) NOT NULL, `date` varchar(255), PRIMARY KEY (`api`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8");
  10. mysql_query("CREATE TABLE IF NOT EXISTS `invitecode` ( `Num` varchar(32) NOT NULL, `Author` varchar(32) NOT NULL, `Registered` varchar(32) NOT NULL, `Date` varchar(255), `Regby` varchar(255) NOT NULL, PRIMARY KEY (`Num`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8");
  11. mysql_query("CREATE TABLE IF NOT EXISTS `invitecodepaid` ( `Num` varchar(32) NOT NULL, `Author` varchar(32) NOT NULL, `Registered` varchar(32) NOT NULL, `Date` varchar(255), `Regby` varchar(255) NOT NULL, PRIMARY KEY (`Num`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8");
  12. mysql_query("CREATE TABLE IF NOT EXISTS `invitecodeforpaid` ( `Num` varchar(32) NOT NULL, `Author` varchar(32) NOT NULL, `Registered` varchar(32) NOT NULL, `Date` varchar(255), `Regby` varchar(255) NOT NULL, PRIMARY KEY (`Num`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8");
  13. mysql_query("CREATE TABLE IF NOT EXISTS `giftcode` ( `num` varchar(32) NOT NULL, `author` varchar(32) NOT NULL, `amount` varchar(32) NOT NULL, `registered` varchar(32) NOT NULL, `date` varchar(255), `regby` varchar(255) NOT NULL, PRIMARY KEY (`num`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8");
  14. mysql_query("CREATE TABLE IF NOT EXISTS `orders` ( `id` varchar(32) NOT NULL, `email` varchar(32) NOT NULL, `amount` varchar(32) NOT NULL, `credit` varchar(32) NOT NULL, `payment` varchar(255) NOT NULL, `date` varchar(255), PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8");
  15. mysql_query("CREATE TABLE IF NOT EXISTS `user` (`email` varchar(32) NOT NULL, `password` varchar(255) NOT NULL, `credits` varchar(255) NOT NULL, `banned` varchar(255) NOT NULL, `admin` varchar(255) NOT NULL,`orders` varchar(255) NOT NULL, `regby` varchar(32) NOT NULL, `invitecode` varchar(255) NOT NULL, PRIMARY KEY (`email`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8");
  16. mysql_query("CREATE TABLE IF NOT EXISTS `news`( `id` int(5) NOT NULL auto_increment,`message` varchar(300) NOT NULL, `date` varchar(300) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8");
  17.  
  18.  
  19.  
  20. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement