60 lines
2.1 KiB
C++
60 lines
2.1 KiB
C++
#include "my_global.h" // Include this file first to avoid problems
|
|
#include "mysql.h" // MySQL Include File
|
|
#include <cstdio>
|
|
#include <iostream>
|
|
#define SERVER "localhost"
|
|
#define USER "root"
|
|
#define PASSWORD "123"
|
|
#define DATABASE "domains"
|
|
|
|
int main()
|
|
{
|
|
MYSQL *connect; // Create a pointer to the MySQL instance
|
|
connect=mysql_init(NULL); // Initialise the instance
|
|
/* This If is irrelevant and you don't need to show it. I kept it in for Fault Testing.*/
|
|
if(!connect) /* If instance didn't initialize say so and exit with fault.*/
|
|
{
|
|
fprintf(stderr,"MySQL Initialization Failed");
|
|
return 1;
|
|
}
|
|
/* Now we will actually connect to the specific database.*/
|
|
|
|
connect=mysql_real_connect(connect,SERVER,USER,PASSWORD,DATABASE,0,NULL,0);
|
|
/* Following if statements are unneeded too, but it's worth it to show on your
|
|
first app, so that if your database is empty or the query didn't return anything it
|
|
will at least let you know that the connection to the mysql server was established. */
|
|
|
|
if(connect){
|
|
printf(" * Connection Succeeded\n");
|
|
}
|
|
else{
|
|
printf("Connection Failed!\n");
|
|
}
|
|
MYSQL_RES *res_set; /* Create a pointer to recieve the return value.*/
|
|
MYSQL_ROW row; /* Assign variable for rows. */
|
|
mysql_query(connect,"SELECT id, fname,lname,username,email FROM users");
|
|
/* Send a query to the database. */
|
|
unsigned int i = 0; /* Create a counter for the rows */
|
|
|
|
res_set = mysql_store_result(connect); /* Receive the result and store it in res_set */
|
|
|
|
unsigned int numrows = mysql_num_rows(res_set); /* Create the count to print all rows */
|
|
|
|
/* This while is to print all rows and not just the first row found, */
|
|
int numfields = mysql_num_fields(res_set);
|
|
MYSQL_FIELD *mfield;
|
|
while((row = mysql_fetch_row(res_set)))
|
|
{
|
|
|
|
//std::cout << mfield->name << std::endl;
|
|
for(i = 0; i < numfields; i++)
|
|
{
|
|
mfield = mysql_fetch_field(res_set);
|
|
char *val = row[i];
|
|
printf(" * %-10s : %s\n", mfield->name, val);
|
|
}
|
|
}
|
|
mysql_close(connect); /* Close and shutdown */
|
|
return 0;
|
|
}
|