/*   +----------------------------------------------------------------------+   | 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 */

<?php // $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;