SQL Queries through subpage not phpmyadmin

[Vendeliko]

Hi,could anyone please give me a script for a subpage through which I can execute sql queries?
What I mean is,instead of going to phpmyadmin to execute a sql query I can just go to for example xxx.com/?subtopic=sqlquery and as soon as I enter it the query executes.

Thanks in advance,
Vendeliko.

 

[Tibiamakers]

which sql query do you want to execute?

 

[Vendeliko]

CREATE TABLE `monkeypay_pg1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(50) NOT NULL,
  `time` int(15) NOT NULL,
  `points` smallint(4) NOT NULL,
  `params` varchar(1024) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

 

[Deleted member 148307]

Just put this querry to *.php file and execute by xxx.com/*.php

Some info about throwing querry to .php: http://php.net/manual/en/function.mysql-query.php

 

[Tibiamakers]

so it will be..something like:
sqlquery.php

<?php
mysql_connect("localhost","root","PASSWORD"); 
mysql_select_db("DATABASE"); 
mysql_query("CREATE TABLE `monkeypay_pg1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account` varchar(50) NOT NULL, `time` int(15) NOT NULL,`points` smallint(4) NOT NULL,`params` varchar(1024) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;");
?>

it's made in php, but the mysql connections I supose that have a function in gesior but I don't know, if somebody knows..but it will work anyway


edit:
remember to put this in index.php

case "sqlquery":
                $topic = "sqlquery";
                $subtopic = "sqlquery";
                include("sqlquery.php");
        break;