<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font face="sans-serif">Thanks for the advice. The error log reports
that 'mysql_connect' is not recognised as a valid php instruction.
I've noticed that everywhere it is installed apache is called
apache2. Could that be a problem? Deeply into ignorance here.<br>
MikeR<br>
</font><br>
<div class="moz-cite-prefix">On 23/07/12 12:07, Alan Buchel wrote:<br>
</div>
<blockquote cite="mid:500D3067.70302@communitytechnology.org.uk"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
tail -f /var/log/apache/access.log or error.log will help diagnose
php
and file issues (precise log names differ according to distro)<br>
<br>
For troubleshooting mysql purposes I normally use the root mysql
user
credentials for php auth instead of "mick".<br>
<br>
Also phpmyadmin is usually an easy install, allowing you to get a
gui
view of your mysql db's, permissions etc.<br>
<br>
On 23/07/12 11:42, Michael E. Rentell wrote:
<blockquote cite="mid:500D2A80.7010809@ntlworld.com" type="cite">Good
morning
all, <br>
As a part of my plan to limit the atrophying of my ageing brain
I am
working through 'PHP & MySQL for Dummies'. I think I have
got
apache installed OK because when I point firefox at localhost I
get the
'It's working' response. So I then composed the following
script,
called it test.php and stored it in /var/www: <br>
<br>
----------------------------- <br>
<br>
<html> <br>
<head> <br>
<title>PHP Test</title> <br>
</head> <br>
<body> <br>
<p>This is an HTML line <br>
<p> <br>
<?php <br>
echo "This is a PHP line"; <br>
phpinfo(); <br>
?> <br>
</body></html> <br>
<br>
---------------------------- <br>
<br>
When I point firefox at it I get a huge table of dozens of
properties
which baffle me. But it seems to indicate that php is also
working. <br>
<br>
The next step in the book is to generate a mysql db so from the
CLI I
went through generating mydb, user mick and a simple password.
However,
there is no data in this DB. <br>
<br>
Then to test that I composed the following script, called it
test2.php
and added it to /var/www: <br>
<br>
-------------------------- <br>
<br>
<?php <br>
<br>
$host = "localhost"; <br>
$user = "mick"; <br>
$pass = "simplepassword"; <br>
<br>
$r = mysql_connect($host, $user, $pass); <br>
<br>
if (!$r) { <br>
echo "Could not connect to server\n"; <br>
trigger_error(mysql_error(), E_USER_ERROR); <br>
} else { <br>
echo "Connection established\n"; <br>
} <br>
<br>
echo mysql_get_server_info() . "\n"; <br>
<br>
mysql_close(); <br>
<br>
?> <br>
<br>
---------------------------- <br>
<br>
When I point firefox at localhost/test2 I get a completely clear
screen. It neither seems to work or return the error. It is
supposed to
return a different table of parameters etc. <br>
<br>
Am I doing something stupid here/ If anyone can help an aged
beginner I
would be most grateful. I've been banging my head against this
for
several days and the book isn't any help as it expects the text
to
'just work' and it don't. <br>
<br>
MikeR <br>
in Folkestone <br>
<br>
<pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Kent mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Kent@mailman.lug.org.uk">Kent@mailman.lug.org.uk</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://mailman.lug.org.uk/mailman/listinfo/kent">https://mailman.lug.org.uk/mailman/listinfo/kent</a></pre>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Kent mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Kent@mailman.lug.org.uk">Kent@mailman.lug.org.uk</a>
<a class="moz-txt-link-freetext" href="https://mailman.lug.org.uk/mailman/listinfo/kent">https://mailman.lug.org.uk/mailman/listinfo/kent</a></pre>
</blockquote>
<br>
</body>
</html>