Gentics Portal.Node PHP API
 All Classes Namespaces Functions Variables Pages
db.php
1 <?
2 // Absolutely no breaks allowed HERE
3 
4 $SETTINGS["dbtype"] = "mysql";
5 $SETTINGS["db"] = "node_utf8";
6 $SETTINGS["server"] = "localhost:42006:/Node/tmp/mysql.sock";
7 $SETTINGS["login"] = "node";
8 $SETTINGS["pw"] = "";
9 $SETTINGS["charset"] = "utf8";
10 $SETTINGS["jdbcparameters"] = "netTimeoutForStreamingResults=900";
11 
12 $DBHOST = $SETTINGS['server'];
13 $DBUSER = $SETTINGS['login'];
14 $DBPASS = $SETTINGS['pw'];
15 $DBNAME = $SETTINGS['db'];
16 
17 // TODO integrate other databases
18 // adapt all SQL-queries to standard-SQL
19 
20 // we use permanent connect to mysql
21 // only with mysql-support available at the moment
22 $db = mysql_pconnect($DBHOST, $DBUSER, $DBPASS);
23 
24 // if no database-connect is available
25 if (!$db)
26  include("uups.php");
27 else
28  mysql_select_db($DBNAME,$db);
29 
30 if ( !function_exists( 'query' ) )
31 {
32 
33 function query($sql, $dbhandle = FALSE ) {
34  global $db, $DEBUG;
35 
36  if ( $dbhandle === FALSE )
37  $dbhandle = $db;
38 
39  $iid = 0;
40  $num = 0;
41 
42  $cmd = strtolower(substr($sql,0,6));
43  $rs = mysql_query($sql, $dbhandle);
44 
45  if (!$rs && $DEBUG["sql"]) echo "<b>SQL Error:</b> $sql;<br>Error: ".mysql_error($dbhandle)."<br><br>";
46  if ( !$rs )
47  return FALSE;
48 
49  $iid = mysql_insert_id();
50 
51  if ($rs && $cmd == "insert") {
52 
53  $iid = mysql_insert_id($dbhandle);
54  $DEBUG["insert"]++;
55 
56  }
57 
58  if ($rs && $cmd == "select") {
59 
60  $DEBUG["select"]++;
61  $num = mysql_num_rows($rs);
62  while ($rs && $row = mysql_fetch_array($rs)) $arr[] = $row;
63 
64  }
65 
66  $result["arr"] = $arr;
67  $result["num"] = $num;
68  $result["iid"] = $iid;
69 
70  return $result;
71 }
72 
73 } else
74 {
75  $include_db_failed = TRUE;
76 }
77 
78 ?>