Ive got MySQL on my local system and would like to
use C++ to connect to the database
I downloaded an example script from mysql.com
but it throws all sorts of errors when i compile
Ive done
#include <mysql.h>
Is there a quick way i can connect to MySQL
Ive installed MyODBC so i just need the
code syntax to make a connection
Anyone know
Marky_Mark
#include <stdio.h>
#include <mysql.h>
#define host "localhost"
#define username "db_username"
#define password "db_password"
#define database "db"
MYSQL *conn;
int main()
{
conn = mysql_init(NULL);
mysql_real_connect(conn,host,username,password,dat abase,0,NULL,0);
MYSQL_RES *res_set;
MYSQL_ROW row;
unsigned int i;
mysql_query(conn,"SELECT * FROM users WHERE userid=1");
res_set = mysql_store_result(conn);
unsigned int numrows = mysql_num_rows(res_set);
while ((row = mysql_fetch_row(res_set)) != NULL)
{
for (i=0; i<mysql_num_fields(res_set); i++)
{
():
printf("%s\n",row[i] != NULL ? row[i] : "NULL");
}
}
mysql_close(conn);
return 0;
}
mfc2themax-Creator of all that is.
also make sure you download and compile the proper library files.
mfc2themax-Creator of all that is.
Thanks
Marky_Mark
Last edited by Marky_Mark; 10-30-2001 at 03:46 PM.
