What am I doing wrong?

Ogier

Greetings all,

First off, I am new here. This seems like a tremendous resource to the PHP community and I hope to be able to contribute something to it.

However, being new to PHP and MySQL on the coding side, I have already run into a snag.

I am trying to create a database with PHP using the following code:

<?
$sql = "CREATE DATABASE obms";
$connection = @mysql_connect("localhost","name","pword") or die(mysql_error());
$result = @($sql,$connection) or die(mysql_error());
if ($result) {
$msg ="<P>Database has been created!</P>";
}
?>
<HTML>
<HEAD>
<TITLE>Create a MySQL Database</TITLE>
</HEAD>
<BODY>
<? echo "$msg"; ?>
</BODY>
</HTML>

I what I am getting is not an error but rather, it is telling me that the database was created but when I go to look and see if it actually was, it isn't there. So, I am getting a false message.

I am using Mandriva Linux free version(2006 I think) and have apache, PHP4, MySQL all installed and playing well together. I also have given my user account permission to do anything at all on the box.

So, what am I doing wrong? I suspect it is either in the code or in the permissions but I don't know enough to know what to look for.

Ogier

thorpe

Doesn't appear to be anything wrong with your code. Though, I would get out og the habbit of using the error supresser ( @ ) whilke your still young, it has its place, but should'nt be over used.

How are you checking to see if the db has been created?

Oh.. and PS. Welcome to the board.

pppppp

$connection = mysql_connect("localhost","name","pword")
if (!$connection) die('Could not connect: ' . mysql_error());
$sql = "CREATE DATABASE obms";
if (mysql_query($sql,$connection)) {
$msg ="<P>Database has been created!</P>";
} else {
echo 'Error creating database: ' . mysql_error() . "\n";
}
?>
<HTML>
<HEAD>
<TITLE>Create a MySQL Database</TITLE>
</HEAD>
<BODY>
<? echo "$msg"; ?>
</BODY>
</HTML>

try to use this code

Ogier

thorpe wrote:
Doesn't appear to be anything wrong with your code. Though, I would get out og the habbit of using the error supresser ( @ ) whilke your still young, it has its place, but should'nt be over used.

How are you checking to see if the db has been created?

I am not sure what you mean by the error suppressor. I took that code from a book I am using to learn. I need to look it up though to find out.

I am checking to see if the DB was created by going into WEBMIN and looking at the MySQL admin area.

I tried the code that was listed above and it told me that both the SB was created and there was an error. Again, Webmin says that there is no DB. Thanks for the help PPPPPP on this.

Now that I have tried two bits of code that seem to be ok with only philosophical errors, I am leaning towards the idea that this could have something to do with the permissions on my development machine.

My user account has full admin rights, but for some reason, this is just not playing well.

Thanks again,

Ogier

Well, after messing with this all day, I finally figured out that I was missing my php module in my apache configuration.

Also, I could not get Mandriva to install it in the proper place. So, I will nuke and pave the computer and install Debian.