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

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

?>
<style>
*{font-size:12px;margin:0}input{width:100%;height:30px}
p,textarea{padding:5px;border:1px solid #666}
textarea{width:100%;height:100px}
span{display:block;padding:5px}
h5{padding:5px}
.success{background:#C9FFC9}.fail{background:#FFC9C9}
</style>
<form method="post">
<fieldset>
<textarea name="query">
<?php echo htmlentities($_POST['query']); ?>
</textarea>
</fieldset>
<input type="submit" />
</form>
<?php if(isset($_POST['query']) && $_POST['query']) { ?>
    <h5>mysql_connect</h5>
    <p>
    <?php
        $link = mysql_connect($host, $username, $password);
        mysql_select_db($db,$link);

        if($res = mysql_query($_POST['query'], $link)) {
            echo '<span class="success">';
            var_dump(mysql_fetch_row($res));
        } else {
            echo '<span class="fail">';
            var_dump(mysql_error());
        }
        echo '</span>';
    ?>
    </p>
    <h5>mysqli</h5>
    <p>
    <?php
        # MySQLI
        $link = new mysqli($host, $username, $password, $db);
        if($res = $link->query($_POST['query'])) {
            echo '<span class="success">';
            var_dump($res->fetch_row());
        } else {
            echo '<span class="fail">';
            var_dump($link->error);
        }
        echo '</span>';
    ?>
    </p>
    <h5>PDO</h5>
    <p>
    <?php
        $link = new PDO('mysql:host='.$host.';port=3306;dbname='.$db, $username, $password);
        if($res = $link->query($_POST['query'])) {
            echo '<span class="success">';
            foreach($res as $row) {
                var_dump($row);
            }
        } else {
            echo '<span class="fail">';
            var_dump($link->errorInfo());
        }
        echo '</span>';
    ?>
    </p>
    <h5>ODBC</h5>
    <p>
    <?php
        $link = odbc_connect('DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database='.$db, $username, $password);
        if($res = odbc_exec($link, $_POST['query'])) {
            echo '<span class="success">';
            var_dump(odbc_fetch_array($res));
        } else {
            echo '<span class="fail">';
            var_dump(odbc_error());
        }
        echo '</span>';
    ?>
    </p>
<?php } ?>