2 /******************************************************************************************/
3 /* global parameters */
4 /******************************************************************************************/
5 //$pgsqlhost = "10.10.10.145"; // PostgreSQL server
6 //$pgsqlport = "5432"; // PostgreSQL port
7 //$dbname = "gnucomo"; // PostgreSQL database name
9 /******************************************************************************************/
10 /* string function login_form( void ) */
12 /* returns the login form */
13 /******************************************************************************************/
14 function login_form() {
16 $login = "<div class='login'>";
17 $login .= "<h1 align=\"center\">GNU Computer Monitoring</h1>";
18 $login .= "<center><table>";
20 $login .= "<td width='50%'><img src='../doc/logo.png' alt='GnuCoMo logo'></td>";
21 $login .= "<td><form name=\"login\" method=\"POST\" action=\"login.php\">";
24 $login .= " <td>Username</td>";
25 $login .= " <td><input type=\"text\" name=\"username\"></td>";
28 $login .= " <td>Password</td>";
29 $login .= " <td><input type=\"password\" name=\"password\"></td>";
32 $login .= " <td> </td>";
33 $login .= " <td align=\"right\"><input type=\"submit\" value=\"signin\"></td>";
35 $login .= " </table>";
39 $login .= "</table></center>";
45 /******************************************************************************************/
46 /* array function query( resource connection, string sqlquery ) */
48 /* gives an array return. */
49 /* arr[0] = boolean if action completed whitout error, return true otherwise false */
50 /* arr[1] = result sql query result */
51 /* arr[2] = int number of rows */
52 /* arr[3] = string error information */
53 /******************************************************************************************/
54 function query( $conn, $sql ) {
56 $query_result = pg_exec( $conn, $sql );
58 if( $query_result != FALSE ) {
59 $query_nRows = pg_NumRows($query_result);
60 $query_error = pg_errormessage( $conn );
61 return array( TRUE, $query_result, $query_nRows, "" );
63 $query_error = @pg_errormessage( $conn );
64 return array( FALSE, $query_result, 0, $query_error );
68 /******************************************************************************************/
69 /* void function pgsql_error( string error ) */
71 /* prints an error message */
72 /******************************************************************************************/
73 function pgsql_error( $err ) {
74 echo "An error occured. Please contact your systemadministrator.<br>";