Peter J. Boettcher — Wed, 18 Sep 2002 22:22:05 +0000

Mike,

It looks like you had your database name and table name mixed up, that's what support fixed for you so you're able to connect. Are you 100% sure that the Alumni table has data in it?

Maybe you should do a little more reading so you understand the basics a little better, check out this tutorial on webmonky: http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

fifeclub — Wed, 18 Sep 2002 15:12:42 +0000

Here's the code I got from here (minus my password). It gives me a database error (pstvalumni.com/test2.php)

Quote:

<?php // Connect to the database server $dbcnx = @mysql_connect("localhost","pstvalu_director", "PASSWORD"); if (!$dbcnx) { print "Unable to connect to the database server at this time."; exit(); } // Select alumni database if (! @mysql_select_db("alumni") ) { print "Unable to connect to the DB"; } ?>
Here are all alumni in our database:

<?php // Request the listing $query = "SELECT alumni FROM pstvalu_directory "; $result = mysql_query($query); if ($result) { // Display the listing of all alumni in a paragraph while ($row = mysql_fetch_array($result) ) { print "$row[alumni]"; } } else { echo "MySQL Error: "; echo mysql_error(); print ""; exit(); } ?>

I contacted my host tech support to double check the names of my databases and they were nice enough to "fix" the code. It gets rid of the errors but I still see no output. (pstvalumni.com/support.php)

Quote:

<?php // Connect to the database server $dbcnx = @mysql_connect("localhost","pstvalu_director", "PASSWORD"); if (!$dbcnx) { print "Unable to connect to the database server at this time."; exit(); } // Select alumni database if (! @mysql_select_db("pstvalu_directory") ) { print "Unable to connect to the DB"; } ?>
Here are all alumni in our database:

<?php // Request the listing $query = "SELECT * FROM alumni"; $result = mysql_query($query); if ($result) { // Display the listing of all alumni in a paragraph while ($row = mysql_fetch_array($result) ) { print "$row[alumni]"; } } else { echo "MySQL Error: "; echo mysql_error(); print ""; exit(); } ?>

I see a few differences but I don't know enough to which is correct. Other than giving me another suggestion to try out, can anybody also show me a working example of what this code is even supposed to look like (on somebody else's database), once it finally works?

Thanks.

Peter J. Boettcher — Wed, 18 Sep 2002 06:24:20 +0000

Looks like it can't connect to the db. Is the db on the same server as your web? Are you connecting by machine name? Maybe try putting the IP number instead.

fifeclub — Wed, 18 Sep 2002 05:03:42 +0000

Dear nike_guy_man
Dear Peter J. Boettcher
Dear Abhishek Reddy

Sorry for whatever was going on with my site. Short answer was that my domain was hijacked and redirected by a company I never heard of before - but that's for another thread. Basically I'm back and I'd like to revive this thread and hopefully get my database display worked out. I'd appreciate if you gave it another look (and if you're still seeing that "coming soon" screen, just wait another day for further DNS propgation back to my real website)

Thanks.

nike_guy_man — Thu, 12 Sep 2002 20:13:29 +0000

I'm getting a 'coming soon' page...
If your server allows .shtml as PHP parsed... then that should have worked, but not a lot of servers allow that
There was your problem!

Are you on an intranet where you are viewing this and it's working or what?

Peter J. Boettcher — Thu, 12 Sep 2002 18:11:52 +0000

Looks like you fixed your problem? I get a page listing a bunch of different links, no errors.

Starting with won't effect PHP, it is an inline language so it can be interspersed with html.

Abhishek Reddy — Thu, 12 Sep 2002 14:49:33 +0000

Is this what I'm supposed to see?

fifeclub — Thu, 12 Sep 2002 14:29:46 +0000

I definitely have php. I put in your code, nike_guy_man and it says php 4.2.2

Peter, I changed the extention from .shtml to .php and now it doesn't list my code (ie. password). But now it says no database. I know there's a database with info on it because I can get to all of it thru phpMyAdmin. Referring to the code above by nike_guy_man, that's exactly what I have in my php file except with the password changed. To double check, "pstvalu_directory" is the mySQL database name (with a "y"), "pstvalu_director" is the mySQL username (without a "y"), and "alumni" is the name of the table that is inside the database "pstvalu_directory"

Since it isn't listing code, here's my test link again:
pstvalumni.com/test2.php
And here's the php test that nike_guy_man suggested, which lists a whole lot of stuff I don't understand.
pstvalumni.com/testphp.php

Thanks.

P.S. Is it causing a problem that my .php file starts off with ...?

nike_guy_man — Tue, 10 Sep 2002 20:21:34 +0000

Sounds like you don't have PHP installed
try running

<?php
phpinfo();
?>

'
Have you run PHP scripts before?

Peter J. Boettcher — Tue, 10 Sep 2002 18:36:29 +0000

Mike,

I'm not a PHP expert but I think something is definitely wrong. The PHP code was showing up when I viewed the source of your page. Because of this I have removed the URL because your database credentials were exposed. PHP is a server-side language and should not show up on the client-side.

Are you sure PHP is running on your server?
Does your table have data in it?
Is your SQL statement correct?