Referencing php version in script

ttheen

I'm using a server that has both php 4 and 5 loaded on it. When I load a .php page written as if I was using php 5, I get an error msg. The host support told me I need to reference php 5 in my script. They weren't sure how to do that though, but gave me a tip to save my file as "index.php5", but that doesn't seem to work either, at least I don't get an error message, but I end up with a blank screen. Anyone have an idea? I can't seem to find any information on this anywhere!

Thanks,
Terrell

Jack_McSlay

what error message?

ttheen

When I use php 5 syntax as shown here, I get the following Fatal error:

$cxn = mysqli_connect($host,$user,$password,$dbname)
	or die ("Couldn't connect to server.");

$query = "select brand from products";
$result = mysqli_query($cxn,$query)
	or die ("Couldn't execute query.");


    Fatal error: Call to undefined function: mysqli_connect() in     /usr/home/ttheen01/www/htdocs/skate_test_01.php on line 17 (Line 17 is the first line above that connects to the database)

When I use php 4 syntax as shown below, everything works fine.

$cxn = mysql_connect($host,$user,$password)
	or die ("Couldn't connect to server.");
mysql_select_db($dbname);

$query = "select brand from products";
$result = mysql_query($query)
	or die ("Couldn't execute query.");

bpat1434

php 5 uses the same exact functions as php 4. [man]mysqli_connect/man is the improved extension, not the "replacement" function. [man]mysql_connect/man will work in php 5.

Now, that's all dependent upon whether or not you have the MySQL and/or MySQLi extensions enabled in your php build. A quick phpinfo() should help you figure out which extensions are enabled.