Script will not show in browser (http 500 error))

drunkencelt

Hi,

I have been stuck now for 2 hours and I have retyped this from the tutorial book twice in case of typos.

Can anyone tell me why I keep getting an http 500 error? The code is exactly as written in the book but no show in the browser. (IE, FF or NN)

I am using Apache and PHP on a locally set up server on my laptop. Apache is working. MySQL is working. I am able to parse other php scripts but not this one.

Any suggestions would be appreciated.

I have included the whole html/php below.

Many thanks

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<?php
$conn = mysql_connect("localhost","root","enterprise")
or die("Sorry - could not connect to MySQL!")

$rs1 = @mysql_create_db($_REQUEST['db']);
$rs2 = @mysql_list_dbs($conn);
for($row = 0; $row < mysql_num_rows($rs2); $row++)
{ $list .= mysql_tablename($rs2, $row) . " | ";}
?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Create Database</title>
</head>

<body>
<form action="<?php echo($_SERVER['PHP_SELF']); ?>"
method="post">Current databases: <?php echo($list); ?>
<hr />Name:<input type="text" name="db" />
<input type="submit" value="Create database" />
</form>
</body>
</html>

bpat1434

well, $mysql_list_dbs isn't a variable function. I think you meant @mysql_list_dbs 😉

What does the Apache error log say? A 500 error should produce something in the Apache error_log. What's it say?

drunkencelt

Hi,

The Apach log states:

[Mon Nov 26 19:29:18 2007] [error] [client 127.0.0.1] PHP Parse error: syntax error, unexpected T_VARIABLE in D:\Apache\htdocs\create_db.php on line 6

Thanks for the tip. I didn't know Apache wrote an error log. Will probably come in useful sometime when I know what everything means!

The typo you pointed out was a 'typo'. I've changed it and it still will not show. It is on line 7 anyway but the report states an error at line 6.

What do you think the problem is?

bpat1434

You're missing an ending ";" after the or die() call 😉

drunkencelt

Thanks again. I don't know how I missed that with the number of times I've gone through the code.

Only problem is it still doesn't work.

Any chance you could run it through your server? Just to make sure it is nothing to do with my set up?

drunkencelt

Ok. Now I really don't know what is wrong.

I've downloaded the actual code from the website accompanying the book to make sure there are no typos etc. Swapped the logon details only and now notice that the code is different! There's an empty variable called "list" right in the middle of the site code which is not there in the book - "PHP5 in easy steps by Mike McGrath"......not that easy!:glare:

Think I'm going to give up now. I'll have to try and do it another way.

Thanks anyway.

<!-- example for PHP 5.0.0 final release -->

<?php   

$conn = @mysql_connect( "localhost", "root", "enterprise" ) 
	or die( "Sorry - could not connect to MySQL" );

$rs1 =	@mysql_create_db( $_REQUEST['db'] );

$rs2= 	@mysql_list_dbs($conn);

$list = "";

for( $row=0; $row < mysql_num_rows( $rs2 ); $row++ )
{ 
  $list .= mysql_tablename( $rs2, $row ) . " | "; 
} 

?>

<html>

 <head>
  <title>Creating databases</title>
 </head>

 <body>

 <form action="<?php echo( $_SERVER['PHP_SELF'] ); ?> " method="post">

 Current databases: <?php echo( $list ); ?> 
 <hr>
 Name:<input type = "text" name = "db"> 
 <input type = "submit" value = "Create database">
 </form>

 </body>

</html>