Tutorial Gambas Koneksi Mysql Lampp

Cara koneksi data mysql ( kebetulan aku pakai lampp ) dengan Gambas2 langkah - langkahnya,

1. Dalam terminal ketik perintah

sudo su
mkdir /var/run/mysqld
ln -s /opt/lampp/var/mysql/mysql.sock /var/run/mysqld/mysqld.sock

2. Menjalankan lampp

/opt/lampp/lampp start

3. Jalankan Gambas2 buat projek baru, Klik Proyek -> Propeti -> Klik Tab Komponen, beri tanda centang pada gb.db, gb.db.fom dan gb.db.mysql

4. Code Koneksi

' Gambas class file
h AS String
A AS Connection

PUBLIC SUB Form_Open()
DIM t AS String
    t = "Hai selamat datang di Gambas Ubuntu"
    Message(t)
    A = NEW Connection
END

PUBLIC SUB Button2_Click()
 konek()
END
PUBLIC PROCEDURE konek()
  WITH A
       .Close() 'Tutup koneksi
       .Type = "mysql" ' Type database
       .Host = "localhost" ' Nama server
       .Login = "hans" ' User
       .Port = "3306" ' Port mysql 3306
       .Name = "test" ' nama database
       .Password = "123456" ' password user
       .Open() ' buka koneksi
   END WITH
END