Creating a database

fvs

I'm trying to create a database within ny server using php script. I have a script that I have found in a book that I copied to use,However I must have copied it wrong or it has a bug i can't figure out, Need Help. Thanks.
<?php

$conn = @mysql_connect("localhost","frank","")
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><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>

Roger_Ramjet

So tell us what it is doing.

fvs

It doesn't display on my server, I have it in my /var/www/html directory with the rest of my files that work well. Will not display?

Roger_Ramjet

What won't display? Look you have to ask sensible questions to get sensible answers.

fvs

The server web page as a form. The very thing that it suposed to do.

bradgrafelman

Since you're having problems with the script, why are you suppressing the error messages? Remove all of the '@' signs, and verify that display_errors is set to On and error_reporting is set to E_ALL. A more descriptive explanation of what is happening/not happening, as Roger points out, would be quite helpful.

fvs

When I call ithe http://localhost/create_db.php I dont get an error message just a blank white screen?
This scipt is supposed to have a form which will have current databases and have a place to create a new database.

PS I'm totally new, Thanks

leatherback

Hi,

Sorry, but -unless your server is completely mal-installed- there is no way this is creating a fully blank page, especially when you remove all the @ symbols.

Please post -between [php ] [/php ] tags- the EXACT script as you run it, and exactlu the output it creates.

fvs

I did remove the@ still have this result
http://localhost/create_db.php

fvs

<?php

$conn = mysql_connect("localhost","frank","")
               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><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>

leatherback

And what is the output please?

fvs

What was wrong with php code? I Can't learn if I can't get an answer I understand.
Nothing is wrong with my server, I do get other php codes to work well, I'm just curious to find out what mistakes are in this code? I would really like to find out.

Roger_Ramjet

So, give the information being asked for by the people trying to help you.

That script must output at least the text in the html content unless it terminates with a php error before the html is reached, in which case you should be getting a php error message.

leatherback

As I said.. What is the output of the script please.

I do not see any clear reason why the script would not produce output.

But..

1) $_REQUEST['db'] will not produce anything when you do not post / URL-load any variables.

2) $rs1 = mysql_create_db( $_REQUEST['db'] ); will therefor nore work on first load

3) $rs2 = mysql_list_dbs( $conn ); if there are not tables, this will not result in output

4) for( $row = 0; $row < mysql_num_rows( $rs2 ); $row++ )
use: while($row = mysql_fetch_array($rs2)) instead

The form code looks ok, and should produce output.
{ $list .= mysql_tablename( $rs2, $row) . " | "; }
?>

fvs

Hello, First let me say thanks for the replies.
Now I just started to explore php for the first time, I picked up this book "PHP5 in easy steps" by Mike McGrath from Barnes & Noble easy learn series.
I'm running Linux Fedora core 6, I have installed and running Apache2.2 server, MySQL5.0.27 and PHP5.1.6. I've been doing lessons from this book and have gotten php to work simple code on my server.
This is what the code should:
"The example below displays all existing databases, then provides a form where a new database name can be input. When the form submitted,the script attempts to create a new database with the specified name."

When it is run I just recieve a blank white space below the URL bar

Roger_Ramjet

Typical shoddy book code, exactly NOT how to write PHP.

OK: view source to see what is behind the blank page. - paste whatever you see here.

fvs

Nothing behind source page? Blank also, May I ask you? I've been writing php source code in the
gedit editor which comes with Feddora 6, I like it but I really don't know if I use it well enough to tell if any lines are buggy, Can you recommend an editor for linux that can debug my source code if I write it wrong or if I leave something out?
Thanks

leatherback

This problem is not in your code. Your code would at least create the form. There is a thread on editors on the forums somewhere. do a search

fvs

Thanks leatherneck, found an editor called eclipse for fedora, I'll try it out.
thanks once more. fvs

Roger_Ramjet

Do any php scripts work on your server? Have you told Apache what to do with php files? Cos that's the only reason I can think of for totally blank output. Simple test, take out all the php code and leavr just the html but keep the .php extension, you should then see the form, if you don't then it is apache config.