Using C++ to create a database

[incremental]

Is there a way I can store some data into a database and write a C++ program that allows users to access that data?

[Moschops]

Yes. Many ways, from a simple text file to accessing SQl (and other such) databases.

[Jikax]

i used sqlite in the past... very easy...

[BHX]

I normally use the MySQL C API and it seems to work just fine for my needs.

#include <mysql.h>
#include <cstdio>

int main()
{
	MYSQL *conn;
	MYSQL_RES *res;
	MYSQL_ROW row;
	char *server = "localhost";
	char *user = "user";
	char *password = "password";
	char *database = "database";
	conn = mysql_init(NULL);
	
	// connect to database
	if(!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0))
	{
		fprintf(stderr, "%s\n", mysql_error(conn));
		return -1;
	}
	
	// send SQL query
	if(mysql_query(conn, "select * from cpp_testTAB"))
	{
		fprintf(stderr, "%s\n", mysql_error(conn));
		return -1;
	}
	
	res = mysql_use_result(conn);
	
	// output table name
	printf("MySQL Tables in mysql database:\n");
	while ((row = mysql_fetch_row(res)) != NULL)
	{
		printf("%s %s %s %s\n", row[0], row[1], row[2], row[3]);
	}
	
	// close connection
	mysql_free_result(res);
	mysql_close(conn);
	
	return 0;
}
/*
 *    To compile in Linux type this in:
 *         g++ -o sqltest $(mysql_config --cflags) mysqltest.cpp $(mysql_config --libs) -Wno-write-strings
 */