#include <cstdlib>
#include <iostream>
#include <windows.h>
#include <mysql/mysql.h>//library mysql nya <img class="emoji" draggable="false" alt="" src="https://s0.wp.com/wp-content/mu-plugins/wpcom-smileys/twemoji/2/svg/1f642.svg">

using namespace std;

static char *host="localhost"; //hostname
static char *user="root"; //username
static char *pass=""; //password
static char *db="mysql"; //database
static int port=0; //port
static char *soket=NULL; //soket
static int flags=0; //flags
MYSQL *conn; //objek conn
static MYSQL *conection; //objek conection
MYSQL_RES *result;
MYSQL_ROW row;

int main(int argc, char *argv[])
{
    system("color f0");
    string stats;
    conn = mysql_init(NULL);
    if(conn == NULL){
             cout<<"Error!!\n";
             exit(1);
             }
    conection = mysql_real_connect(conn,host,user,pass,db,port,soket,flags);
    //mysql_real_connect => buat koneksi ke database mysql + select database yang mau kita gunakan
    if(conection==NULL){ //untuk mengecek koneksi, apakah terkoneksi apa tidak
             stats="Connection MYSQL None Exist";
                }else{
                      stats="MYSQL Connected";
                      }
                cout<<"Status: "<<stats<<endl<<endl;

    if(mysql_query(conn, "show tables")){//query nya
             cout<<stderr<<mysql_error(conn);
             system("pause");
             exit(1);
             }else{
                   result = mysql_use_result(conn);
                   cout<<"Table on Database : \""<<db<<"\" : \n\n";
                   while((row = mysql_fetch_row(result)) != NULL){
                             cout<<row[0]<<endl; //Display Tabel
                             }
                   }
 	cout<<"\nCredit Dionisius AN GTC\n";
    cout<<endl<<endl;
    system("PAUSE");
    mysql_close(conn);
    return EXIT_SUCCESS;
}