void CMfc2Dlg::OnButton1() { // TODO: Add your control notification handler code here unsigned short Port = 3306; char *IPAddress = "localhost"; char *UserName = "admin"; char *Password = "BroadGate"; char *DBName = "bedrock"; MYSQL *ssock; MYSQL_RES *result; MYSQL_ROW row; //char execsql[500]; ssock = (MYSQL *)malloc(sizeof(MYSQL)); mysql_init(ssock); if(ssock == NULL) { MessageBox("EROR: MySQL ssock init error. \n"); } ssock = mysql_real_connect(ssock, IPAddress, UserName, Password, NULL, Port, NULL, 0); if(!ssock) { MessageBox("conn fail... \n"); mysql_errno(ssock); } else { cout<<" MySql Connected\n"; mysql_query(ssock, "call testproc"); result = mysql_store_result(ssock); num_fields = mysql_num_fields(result); while ((row = mysql_fetch_row(result))) { for(i = 0; i < num_fields; i+=1) { cout<< row[i] << endl; cout<<"\n"; } } mysql_free_result(result); mysql_close(conn); system("pause"); return; } if(mysql_select_db(ssock, DBName) != 0) { MessageBox("select db error. \n"); } }
#include <mysql.h>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)