WebSVN – ALCASAR – Diff – /web/acc/manager/lib/sql/drivers/mysql/functions.php


<?php
function da_sql_limit($limit,$point,$config)
{
	switch($point){
		case 0:
			return '';
		case 1:
			return '';
//modif by MG for Alcasar
		case 2:
			return "LIMIT $limit";
		case 3:
			return "LIMIT $limit";
	}
}
 
function da_sql_host_connect($server,$config)
{
	if ($config['sql_use_http_credentials'] == 'yes'){
		global $HTTP_SERVER_VARS;
		$SQL_user = $HTTP_SERVER_VARS["REMOTE_USER"];
		$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];
	}
	else{
		$SQL_user = $config['sql_username'];
		$SQL_passwd = $config['sql_password'];
	}
 
	if ($config['sql_connect_timeout'] != 0)
		ini_set('mysql.connect_timeout',$config['sql_connect_timeout']);
	if ($config['sql_debug'] == 'true')
		print "<b>DEBUG(SQL,MYSQL DRIVER): Connect: User=$SQL_user,Password=$SQL_passwd </b><br>\n";
	return mysqli_connect("$server:$config[sql_port]",$SQL_user,$SQL_passwd,$config['sql_database']);
}
 
function da_sql_connect($config)
{
	if (isset($config['sql_use_http_credentials']) && $config['sql_use_http_credentials'] == 'yes'){
		global $HTTP_SERVER_VARS;
		$SQL_user = $HTTP_SERVER_VARS["REMOTE_USER"];
		$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];
	}
	else{
		$SQL_user = $config['sql_username'];
		$SQL_passwd = $config['sql_password'];
	}
 
	if ($config['sql_connect_timeout'] != 0)
		ini_set('mysql.connect_timeout',$config['sql_connect_timeout']);
	if ($config['sql_debug'] == 'true')
		print "<b>DEBUG(SQL,MYSQL DRIVER): Connect: User=$SQL_user,Password=$SQL_passwd </b><br>\n";
	return mysqli_connect("$config[sql_server]:$config[sql_port]",$SQL_user,$SQL_passwd,$config['sql_database']);
}
 
function da_sql_pconnect($config)
{
	if (isset($config['sql_use_http_credentials']) && $config['sql_use_http_credentials'] == 'yes'){
		global $HTTP_SERVER_VARS;
		$SQL_user = $HTTP_SERVER_VARS["REMOTE_USER"];
		$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];
	}
	else{
		$SQL_user = $config['sql_username'];
		$SQL_passwd = $config['sql_password'];
	}
	if ($config['sql_connect_timeout'] != 0)
		ini_set('mysql.connect_timeout',$config['sql_connect_timeout']);
	if ($config['sql_debug'] == 'true')
		print "<b>DEBUG(SQL,MYSQL DRIVER): Connect: User=$SQL_user,Password=$SQL_passwd </b><br>\n";
	return mysqli_connect($config['sql_server'],$SQL_user,$SQL_passwd,$config['sql_database'],$config['sql_port']);
}
 
function da_sql_close($link,$config)
{
	return mysqli_close($link);
}
 
function da_sql_escape_string($link, $string)
{
	return mysqli_real_escape_string($link, $string);
}
 
function da_sql_query($link,$config,$query)
{
	if ($config['sql_debug'] == 'true')
		print "<b>DEBUG(SQL,MYSQL DRIVER): Query: <i>$query</i></b><br>\n";
	return mysqli_query($link,$query);
}
 
function da_sql_num_rows($result,$config)
{
	if ($config['sql_debug'] == 'true')
		print "<b>DEBUG(SQL,MYSQL DRIVER): Query Result: Num rows:: " . mysqli_num_rows($result) . "</b><br>\n";
	return mysqli_num_rows($result);
}
 
function da_sql_fetch_array($result,$config)
{
	$row = @array_change_key_case(mysqli_fetch_array($result,
		MYSQLI_ASSOC),CASE_LOWER);
	if ($config['sql_debug'] == 'true'){
		print "<b>DEBUG(SQL,MYSQL DRIVER): Query Result: <pre>";
		print_r($row);
		print "</b></pre>\n";
	}
	return $row;
}
 
function da_sql_affected_rows($link,$result,$config)
{
	if ($config['sql_debug'] == 'true')
		print "<b>DEBUG(SQL,MYSQL DRIVER): Query Result: Affected rows:: " . mysqli_affected_rows($result) . "</b><br>\n";
	return mysqli_affected_rows($link);
}
 
function da_sql_list_fields($table,$link,$config)
{
	return da_sql_query($link, $config, "SHOW COLUMNS FROM $table");
}
 
 
function da_sql_field_name($fields,$num,$config)
{
	return mysqli_fetch_field_direct($fields,$num);
}
 
function da_sql_error($link,$config)
{
	return mysqli_error($link);
}
?>
 

Subversion Repositories ALCASAR

(root)/web/acc/manager/lib/sql/drivers/mysql/functions.php – Rev 1852 → 2488

Rev 1852		Rev 2488
1	`<?php`	1	`<?php`
2	`function da_sql_limit($limit,$point,$config)`	2	`function da_sql_limit($limit,$point,$config)`
3	`{`	3	`{`
4	`switch($point){`	4	`switch($point){`
5	`case 0:`	5	`case 0:`
6	`return '';`	6	`return '';`
7	`case 1:`	7	`case 1:`
8	`return '';`	8	`return '';`
9	`//modif by MG for Alcasar`	9	`//modif by MG for Alcasar`
10	`case 2:`	10	`case 2:`
11	`return "LIMIT $limit";`	11	`return "LIMIT $limit";`
12	`case 3:`	12	`case 3:`
13	`return "LIMIT $limit";`	13	`return "LIMIT $limit";`
14	`}`	14	`}`
15	`}`	15	`}`
16		16
17	`function da_sql_host_connect($server,$config)`	17	`function da_sql_host_connect($server,$config)`
18	`{`	18	`{`
19	`if ($config['sql_use_http_credentials'] == 'yes'){`	19	`if ($config['sql_use_http_credentials'] == 'yes'){`
20	`global $HTTP_SERVER_VARS;`	20	`global $HTTP_SERVER_VARS;`
21	`$SQL_user = $HTTP_SERVER_VARS["PHP_AUTH_USER"];`	21	`$SQL_user = $HTTP_SERVER_VARS["REMOTE_USER"];`
22	`$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];`	22	`$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];`
23	`}`	23	`}`
24	`else{`	24	`else{`
25	`$SQL_user = $config['sql_username'];`	25	`$SQL_user = $config['sql_username'];`
26	`$SQL_passwd = $config['sql_password'];`	26	`$SQL_passwd = $config['sql_password'];`
27	`}`	27	`}`
28		28
29	`if ($config['sql_connect_timeout'] != 0)`	29	`if ($config['sql_connect_timeout'] != 0)`
30	`ini_set('mysql.connect_timeout',$config['sql_connect_timeout']);`	30	`ini_set('mysql.connect_timeout',$config['sql_connect_timeout']);`
31	`if ($config['sql_debug'] == 'true')`	31	`if ($config['sql_debug'] == 'true')`
32	`print "<b>DEBUG(SQL,MYSQL DRIVER): Connect: User=$SQL_user,Password=$SQL_passwd </b><br>\n";`	32	`print "<b>DEBUG(SQL,MYSQL DRIVER): Connect: User=$SQL_user,Password=$SQL_passwd </b><br>\n";`
33	`return mysqli_connect("$server:$config[sql_port]",$SQL_user,$SQL_passwd,$config['sql_database']);`	33	`return mysqli_connect("$server:$config[sql_port]",$SQL_user,$SQL_passwd,$config['sql_database']);`
34	`}`	34	`}`
35		35
36	`function da_sql_connect($config)`	36	`function da_sql_connect($config)`
37	`{`	37	`{`
38	`if (isset($config['sql_use_http_credentials']) && $config['sql_use_http_credentials'] == 'yes'){`	38	`if (isset($config['sql_use_http_credentials']) && $config['sql_use_http_credentials'] == 'yes'){`
39	`global $HTTP_SERVER_VARS;`	39	`global $HTTP_SERVER_VARS;`
40	`$SQL_user = $HTTP_SERVER_VARS["PHP_AUTH_USER"];`	40	`$SQL_user = $HTTP_SERVER_VARS["REMOTE_USER"];`
41	`$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];`	41	`$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];`
42	`}`	42	`}`
43	`else{`	43	`else{`
44	`$SQL_user = $config['sql_username'];`	44	`$SQL_user = $config['sql_username'];`
45	`$SQL_passwd = $config['sql_password'];`	45	`$SQL_passwd = $config['sql_password'];`
46	`}`	46	`}`
47		47
48	`if ($config['sql_connect_timeout'] != 0)`	48	`if ($config['sql_connect_timeout'] != 0)`
49	`ini_set('mysql.connect_timeout',$config['sql_connect_timeout']);`	49	`ini_set('mysql.connect_timeout',$config['sql_connect_timeout']);`
50	`if ($config['sql_debug'] == 'true')`	50	`if ($config['sql_debug'] == 'true')`
51	`print "<b>DEBUG(SQL,MYSQL DRIVER): Connect: User=$SQL_user,Password=$SQL_passwd </b><br>\n";`	51	`print "<b>DEBUG(SQL,MYSQL DRIVER): Connect: User=$SQL_user,Password=$SQL_passwd </b><br>\n";`
52	`return mysqli_connect("$config[sql_server]:$config[sql_port]",$SQL_user,$SQL_passwd,$config['sql_database']);`	52	`return mysqli_connect("$config[sql_server]:$config[sql_port]",$SQL_user,$SQL_passwd,$config['sql_database']);`
53	`}`	53	`}`
54		54
55	`function da_sql_pconnect($config)`	55	`function da_sql_pconnect($config)`
56	`{`	56	`{`
57	`if (isset($config['sql_use_http_credentials']) && $config['sql_use_http_credentials'] == 'yes'){`	57	`if (isset($config['sql_use_http_credentials']) && $config['sql_use_http_credentials'] == 'yes'){`
58	`global $HTTP_SERVER_VARS;`	58	`global $HTTP_SERVER_VARS;`
59	`$SQL_user = $HTTP_SERVER_VARS["PHP_AUTH_USER"];`	59	`$SQL_user = $HTTP_SERVER_VARS["REMOTE_USER"];`
60	`$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];`	60	`$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];`
61	`}`	61	`}`
62	`else{`	62	`else{`
63	`$SQL_user = $config['sql_username'];`	63	`$SQL_user = $config['sql_username'];`
64	`$SQL_passwd = $config['sql_password'];`	64	`$SQL_passwd = $config['sql_password'];`
65	`}`	65	`}`
66	`if ($config['sql_connect_timeout'] != 0)`	66	`if ($config['sql_connect_timeout'] != 0)`
67	`ini_set('mysql.connect_timeout',$config['sql_connect_timeout']);`	67	`ini_set('mysql.connect_timeout',$config['sql_connect_timeout']);`
68	`if ($config['sql_debug'] == 'true')`	68	`if ($config['sql_debug'] == 'true')`
69	`print "<b>DEBUG(SQL,MYSQL DRIVER): Connect: User=$SQL_user,Password=$SQL_passwd </b><br>\n";`	69	`print "<b>DEBUG(SQL,MYSQL DRIVER): Connect: User=$SQL_user,Password=$SQL_passwd </b><br>\n";`
70	`return mysqli_connect($config['sql_server'],$SQL_user,$SQL_passwd,$config['sql_database'],$config['sql_port']);`	70	`return mysqli_connect($config['sql_server'],$SQL_user,$SQL_passwd,$config['sql_database'],$config['sql_port']);`
71	`}`	71	`}`
72		72
73	`function da_sql_close($link,$config)`	73	`function da_sql_close($link,$config)`
74	`{`	74	`{`
75	`return mysqli_close($link);`	75	`return mysqli_close($link);`
76	`}`	76	`}`
77		77
78	`function da_sql_escape_string($link, $string)`	78	`function da_sql_escape_string($link, $string)`
79	`{`	79	`{`
80	`return mysqli_real_escape_string($link, $string);`	80	`return mysqli_real_escape_string($link, $string);`
81	`}`	81	`}`
82		82
83	`function da_sql_query($link,$config,$query)`	83	`function da_sql_query($link,$config,$query)`
84	`{`	84	`{`
85	`if ($config['sql_debug'] == 'true')`	85	`if ($config['sql_debug'] == 'true')`
86	`print "<b>DEBUG(SQL,MYSQL DRIVER): Query: <i>$query</i></b><br>\n";`	86	`print "<b>DEBUG(SQL,MYSQL DRIVER): Query: <i>$query</i></b><br>\n";`
87	`return mysqli_query($link,$query);`	87	`return mysqli_query($link,$query);`
88	`}`	88	`}`
89		89
90	`function da_sql_num_rows($result,$config)`	90	`function da_sql_num_rows($result,$config)`
91	`{`	91	`{`
92	`if ($config['sql_debug'] == 'true')`	92	`if ($config['sql_debug'] == 'true')`
93	`print "<b>DEBUG(SQL,MYSQL DRIVER): Query Result: Num rows:: " . mysqli_num_rows($result) . "</b><br>\n";`	93	`print "<b>DEBUG(SQL,MYSQL DRIVER): Query Result: Num rows:: " . mysqli_num_rows($result) . "</b><br>\n";`
94	`return mysqli_num_rows($result);`	94	`return mysqli_num_rows($result);`
95	`}`	95	`}`
96		96
97	`function da_sql_fetch_array($result,$config)`	97	`function da_sql_fetch_array($result,$config)`
98	`{`	98	`{`
99	`$row = @array_change_key_case(mysqli_fetch_array($result,`	99	`$row = @array_change_key_case(mysqli_fetch_array($result,`
100	`MYSQLI_ASSOC),CASE_LOWER);`	100	`MYSQLI_ASSOC),CASE_LOWER);`
101	`if ($config['sql_debug'] == 'true'){`	101	`if ($config['sql_debug'] == 'true'){`
102	`print "<b>DEBUG(SQL,MYSQL DRIVER): Query Result: <pre>";`	102	`print "<b>DEBUG(SQL,MYSQL DRIVER): Query Result: <pre>";`
103	`print_r($row);`	103	`print_r($row);`
104	`print "</b></pre>\n";`	104	`print "</b></pre>\n";`
105	`}`	105	`}`
106	`return $row;`	106	`return $row;`
107	`}`	107	`}`
108		108
109	`function da_sql_affected_rows($link,$result,$config)`	109	`function da_sql_affected_rows($link,$result,$config)`
110	`{`	110	`{`
111	`if ($config['sql_debug'] == 'true')`	111	`if ($config['sql_debug'] == 'true')`
112	`print "<b>DEBUG(SQL,MYSQL DRIVER): Query Result: Affected rows:: " . mysqli_affected_rows($result) . "</b><br>\n";`	112	`print "<b>DEBUG(SQL,MYSQL DRIVER): Query Result: Affected rows:: " . mysqli_affected_rows($result) . "</b><br>\n";`
113	`return mysqli_affected_rows($link);`	113	`return mysqli_affected_rows($link);`
114	`}`	114	`}`
115		115
116	`function da_sql_list_fields($table,$link,$config)`	116	`function da_sql_list_fields($table,$link,$config)`
117	`{`	117	`{`
118	`return da_sql_query($link, $config, "SHOW COLUMNS FROM $table");`	118	`return da_sql_query($link, $config, "SHOW COLUMNS FROM $table");`
119	`}`	119	`}`
120		120
121		121
122	`function da_sql_field_name($fields,$num,$config)`	122	`function da_sql_field_name($fields,$num,$config)`
123	`{`	123	`{`
124	`return mysqli_fetch_field_direct($fields,$num);`	124	`return mysqli_fetch_field_direct($fields,$num);`
125	`}`	125	`}`
126		126
127	`function da_sql_error($link,$config)`	127	`function da_sql_error($link,$config)`
128	`{`	128	`{`
129	`return mysqli_error($link);`	129	`return mysqli_error($link);`
130	`}`	130	`}`
131	`?>`	131	`?>`
132		132