程序如下:
#include <stdlib.h>
#include <stdio.h>
#include "mysql/mysql.h"
MYSQL my_connection;
MYSQL_RES *res_ptr;
MYSQL_ROW sqlrow;
char *userName="z";//!!!
void display_row();
int main(int argc, char *argv[]) {
int res;
mysql_init(my_connection);
if (mysql_real_connect(my_connection, "localhost", "root",
"111111", "zl", 0, NULL, 0)) {
printf("Connection success\n");
char *sSQL;
sprintf(sSQL,"SELECT username,password FROM user where='%s'",userName);
res = mysql_query(my_connection, sSQL); // changed by ACMAIN
if (res) {
printf("SELECT error: %s\n", mysql_error(my_connection));
} else {
res_ptr = mysql_use_result(my_connection);
if (res_ptr) {
while ((sqlrow = mysql_fetch_row(res_ptr))) {
printf("Fetched data...\n");
display_row();
}
if (mysql_errno(my_connection)) {
printf("Retrive error: %s\n", mysql_error(my_connection));
}
}
mysql_free_result(res_ptr);
}
mysql_close(my_connection);
} else {
fprintf(stderr, "Connection failed\n");
if (mysql_errno(my_connection)) {
fprintf(stderr, "Connection error %d: %s\n",
mysql_errno(my_connection), mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
void display_row() {
unsigned int field_count;
field_count = 0;
while (field_count < mysql_field_count(my_connection)) {
printf("%s ", sqlrow[field_count]);
field_count++;
}
printf("\n");
} 哪位达人知道应该怎么修改啊?小弟初学mysql,就此谢过啦
#include <stdlib.h>
#include <stdio.h>
#include "mysql/mysql.h"
MYSQL my_connection;
MYSQL_RES *res_ptr;
MYSQL_ROW sqlrow;
char *userName="z";//!!!
void display_row();
int main(int argc, char *argv[]) {
int res;
mysql_init(my_connection);
if (mysql_real_connect(my_connection, "localhost", "root",
"111111", "zl", 0, NULL, 0)) {
printf("Connection success\n");
char *sSQL;
sprintf(sSQL,"SELECT username,password FROM user where='%s'",userName);
res = mysql_query(my_connection, sSQL); // changed by ACMAIN
if (res) {
printf("SELECT error: %s\n", mysql_error(my_connection));
} else {
res_ptr = mysql_use_result(my_connection);
if (res_ptr) {
while ((sqlrow = mysql_fetch_row(res_ptr))) {
printf("Fetched data...\n");
display_row();
}
if (mysql_errno(my_connection)) {
printf("Retrive error: %s\n", mysql_error(my_connection));
}
}
mysql_free_result(res_ptr);
}
mysql_close(my_connection);
} else {
fprintf(stderr, "Connection failed\n");
if (mysql_errno(my_connection)) {
fprintf(stderr, "Connection error %d: %s\n",
mysql_errno(my_connection), mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
void display_row() {
unsigned int field_count;
field_count = 0;
while (field_count < mysql_field_count(my_connection)) {
printf("%s ", sqlrow[field_count]);
field_count++;
}
printf("\n");
} 哪位达人知道应该怎么修改啊?小弟初学mysql,就此谢过啦
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货