Re: [PHP] calling function from function?

Jason Thu, 11 Nov 2004 12:08:29 -0800

Rick Fletcher wrote:

function db( $host, $user, $pass, $dbnam ) {
 $db = @mysql_pconnect( $host, $user, $pass )or die( mysql_error( $db ));
       @mysql_select_db( $dbnam )or die( mysql_error( $db ) );
 return $db;
}
function logs() {
 global $defined;
 db( $defined[9], $defined[1], $defined[2], $defined[3] );
 ... do some processing ...
}
what am i missing here? i get errors if i try to pass $db to logs. i.e. logs( $db );
What's missing? The error message. Include it, and the offending line(s) of code, and ask again.

--Rick

There isnt an error at all. According to the die() functions at the end of the mysql() functions it should give it there, instead I get blank as if the function has not successfully completed. The reason I say this is if you try to access the mysql resource pointer ( $db, in this case ) I get nothing, a return code of 0. Example in point...

function db( $host, $user, $pass, $dbnam ) { $db = @mysql_pconnect( $host, $user, $pass )or die( "phpDHCPAdmin currently not active, is under repair or is not configured correctly. Error Number: " . mysql_errno( $db ) . " Error Message: " . mysql_error( $db ) . " Email Administrator: <a href=\"mailto:$defined[5]\";>$defined[5]</a>" ); @mysql_select_db( $dbnam )or die( "Could not connect to database: $defined[3] Error Message: " . @mysql_error( $db ) . " " . "Error Number: " . @mysql_errno( $db ) . " Email Administrator: <a href=\"mailto:$defined[5]\";>$defined[5]</a>" ); return $db; }

function logs() {
 global $defined;

db( $defined[9], $defined[1], $defined[2], $defined[3] ); $pagecount = "1"; $tble = "logs"; $sql = @mysql_query( "SELECT * FROM $tble WHERE session = \"$_SESSION[hash]\"", $db )or die( "Error occured when searching logs for session id: $_SESSION[hash] Error Message: " . @mysql_error( $db ) . " " . "Error Number: " . @mysql_errno( $db ) . " Email Administrator: <a href=\"mailto:$defined[5]\";>$defined[5]</a>" ); while( $row = @mysql_fetch_array( $sql ) ) { $id = $row["session"]; } if( @mysql_num_rows( $sql ) == 0 ) { $insert = @mysql_query( "INSERT INTO $tble VALUES (\"\",\"$_SESSION[date]\",\"$_SESSION[hour]\",\"$_SESSION[ipaddy]\",\"$_SESSION[host]\",\"$_SESSION[ref]\",\"$_SERVER[HTTP_USER_AGENT]\",\"$_SERVER[PHP_SELF]\",\"$pagecount\",\"$_SESSION[msg]\",\"$_SESSION[hash]\")", $db )or die( "Error occured creating logs for $_SESSION[hash] Error Message: " . @mysql_error( $db ) . " " . "Error Number: " . @mysql_errno( $db ) . " Email Administrator: <a href=\"mailto:$defined[5]\";>$defined[5]</a>" ); } elseif( @mysql_num_rows( $sql ) != 0 ) { if( ( $_SESSION['hash'] == $id ) || ( empty( $pagecount ) ) ) { $pagecount++; $update = @mysql_query( "UPDATE $tble SET date=\"$_SESSION[date]\", time=\"$_SESSION[hour]\", ip=\"$_SESSION[ipaddy]\", host=\"$_SESSION[host]\", referer=\"$_SESSION[ref]\", agent=\"$_SERVER[HTTP_USER_AGENT]\", page=CONCAT(page,\".:||:.$_SERVER[PHP_SELF]\"), pagecount=\"$pagecount\", message=\"$_SESSION[msg]\", session=\"$_SESSION[hash]\" WHERE session=\"$id\"", $db )or die( "Error occured while updating logs for $_SESSION[hash] Error Message: " . @mysql_error( $db ) . " " . "Error Number: " . @mysql_errno( $db ) . " Email Administrator: <a href=\"mailto:$defined[5]\";>$defined[5]</a>" ); } else { call_user_func( "exit_app" ); } } else { call_user_func( "exit_app" ); } }

when called with logs(); returns this: Error occured when searching logs for session id: 82a831c4190f6e929032c0a9512c3657 Error Message: Error Number: Email Administrator: [EMAIL PROTECTED]

--
Jason Gerfen
[EMAIL PROTECTED]

"And remember... If the ladies
 don't find you handsome, they
 should at least find you handy..."
             ~The Red Green show

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] calling function from function?

Reply via email to