PHP/Pear problem

cac818

I've put together a rather simple PHP application from one of the books I've read. The problem is that the book uses Pear DB script in the PHP procedures yet the GoDaddy account I have doesn't have Pear DB. (At least I believe this is the problem)

Is there any easy way of rewriting scripts so it's just plain PHP/MySQL instead of with the Pear DB?

For example, at the outset of loading the PHP application, I'm getting an error here:

'dsn'=>"mysql://$db_username:$db_password@$db_host/$db_database"

There's nothing wrong with the script, the whole script up to that point is the following:

<?php
// Example of Auth_HTTP the also returns additional information about the user
require_once('config.php');
require_once('db_login.php');
require_once('Auth/HTTP.php');
//We use the same connection string as the pear db functions
$AuthOptions = arrary(

'dsn'=>"mysql://$db_username:$db_password@$db_host/$db_database",

There error states:

Parse error: syntax error, unexpected T_DOUBLE_ARROW in /html/ACA/SA/index.php on line 8

Would anyone have an idea on what the problem could be? Thanks in advance.

halojoy

Simple spelling mistake:

$AuthOptions = arrary(

cac818

Thanks for the reply,

Unfortunately, I caught that after the post but that was not the problem. I think it's the => because I've run into problems with that before and I think that's part of the PEAR. I'm still doing research but please reply if anyone knows the answer.

Thanks.

NogDog

The "=>" operator has nothing to do with PEAR, it's a standard PHP operator for use in specifying the connection between an array element key and its value.

From the code provided, I noted the comment:

//We use the same connection string as the pear db functions

This suggests to me that -- possibly -- they are using something other than PEAR:😃B, but like it. Then again, it may just be a misleading comment.

Anyway, certainly things could be changed to use another database interface, but where exactly to make those changes would depend on whether you want to rewrite code everywhere in the main script where a database interaction occurs, or if you want to rewrite one or more of the include files, or what...?

cac818

Many thanks for the replies.

Apparently, it's getting into the database now but I have an error on the 'Auth/HTTP.php' side. My code and the error is below:
Code:
<?php
// example of auth_http the also returns additional information about the user
require_once('config.php');
require_once('db_login.php');
require_once('Auth/HTTP.php');
//we use the same connection string as the pear db functions
$AuthOptions = array(
'dsn'=>"mysql://$user:$pass@$host/$db",
'table'=>"users",// your table name
'usernamecol' =>"username", //the table username column
'passwordcol' =>"password",//the table password column
'crypttype'=>"md5", //password encryption type in your db
'db_fields'=>"*"//enabling fetch for other db columns
);
$authenticate = new Auth_HTTP("db", $AuthOptions);

Error:
Fatal error: Class 'Auth_HTTP' not found in /home/content/c/a/c/cachickedantz/html/ITQHome/SA/index.php on line 15

I'm assuming this means that the class cannot be found because the 'HTTP.php' is not in the right directory.

Still researching and I will update this post if I find a good solution. Thanks for any guidance.

halojoy

Checkout the include_path in php.ini
The directory where /Auth/ is should be one of include_paths.
This is the root folder of PEAR, I think.

phpinfo(); shows what is include_path

One workaround is to put a copy of /Auth/HTTP.php in your website root.
But better is to fix the include_path in php.ini to have correct path to your PEAR directory.

cac818

So I moved the php.ini path but I'm using WordPress on GoDaddy (mistake?) and in the http.php file I have from the WordPress server has a LONG http.php file. I looked for a class in this file that seemed like it would fit with the Auth_http and used the WP_http but now I'm getting the following error on the http.php code:

Code:
function test($args = array()) {
return apply_filters('use_http_extension_transport', function_exists('http_request'), $args );

Error:

Fatal error: Call to undefined function apply_filters() in /home/content/c/a/c/cachickedantz/html/ITQHome/SA/http.php on line 1188

I'm not sure what the problem is here. The http.php file is excessively long so would there be a different file out there used for PEAR and http.php?