· 9 years ago · Jul 27, 2017, 12:40 PM
1$TBWA_DB = new DB(TBWA_DATABASE_SERVER, // server address
2 TBWA_DATABASE_USER,TBWA_DATABASE_PASSWORD, // user and password
3 TBWA_DATABASE_DATABASE, // database
4 TBWA_DATABASE_TABLE_PREFIX // table prefix
5 );
6
7//phpinfo();
8$query = "SHOW TABLES";
9
10//$query = "DROP TABLE test";
11
12$user = "mcmaze";
13$password = "xxxxxx";
14$database = "mcmaze";
15
16mysql_connect("localhost",$user,$password);
17
18mysql_select_db($database) or die("Unable to select db");
19
20var_dump(mysql_query($query));
21$res = mysql_query($query);
22
23if ($res !== FALSE)
24{
25 $row = mysql_num_rows($res);
26 for ($i=0;$i < $row;$i++)
27 {
28 var_dump(mysql_fetch_array($res));
29 }
30}
31
32/*$query = "CREATE TABLE IF NOT EXISTS ".$TBWA_DB->GetTablePrefix()."score ".
33 "(ID INT AUTO_INCREMENT,".
34 "nickname VARCHAR(100),".
35 "gameStartTime DATETIME,".
36 "gameEndTime DATETIME,".
37 "sessionStartTime DATETIME,".
38 "sessionEndTime DATETIME,".
39 "score INT,".
40 "email VARCHAR(200),".
41 "PRIMARY KEY (ID))"; /**/