<?php
/**
 * Universal connector test 0.1
 *
 * @author mario
 */

$host = '';
$db = '';
$username = '';
$password = '';

?>
<p>
<form>
<textarea name="query">
<?php echo htmlentities($_POST['query']); ?>
</textarea>
<input type="submit" />
</form>
</p>
<?php if(isset($_POST['query']) && $_POST['query']) { ?>
    <p>
    <?php
        # MySQL
        $link = mysql_connect($host, $username, $password);
        mysql_select_db($db,$link);

        if($res = mysql_query($_POST['query'], $link)) {
            var_dump(mysql_fetch_row($res));
        } else {
            var_dump(mysql_error());
        }
    ?>
    </p>
    <p>
    <?php
        # MySQLI
        $link = new mysqli($host, $username, $password, $db);
        if($res = $link->query($_POST['query'])) {
            var_dump($res->fetch_row());
        } else {
            var_dump($link->error);
        }
    ?>
    </p>
    <p>
    <?php
        $link = new PDO('mysql:host='.$host.';port=3306;dbname='.$db, $username, $password);
        if($res = $link->query($_POST['query'])) {
            foreach($res as $row) {
                var_dump($row);
            }
        } else {
            var_dump($link->errorInfo());
        }
    ?>
    </p>
<?php } ?>