PHP - How To Call Object Without Foreach ?

I am getting this error while building OOP portal. Fatal error: Call to a member function count() on a non-object in C:\Users\Rishi\Documents\xampp\htdocs\PDO\Pitch_It\index.php on line 6   My index.php file: <?php

Hi,
  I have the following class:

   

class User
    {  private $_db;
       
       public function __construct($user = null)
       {
          $this->_db = DB::getInstance();
           .......
       }
       public function find($user = null)
       { if($user)
         { $field = (is_numeric($user)) ? 'id' : 'username';
         $data = $this->_db->get('users', array($field, '=', $user));
           if($data->count())
           { .........
             return true;
           }
         }
         return false;
       }

In class DB I have:
   

public static function getInstance()
      { if(!(self::$_instance)): self::$_instance = new self();
        endif;
        return self::$_instance;
      }

public function get() in class DB, after processing, returns $this, the single instance of class DB, this is assigned to $data which is then used to invoke public function count(), a member function of class DB. I am getting the following error:  Fatal error: Call to a member function count() on a non-object.  I would be very grateful if someone can point out my mistake.

I am changing my script from connecting to the database within every function, to using one connection (in the main class).

However, I am getting an error:
Call to a member function query() on a non-object

Here is  the main class:
<?php
class main{
// the configuration vars
public $config;
// the current user variables
public $uid = 0; // contains the user ID
public $gid = 0; // contains the group ID
// database variables
public $DB; // contains the connection
public $query_id; // contains the query ID
public $query_count; // how many queries have there been?
// cache variables
public $cache;
public $test = 'hi';
// initiate
public function __construct(){
}
// start up functions
public function startup(){
// first, set up the caching
if($this->config['use_memcache'] == true){
// start up cache
require_once('cache.class.php');
$this->cache = new cache_TS();
}
// now, set up the DB
$this->connectToDatabase();
// now, set up the user session
$this->setUserSession();
// are we logged in? If so, update our location
if($this->uid > 0){
// update location
$this->updateUserSession();
}
}
// connect to database
public function connectToDatabase(){
// connect to database
$this->DB = new mysqli($this->config['host'],$this->config['user'],$this->config['pass'],$this->config['db']);
// were we able to connect?
if(!isset($this->DB)){
// this is an error
exit('could not connect to the database.');
}
// test query
$q = "SELECT id,title FROM topics WHERE id='1' LIMIT 1;";
$q = $this->DB->query($q);
$r = $q->fetch_assoc();
echo $r['id'] . $r['title'];
// send back
return $this->DB;
}
// some removed....

The test query works fine.

It fails he
<?php
class forum extends main{
public function viewTopic($tid){
// Connect To Database
//$sql = new mysqli(db::$config['host'], db::$config['user'], db::$config['pass'], db::$config['db']);
// Get assorted details (topic, forum, etc)
// Get topic details
$tid = intval($tid);
$tq = "SELECT * FROM `topics` WHERE id='$tid' LIMIT 1";
$tq = $this->DB->query($tq);
$tr = $tq->fetch_assoc();

startup in main has already been called before forum is. The DB connects without failure.

Can anyone see what the problem is? How can I get $this->DB->query to work? (The query works fine when it's ran in the main class)

I am just trying out PDO and I get this error, Fatal error: Call to a member function fetch() on a non-object, but isn't it already on the $this->db object?

class shoutbox {

private $db;

function __construct($dbname, $username, $password, $host = "localhost" ) 
{ # db conections
try {
$this->db = new PDO("mysql:host=".$hostname.";dbname=".$dbname, $username, $password);
}
catch(PDOException $e)
{
echo $e->getMessage();
}
}

function getShouts()
{
$sql_shouts = $this->db->query('SELECT shoutid, message, pmuserid, ipadress, time FROM shouts WHERE pmuserid == 0');

return $sql_shouts->fetch(PDO::FETCH_OBJ);

}

}

When I use another class inside one class, I get this error

Quote

Call to a member function _safestring() on a non-object


The code is here
Code: [Select]
<?php

    require ('db.inc.php');
    $db = new db();
    
class common {
    
    function _cookiecheck() {
        if(!isset($_SESSION['username'])) {
            if(isset($_COOKIE['username'])&&isset($_COOKIE['password'])) {
                $pass = $db->_safestring($_COOKIE['password']);
                $user = $db->_safestring($_COOKIE['username']);
                $check = _query("select password from users where username='{$user}'");
                 if($check) {
                     $_SESSION['username'] = $user;
                 }
            }
        }
    }
    

}

?>
I get the error on the line when I call $db->_safestring();

Thanks for the help

i am tring to extend from DataAccess to Module... but is showing an error:
location: Library/database.php

<?php
Class DatabaseAccess
{

public $db;
public $sqlQuery;

public function ConnectDB($host,$user,$password,$database){
$this->db = mysqli_connect($host,"",$password);
if (mysqli_connect_errno()) {
echo '<p>Cannot connect to DB: ' . mysqli_connect_error() . '</p>';
}
$this->db &= mysqli_select_db($this->db,$database);
}
public function SqlQuery($sql)
{
return mysqli_query($this->db,$sql);//or die("Error:".mysqli_error()."<br />The Query:<b>$sql</b>");
}

}
?>

The Module class
Location:Library/module.php

<?php
Class Module extends DatabaseAccess
{


public function DoInsert($tableName,$fields = array(),$values = array())//delete from table
{
$fields = implode(",", $fields);
$values = implode("','", $values);

return $this->db->SqlQuery ("INSERT INTO $tableName($fields) VALUES('$values')");//The error is here!!!!!!!!!!!!!!!!

}

}
?>

and the controller file name:
newProfile.php
this is the cdode

include "config.php";
include "Library/database.php";
include "Library/module.php";
$db = new DatabaseAccess;
$db->ConnectDB(MYSQL_HOST_NAME,MYSQL_USER_NAME,MYSQL_PASSWORD,MYSQL_DATABASE);//define in config.php
$db->Module = New Module;
$db->Module->DoInsert("twitter_profiles",
array(profile_user_name,profile_password,user_id),
array($_POST['userName'],$_POST['password'],$userID));//DoInsert(tableName,Fields,Values)
echo sysMessage("NewProfile.txt");

the error:

Fatal error:   /home/omerbsh/blalalala.com/tra/Library/module.php on line 59
the error is in the modle class where the comment: "The error is here!!!!!!!!!!!!!!!!"
its cant to fine SqlQuery object but why???

thanks

I have a database called "mp_users" with the following setup:
Code: [Select]
CREATE TABLE IF NOT EXISTS `mp_users` (
  `id` int(10) unsigned default NULL auto_increment,
  `uid` int(10) unsigned NOT NULL,
  `username` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `points` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
When I try to run the following query, I get an error:
Quote

SELECT COUNT(id) AS user_exists FROM `mp_users` WHERE uid=$uid LIMIT 1;


Error:
Fatal error: Call to a member function query() on a non-object in /home/user/public_html/marketplace-functions.php on line 52

Here is the code:
Code: [Select]
<?php
require_once "config.php";
$sql = new mysqli($db1['host'], $db1['user'], $db1['pass'], $db1['db']);
function checkUserExists($uid){
// Query
$q = "SELECT COUNT(id) AS user_exists FROM `mp_users` WHERE uid=$uid LIMIT 1;";
echo $q;
$q = $sql->query($q);
$r = $q->fetch_assoc();
// Any results?
if($r['user_exists'] == 0){
// redirect to runonce...
header('Location: marketplace.php?do=runonce&return='.urlencode($_SERVER['QUERY_STRING']));
exit();
}
}
?>
Line 52 is the $q query.

I really cannot see what the problem is. The database exists, I've tried it in phpMyAdmin and it runs without trouble, but this wont!

Can anyone help?
Thanks in advance

Hi All,

My appologies in advance.  I am pretty sure that this has probably been answered before by someone...but for the life of me I carn't find the answer in any forums. 

My basic question is this.  Can you create an object at the beginning of a script, and then call its methods from within functions?

I have coded the following:



<?php

///import classes to use
require "booking_form_gui.php";

$booking = new booking_form_gui();

function _booking_form($form_state){
    
    ///$booking = new booking_form_gui();
   
    return $booking -> date_selection();         <----------this line causes the error I guess


}



The problem is that when I run this code, I get an error message similar to the following:

Fatal error: Call to a member function date_selection() on a non-object in /var/www/drupal_6/sites/default/modules/booking_system/booking_form/booking_form.module on line 127

Anyone any ideas how I could get round this? 

Thanks,

Mark.

Random Error that im getting on my webhost, not localhost.

Fatal error: Call to a member function fetch_assoc() on a non-object in /home/*****/index.php on line 127

Line 127:
while ($premium = $row->fetch_assoc()) {

Code:
<div class="toplist-content">
<table cellspacing="0">
<tbody>
<?php
$row = $home->getList(1);
while ($premium = $row->fetch_assoc()) {
?>
<tr class="table">
<td class="name"><a
href="server.html">
<h3>
<?php echo ucfirst($premium['servername']); ?>

</a> <font size='1.5'><?php echo ucfirst(substr($premium['serverdesc'],0,25)). "..."; ?>
</h3> </font>
</td>
<td class="revision"><h3>
<?php echo ucFirst($premium['revision']); ?>
</h3></td>
<td class="votes"><h3>
<?php echo $premium['vote']; ?>
</h3></td>
<td class="status"><?php 
if($home->getStatus($premium['host'], $premium['port']) == true) {
echo "<span class='ticket open'>Online</span>";
} else {
echo "<span class='ticket closed'>Offline</span>";
}
?>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>


The getList() function :

function getList($premium) {
$query = $this->con->query("SELECT * FROM `".$this->prefix."servers` WHERE `premium` = '".$premium."' && `ban` = '0'
ORDER BY (SELECT COUNT(*) FROM `".$this->prefix."votes` WHERE `serverId` = '".$this->prefix."servers.id') DESC") or die(mysqli_error());
return $query;
}

i am really struggling and i have no idea  what to do.

Call to a member function stmt_init() on a non-object

on this code.
if (isset($_POST['insert'])) {
  require_once('includes/connection.php');
  // initialize flag
  $OK = false;
  // create database connection
  $conn = dbConnect('write');
  // initialize prepared statement
  $stmt = $conn->stmt_init();
  // create SQL

i am using a book but i have tried it many ways and the same error occurs.

i have looked on forums and they say that i have not set up  the users correctley. but for a test i give my user all the permitions that i could and same problem.

the error occurs on this line

$stmt = $conn->stmt_init();

with the error message stating 

Call to a member function stmt_init() on a non-object

please if you have seen this before could you help

thanks in advance

Hi
I did something in phpmyadmin the other day and I cant my site back to work. please see the attatched pdf with print screens of what I did.
Basically I was trying to add this: Code: [Select]
INSERT INTO `PP088_config_options` ( `id` , `category_name` , `name` , `value` , `config_handler_class` , `is_system` , `option_order` , `dev_comment` ) VALUES ( NULL , 'general', 'installation_base_language', 'se_se', 'StringConfigHandler', '0', '12', NULL
);
in one of the tables. When visiting www.konto.gradeup.se you will see the error message. I inserted the code from the DB.class.php file that I think is causing the problem.
Code: [Select]
*/
    static function escape($value) {
      return self::connection()->escapeValue($value);
    } // escape
   
    /**
    * Escape field / table name line 262 is the line with that starts with return self::connection
Thanks so much in advance. Im novice at phpmyadmin
Code: [Select]
<?php

  /**
  * This function holds open database connections and provides interface to them. It is also used
  * for SQL logging
  *
  * @version 1.0
  * @http://www.projectpier.org/
  */
  final class DB {
    
    /** ID of primary connection **/
    const PRIMARY_CONNECTION_ID = 'PRIMARY';
    
    /**
    * Collection of connections
    *
    * @var array
    */
    static private $connections = array();
    
    /**
    * ID of primary connection. This connection will be used if connection name is not suplied
    *
    * @var string
    */
    static private $primary_connection = self::PRIMARY_CONNECTION_ID;
    
    /**
    * SQL log
    *
    * @var array
    */
    static private $sql_log = array();
    
    /**
    * This function will return specific connection. If $connection_name is NULL primary connection will be used
    *
    * @access public
    * @param string $connection_name Connection name, if NULL primary connection will be used
    * @return AbstractDBAdapter
    */
    static function connection($connection_name = null) {
      if (is_null($connection_name)) {
        $connection_name = self::getPrimaryConnection();
      } // if
      return array_var(self::$connections, $connection_name);
    } // connection
    
    /**
    * Create new database connection
    *
    * @access public
    * @param string $adapter Adapter name (currently only mysql adapter is implemeted)
    * @param array $params Connection params
    * @param string $connection_name Name of the connection, if NULL default connection ID will be used
    * @return boolean
    * @throws FileDnxError
    * @throws DBAdapterDnx
    */
    static function connect($adapter, $params, $connection_name = null) {
      $connection_name = is_null($connection_name) || trim($connection_name) == '' ? 
        self::PRIMARY_CONNECTION_ID : 
        trim($connection_name);
        
      $adapter = self::connectAdapter($adapter, $params);
      if (($adapter instanceof AbstractDBAdapter) && $adapter->isConnected()) {
        self::$connections[$connection_name] = $adapter;
        return $adapter;
      } else {
        return null;
      } // if
      
    } // connect
    
    /**
    * This function will include adapter and try to connect. In case of error DBConnectError will be thrown
    *
    * @access public
    * @param string $adapter_name
    * @param array $params
    * @return AbstractDBAdapter
    * @throws DBAdapterDnx
    * @throws DBConnectError
    */
    private function connectAdapter($adapter_name, $params) {
      
      self::useAdapter($adapter_name);
      
      $adapter_class = self::getAdapterClass($adapter_name);
      if (!class_exists($adapter_class)) {
        throw new DBAdapterDnx($adapter_name, $adapter_class);
      } // if
      
      return new $adapter_class($params);
      
    } // connectAdapter
    
    /**
    * Figure out adapter location and include it
    *
    * @access public
    * @param string $adapter_class
    * @return void
    */
    private function useAdapter($adapter_name) {
      $adapter_class = self::getAdapterClass($adapter_name);
      $path = dirname(__FILE__) . "/adapters/$adapter_class.class.php";
      if (!is_readable($path)) {
        throw new FileDnxError($path);
      } // if
      include_once $path;
    } // useAdapter
    
    /**
    * Return class based on adapter name
    *
    * @access public
    * @param string $adapter_name
    * @return string
    */
    private function getAdapterClass($adapter_name) {
      return Inflector::camelize($adapter_name) . 'DBAdapter';
    } // getAdapterClass
    
    // ---------------------------------------------------
    //  Interface to primary adapter
    // ---------------------------------------------------
    
    /**
    * Try to execute query, ignore the result
    *
    * @access public
    * @param string $sql
    * @return true
    */
    static function attempt($sql) {
      $arguments = func_get_args();
      array_shift($arguments);
      $arguments = count($arguments) ? array_flat($arguments) : null;
      try {
        self::connection()->execute($sql, $arguments);
      } catch(Exception $e) {
      }
      return true;
    } // execute

    /**
    * Execute query and return result
    *
    * @access public
    * @param string $sql
    * @return DBResult
    * @throws DBQueryError
    */
    static function execute($sql) {
      $arguments = func_get_args();
      array_shift($arguments);
      $arguments = count($arguments) ? array_flat($arguments) : null;
      
      return self::connection()->execute($sql, $arguments);
    } // execute
    
    /**
    * Execute query and return first row from result
    *
    * @access public
    * @param string $sql
    * @return array
    * @throws DBQueryError
    */
    static function executeOne($sql) {
      $arguments = func_get_args();
      array_shift($arguments);
      $arguments = count($arguments) ? array_flat($arguments) : null;
      
      return self::connection()->executeOne($sql, $arguments);
    } // executeOne
    
    /**
    * Execute query and return all rows
    *
    * @access public
    * @param string $sql
    * @return array
    * @throws DBQueryError
    */
    static function executeAll($sql) {
      $arguments = func_get_args();
      array_shift($arguments);
      $arguments = count($arguments) ? array_flat($arguments) : null;
      
      return self::connection()->executeAll($sql, $arguments);
    } // executeAll
    
    /**
    * Start transaction
    *
    * @access public
    * @param void
    * @return boolean
    * @throws DBQueryError
    */
    static function beginWork() {
      return self::connection()->beginWork();
    } // beginWork
    
    /**
    * Commit transaction
    *
    * @access public
    * @param void
    * @return boolean
    * @throws DBQueryError
    */
    static function commit() {
      return self::connection()->commit();
    } // commit
    
    /**
    * Rollback transaction
    *
    * @access public
    * @param void
    * @return boolean
    * @throws DBQueryError
    */
    static function rollback() {
      return self::connection()->rollback();
    } // rollback
    
    /**
    * Return insert ID
    *
    * @access public
    * @param void
    * @return integer
    */
    static function lastInsertId() {
      return self::connection()->lastInsertId();
    } // lastInsertId
    
    /**
    * Return number of affected rows
    *
    * @access public
    * @param void
    * @return integer
    */
    static function affectedRows() {
      return self::connection()->affectedRows();
    } // affectedRows
    
    /**
    * Escape value
    *
    * @access public
    * @param mixed $value
    * @return string
    */
    static function escape($value) {
      return self::connection()->escapeValue($value);
    } // escape
    
    /**
    * Escape field / table name
    *
    * @access public
    * @param string $field
    * @return string
    */
    static function escapeField($field) {
      return self::connection()->escapeField($field);
    } // escapeField
    
    /**
    * Prepare string. Replace every '?' with matching escaped value
    *
    * @param string $sql
    * @param array $arguments Array of arguments
    * @return string
    */
    static function prepareString($sql, $arguments = null) {
      if (is_array($arguments) && count($arguments)) {
        foreach ($arguments as $argument) {
          $sql = str_replace_first('?', DB::escape($argument), $sql);
        } // foreach
      } // if
      return $sql;
    } // prepareString
    
    // ---------------------------------------------------
    //  Getters and setters
    // ---------------------------------------------------
    
    /**
    * Get primary_connection
    *
    * @access public
    * @param null
    * @return string
    */
    static function getPrimaryConnection() {
      return self::$primary_connection;
    } // getPrimaryConnection
    
    /**
    * Set primary_connection value
    *
    * @access public
    * @param string $value
    * @return null
    * @throws Error if connection does not exists
    */
    static function setPrimaryConnection($value) {
      if (!isset(self::$connections[$value])) {
        throw new Error("Connection '$value' does not exists");
      } // if
      self::$primary_connection = $value;
    } // setPrimaryConnection
    
    /**
    * Add query to SQL log
    *
    * @access public
    * @param string $sql
    * @return void
    */
    function addToSQLLog($sql) {
      self::$sql_log[] = $sql;
    } // addToSQLLog
    
    /**
    * Return SQL log
    *
    * @access public
    * @param void
    * @return array
    */
    function getSQLLog() {
      return self::$sql_log;
    } // getSQLLog
  
  } // DB

?>

Hi,

i'm having a problem with some coding ive done not too sure why I am getting the following error message Fatal error: Call to a member function escapeValue() on a non-object /commonResources/php.lib/validateForm.class.php on line 82

At first I thought it was my database class object wasn't being created, but double checked and I have create a new object called $database of the database class.

Any ideas??

Code: [Select]
<?php
require_once ("/home/innova11/public_html/commonResources/dbConnection/dbConnection.php");
    class validateForm 
{
               public $email, $fName, $surname, $addressLine1, $townCity, $county, $postcode, $contactNum, $comments, $recaptchaVal;
public $resp;
public $error;
                function validateRecaptcha2($recaptchaVal)
{   
                        $this->recaptchaVal = $recaptchaVal;
if(empty($this->recaptchaVal))
                        {
                           return false;
                        }
                        else
                        {

                            $safe = $database->escapeValue($this->recaptchaVal);
                            $sql = "
                                    SELECT 
                                        *
                                    FROM 
                                        test
                                    WHERE 
                                        test = '".$safe."'
                                  ";
                            $results = $database->sqlQuery($sql);
                            if(mysql_num_rows($results)>0)
                            {
                                
                                return true; 
                            }
                            else
                            {
                                return false;
                            }
                        }
                  }

?>

Iam trying to access amazon API and iam receiving XML perfectly but now I dont know how to traverse all records as in the below example Iam having 3 records but can't travers the xml using foreach Loop
Please help me out and tell me how to use foreach loop ?? Its urgent

$search="9781439181799,9780393334296,9781605298627";  

$result = $obj->getItemByUpc($search, "Books");

foreach($result->children() as $key )
{

$data  = $key->Items->Request->ItemLookupRequest->ItemId."<br/ >";
echo $data;
}

Moderator Edit: added [php] tags

Hello,
   I have the situation shown below in the code:

if(//condition is met)
{ $val = new Val();
  $valon = $val->check($_POST, array(.........));
}
if($valon->passes())
{ $use = new Use();
  ........
}
//check() and passes() both belong to class Val
public function check($source, $items = array())
{ ......................
  return $this;
}

I get the following warning and error:

Notice: Undefined variable: valon
and
Fatal error: Call to a member function passes() on a non-object

I can't see anything wrong with the code. check() returns an object of class Val which is assigned to $valon, $valon then calls a member function of class Val. Could you please help. Please let me know whether to include further code.

Hello guys

I'm pulling out my last remaining hairs with this PHP problem. I'm not really good at PHP but I'm trying to do some changes to a script as instructed by the developer, but apparently I got some wrong instructions. The error I get is:

Fatal error: Call to a member function postage_country_display() on a non-object in file.php on line 34

I've been searching the web high and low and can't seem to find a solution. Does anyone have a hint at what might be wrong?



Here is the code that's causing the problem and the class.

Code:

Code: [Select]
$template->set('items_id', intval($_REQUEST['items_id']));

$item_details = $db->get_sql_row("SELECT * FROM " . DB_PREFIX . "items WHERE
items_id='" . intval($_REQUEST['items_id']) . "'");

$unCountryPrice = unserialize(stripslashes($db->add_special_chars($item_details['country_postage'])));
// print_r($unCountryPrice);

$postageCountry = $item->postage_country_display($unCountryPrice,$item_details['currency']);

$template->set('postageCountry', $postageCountry);


$template->set('item_details', $item_details);

And here is the class:

Code: [Select]
function postage_country_display($unCountryPrice,$currency) {
  if (is_array($unCountryPrice)) {

$postageCountry = "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
";
        $fees = new fees();
while (list($k,$v)= each($unCountryPrice)){
       $cQueyr = $this->query("SELECT a.name as name1,b.name as name2 FROM " . DB_PREFIX . "countries a LEFT JOIN " . DB_PREFIX . "countries b ON (a.parent_id = b.id) WHERE a.id = '". $k ."'");
$cRow = $this->fetch_array($cQueyr);

$postageCountry.="<tr><td>". ($cRow['name2']==""?$cRow['name1']:$cRow['name2'].' > '.$cRow['name1']) ."</td><td>&nbsp;".$currency.' '.number_format($v,2)."</td></tr>";
    }
$postageCountry.="</table>";
}
return  $postageCountry;