PHP开发中的MySQL扩展

/*
  +----------------------------------------------------------------------+
  | PHP Version 5                                                        |
  +----------------------------------------------------------------------+
  | Copyright (c) 1997-2012 The PHP Group                                |
  +----------------------------------------------------------------------+
  | This source file is subject to version 3.01 of the PHP license,      |
  | that is bundled with this package in the file LICENSE, and is        |
  | available through the world-wide-web at the following url:           |
  | http://www.php.net/license/3_01.txt                                  |
  | If you did not receive a copy of the PHP license and are unable to   |
  | obtain it through the world-wide-web, please send a note to          |
  | license@php.net so we can mail you a copy immediately.               |
  +----------------------------------------------------------------------+
  | Author:                                                              |
  +----------------------------------------------------------------------+
*/

 

/* $Id$ */

#ifndef PHP_MY_MYSQL_H
#define PHP_MY_MYSQL_H

extern zend_module_entry my_mysql_module_entry;
#define phpext_my_mysql_ptr &my_mysql_module_entry

#ifdef PHP_WIN32
# define PHP_MY_MYSQL_API __declspec(dllexport)
#elif defined(__GNUC__) && __GNUC__ >= 4
# define PHP_MY_MYSQL_API __attribute__ ((visibility("default")))
#else
# define PHP_MY_MYSQL_API
#endif

#ifdef ZTS
#include "TSRM.h"
#endif

PHP_MINIT_FUNCTION(my_mysql);
PHP_MSHUTDOWN_FUNCTION(my_mysql);
PHP_RINIT_FUNCTION(my_mysql);
PHP_RSHUTDOWN_FUNCTION(my_mysql);
PHP_MINFO_FUNCTION(my_mysql);

PHP_FUNCTION(my_mysql_connect);
PHP_FUNCTION(my_mysql_close);

PHP_FUNCTION(my_mysql_get_conn);
PHP_FUNCTION(my_mysql_select_db);
PHP_FUNCTION(my_mysql_ping);
PHP_FUNCTION(my_mysql_query);
PHP_FUNCTION(my_mysql_fetch_assoc);
PHP_FUNCTION(my_mysql_get_insert_id);

/*
   Declare any global variables you may need between the BEGIN
 and END macros here:    
*/
ZEND_BEGIN_MODULE_GLOBALS(my_mysql)
 long  max_connection;
  long  default_connection;
 char *driver_name;

  char *host;
  char *pwd;
  char *user;
  long port;
ZEND_END_MODULE_GLOBALS(my_mysql)

/* In every utility function you add that needs to use variables
   in php_my_mysql_globals, call TSRMLS_FETCH(); after declaring other
   variables used by that function, or better yet, pass in TSRMLS_CC
   after the last function argument and declare your utility function
   with TSRMLS_DC after the last declared argument.  Always refer to
   the globals in your function as MY_MYSQL_G(variable).  You are
   encouraged to rename these macros something shorter, see
   examples in any other php module directory.
*/

#ifdef ZTS
#define MY_MYSQL_G(v) TSRMG(my_mysql_globals_id, zend_my_mysql_globals *, v)
#else
#define MY_MYSQL_G(v) (my_mysql_globals.v)
#endif

#endif /* PHP_MY_MYSQL_H */

 

// $mysql = my_mysql_connect("localhost", "root", "", "test", 3306);
// var_dump($mysql);
// // my_mysql_close($mysql);

// sleep(10);
$conn = array();
$conn[] = my_mysql_get_conn();
$conn[] = my_mysql_get_conn();
// $conn[] = my_mysql_get_conn();
// $conn[] = my_mysql_get_conn();
// $conn[] = my_mysql_get_conn();

// $conn[] = my_mysql_get_conn();
// $conn[] = my_mysql_get_conn();
// $conn[] = my_mysql_get_conn();
// $conn[] = my_mysql_get_conn();
// $conn[] = my_mysql_get_conn();

// $conn[] = my_mysql_get_conn();
// $conn[] = my_mysql_get_conn();
// print_r($conn);

var_dump($conn[0]);

// my_mysql_select_db($conn[0], "test");

// mysql_query("show processlist", $conn[0]);
// print_r($status);

// sleep(1);

my_mysql_select_db($conn[0], "mysql");

// sleep(1);

my_mysql_select_db($conn[1], "test");

my_mysql_ping($conn[1]);

$result = my_mysql_query($conn[1], "select * from test");

var_dump($result);

$arr = my_mysql_fetch_assoc($result);

my_mysql_query($conn[1], "INSERT INTO test VALUES(id, 'abc')");

$insert_id = my_mysql_get_insert_id($conn[1]);

print_r($arr);

echo $insert_id;