Not Sure if Syntax Error or Otherwise With MySQL/PHP

[lucid]

Ugh, I didn't want to post this here but I can't find the answer anywhere. It seems to be an incredibly noobish problem but Alas, I've never worked with MySQL or PHP before(Another one of my ADD induced changes of mind, decided to put C on the backburner). So here goes...

I've been following an online tutorial that ande had posted about a long time ago and currenty I'm at this part of it:

http://www.tizag.com/mysqlTutorial/mysqlconnection.php

Code: (php) [Select]

<?php mysql_connect("localhost", "root", "mypass") or die(mysql_error()); echo "Connected to MySQL<br />"; ?>

I create that first bit of code, of course with my own user and pass, save it in /srv/http(where these things go in Arch) and then go to http://localhost and click on the appropriate file to try to view it and I see nothing. Not even an error. Just a blank page. All of my other PHP scripts work fine. This is the only one that doesn't work and I simply can't figure out why. Embarrasingly enough I've been searching around for the answer for about two days with no results.

EDIT: I also noticed that if I make some code that should produce some kind of error I always just get a blank page instead. Or something like this for example:

Code: (php) [Select]

<?php
include("noFileExistsHere.php");
echo "I'm Retarded!";
?>
Simply displays as

I'm Retarded! With no error in front of it. I'm sure this has something to do with it.

 

[EmilKXZ]

I had the exact same problem whilst analysing Blackhole Exploit Kit... It did not execute at all, but whilst I knew something wasn't working fine, it didn't show anything.

You have to enable error reporting:

http://www.php.net/manual/en/function.error-reporting.php

[lucid]

I actually just fixed the problem. Only to cause a new one. I was able to view the proper display of the code I posted above for awhile but, In attempt to switch the Document_Root from /srv/http to a directory in my home folder I seem to have broken something else. Now when I try to view the page I see this error:

Code: [Select]

Fatal error: Call to undefined function mysql_connect() in /home/'user'/code/php/connect.php on line 2


And when I try to open phpMyAdmin I get this:

Code: [Select]

The mysqli extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>

 

[EmilKXZ]

You have to go to the PHP.INI en enable it (or add it), like this:

Code: [Select]

extension=mysqli.soBut go and google for the exact documentation on it, I'm just talking on what I can remember right now. Perhaps you don't have it at all. Can't tell you all 

[lucid]

I've already done that too. I've read the whole Arch Linux wiki and done all the required configurations and everything was working prior to me changing the Directory_Root where I put my files. Now even if I switch it back it still gives me the same errors.

UPDATE: Fixed the errors. It was a simple random syntax error in the /etc/php/php.ini file. Found it after running php -m. I can't believe I didn't try that sooner. *facepalm*

Now though I'm back to the issue I had in the first post of this thread. I don't understand why either. I have all errors enabled in /etc/php/php.ini. It simply won't display them