[RESOLVED] problems after upgrading to php5

rickbot

hi folks. i've recently upgraded my php from 4 to 5 and its acting very strangely.
i've been following a book (Beginning php apache mysql web development) and some of my scripts are still working but when i try anything that involves mysql, i get a blank page. no errors, just blank, and 'display_errors' is turned on in php.ini. phpinfo() also gives the same result. i'm using suse 10.0 with apache 2.0.54 and mysql 4.1.13. i've used apt/synaptic to upgrade php and i selected everything available so i don't think i could be missing anything. if anyone is familliar with this book, i'm on the 'moviesite' section and the earlier files which only access other php files are working fine, its when i try the stuff that creates the database and populates it that apparently nothing happens. the same phpinfo() file which worked fine with php4 now comes up blank as well. i've gone through my apache config files and can't see anything wrong. any ideas?

bradgrafelman

You say phpinfo() is blank? By any chance, is this what your file looks like:

<?
phpinfo();
?>

If so, ditch the deprecated short tags and use the proper, full tags:

<?php
phpinfo();
?>

Next... as to why MySQL commands won't work... you probably are using the [man]MySQL[/man] module. In PHP5, the MySQL module is not enabled by default - instead, it has been replaced by the [man]MySQLi[/man] module.

rickbot

my phpinfo file is identical to your second expmple. i don't use short open tags. as for the module, i have both php5-mysql and php5-mysqli packages installed. do i have to do something else to enable a module? and in either case, shouldn't i still get an error displayed?

stolzyboy

so, sounds like apache/php don't konw about mysql being there or are not config'd correctly... do you have full error_reporting on to see if there are any messages, normally if mysql isn't working, it'll throw errors

have you gotten ANY mysql integration to work aside from the movies chapter?? i mean, have you tried any other simple scripts, such as just a quick mysql_connect() to see what it does?

btw, that book sounds oddly familiar 😉

stolzyboy

rickbot

One of the authors! far out! so i guess you know what i'm up to. i tried running this:

<?php
     mysql_connect("localhost", "root", "*****")
        or die (mysql_error());
     echo "connection successful";
?>

and got this:

Unknown MySQL server host 'â&#8364;&#339;localhostâ&#8364;' (1)

at least its something but i have no idea what. as far as error reporting, my php.ini shows:

error_reporting  =  E_ALL & ~E_NOTICE
display_errors = On

is this what you mean by 'full error_reporting'? my original php4 install was what came with the distro and since i upgraded, i haven't changed anything config-wise so i have no idea what could have gone haywire.

rickbot

ok, i think i found something. in the files i used to create and populate the database, i just copied and pasted code from the book (pdf) and for some reason, the double-quotes turned out to be not recognized by php. once i re-typed all the double-quotes manually, everything works. what i don't understand is that phpinfo() now works also and i didn't change anything there. thanks for looking into it anyways.

bradgrafelman

The PDF apparently used curly quotes. Sure, they're more aesthetically pleasing, but PHP only recognizes a standard double quote. Guess you should blame the authors of the book... erm, well, nevermind. :p

rickbot

ok, not resolved...
i typed this all manually and no 'Movie Database successfully created', no errors, nothing. browser says 'page loaded' but its blank.

<?php
//connect to mysql
$connect = mysql_connect("localhost", "root", "*****") or
    die (mysql_error());

//create main database
mysql_create_db("wiley") or
    die (mysql_error());

//select database
mysql_select_db("wiley");

//create "movie" table
$movie = "CREATE TABLE movie (
    movie_id int(11) NOT NULL auto_increment,
    movie_name varchar(255) NOT NULL,
    movie_type tinyint(2) NOT NULL default 0,
    movie_year int(4)  NOT NULL default 0,
    movie_leadactor int(11) NOT NULL default 0,
    movie_director int(11) NOT NULL default 0,
    PRIMARY KEY (movie_id),
    KEY movie_type (movie_type, movie_year)
    )
    TYPE=MyISAM AUTO_INCREMENT=4";

$results = mysql_query($movie)
    or die (mysql_error());

//create "movietype" table
$movietype = "CREATE TABLE movietype (
    movietype_id int(11) NOT NULL auto_increment,
    movietype_label varchar(100) NOT NULL,
    PRIMARY KEY (movietype_id)
    )
    TYPE-MyISAM AUTO_INCREMENT=9";

$results = mysql_query($movietype)
    or die (mysql_error());

//create "people" table
$people = "CREATE TABLE people (
    people_id int(11) NOT NULL auto_increment,
    people_fullname varchar(255) NOT NULL,
    people_isactor tinyint(1) NOT NULL default 0,
    people_isdirector tinyint(1) NOT NULL default 0,
    PRIMARY KEY (people_id)
    )
    TYPE=MyISAM AUTO_INCREMENT=7";

$results = mysql_query($people)
    or die (mysql_error());

echo "Movie Database successfully created!";
?>

my apologies for calling 'resolved'. when i tried this(with quotes fixed):

<?php
     mysql_connect("localhost", "root", "*****")
        or die (mysql_error());
     echo "connection successful";
?>

i got 'connection successful' so i got excited but apparently i haven't got much further.

bradgrafelman

Is display_errors set to On and error_reporting set to E_ALL ? If not, make those changes (using [man]ini_set/man at the top of your script, if nothing else) and let us know if PHP gives you any errors.

How far does the script get? Does the database get created? Do ANY of the tables get created?

EDIT: It might be more error-proof to get rid of mysql_create_db() in place of this query:

$query = 'CREATE DATABASE IF NOT EXISTS `dbName`';

In fact, you can add the 'IF NOT EXISTS' keywords after 'CREATE TABLE' as well. Or, if you want to make sure the tables have the correct structure, drop 'em first:

$query = 'DROP TABLE IF EXISTS `tableName`';
mysql_query($query);

$query = 'CREATE TABLE `tableName`'; // etc.

EDIT2: Well, I started debugging your queries (copied & pasted them into phpMyAdmin on a test D😎 and found an error: In the 'movietype' query, you have "TYPE-MyISAM" instead of "TYPE=MyISAM". That's the only SQL error I found.

EDIT3: Oh, by the way, I forgot... I 'unmarked' this thread as resolved for you. :p

rickbot

ok, fixed the syntax error. no change. as i mentioned before, my php.ini has:

error_reporting  =  E_ALL & ~E_NOTICE
display_errors = On

so that means i should get errors displayed, right? i've checked with mysql via terminal and 'show databases;' shows nothing new so the script apparently didn't get anywhere. i'll try the other method you show here when i have time to get into it again (i'm done for the night) but unless i have a config error or something really wrong, shouldn't the code i have be working? and since no database or tables have been created, there's nothing to 'drop' first. i've read in several places that the mysql extension is not enabled by default in php5 and all i know is that i installed an rpm for it. i don't know if that means its 'enabled' but then the simple 'connect' script did work so... i'm lost.

bradgrafelman

Well, first thing would indeed be to double check that the MySQL extension is available. To do that, do a phpinfo() and look for a "mysql" table.

Next... I would add ini_set('error_reporting', E_ALL); to this script. Your setting shows all errors except notices, and since this script isn't working we really want to see every single error message PHP has to give us.

stolzyboy

k, rickbot... curious to where you are at at this point?

i didn't write this chapter, but i know who did and i went through it at one point or another for "quality assurance"(LOL)... and it worked fine for me

so, again, just curious to see at what point you are at now

stolzyboy

rickbot

hi, stolzyboy. i'm still at the same point i was at last time i heard from you - the 'moviesite' section. i've done little bits of php/mysql stuff in the past and i'm really just going through the book to re-aquaint myself after a long break. i know enough that i can at least understand a piece of code when i look at it and i can see nothing wrong with the scripts in the book. its got to be a config problem on my end. i'm really happy with the book actually. you get to put everything into practice as you learn which is really the only way to learn. i've gotten to the part where i've written the scripts which create the database and load the data. everything before this has worked perfectly but i seem to have a problem with php and mysql playing together.

bradgrafelman, i tried adding 'ini_set('error_reporting', E_ALL);' to the top of the script and there's no change. phpinfo() shows both mysql and mysqli tables. here they are:

mysql
MySQL Support
enabled
Active Persistent Links   0 
  Active Links   0 
  Client API version   4.1.13 
  MYSQL_MODULE_TYPE   external 
  MYSQL_SOCKET   /var/lib/mysql/mysql.sock 
  MYSQL_INCLUDE   -I/usr/include/mysql 
  MYSQL_LIBS   -L/usr/lib -lmysqlclient 


Directive
Local Value
Master Value
mysql.allow_persistent  Off  Off
  mysql.connect_timeout  60  60
  mysql.default_host  no value  no value
  mysql.default_password  no value  no value
  mysql.default_port  no value  no value
  mysql.default_socket  no value  no value
  mysql.default_user  no value  no value
  mysql.max_links  Unlimited  Unlimited
  mysql.max_persistent  Unlimited  Unlimited
  mysql.trace_mode  Off  Off


mysqli
MysqlI Support
enabled
Client API version   4.1.13 
  MYSQLI_SOCKET   /var/lib/mysql/mysql.sock 


Directive
Local Value
Master Value
mysqli.default_host  no value  no value
  mysqli.default_port  3306  3306
  mysqli.default_pw  no value  no value
  mysqli.default_socket  no value  no value
  mysqli.default_user  no value  no value
  mysqli.max_links  Unlimited  Unlimited
  mysqli.reconnect  Off  Off

there's alot of things that say 'no value', is there a default value thats used or am i missing something there? and btw, i did change 'error_reporting = E_ALL & ~E_NOTICE' to 'error_reporting = E_ALL & E_NOTICE' and i'm still getting blank pages.

rickbot

now i feel stupid. turns out there are -2- 'php.ini' files. all this time i've been looking at /etc/php.ini and now i've discovered /etc/php5/apache2/php.ini. i've edited the latter to turn display_errors on and ran the script again and:

Fatal error: Call to undefined function mysql_create_db() in /home/rickbot/public_html/htdocs/moviesite/createmovie.php on line 8

i wrote that part exactly as it is in the book so erm... gotta blame somebody!😃

bradgrafelman

'Tis why I suggested my replacement for that function above :p You have the Mysql 4.x client library, which doesn't support this function.

I'm not sure when the book was written, but perhaps this function wasn't deprecated back then? Otherwise... I still blame stolzy! :p

rickbot

just kidding about the blaming. got it this time! the edition of the book i'm using concerns php4 and 'mysql_create_db()' no longer works in php5. i changed:

mysql_create_db("wiley") or
    die (mysql_error());

to:

mysql_query("CREATE DATABASE IF NOT EXISTS wiley")
    or die (mysql_error());

and... "Movie Database successfully created!". at least i can say that using an old book and debugging things like this ought to be a good learning experience. thanks guys.

stolzyboy

yeah, that one was php4, there has since been a php5 that was released 🙂 no blame here, lol...