how to delete database

[exoskeleton]

good day dear expert...here i am again...i have a problem on how to delete database!

$hostname="localhost";
$database="exo";

if( !$pg_con=pg_connect("host=$hostname dbname=$database user=user1 password=pass1") ) {
print "Error : connect to ${hostname}<br>";
exit;
}

$del_database = "DROP DATABASE db_yy";
$exec = pg_exec($del_database);

is this correct? another thing is...how to connect to server? i connect with the usual way having database to connect to just like above written. but here of course i think you just need to connect to server in order to delete database. but i dont know how...please help

BTW im using postgre

TIA

[ak1dnar]

Try this You can use the same Coding for Create,Drop,Delete Databases by
changing your mysql_query .
Convert this to pg SQL :)

$con is for Connect to the server with your userName and Password

[PHP]
<?php
$con = mysql_connect("localhost","userName_Here","Passwor d_Here");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

if (mysql_query("DROP DATABASE Your_DB_NAME_HERE",$con))
{
echo "Database Deleted";
}
else
{
echo "Error deleting database: " . mysql_error();
}

mysql_close($con);
?>[/PHP]

[exoskeleton]

Try this You can use the same Coding for Create,Drop,Delete Databases by
changing your mysql_query .
Convert this to pg SQL :)

$con is for Connect to the server with your userName and Password

[PHP]
<?php
$con = mysql_connect("localhost","userName_Here","Passwor d_Here");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

if (mysql_query("DROP DATABASE Your_DB_NAME_HERE",$con))
{
echo "Database Deleted";
}
else
{
echo "Error deleting database: " . mysql_error();
}

mysql_close($con);
?>[/PHP]

thank you very sir... :) i really appreciate it...more power

[savanm]

Hi

Try this one...
[php]
<?php

$conn = ("localhost","username","password");

mysql_connect($conn) or die("the connection failed");

$query = ("DROP database databasename",$conn);


?>[/php]

Thanks
Navas