PHP - Pdo Exception And Object Problem

How to get cURL timedout Exception or cURL timedout Message ?

at this point, I've authenticated with the login service, and I believe I'm now passing the cookie correctly to the ADBAccess service, but when I do a soapcall to getCMSData, I'm getting an exception.

Here's the relevant code:

                $agDataService->__setCookie('cookie', $s_Cookie);
               
                $a_includeList[0]="*";

                $a_getCMSTables_args['opName']='accounts';
                $a_getCMSTables_args['startDate']='01/07/2011';
                $a_getCMSTables_args['endDate']='01/08/2011';
                $a_getCMSTables_args['lastID']='';
                $a_getCMSTables_args['includeList']= a_includeList;

                $agTables = $agDataService->__soapCall('getCMSData', $a_getCMSTables_args, null, new SoapHeader('http://webservice.agemni.com', 'cookie', $s_Cookie));

and here's the exception:
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object. at ADBAccess.setErrorXML(XmlDocument& responseDoc, XmlElement& DocRoot, String ErrorMessage, Int32 ErrorNum, Int32 numRecords) at ADBAccess.getCMSData(String opName, String startDate, String endDate, String lastID, String[] includeList) --- End of inner exception stack trace ---

any ideas?

hello to all, My issue is that i have a script encoded with zend and the script some pages work some are just BLANK  Zend it is installed :     This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.4.0, Copyright © 1998-2014 Zend Technologies
    with the ionCube PHP Loader v4.7.1, Copyright © 2002-2014, by ionCube Ltd., and
    with Zend Guard Loader v3.3, Copyright © 1998-2013, by Zend Technologies
Configuration File (php.ini) Path /usr/local/lib Loaded Configuration File /usr/local/lib/php.ini     and Its throwing exception he     Can someone please help cuz i am tryin like a week to fix it but no results
Edited by SSopranos, 07 January 2015 - 02:21 PM.

For convenience and efficiency purposes I'm changing my MySQL database to store PHP Objects as opposed to tons of individuals variables. In converting the user/login system I've come across a really weird problem. I can register a new user to the site, but only the first one in the database will work. I can register others and they get put in the database correctly, but for some reason the app doesn't see them or even recognize that they exist. Only the first entry in the database will work as it's supposed to. For instance, if I drop the first database entry, the second one (now first) will begin to work.

In most cases, I'm pulling all Object entries from the database and looping through them with foreach() to find the specific one I want.

I've just come off of an 8 hour coding spree and my brain is just shot at the moment. I really think I just need a new pair of eyes. I'm sure that it's something simple, but I can't see it atm. I'm attaching the User class file which handles login, registration, and anything that I think would be affecting this.

Thanks for the help.

Hi guys, I'm reviewing a piece of small web application and the current application does not have any error / exception handling capability. If there is any error, it would simply show an error message followed by die;.

I'm planning to implement a simple exception handling class to handle the errors. What I'm thinking is a simple redirect when an error is being caught together with an error code that correspond to an error message in a simple flat text file. The error page will then show an error message that corresponds to the code.

Here's what I have so far. Would appreciate if the PHP experts here would give simple pointers to enhance it.

<?php
class MyException extends Exception {}

try {
throw new MyException("error.php");
}

catch (MyException $e) {
$file = $e->getMessage();
header("Location: $file?e=1");
}

?>

This is what I have on my error.php page

<?php
$errorcode = $_GET['e'];

function getErrorMessage($errorcode) {
$errors = file("english.txt");
foreach ($errors as $error) {
list ($key,$value) = explode(",",$error,2);
$errorArray[$key] = $value;
}
return $errorArray[$errorcode];
}
echo "Test <br />";
echo getMessageMap($errorcode);
?>

As you can see here, exception class would redirect user to error.php if an error is caught together with a GET variable on the URL. On error.php page, it would GET the error code and then run it through a function to get the error message of the corresponding error code and then echos it out.

Was wondering if this is a good practice? My ultimate goal here is to avoid displaying the error message itself on private includes file.

Thank you in advance for your suggestions.

I've been starting to play around the mysqli class and I've been having trouble using it due to various error it gives me from simple queries like this one. I'm not sure what the error is really, I've been following the php manual. Any help would be greatly appreciated.



Code: [Select]
<?php 


$mysqli = new MySQLi('localhost', 'root', 'root', 'jaipai');

if ($mysqli->connect_errno)
{
echo "There was a connection error: ". $mysqli->connecterrno;
}



class testClass 

{

private $db;


function __construct($mysqli)
{
$this->db = $mysqli;
}

public function pageInfo()
{
$query = "SELECT * FROM users WHERE username = jaipai";
$results = $this->db->query($query);

$result = $this->db->fetch_assoc($results);

return $result['username'];

}

}

$testClass = new testClass($mysqli);

echo $testClass->pageInfo();


?>
This gives me this error:
Code: [Select]
Fatal error: Call to undefined method mysqli::fetch_assoc() in /Users/JPFoster/Sites/Research & Development/Programs/Object Sandbox/DatabaseConnection.php on line 30



Just to be a little more informative I've also tried this method
Code: [Select]
$results = $this->db->query($query);

$result = $results->fetch_assoc();

return $result['username'];

This gives me an error:
Code: [Select]
Fatal error: Call to a member function fetch_assoc() on a non-object in Sites/Research & Development/Programs/Object Sandbox/DatabaseConnection.php on line 30

I'm not sure which is on the best path to go. Any help would be greatly appreciated.

This topic has been moved to Other Libraries and Frameworks.

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

In drive.php   public function insert($postBody, $optParams = array())

Hey all,

I want to have an object that has a property which is an object containing instances of other objects. I try this:
Code: [Select]
class Blog extends Posts {
public $has_posts;

public function __construct($a,$b,$c){
$has_posts = (object) array_merge((array) $a, (array) $b, (array) $c);
}
}

class Posts {
public $b;

public function __construct($b){
$this->b = $b;
}
}

$post1 = new Posts(1);
$post2 = new Posts(2);
$post3 = new Posts(3);

$blog = new Blog($post1,$post2,$post3);
var_dump($blog->has_posts); //null
foreach($blog->has_posts as $post){ //Invalid argument supplied for foreach()
echo $post->b;
}

But as you see, has_posts is null, not an object containing other objects.

Thanks for response.

I'm sure it's not much, but I'm not understanding something with custom error handlers:

I've created a custom error handler, which I initially set when my page loads :

set_error_handler(array ( new ErrorHandler(), 'handleError' ));

 

It seems to catch all internal PHP errors, such as if I: var_dump($non_existing_var); right after the set_error_handler....

Now, I have an object that throws an exception after:

set_error_handler(array ( new ErrorHandler(), 'handleError' )); 
$locale = new \CorbeauPerdu\i18n\Locale(...); // this should throw an exception 
...

I thought that with an error handler set, I could 'skip' the try/catch for it, but doing so, PHP spits out in its internal log:

PHP Fatal error: Uncaught CorbeauPerdu\i18n\LocaleException: ....

 

My error handler doesn't catch it at all before, thus my page breaks!!

If I want it to go through the error handler, I have to init my Locale with a try/catch and use trigger_error() like so:

set_error_handler(array ( new ErrorHandler(), 'handleError' ));

try { 
  $locale = new \CorbeauPerdu\i18n\Locale(...); // this should throw an exception 
}
catch(Exception $e) { 
  trigger_error($e->getMessage(), E_USER_ERROR); 
} 
...

Is this normal ? I thought one of the goals of the error_handler was to catch anything that wasn't dealt with?

Thanks for your answers!

I have a Soup object in a Bowl object in a Microwave object.

The Microwave object has the methods:

receiveItem(Bowl $b)
cookItem(???)

I want the Microwave to be able to set the Soup->temperature but I'm not how to do that?

Make sense?



TomTees

Hi

I am implementing a read-only access to some specific attributes of a class via the magic __get method. I intend to raise an exception when trying to write to it using __set, but I'm not sure which exception is suitable to use.

Is there any predefined exception to indicate such an error or should I just go ahead and define my own?

Hello all,   Appreciate if you folks could pls. help me understand (and more importantly resolve) this very weird error:     Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC, purchase_later_flag ASC, shopper1_buy_flag AS' at line 3' in /var/www/index.php:67 Stack trace: #0 /var/www/index.php(67): PDO->query('SELECT shoplist...') #1 {main} thrown in /var/www/index.php on line 67   Everything seems to work fine when/if I use the following SQL query (which can also be seen commented out in my code towards the end of this post) :  

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
           FROM shoplist, store_master, item_master
           WHERE     shoplist.store_id = store_master.store_id
                   AND shoplist.item_id = item_master.item_id";

  However, the moment I change my query to the following, which essentially just includes/adds the ORDER BY clause, I receive the error quoted above:

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name 
		FROM shoplist, store_master, item_master 
		ORDER BY purchased_flag ASC, 
				purchase_later_flag ASC, 
				shopper1_buy_flag ASC, 
				shopper2_buy_flag ASC, 
				store_name ASC) 
		WHERE 	shoplist.store_id = store_master.store_id 
				AND shoplist.item_id = item_master.item_id";

In googling for this error I came across posts that suggested using "ORDER BY FIND_IN_SET()" and "ORDER BY FIELD()"...both of which I tried with no success.   Here's the portion of my code which seems to have a problem, and line # 67 is the 3rd from bottom (third last) statement in the code below:  

                    <?php
                        /*
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        */
                    
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                ORDER BY FIND_IN_SET(purchased_flag ASC,
                                                 purchase_later_flag ASC,
                                                 shopper1_buy_flag ASC,
                                                 shopper2_buy_flag ASC,
                                                 store_name ASC)
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        $result = $pdo->query($sql);                        
                        
                        // foreach ($pdo->query($sql) as $row) {
                        foreach ($result as $row) {
                            echo '<tr>';
                                print '<td><span class="filler-checkbox"><input type="checkbox" name="IDnumber[]" value="' . $row["idnumber"] . '" /></span></td>';

    Thanks