API

I see that lots of c/c++ authors are looking for MySQL API examples
in c/c++. So I thought to make MySQL C API
examples in this web site. And in near future I will publish this as
book with a full web system
as bonus.

Since my return to my country Bangladesh, I've got so much time to
myself and thought to contribute
to the GNU applications that I use most ( ie, MySQL,FreeBSD,CGICC,GCC),
while my country and government
catches up with me. (phhhhoooooooo)

Prior to this I have contributed the mysql_last_value(),
released http://www.DhakaStockExchangeGame.com
http://www.NYSEGame.com and now going to release this.

-Jahan Saturday, September
25, 2004 03:28:23 PM

Aftab Jahan Subedar
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
North Jatrabari
Dhaka 1204
Bangladesh
http://www.DhakaStockExchangeGame.com/
http://www.NYSEGame.com/
http://www.CEOBangladesh.com/
http://www.geocities.com/jahan.geo/
- mysql_last_value() available here.
Phone://+88027519050
jahan@bol-online.com

Pre-requisite

You should know how to use C/C++, and what is MySQL.

Basic Structure of C/C++
Programs that uses MySQL C/C++ API

All programs must include <mysql/mysql.h> as the last
include.
Define MYSQL type variable. NOTE: THERE CAN BE ONLY ONE
MYSQL VARIABLE. (Sounds like highlander.)
Initialize MYSQL type variable with mysql_init()
Load any options, if required, by using mysql_options(). If you
don't need don't call.
You can call this fuction multiple times if you require. If you call
this, call this before
mysql_real_connect() and after mysql_init().
Connect by calling mysql_real_connect()
Call the business logic and MySQL API's
Close the MYSQL type variable.

An infra structure

#include <mysql/mysql.h>

return_type function_name(parameters)

{

MYSQL mysql;

mysql_init(&mysql);

mysql_options(&mysql,MYSQL_OPT_COMPRESS,0);/*call only if
required otherwise omit*/

mysql_options(&mysql,MYSQL_READ_DEFAULT_GROUP,"jahans_Dhaka_Stock_Exchange_Game");/*call
only if required otherwise omit*/

mysql_real_connect(....);

/* now call other API's*/

mysql_close(&mysql);

}

Compiling and
Running

Compiling and Running in UNIX

$gcc mysql_app.c -o mysql_app -I/usr/local/include
-L/usr/local/lib/mysql -lmysqlclient

$./mysql_app

Compiling and Running in Visual
C++

-not yet added, will be added
later.

Initialization Examples

Initializing MySQL
API

/*------InitMySQLv1.c--------*/

/*Variation #1*/

/*
Calls:
MYSQL *mysql_init(MYSQL *mysql)
char *mysql_get_server_info(MYSQL *mysql)
void mysql_close(MYSQL *mysql)
*/

#ifdef WIN32
#include <windows.h>
#include <winsock.h>
#pragma warning (disable: 4514 4786)
#pragma warning( push, 3 )
#endif

#include <stdio.h>
#include "mysql/mysql.h"
#ifndef WIN32
#include <unistd.h>
#endif

int main(int argc, char **argv)
{

MYSQL mysql;/* variation #1*/

printf("\n\n\tCopyright Aftab Jahan
Subedar\n\t\thttp://www.geocities.com/jahan.geo");
printf("\n\t\tjahan@geocities.com
\n\t\tPhone:+88027519050\n");

if(mysql_init(&mysql)==NULL)
        {
                printf("\nFailed to initate MySQL
connection");
                exit(1);
        }

/*now you can call any MySQL API function you like*/

mysql_close(&mysql);

}

/*------InitMySQLv2.c--------*/

/*Variation #2*/

/*
Calls:
MYSQL *mysql_init(MYSQL *mysql)
char *mysql_get_server_info(MYSQL *mysql)
void mysql_close(MYSQL *mysql)

#ifdef WIN32
#include <windows.h>
#include <winsock.h>
#pragma warning (disable: 4514 4786)
#pragma warning( push, 3 )
#endif

#include <stdio.h>
#include "mysql/mysql.h"
#ifndef WIN32
#include <unistd.h>
#endif

int main(int argc, char **argv)
{

MYSQL *mysql=NULL;/* variation #2*/

printf("\n\n\tCopyright Aftab Jahan
Subedar\n\t\thttp://www.geocities.com/jahan.geo");
printf("\n\t\tjahan@geocities.com
\n\t\tPhone:+88027519050\n");

if((mysql=mysql_init(mysql))==NULL)/* variation #2*/
        {
                printf("\nFailed to initate MySQL
connection");
                exit(1);
        }

/*now you can call any MySQL API function you like*/

mysql_close(mysql);

}

Checking
Client Library Version

/*------ClientVersion.c--------*/

/**/

/*
Calls:
MYSQL *mysql_init(MYSQL *mysql)
char *mysql_get_client_info(void)
void mysql_close(MYSQL *mysql)
*/

#ifdef WIN32
#include <windows.h>
#include <winsock.h>
#pragma warning (disable: 4514 4786)
#pragma warning( push, 3 )
#endif

#include <stdio.h>
#include "mysql/mysql.h"
#ifndef WIN32
#include <unistd.h>
#endif

int main(int argc, char **argv)
{

/*Notice: it does not require MYSQL initialization*/

   printf("\n\n\tCopyright Aftab Jahan
Subedar\n\t\thttp://www.geocities.com/jahan.geo");
   printf("\n\t\tjahan@geocities.com
\n\t\tPhone:+88027519050\n");
   printf("MySQL Client Version is
%s\n",mysql_get_client_info());

}

Checking Server
Version

/*------ServerVersion.c--------*/

Calls:
MYSQL *mysql_init(MYSQL *mysql)
char *mysql_get_server_info(void)
void mysql_close(MYSQL *mysql)

#ifdef WIN32
#include <windows.h>
#include <winsock.h>
#pragma warning (disable: 4514 4786)
#pragma warning( push, 3 )
#endif

#include <stdio.h>
#include "mysql/mysql.h"
#ifndef WIN32
#include <unistd.h>
#endif

int main(int argc, char **argv)
{

MYSQL mysql;

mysql_init(&mysql);

mysql_real_connect(&mysql,"subedartech.sytes.net","jahan","shoja_passwd","DBDSE",0,NULL,0))

printf("\n\n\tCopyright Aftab Jahan
Subedar\n\t\thttp://www.geocities.com/jahan.geo");
printf("\n\t\tjahan@geocities.com
\n\t\tPhone:+88027519050\n");
printf("MySQL Server Version is
%s\n",mysql_get_server_info(&mysql));

}

Logging into
MySQL Server

/*------DBLogonv1.c--------*/

/*Variation #1*/

/*
MYSQL *mysql_init(MYSQL *mysql)
MYSQL *mysql_real_connect(MYSQL *mysql, const char *host, const char
*user, const char *passwd, const char *db,
unsigned int port, const char *unix_socket, unsigned int client_flag)
char *mysql_error(MYSQL *mysql)
void mysql_close(MYSQL *mysql)

#ifdef WIN32
#include <windows.h>
#include <winsock.h>
#pragma warning (disable: 4514 4786)
#pragma warning( push, 3 )
#endif

#include <stdio.h>
#include "mysql.h"
#ifndef WIN32
#include <unistd.h>
#endif

int main(int argc, char **argv)
{

MYSQL mysql;

printf("\n\n\tCopyright Aftab Jahan
Subedar\n\t\thttp://www.geocities.com/jahan.geo");
printf("\n\t\tjahan@geocities.com
\n\t\tPhone:+88027519050\n");

if(mysql_init(&mysql)==NULL)
        {
                printf("\nFailed to initate MySQL
connection");
                exit(1);
        }

/*now you can call any MySQL API function you like*/

if
(!mysql_real_connect(&mysql,"subedartech.sytes.net","jahan","shoja_passwd","DBDSE",0,NULL,0))

/*variation #1*/

{

printf( "Failed to connect to MySQL: Error: %s\n",
mysql_error(&mysql));

exit(1);

}

printf("Logged on to database sucessfully");

mysql_close(&mysql);

}

/*------DBLogonv2.c--------*/

/*Variation #2 without database
parameter*/

#ifdef WIN32
#include <windows.h>
#include <winsock.h>
#pragma warning (disable: 4514 4786)
#pragma warning( push, 3 )
#endif

#include <stdio.h>
#include "mysql.h"
#ifndef WIN32
#include <unistd.h>
#endif

int main(int argc, char **argv)
{

MYSQL mysql;

printf("\n\n\tCopyright Aftab Jahan
Subedar\n\t\thttp://www.geocities.com/jahan.geo");
printf("\n\t\tjahan@geocities.com
\n\t\tPhone:+88027519050\n");

if(mysql_init(&mysql)==NULL)
        {
                printf("\nFailed to initate MySQL
connection");
                exit(1);
        }

/*now you can call any MySQL API function you like*/

if
(!mysql_real_connect(&mysql,"subedartech.sytes.net","jahan","shoja_passwd",NULL/*variation
#2*/,0,NULL,0))
{
printf( "Failed to connect to MySQL: Error: %s\n",
mysql_error(&mysql));
exit(1);
}

if(mysql_select_db(&mysql,"DhakaStockExchangeGame"
/*const char *db*/)==0)/*success*/
printf( "Database Selected\n");
else
printf( "Failed to connect to Database: Error: %s\n",
mysql_error(&mysql));

mysql_close(&mysql);

}

Changing Logged
user

/*------ChangeUser.c--------*/

#ifdef WIN32
#include <windows.h>
#include <winsock.h>
#pragma warning (disable: 4514 4786)
#pragma warning( push, 3 )
#endif

#include <stdio.h>
#include "mysql.h"
#ifndef WIN32
#include <unistd.h>
#endif

int main(int argc, char **argv)
{

MYSQL mysql;

printf("\n\n\tCopyright Aftab Jahan
Subedar\n\t\thttp://www.geocities.com/jahan.geo");
printf("\n\t\tjahan@geocities.com
\n\t\tPhone:+88027519050\n");

if(mysql_init(&mysql)==NULL)
        {
                printf("\nFailed to initate MySQL
connection");
                exit(1);
        }

/*now you can call any MySQL API function you like*/

if
(!mysql_real_connect(&mysql,"subedartech.sytes.net","jahan","shoja_passwd","DBDSE",0,NULL,0))

{

printf( "Failed to connect to MySQL: Error: %s\n",
mysql_error(&mysql));

exit(1);

}

printf("Logged on to database sucessfully as jahan.\n going
to change login to web_user.");

if( mysql_change_user(&mysql, "web_user",
"nopassword", "DBDSE")==0)/*warning it initiates
rollback*/
printf("User changed\n);
else
printf("Error occuered:%s",mysql_error(&mysql));

mysql_close(&mysql);

}

Selecting a
Database

/*-------SelectDB.c---------*/

#ifdef WIN32
#include <windows.h>
#include <winsock.h>
#pragma warning (disable: 4514 4786)
#pragma warning( push, 3 )
#endif

#include <stdio.h>
#include "mysql.h"
#ifndef WIN32
#include <unistd.h>
#endif

int main(int argc, char **argv)
{

MYSQL mysql;

printf("\n\n\tCopyright Aftab Jahan
Subedar\n\t\thttp://www.geocities.com/jahan.geo");
printf("\n\t\tjahan@geocities.com
\n\t\tPhone:+88027519050\n");

if(mysql_init(&mysql)==NULL)
        {
                printf("\nFailed to initate MySQL
connection");
                exit(1);
        }

/*now you can call any MySQL API function you like*/

if
(!mysql_real_connect(&mysql,"subedartech.sytes.net","jahan","shoja_passwd",NULL/*variation
#2*/,0,NULL,0))
{
printf( "Failed to connect to MySQL: Error: %s\n",
mysql_error(&mysql));
exit(1);
}

if(mysql_select_db(&mysql,"DhakaStockExchangeGame"
/*const char *db*/)==0)/*success*/
printf( "Database Selected\n");
else
printf( "Failed to connect to Database: Error: %s\n",
mysql_error(&mysql));

mysql_close(&mysql);

}

Data Definition Examples

Creating a
Database

/*-------CreateDB.c---------*/

/*
MYSQL *mysql_init(MYSQL *mysql)
MYSQL *mysql_real_connect

源文档 <http://www.cs.wichita.edu/~chang/lecture/cs742/program/how-mysql-c-api.html>

posted @ 2012-10-04 20:44 hhdllhflower 阅读(442) 评论(0) 收藏举报

刷新页面返回顶部