[RESOLVED] Php 4/5 issues

[everynewday]

I'm building a website, and I've been using Php 5 on my computer. I found out, however, that my hosting company still uses php 4. I uploaded my php files anyway, and they don't seem to be working. Does anyone know a good place to find what in my Php files may not be compatible with Php 4? Thanks

[bradgrafelman]

everynewday wrote:

Does anyone know a good place to find what in my Php files may not be compatible with Php 4?

First place? Your browser window. Turn on display_errors and set error_reporting to E_ALL and pay attention to all of the notices/warnings/errors.

Second place? Here. If you've got some lines that are causing you trouble, post some code snippets here.

[everynewday]

Here's part of the code. It's all pretty much just querying MySQL databases. I took out the urls for the files, but I have the correct ones in the real file.

require_once('database class file');

if ($_POST['action'] == 'listAll') {
$sql = 'SELECT * FROM bandlist ORDER BY band_name';
echo getUserList($sql);
}

function getUserList($sql) {
$db = new Database('sql server name',username,password,table);
$result = $db->query($sql);
$numrows = $result->num_rows;
$userlist = "total=$numrows";
$counter = 0;
while ($row = $result->fetch_assoc()) {
$userlist .= '&band_id'.$counter.'='.urlencode(stripslashes($row['band_id']));
$userlist .= '&band_name'.$counter.'='.urlencode(stripslashes($row['band_name']));
$userlist .= '&band_picture'.$counter.'='.urlencode(stripslashes($row['band_picture']));
$counter++;
}
$db->close();
return $userlist;
}

This code fails to run on my server, but works perfectly on my own computer.

[bradgrafelman]

What kind of errors are you getting? Something like this?

Fatal error: Cannot instantiate non-existent class: database

If so, try using functions instead of objects:

$db = mysql_connect('sql server name', 'username', 'password');
mysql_select_db('dbname');
$result = mysql_query($sql);
// etc.

[everynewday]

I think, for some reason, the "require_once" thing isn't working. The error I get says "Fatal error: class Database not found".

[bradgrafelman]

What does the database class file look like?

[everynewday]

This is the database php.

<?php
class Database {

var $host;
var $user;
var $pwd;
var $dbName;
var $flash;
var $dbLink;
var $result;
var $resultObj;

function Database($host, $user, $pwd, $dbName, $flash=1){
$this->host = $host;
$this->user = $user;
$this->pwd = $pwd;
$this->dbName = $dbName;
$this->flash = $flash;
$this->connect();
}

// Connect to the mySQL Server and Select the database
function connect() {
$this->dbLink = @mysql_pconnect($this->host, $this->user, $this->pwd);
if (!$this->dbLink) {
$error = 'Couldn\'t connect to mySQL Server';
echo $this->flash ? 'error='.urlencode($error) : $error;
exit();
}
if (!mysql_select_db($this->dbName, $this->dbLink)) {
$error = 'Couldn\'t open Database: '. $this->dbName;
echo $this->flash ? 'error='.urlencode($error) : $error;
exit();
}
return $this->dbLink;
}

// Execute an SQL query
function query($query) {
$this->result = mysql_query($query, $this->dbLink);
if (!$this->result) {
$error = 'MySQL Error: ' . mysql_error();
echo $this->flash ? 'error='.urlencode($error) : $error;
exit();
}
// store result in new object to emulate mysqli OO interface
$this->resultObj = new MyResult($this->result);
return $this->resultObj;
}

function close(){
// Close MySQL Connection
mysql_close($this->dbLink);
}
}

class MyResult {

var $theResult;
var $num_rows;

function MyResult(&$r) {
if (is_bool($r)) {
$this->num_rows = 0;
}
else {
$this->theResult = $r;
// get number of records found
$this->num_rows = mysql_num_rows($r);
}
}

// fetch associative array of result (works on one row at a time)
function fetch_assoc() {
$newRow = mysql_fetch_assoc($this->theResult);
return $newRow;
}

}
?>

[bradgrafelman]

Hmm. That code works fine on my server running PHP 4.4.2 ... what version of PHP are you running?

What is the path you're using in require_once ?

[everynewday]

My server uses Php 4.3.10

The path in my require_once statement is http://alternativedevotion.com/phpfiles/database.php

[bradgrafelman]

Ah, there's your problem. You can't include PHP files through an URL.

Well, technically you can, but think about what you're doing: you're making an HTTP request to the server for that requested file. That's the equivalent of opening up your browser, going to that URL, and viewing the source of the page. That is what PHP is loading.

You'll need to load the file using a path relative to the server's hard drive. You can either use absolute or relative paths, such as:

require_once 'includes/database.php'; // relative path; looks for "includes" folder in current folder
require_once '/home/username/path/to/database.php'; // absolute path, the full path on the hard drive

[everynewday]

Yeah, I actually just figured that out. Now the php seems to be working fine, but it won't connect to the database. Now I have to figure out how to connect to the database.

[bradgrafelman]

Sounds like you might need to check with the host - verify that you have the correct address to the MySQL server, as well as the correct username, password, database name, etc.

Just a note for clarification - in your getUserList() function, you had "table" as the last parameter for the Database() function... but that should be the name of the database, not the table. I wasn't sure if that was a typo or not... just making sure.

[everynewday]

Got it! It was this line in the database class file that was messing it up:

$this->dbLink = @mysql_pconnect($this->host, $this->user, $this->pwd);

I changed it to this:

$this->dbLink = @mysql_connect($this->host, $this->user, $this->pwd);

It works now. Thanks a ton for your help!