Error with a exec in php

Question

I need to get the sso (employee number) number from the logged user in order to complete a query, but it tells me that there is an error in line 12, I can't figure out the problem can somebody help me?

include_once('../../include/config.inc.php');

session_start();
if($_SESSION['utype']=='Manager'){
    //Se buscan todos los datos de los empleados q pertenecen a el área lidereada por el usuario
    //Se extrae el id del jefe
    $query='select HIGH_PRIORITY userId from mgit_users.users where hrOracleNumber='.$_SESSION['sso'];
    $exec=$conn->execute ($query) or die ("Error $query".$conn->errorMsg());        
    $chiefId=$exec->fields['userId'];   
    $exec->Close();
    }
//Despliega la tabla principal
function cargar(){
    $respuesta = new xajaxResponse('ISO-8859-1');
    include('../connection/connection.php');
    //Se extrae la información de todos los records existentes
$query="SELECT HIGH_PRIORITY cc.name ccname, cc.description ccdesc, CONCAT(u.firstName,' ',u.lastName) ccowner, cc.ownerSSO osso, cc.initialBudget abudget, cc.actualBudget cbudget, cc.plannedBudget pbudget  
        FROM hr_cost_centers cc, mgit_users.users u
        WHERE cc.ownerSSO = hrOracleNumber
    ORDER BY ccname";

is this: $exec=$conn->execute ($query) or die ("Error $query".$conn->errorMsg()); and it says this: Fatal error: Call to a member function on a non-object in /usr/local/apache/htdocs/areas/psae/psae_tools/TrainingNeedsAssesment/modules/costCentersStatus/index.php on line 12 — Monk LikeaSir
– Monk LikeaSir, Commented Jan 12, 2013 at 0:32
@cheese - it's assumed he just stopped copy/paste there. he does nothing with the query either. If this is really how his file ends his problems are much greater than whatever's on line 12 — Kai Qing
– Kai Qing, Commented Jan 12, 2013 at 0:32

Kai Qing · Accepted Answer · 2013-01-12 00:54:53Z

1

This...

Fatal error: Call to a member function on a non-object in /usr/local/apache/htdocs/areas/psae/psae_tools/TrainingNeedsAssesment/modules/co‌stCentersStatus/index.php on line 12

...means that $conn is not an instance of a class at this point. Typically instantiated by calling new on a class:

$conn = new databaseClass;

EDIT

This resource's example shows "Execute" and not "execute" - this may be important. http://phplens.com/lens/adodb/docs-adodb.htm#ex1

so your line should perhaps be:

$exec=$conn->Execute($query) or die ("Error $query".$conn->errorMsg());

edited Jan 12, 2013 at 0:54

answered Jan 12, 2013 at 0:41

Kai Qing

18.9k6 gold badges41 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Monk LikeaSir Over a year ago

I think not because this has never happend before but I'm gonna try doing that.

Kai Qing Over a year ago

I see examples of both with and without new, so I doubt that's your problem. It could be you need to call Execute and not execute. Case sensitive.

Kai Qing Over a year ago

can you print_r($conn) right after your config include? it should say "object" or something similar.

Collectives™ on Stack Overflow

Error with a exec in php

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related