sesuaikan saja

<?php
/*mysql> CREATE DATABASE mahasiswa;

mysql> USE mahasiswa;

mysql> CREATE TABLE data_mahasiswa ( nim char(9), nama char(50),
umur int, tempat_lahir char(50), jurusan char (30) );

mysql> DESCRIBE data_mahasiswa;
*/

$host="localhost";
$user="root";
$pass="";
$db="work_mujur";

$mysqli = new mysqli($host, $user, $pass, $db);

/* Membuka Koneksi */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}else{
//evertyhing looks fine

}

printf("Host information: %s\n", $mysqli-> host_info);

$sql="show tables from {$db};";
$sql="describe gmjr_associations";
if ($result = $mysqli->query($sql)) {
                  while ($row = $result->fetch_assoc()) {
                                $ar[]=$row;
                        }
                       echo '<pre>'.print_r( $ar,1);
              }else{

           }

/* Menutup Koneksi */
$mysqli-> close();