如何使用PHP和MySQL创建数据库？

Question

In this create function, I am trying to create a database. However, it fails to create and displays the error Error creating database: Access denied. So, this means there is a connection and it makes it past the first check. Then when mysql_query is called, it doesn't return true. Can anyone help?

function create($dbName, $tbName, $fields, $types_sizes, $PK)
        {
            $sql = null;
            $con = mysql_connect("borg.cs.up.ac.za","username", "password");

            if (!$con)
            {
                die('Could not connect: ' . mysql_error());
            }
            else 
                {
                  if(mysql_query("CREATE DATABASE". $dbName, $con))
                    {
                        echo "Database created";
                        $dbExists = 1;
                    }
                   else
                    {
                        echo "Error creating database: " . mysql_error();
                        $dbExists = 0;
                    }
                   $i = 0;
                    if(($con)&&($bdExists = 1))
                    {
                        $sql . "CREATE TABLE " . $tbName . "(";
                        while($i < count($fields))
                        {
                            $sql . $fields[$i] . " " + $types_sizes[$i] . ",";
                            $i++;
                        }
                    if($PK != null)
                    {
                        $sql . "PRIMARY KEY (" . $PK .")";
                    }
                    }
                mysql_query($sql,$con);
                mysql_close($con);
            }
         }

Answer 1

you have not given space in the line

if(mysql_query("CREATE DATABASE". $dbName, $con)), please provide space after "Create Database" -> "create database ".$dbname, because otherwise it will be database+name combined.