_mysql_syain3.php

<form method="post">
    <textarea name="query" style="width:800px;height:250px;"><?= $_POST["query"] ?></textarea>
    <input type="submit" name="send" value="送信">
</form>
 
<?php
require_once("db_connect.php");
 
if ( $_POST["query"] != "" ) {
 
 
    // SQL の実行
    $result = $mysqli->query( $_POST["query"] );
 
    // 列の情報一覧を取得
    $field = $result->fetch_fields( );
 
    print "<pre>";
 
    // 配列の内容を確認
    // print_r( $field );
 
    for( $i = 0; $i < count( $field ); $i++ ) {
 
        print $field[$i]->name . " ";
 
    }
 
    print "\n";
 
 
    // MYSQLI_BOTH
    while ( $row = $result->fetch_array( MYSQLI_BOTH ) ) {
 
        for( $i = 0; $i < count( $field ); $i++ ) {
 
            print $row[$i] . " ";
 
        }
 
        print "\n";
 
        //print "{$row[0]} {$row[1]}\n";
 
    }
    print "</pre>";
 
}
 
// ***************************
// 接続解除
// ***************************
$mysqli->close();
 
?>