Author |
|
Piano_wamp
Joined: 25 May 2008 Posts: 3
|
Posted: Sun 25 May '08 23:30 Post subject: Functions don't work, require once |
|
|
I've done my first istallation of Apache, PHP, and MySQL. Simple stuff seems to work OK.
However, when I try to use the require_once function, my error log says:
[Sun May 25 17:27:24 2008] [error] [client 127.0.0.1] PHP Warning: require_once(DB.PHP) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in D:\\Program Files\\Apache Software Foundation\\Apache2.2\\htdocs\\test.php on line 12
[Sun May 25 17:27:24 2008] [error] [client 127.0.0.1] PHP Fatal error: require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'DB.PHP' (include_path='.;C:\\php5\\pear') in D:\\Program Files\\Apache Software Foundation\\Apache2.2\\htdocs\\test.php on line 12
This has never worked and strikes me as a configuration issue.
I have tried unistalling and re-installing MySQL, but still get the same error. It's commented out now, but I also used to get a similar error on mysql_connect();
TYFYH |
|
Back to top |
|
James Blond Moderator
Joined: 19 Jan 2006 Posts: 7371 Location: Germany, Next to Hamburg
|
Posted: Mon 26 May '08 0:06 Post subject: |
|
|
can you post an example code? ist the DB.PHP in the same folder? |
|
Back to top |
|
Piano_wamp
Joined: 25 May 2008 Posts: 3
|
Posted: Mon 26 May '08 0:12 Post subject: |
|
|
TY, I can't find any DB.php file anywhere.
Here's the example code:
<?php
/*
phpinfo();
*/
require_once "DB.PHP";
require "db.inc";
$dbhost = 'localhost';
$dbuser = 'Admin';
$dbpass = 'admin';
/*
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'test';
mysql_select_db($dbname);
/*
require_once "DB.php";
require "db.inc";
$dsn = "mysql://Admin:admin@localhost/test";
print "{$dsn}";
*/
print "<p>END test<p/> </BODY>";
print "</html>";
?> |
|
Back to top |
|
James Blond Moderator
Joined: 19 Jan 2006 Posts: 7371 Location: Germany, Next to Hamburg
|
Posted: Mon 26 May '08 12:03 Post subject: |
|
|
*g*
require!!(_once) means that there must be a db.php
comment out that lines...
Where did you get that code?
very short working example
Code: |
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
|
See the docs for more details
http://www.php.net/mysql_connect
http://www.php.net/require |
|
Back to top |
|
Piano_wamp
Joined: 25 May 2008 Posts: 3
|
Posted: Mon 26 May '08 23:50 Post subject: |
|
|
TY.
Code came from O'Reilly's "PHP and MySQL" - 2nd edition.
Tried your code. It worked at least until the point of getting an Access denied for user message, but that's probabl something else. At least the function was called.
Shouldn't DB.php have come down with the PHP download? Or is this something obsolete in PHP5. PHP5 was only in beta at the time the book was published, so it's mostly about PHP4. I'm pretty sure I did a full sownload with options maxed. Maybe an uninstall and re-install? |
|
Back to top |
|
alex.w474
Joined: 20 Feb 2008 Posts: 11
|
Posted: Tue 27 May '08 2:13 Post subject: |
|
|
You do need to reinstall PHP.
I suspect that the DB.php file from the example may come from PEAR (PHP repository of reusable code). In any case, please do not learn outdated stuff. Look at PHP manual or Zend Framework examples. |
|
Back to top |
|
James Blond Moderator
Joined: 19 Jan 2006 Posts: 7371 Location: Germany, Next to Hamburg
|
Posted: Tue 27 May '08 11:37 Post subject: |
|
|
alex.w474 wrote: | You do need to reinstall PHP. |
That is not true!! PHP works fine! There is missing a php file not something from the installation. if you realy need pear you can install it by using go-pear.bat inside the PHP folder. Or install it by hand.
If you need Zend Framework you can download it on the zend page.
Don't reinstall PHP!
Please read the O'Reilly's "PHP and MySQL" what you need to run that code! |
|
Back to top |
|
alex.w474
Joined: 20 Feb 2008 Posts: 11
|
Posted: Tue 27 May '08 15:37 Post subject: |
|
|
I'm frustrated because of my mind. Of course "You do NOT need to reinstall PHP". I'm sorry for the mistype. |
|
Back to top |
|