MySQL and PHP 4.2.0

[Clete2]

Hi, I just upgraded to PHP 4.2.0... have they changed the way you connect to mysql? Cos I can get to mysql VIA command line but when I do it in a script ( @mysql_connect("localhost","myusername","mypass") or die(mysql_error()) ), I get an access denied error (see Http://clete.d2g.com/Guestbook/index.php )

[Clete2]

also the server's behavior is odd, its the newest apache, dled today. I must start the server with the last 2 lines commented (
AddType application/x-httpd-php .php

LoadModule php4_module modules/libphp4.so)

which will disable php... then i use bin/apachectl restart after i uncomment those lines. then it works, no other way, anyone know a solution? should i revert back to Apache1.3?

[DR_LaRRY_PEpPeR]

Originally posted by Clete2
should i revert back to Apache1.3?

does this mean you are using Apache 2 now? if so, did you compile PHP with Apache 2 support? e.g. `--with-apxs2'?

otherwise, no, you should be able to connect to MySQL just fine if you username/password is correct.

[Clete2]

yea, it failed when i said apxs, told me to use apxs2... so I did, sorry i didn't say so but i got it fixed not the odd server startup tho, maybe its a bug...

[Clete2]

oh sorry to ask soo much but umm what can I use besides ?Name=1 in the title bar in 4.2.0? Since it doesn't work...

[Clete2]

Originally posted by Clete2
oh sorry to ask soo much but umm what can I use besides ?Name=1 in the title bar in 4.2.0? Since it doesn't work...

anyone? I can't think of a way besides using a form, which makes the page look ugly... I still just wanna use a link

[DR_LaRRY_PEpPeR]

a form wouldn't work either. i don't think it's a problem with PHP, but your scripts. register_globals is probably off if you used the new php.ini. you basically have 2 choices: 1) turn register_globals on in php.ini, or 2) access your variables the preferred way, as $_GET['Name'] instead of $Name, etc.

[Clete2]

hmm yes I got this info from another person... only thing is when I use $_POST[""] and GET to do stuff... doesn't work... here is what I got:

<? // PHP42.php
$name="test.html";
$_POST['yay'] = $name;
?>
<a href="Bla.php"><? echo $name; ?></a>

<? .. Bla.php
$_GET['yay'] = $name;
echo $name;
include("$name"); // Yes, I know there is a big security risk with this
?>

I want to:

1) pass name to Bla.php
2) Include $name in the page

what am I doing wrong?

[DR_LaRRY_PEpPeR]

your assignments are wrong in those examples. go to `file.php?name=file.html'. in file.php:

<?php

include($_GET['name']);

?>

[Clete2]

ohh -- worked, thanks!