PHP Problems

[CanMan2004]

Hi all

 

I am using a very simple php script which i've uploaded to a server, but I get no result not do I get any errors, this is the same with any code im trying to use where it pulls content from a MySQL datababase.

 

Can anyone give me any idea what it might be? Im battling with it to get anything to come up.

 

<?
$db_name ="****";
$server = "localhost";
$dbusername = "****";
$dbpassword = "****";

$connection = mysql_connect($server, $dbusername, $dbpassword) or die(mysql_error());
$db = mysql_select_db($db_name,$connection)or die(mysql_error());


$sql = mysql_query("SELECT * FROM documents ORDER BY value ASC")or die(mysql_error());
while($row = mysql_fetch_array($sql))
{
print "".$row['id']."<br><br>";
}
?>

 

Any help at all would be great.

 

Thanks

 

Ed

[CanMan2004]

Is there another way I should write the code? we have to connect to the database through a SSH client if that helps in anyway

[JasonLewis]

change this:

while($row = mysql_fetch_array($sql))
{
print "".$row['id']."<br><br>";
}

 

to this:

$i = 0;
while($row = mysql_fetch_array($sql)){
echo $row['id']." - I = {$i}<br><br>";
$i++;
}

 

and see if it outputs any numbers. should output 0, 1, 2 or however much results are in the database.

[CanMan2004]

I still get nothing displayed on the page

[JasonLewis]

do you have anything in your database? put this above your while loop:

 

echo "Rows: ".mysql_num_rows($sql)."<br>";

 

make sure its below your $sql line though. tell me how much rows it displays.

[CanMan2004]

Hi

 

That doesnt seem to work, nor does it print anything.

 

What's strange, is that if I place

 

<?

print "testing";

?>

 

and put it right at the top of my php page, above all the db connection details, then it prints "testing" without a problem, but if I place

 

<?

print "testing";

?>

 

and put this anywhere under the db connection details, then it wont print anything.

 

Does that make sense?

 

Why would that happen?

 

Thanks

 

Ed

[CanMan2004]

Can anyone help me on this? Getting no result despite what I do

[fiddy]

If you are getting a blank page. then there should be problem with the DB connection i guess. It might not show you errors if error reporting is off in your php.ini.

 

Just a Thought...

[CanMan2004]

Is there a default port number that is used as my port number maybe different, could this be the reason?

[Tyche]

It sounds like your are generating a mysql_error but the die statement is not closing off your html

so no error is visible in your browser

 

Try replacing the 3 occurances of

die(mysql_error())

with

die(mysql_error()."</body></html>")

 

[CanMan2004]

I've just tried

 

<?php
$link = mysql_connect('localhost', 'xxx', 'xxx');
print "hello";
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

 

Anything test page text you put above that code displays on the page, but anything that is added under that code, does not work.

 

Strange, totally confused it wont even tell me it cant connect

[CanMan2004]

Thanks Tyche, but it still doesnt show anything

[CanMan2004]

What should I check in the php.ini file? Or would that not be causing the issue

[trq]

You may need to tun on error reporting. Put this at the top of your script.

 

<?php error_reporting(E_ALL); ini_set('display_errors','1'); ?>

[CanMan2004]

Thanks, I get the error

 

Call to undefined function mysql_connect()

 

Do I need to enable something?

[sayedsohail]

is your application on webserver or localwebserver?

if you change the location than your sql connect variable need to be changed.

[wildteen88]

Thanks, I get the error

 

Call to undefined function mysql_connect()

 

Do I need to enable something?

In that case please read the FAQ thread on this problem  - CLICKY.