Jump to content
Sign in to follow this  
game-game

Socket Programming~ngan Database

Recommended Posts

Hye rakan-rakan..

ader sape-sape tau macam mane nak connect socket programming ngan database, ie mysql, tak?

aku dah cari dalam google, still takde.. bleh tunjuk tak camner nak buat? at least untuk login pon jadi r, pastu aku blajar sndri.. aku tak nmpak n takde idea camne nak start..

thanks..

Share this post


Link to post
Share on other sites

ek.. aku dah blajar sket2 pasal socket ngan mysql, aku cube compile ngan cara camni

1. gcc -c -I/usr/include/mysql connect1.c

2. gcc -o connect1 connect1.o -L/usr/include/mysql -lmysqlclient

3 ./connect1

tapi aku dapat segmentation fault pas aku cube run file kat bawah ni dengan name connect1.c

kenape ek?

#include <my_global.h>
#include <my_sys.h>
#include <mysql.h>

static char *opt_host_name = NULL;     // server host (defaul t= localhost)
static char *opt_user_name = NULL;     // username (default = login name)
static char *opt_password = NULL;      // password (default = none)
static unsigned int opt_port_num = 0;    // port number (use built-in value)
static char *opt_socket_name = NULL;   // socket name (use built-in value)
static char *opt_db_name = NULL;       // database name (default = none)
static unsigned int opt_flags = 0;     // connection flags(none)

static MYSQL *conn;

int main (int argc, char *argv[])  {
//initialize connection handler
conn = mysql_init (NULL);
        if (conn = NULL)  {
              fprintf(stderr, "mysql_init() failed (probably out of memory)\n");
              exit(1);
        }
//connect to server
if (mysql_real_connect (conn,opt_host_name, opt_user_name, opt_password,opt_db_name, opt_port_num, opt_socket_name, opt_flags) == NULL)    {
        fprintf(stderr, "mysql_real_connect() failed\n");
        mysql_close (conn);
        exit(1);
    }

//disconnect from server
mysql_close (conn);
exit(0);
}

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...