4 $SETTINGS[
"dbtype"] =
"mysql";
5 $SETTINGS[
"db"] =
"node_utf8";
6 $SETTINGS[
"server"] =
"localhost:42006:/Node/tmp/mysql.sock";
7 $SETTINGS[
"login"] =
"node";
9 $SETTINGS[
"charset"] =
"utf8";
10 $SETTINGS[
"jdbcparameters"] =
"netTimeoutForStreamingResults=900";
12 $DBHOST = $SETTINGS[
'server'];
13 $DBUSER = $SETTINGS[
'login'];
14 $DBPASS = $SETTINGS[
'pw'];
15 $DBNAME = $SETTINGS[
'db'];
22 $db = mysql_pconnect($DBHOST, $DBUSER, $DBPASS);
28 mysql_select_db($DBNAME,$db);
30 if ( !function_exists(
'query' ) )
33 function query($sql, $dbhandle = FALSE ) {
36 if ( $dbhandle === FALSE )
42 $cmd = strtolower(substr($sql,0,6));
43 $rs = mysql_query($sql, $dbhandle);
45 if (!$rs && $DEBUG[
"sql"]) echo
"<b>SQL Error:</b> $sql;<br>Error: ".mysql_error($dbhandle).
"<br><br>";
49 $iid = mysql_insert_id();
51 if ($rs && $cmd ==
"insert") {
53 $iid = mysql_insert_id($dbhandle);
58 if ($rs && $cmd ==
"select") {
61 $num = mysql_num_rows($rs);
62 while ($rs && $row = mysql_fetch_array($rs)) $arr[] = $row;
66 $result[
"arr"] = $arr;
67 $result[
"num"] = $num;
68 $result[
"iid"] = $iid;
75 $include_db_failed = TRUE;