Another newbie question. - Page 2

Odoggy5 · 08-27-2003, 07:07 AM

cool,
I think it will be litte while before I get to that point. Im still doing the prerequisites:p But do you have any suggestions for a good book? I am going to the bookstore and computer store after work. I need some RAM and some drives so I'll have another box, which I am going to put RedHat on. I don't know if I am a dork but...I love this stuff!:rock:

sde · 08-27-2003, 09:07 AM

i've always liked WROX .. they are the red books with the geek looking people on the front =)

beginning php
professional php

then as a good function reference

core php
php cookbook

i have other books, but these are what i have used the most.

Odoggy5 · 09-02-2003, 08:22 AM

ok still did'nt make it to the bookstore still using a tutorial on the web. I am tryin to connect to a mysql databse now and need some help. this is what I got.

Code:

<html>
<body>
<?
$dbcnx = @mysql_connect("localhost", "root", "mypasswd");
if (!$dbcnx) {  echo( "<P>Unable to connect to the " . 
"database server at this time.</P>" );  
exit();}
?>
</body>
</html>

I am trying to get that error message to pop up to verfiy that it is trying to connect, by using the wrong password, but it does not.

sde · 09-02-2003, 01:50 PM

hey, please start a new thread for new topics .. it's easier to follow and more beneficial for people searching for past threads.

also, there's great php highlighting built into this forum .. use the [php ] and [/ php] tags =) easier to read.

ok, now for the questions and help... hehe

are you running mysql locally? are you on windows? are you sure your permissions in mysql are set up right?

in mysql, you can grant full permission on all tables to a user like this:

Code:

GRANT ALL PRIVILEGES ON *.* TO username@'%' IDENTIFIED BY 'password';

bdl · 09-02-2003, 02:04 PM

PHP Code:


			
<?

$dbcnx = @mysql_connect("localhost", "root", "mypasswd");

if (!$dbcnx)

{

  echo( "<P>Unable to connect to the database server at this time.</P>" );  

  exit();

}

?>

Hmm. Correct me if I'm wrong, but in your syntax above, $dbcnx would still 'have value' or 'exist' in the method you use. You supply it with a null value even if the MySQL connection fails.

Your syntax on echo ( " (with the extra spacing) may also be hanging things up, try just using echo " or echo(".

What I usually do is this:

PHP Code:


			
if (!$dbcnx = mysql_connect("server", "user", "password"))

  die("Could not connect to MySQL DB: " . mysql_error());

That would definitely give you an error if you couldn't connect to the MySQL server, and tell you why (thats the mysql_error() part). You should try removing error suppression (the '@' symbol) when you test a script, make sure you get all the bugs first. Then if it fails later on at least error messages won't get to the user.

sde · 09-02-2003, 03:26 PM

mysql_connect returns a MySQL link identifier on success, or false on failure, so his code should work fine. he's just testing for false as you are in the example you show.

bdl · 09-02-2003, 07:01 PM

Ok, I stand corrected. =P

I tried the same code on my server, works fine, gives an error code as you would expect. Even with the echo statement spaced out some, although I have seen a script fail with minor details like that before. For example, IIRC, you must use parenthesis with die().

Odoggy5 · 09-03-2003, 07:31 AM

My permissions are ok, and if they were not should'nt the error message appear? I am using the wrong password purposely to make the error message pop up.

Odoggy5 · 09-03-2003, 08:08 AM

Ok I got it to work. I don't even want to tell you guys what I was doing wrong, because I was being a dumbass!

Odoggy5 · 09-03-2003, 08:21 AM

ok ok, I guess thats not fair...
I was saving them as an html file instead of a php file.
Why does that not work?

Admin · 09-03-2003, 08:26 AM

because HTML is a static page, the server simply sends that file without processing it.

PHP being dynamic is processed on the server before being sent to the user.

bdl · 09-03-2003, 02:19 PM

Actually, it's simple to have an .html page or .phtml, whatever to be recognized as a PHP script and work properly. Just change your Apache config like so:

Code:

AddType application/x-httpd-php .php .html .phtml

Restart Apache server.

Basically just tells Apache to allow those suffixes to parse as PHP files if they happen to contain any PHP code.