php mysql存储过程调用 带参数_调用Mysql存储过程输入输出参数

欢迎进入Linux社区论坛，与200万技术人员互动交流 >>进入 nID = 0; nUserID = 0; nFeaLen = 0; memset(szFea,0,sizeof(szFea))； memset(szUrl,0,sizeof(szUrl))； nType1 = 0; nType2 = 0; nType3 = 0; memset(szType4,0,sizeof(szType4))； me

欢迎进入Linux社区论坛，与200万技术人员互动交流 >>进入

nID = 0;

nUserID = 0;

nFeaLen = 0;

memset(szFea,0,sizeof(szFea))；

memset(szUrl,0,sizeof(szUrl))；

nType1 = 0;

nType2 = 0;

nType3 = 0;

memset(szType4,0,sizeof(szType4))；

memset(szStamp,0,sizeof(szStamp))；

memset(szRemarks,0,sizeof(szRemarks))；

}

}FACE_INFO, *PFACE_INFO;

//调研代码如下

HRESULT CFaceDB::RegFaceP(FACE_INFO info,ULONGLONG & nID)

{

MYSQL_STMT * stmt_mysql = mysql_stmt_init(m_pMysql)；

try

{

MYSQL_BIND bind[11];

memset(bind, 0, sizeof(bind))；

bind[0].buffer_type = MYSQL_TYPE_LONGLONG;

bind[0].buffer = (unsigned char*)&nID;

bind[0].buffer_length = (unsigned long)sizeof(nID)；

bind[0].length = 0;

bind[1].buffer_type = MYSQL_TYPE_LONGLONG;

bind[1].buffer = (unsigned char*)&info.nUserID;

bind[1].buffer_length = (unsigned long)sizeof(info.nUserID)；

bind[1].length = 0;

bind[2].buffer_type = MYSQL_TYPE_SHORT;

bind[2].buffer = (unsigned char*)&info.nFeaLen;

bind[2].buffer_length = (unsigned long)sizeof(info.nFeaLen)；

bind[2].length = 0;

unsigned long nFeaLen = info.nFeaLen;

bind[3].buffer_type = MYSQL_TYPE_BLOB; //特征值

bind[3].buffer = (unsigned char*)info.szFea;

bind[3].buffer_length = (unsigned long)nFeaLen;

bind[3].length = &nFeaLen;

unsigned long nUrlLen = strlen(info.szUrl)；

bind[4].buffer_type = MYSQL_TYPE_STRING; //ImgUrl

bind[4].buffer = (char*)info.szUrl;

bind[4].buffer_length = 64;

bind[4].length = &nUrlLen;

bind[5].buffer_type = MYSQL_TYPE_LONG; //type1

bind[5].buffer = (unsigned char*)&info.nType1;

bind[5].buffer_length = (unsigned long)sizeof(info.nType1)；

bind[5].length = 0;

bind[6].buffer_type = MYSQL_TYPE_LONG; //type2

bind[6].buffer = (unsigned char*)&info.nType2;

bind[6].buffer_length = (unsigned long)sizeof(info.nType2)；

bind[6].length = 0;

bind[7].buffer_type = MYSQL_TYPE_LONG; //type3

bind[7].buffer = (unsigned char*)&info.nType3;

bind[7].buffer_length = (unsigned long)sizeof(info.nType3)；

bind[7].length = 0;

unsigned long nType4Len = strlen(info.szType4)；

bind[8].buffer_type = MYSQL_TYPE_STRING; //typ4

bind[8].buffer = (char*)info.szType4;

bind[8].buffer_length = 32;

bind[8].length = &nType4Len;

unsigned long nRemarksLen = strlen(info.szRemarks)；

bind[9].buffer_type = MYSQL_TYPE_STRING; //remarks

bind[9].buffer = (char*)info.szRemarks;

bind[9].buffer_length = 64;

//bind[9].is_null = 0;

[1] [2] [3]

本文原创发布php中文网，转载请注明出处，感谢您的尊重！