lbbs/src/database.c

/***************************************************************************
                         database.c  -  description
                             -------------------
    begin                : Mon Oct 11 2004
    copyright            : (C) 2004 by Leaflet
    email                : leaflet@leafok.com
 ***************************************************************************/

/***************************************************************************
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 ***************************************************************************/

#include "common.h"
#include <mysql.h>
#include <stdio.h>

MYSQL *
db_open ()
{
  MYSQL *db;

  db = mysql_init (NULL);
  if (db == NULL)
    {
      log_error ("mysql_init() failed\n");
      return NULL;
    }

  db = mysql_real_connect (db, DB_host, DB_username, DB_password, DB_database,
                           0, NULL, 0);
  if (db == NULL)
    {
      log_error ("mysql_connect() failed\n");
      return NULL;
    }

  if (mysql_query (db, "SET CHARACTER SET gb2312") != 0)
    {
      log_error ("SET CHARACTER SET failed\n");
      return NULL;
    }

  if (mysql_query (db, "SET NAMES \'gb2312\'") != 0)
    {
      log_error ("SET NAMES failed\n");
      return NULL;
    }

  return db;
}
1	sysadm	1.1	/***************************************************************************
2			database.c - description
3			-------------------
4			begin : Mon Oct 11 2004
5			copyright : (C) 2004 by Leaflet
6			email : leaflet@leafok.com
7			***************************************************************************/
8
9			/***************************************************************************
10			* *
11			* This program is free software; you can redistribute it and/or modify *
12			* it under the terms of the GNU General Public License as published by *
13			* the Free Software Foundation; either version 2 of the License, or *
14			* (at your option) any later version. *
15			* *
16			***************************************************************************/
17
18			#include "common.h"
19	sysadm	1.3	#include <mysql.h>
20			#include <stdio.h>
21	sysadm	1.1
22			MYSQL *
23			db_open ()
24			{
25	sysadm	1.2	MYSQL *db;
26	sysadm	1.5
27			db = mysql_init (NULL);
28	sysadm	1.2	if (db == NULL)
29	sysadm	1.5	{
30			log_error ("mysql_init() failed\n");
31			return NULL;
32			}
33	sysadm	1.2
34	sysadm	1.5	db = mysql_real_connect (db, DB_host, DB_username, DB_password, DB_database,
35			0, NULL, 0);
36	sysadm	1.2	if (db == NULL)
37	sysadm	1.5	{
38			log_error ("mysql_connect() failed\n");
39			return NULL;
40			}
41
42	sysadm	1.6	if (mysql_query (db, "SET CHARACTER SET gb2312") != 0)
43			{
44			log_error ("SET CHARACTER SET failed\n");
45			return NULL;
46			}
47
48			if (mysql_query (db, "SET NAMES \'gb2312\'") != 0)
49			{
50			log_error ("SET NAMES failed\n");
51			return NULL;
52			}
53
54	sysadm	1.4	return db;
55	sysadm	1.1	}
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1