create new db in mysql with php syntax

Question

I am trying to create a new db called testDB2, below is my code. Once running the script all I am getting an error on line 7

Fatal error: Call to undefined function mysqlquery() in /home/admin/domains/domain.com.au/public_html/db_createdb.php on line 7

This is my code

<?
$sql = "CREATE database testDB2";

$connection = mysql_connect("localhost", "admin_user", "pass")
    or die(mysql_error());

$result = mysqlquery($sql, $connection) 
    or die(mysql_error());

if ($result) {
    $msg = "<p>Databse has been created!</p>";
}
?>

<HTML>
<head>
<title>Create MySQL database</title>
</head>
<body>

<? echo "$msg"; ?>

</body>
</HTML>

UPDATE, now I get error

Access denied for user 'admin_user'@'localhost' to database 'testDB2'

what does this mean?

Ikke · Accepted Answer · 2010-04-18 06:13:02Z

2

The function is called mysql_query. Note the _

answered Apr 18, 2010 at 6:13

Ikke

102k23 gold badges101 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

create new db in mysql with php syntax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related