Guess Whoo!!!!

**Tegwin** · May 4, 2003, 08:53

Firstly, I wanted to thank everyone for their help. It is really nice to know that there are some people out there that can help.

I am getting a wierd error that is saying I do not have access

I am running a script that creates a database. WHen I click on submit after entering the DB name I am getting the following error : -

Forbidden
You don't have permission to access /<br /><b>Notice</b>: Undefined variable: PHP_SELF in <b>D:/defaultWeb1/create_db.php</b> on line <b>13</b><br /> on this server.

--------------------------------------------------------------------------------

Apache/2.0.44 (Win32) Server at localhost Port 80

I am using Apache Server, on Windows XP with version 4.3.1 of PHP.

Any Idea..

Here is the code.

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

$rs1= @mysql_create_db($new_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($PHP_SELF); ?>" method="post">
Current databases: <?php echo($list); ?> <hr>
Name

input type="text" name="new_db">
<input type="submit" value="Create database">
</form></body></html>

**mofu** · May 4, 2003, 09:02

Im new but u could try:

<form action="<?=$_SERVER[PHP_SELF] ?>" method="post">

cheers

**Dr Livingston** · May 4, 2003, 11:21

Do you have the 'priveleges' in mysql to create a new database I wonder ?

If it's a local dev box you should be able to reset the 'priveleges' back to root user, or maybe your logging into mysql as a different user ?

**Tegwin** · May 5, 2003, 09:47

I am logging on with root to MySQL which has access to everything. I can create the db manually in MySQL

**samsm** · May 5, 2003, 10:13

I'm 99% possitive mofu is correct that you need to use $_SERVER['PHP_SELF'] rather than $PHP_SELF.

Change that, and check back in. :-)

**Tegwin** · May 5, 2003, 11:49

Ok I have now changed it and now when I press the submit button it does not create the db. Infact it does nothing.. Here is the code.

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

$rs1= @mysql_create_db($new_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="new_db">
<input type="submit" value="Create database">
</form></body></html>

**Jeff Lange** · May 5, 2003, 12:04

Do you have register_globals turned on?

**samsm** · May 5, 2003, 14:13

In this case, "nothing" is a step in the right direction (away from the error)!

I'm guessing that there are more register globals issues. Here's the knee-jerk link on the subject: http://www.sitepoint.com/article/758

Just eyeballing it, $new_db probably needs to become $_POST['new_db']

**Tegwin** · May 5, 2003, 22:18

samsm. You are correct. I changed it to read $_POST['new_db'] and it all works ok now... Thanks to all for the help

The SitePoint Forums have moved.

User Tag List

Thread: Guess Whoo!!!!

Thread Tools

Display

Guess Whoo!!!!

Bookmarks

Bookmarks

Posting Permissions