PHP - Moved: Complex Query Call In Php

Hi guys,

I am trying to implement a Pagination class for a website displaying movies. I need to have the total number of posts, but on accessing the function row_count() from class Connection I get the error: "Fatal error: Uncaught Error: Call to a member function query() on null in ..\connection.php:30 Stack trace: #0 from ...\index.php(20): Connection->row_count() #1 ..."

I only found two posts concerning this issue, and they led me to think this might be a scope issue with $db variable; $db is defined in the constructor function of the same Connection class so I thought the scope would be ok; but apparently, not.

Can anybody help? This is a real show-stopper just now. Please let me know if you need any further information.

Thanks in advance.

Sept

connection.txt index.txt

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

I don't even know how to explain what I want to do as a subject. >.<

Okay, so what I want to do is pull up all the entries in a table, (in this case "horse") for a specific location. Then, I want to pull all the results for that horse from the "result" table. Next, I want to compare each result from that table to a list of if/elseif for points. Finally, I want all the points gathered and totaled and displayed for that horse, and every other horse at that location, in a single page.

Here is the coding that I have:

Code: [Select]
<?
---- connection information is here but removed -----


echo "<table>
<tr><td><b>Name</b></td> <td><b>Points</b></td> <td><b>Title</b></td></tr>";

//finds horses at specific location
$query = "SELECT * FROM horse WHERE location='DESIRED_LOCATION' ORDER BY name";
$result = mysql_query($query) or die (mysql_error());
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$name = $row['name'];

        //gathers results based upon the above two pieces of information
        //the include is shown below as it contains the point info
include('includes/points.php');
$query92 = "SELECT * FROM results WHERE MAIN_KEY='$id' OR MAIN_KEY = '$name'";
$result92 = mysql_query($query92) or die (mysql_error());
while($row92 = mysql_fetch_array($result92)) {
$place = $row92['place'];
echo "<tr><td>$name</td> <td>$points</td> <td>$title</td></tr>";
}
}
echo "</table>";
?>
and this is the points.php file:
Code: [Select]
<?

if($place === '1st') {$points += 50;}
elseif($place === '2nd') {$points += 45;}
elseif($place === '3rd') {$points += 40;}
elseif($place === '4th') {$points += 35;}
elseif($place === '5th') {$points += 30;}
elseif($place === '6th') {$points += 25;}
elseif($place === '7th') {$points += 20;}
elseif($place === '8th') {$points += 15;}
elseif($place === '9th') {$points += 10;}
elseif($place === '10th') {$points += 10;}
elseif($place === 'CH') {$points += 50;}
elseif($place === 'RCH') {$points += 40;}
elseif($place === 'TT') {$points += 30;}
elseif($place === 'T5') {$points += 30;}

if($points < 500) {$title = "No Title";}
elseif ($points >= 500 && $points < 1000) {$title = "Champion";}
elseif ($points >= 1000 && $points < 2500) {$title = "Grand Champion";}
elseif ($points >= 2500 && $points < 5000) {$title = "State Champion";}
elseif ($points >= 5000 && $points < 8000) {$title = "National Champion";}
elseif ($points >= 8000 && $points < 10000) {$title = "World Champion";}
elseif ($points >= 10000) {$title = "Hall of Fame";}
?>

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)

Code: [Select]
<?php

class OnlineStore {

private $DBConnect = NULL;
private $storeID = "";
private $inventory = array();
private $shoppingCart = array();
function __construct() {
include("inc_OnlineStoreDB.php");
$this->DBConnect = $DBConnect;
}
function __destruct() {
if (!$this->DBConnect->connect_error)
$this->DBConnect->close();
}

public function setStoreID($storeID) {
if ($this->storeID != $storeID) {
$this->storeID = $storeID;
$SQLstring = "SELECT * FROM inventory " .
" where storeID = 'jw" .
$this->storeID . "'";
$QueryResult = $this->DBConnect->query($SQLstring);
if ($QueryResult === FALSE) {
$this->storeID = "";
} else {
$this->inventory = array();
$this->shoppingCart = array();
while (($Row = $QueryResult->fetch_assoc()) !== NULL) {
$this->inventory[$Row['productID']] = array();
$this->inventory[$Row['productID']]['name'] = $Row['name'];
$this->inventory[$Row['productID']]['description'] = $Row['description'];
$this->inventory[$Row['productID']]['price'] = $Row['price'];
$this->shoppingCart[$Row['productID']] = 0;
}
}
}
}

public function getStoreInformation() {
$retval = FALSE;
if ($this->storeID != "") {
$SQLstring = "SELECT * FROM store_info " .
" WHERE storeID = '" .
$this->storeID . "'";
$QueryResult = @$this->DBConnect->query($SQLstring);
if ($QueryResult !== FALSE) {
$retval = $QueryResult->fetch_assoc();
}
}
return($retval);
}

public function getProductList() {
$retval = FALSE;
$subtotal = 0;
if (count($this->inventory) > 0) {
echo "<table width='100%'>\n";
echo "<tr><th>Product</th><th>Description</th>" .
"<th>Price Each</th><th># in Cart</th>" .
"<th>Total Price</th><th>&nbsp;</th></tr>\n";
foreach ($this->inventory as $ID => $Info) {
echo "<tr><td>" .
htmlentities($Info['name']) . "</td>\n";
echo "<td>" . htmlentities($Info['description']) . "</td>\n";
printf("<td class='currency'>$%.2f</td>\n", $Info['price']);
echo "<td class='currency'>" . $this->shoppingCart[$ID] . "</td>\n";
printf("<td class='currency'>$%.2f</td>\n", $Info['price'] * $this->shoppingCart[$ID]);
echo "<td><a href='" . $_SERVER['SCRIPT_NAME'] . "?PHPSESSID=" . session_id() . "&ItemToAdd=$ID'>Add " . " Item</a></td>\n";
$subtotal += ($Info['price'] * $this->shoppingCart[$ID]);
}
echo "<tr><td colspan='4'>Subtotal</td>\n";
printf("<td class='currency'>$%.2f</td>\n", $subtotal);
echo "<td>$nbsp;</td></tr>\n";
echo "</table>";
$retval = TRUE;
}
return($retval);
}

public function addItem() {
$ProdID = $_GET['ItemToAdd'];
if (array_key_exists($ProdID, $this->shoppingCart))
$this->shoppingCart[$ProdID] += 1;
}


}

?>

having an issue to where nothing is appearing on the page and getting the
Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\PHP\Chapter.10\class_OnlineStore.php on line 24

HERE IS THE MAIN PAGE
Code: [Select]
<?php
session_start();
require_once("class_OnlineStore.php");

$storeID = "COFFEE";
$storeInfo = array();

if (class_exists("OnlineStore")) {
if (isset($_SESSION['currentStore']))
$Store = unserialize($_SESSION['currentStore']);
else {
$Store = new OnlineStore();
}
$Store->setStoreID($storeID);
$storeInfo = $Store->getStoreInformation();
} else {
$ErrorMsgs[] = "The OnlineStore class is not available!";
$Store = NULL;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php echo $storeInfo['name']; ?></title>
<link rel="stylesheet" type="text/css" href="<?php echo $storeInfo['css_file']; ?>" />
</head>

<body>
<h1><?php echo htmlentities($storeInfo['name']); ?></h1>
<h2><?php echo htmlentities($storeInfo['description']); ?></h2>
<p><?php echo htmlentities($storeInfo['welcome']); ?></p>

<?php 
$Store->getProductList();
$_SESSION['currentStore'] = serialize($Store);
?>

</body>
</html>

I HAVE REVIEWED IT OVER AND OVER AGAIN AND I CANT SEE THE PROBLEM. MAYBE SOMEONE FROM THE OUTSIDE CAN HELP OUT.

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=334644.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=311501.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=357605.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=321957.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=345884.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=344191.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=311010.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=329559.0

OVERVIEW:

The code is about making call to the escreen web service using SOAP and Curl with client authentication required. Currently I am not getting any result only HTTP 403 and 500 errors.
The call requires client authenticate cert to be on the callng site.

CODE:

    $content = "<TicketRequest>
      <Version>1.0</Version>
      <Mode>Test</Mode>
      <CommitAction></CommitAction>
      <PartnerInfo>
      <UserName>xxxxxxxxxx</UserName>
      <Password>xxxxxxxxxxx</Password>
      </ PartnerInfo>
      <RequestorOrderID></RequestorOrderID>
      <CustomerIdentification>
        <IPAddress></IPAddress>
        <ClientAccount>xxxxxxxxxx</ClientAccount>
        <ClientSubAccount>xxxxxxxxxx</ClientSubAccount>
        <InternalAccount></InternalAccount>
        <ElectronicClientID></ElectronicClientID>
      </CustomerIdentification>
      <TicketAction>
        <Type></Type>
        <Params>
          <Param>
          <ID>4646</ID>
          <Value></Value>
          </Param>
        </Params>
      </TicketAction>
    </TicketRequest>";
    
    $wsdl  = "https://services.escreen.com/SingleSignOnStage/SingleSignOn.asmx";
    
    $headers = array(  "Content-type: text/xml;charset=\"utf-8\"", 
         "Accept: text/xml", 
         "Cache-Control: no-cache", 
         "Pragma: no-cache", 
      //   "SOAPAction: \"\"", 
         "Content-length: ".strlen($content),
        ); 
     
    
    $ch = curl_init(); 
    curl_setopt($ch, CURLOPT_URL, $wsdl); 
    curl_setopt($ch, CURLOPT_HEADER, 1); 
    curl_setopt($ch, CURLOPT_VERBOSE, '1');
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); 
    curl_setopt($ch, CURLOPT_POSTFIELDS, $content); 
    
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, '1');
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, '1');
    //curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type: text/xml"));
    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); 
    //curl_setopt($ch, CURLOPT_HTTPHEADER, array('SOAPAction: ""')); 
    curl_setopt($ch, CURLOPT_CAPATH, '/home/pps/');
    curl_setopt($ch, CURLOPT_CAINFO,  '/home/pps/authority.pem');
    curl_setopt($ch, CURLOPT_SSLCERT, 'PROTPLUSSOL_SSO.pem');
    curl_setopt($ch, CURLOPT_SSLCERTPASSWD, 'xxxxxxxxxxxx');
    
    $output = curl_exec($ch);
    
    // Check if any error occured
    if(curl_errno($ch))
    {
        echo 'Error no : '.curl_errno($ch).' Curl error: ' . curl_error($ch);
    }
    
    print_r($output);



QUESTIONS:

1. I need to call the RequestTicket method and pass the XML string to it.
   I don't know how to do it here(pass the method name to call).

2. For client authentication they gave us three certs, one root cert, one intermediate
   cert and a client authentication cert PROTPLUSSOL_SSOpem(it was a .pfx file). Since we are on linux we converted them to pem . In curl calls I could not find way to how to include both the root cert and the intermediate cert ,so I combined them by making a new pem file and copying the intermediate cert and them the root cert and naming it authority.pem .
I am not sure whether it works or not and would like your opinion.

3. For the current code Iam getting the error
   Error no : 77 Curl error: error setting certificate verify locations: CAfile: /home/pps/authority.pem CApath: /home/pps/

 
  If I disable the curl error message,I am getting blank page with page title 403 - Forbidden. Access is denied.

  If I comment out the CURLOPT_CAPATH and CURLOPT_CAINFO lines it gives http 500 error page with the message as content and the following at the top.

 > HTTP/1.1 500 Internal Server Error. Cache-Control: private Content-Type: text/html Server: Microsoft-IIS/7.5 X-AspNet-Version: 1.1.4322 X-Powered-By: ASP.NET Date: Thu, 02 Sep 2010 14:46:38 GMT Content-Length: 1208

If I comment out as above and also CURLOPT_SSLCERT and CURLOPT_SSLCERTPASSWD it gives 403 error with the message as content.

So I would request you to help me out by pointing out whats wrong with the current code.

Thank you.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=306850.0