How to create a MYSQL Database with a HTML form?

kevin433 · #1 15-Jul-2008, 10:50

Hi,
How can i create a MYSQL Database through a HTML form?
I searched and found one, but it didn't worked for me

kevin433 · #2 15-Jul-2008, 14:43

Please help

TurboPT · #3 15-Jul-2008, 16:23

The topic is not fully clear...

What do you mean 'create with HTML form'? HTML, alone, will NOT do it for you without some sort of back end connectivity.

Can you provide some more specific details about what is trying to be done?

EDIT:
What is this 'other form' that you found that didn't work?

kevin433 · #4 15-Jul-2008, 16:27

I mean, when i submit a HTMl form with a text box where i typed in "lol", it creates a MYSQL database with the name i writed in the text also "lol"

EDIT:
I didn't found it, but this is what i got:

PHP Code:


<?php
    $continued = mysql_connect("localhost","****","******"); 
    if($continued)
  { 
        echo("Connection is succeed"); 
    }
  else
  { 
        echo("Connection is fail"); 
    }
?>
<form>
Database name: 
<input type="text" name="user">
<input type="submit" value="Submit">
</form>

<?php
    $make = mysql_query("CREATE DATABASE $make");
    if($make)
  { 
        echo("Database database succeeds in making"); 
    }
  else
  { 
        echo("Database database fails in making"); 
    } 
?>

TurboPT · #5 15-Jul-2008, 16:36

Ok, then assuming that the back end is available through the submit, that is a query:

Code:

CREATE DATABASE <database_name>;

or, with your example:

CREATE DATABASE lol;

So, with your "lol", simply build the string and pass it to the DB.

[Note that having CREATE permission is assumed]

EDIT:
Ah, I see you basically have it in place. (I jumped to reply before your EDIT was added)
Can you output what $make has after it fails, are you SURE the connection succeeded?

kevin433 · #6 15-Jul-2008, 18:10

When i go on the .php page it says this:

Code:

Connection is succeed
Database name: "here is a text box"    and here is a Submit button
Database database fails in making

It says that it couldn't create a database, but i don't clicked on the Submit Button. It says it when i enter the page. And when i click on the Submit Button nothing happens, just the same is there.

TurboPT · #7 15-Jul-2008, 19:02

Try to add this inside the else [where make fails]

PHP Code:


$message = 'Error check: ' . mysql_error() . "\n"; // any error(s).
die($message);

kevin433 · #8 15-Jul-2008, 19:34

Now it says this:

Error check: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

but line 1 is <?php

TurboPT · #9 15-Jul-2008, 20:23

That's not the line of reference, that is from MySQL.
How are you building the string? It's either complaining about misplaced quote(s), OR it's getting a blank text field when first opened. The easiest check for the second part would be to give the field a default value.

TurboPT · #10 15-Jul-2008, 21:17

I see another small issue, you are passing $make to the query, but how does it know what the database name is supposed to be?

Slightly modified your code, try this example:

PHP Code:


<?php
if (!empty($_GET['user']))
{
    $continued = mysql_connect("localhost","*****","*****");
    if($continued)
    {
        echo "Connection success.<br>";
    }
    else
    {
        echo "Connection failed.<br>";
    }
    
    $db_name = $_GET['user'];
    echo "<br>==>DBname: " . $db_name . "<br>";
    
    $make = mysql_query("CREATE DATABASE $db_name");
    if($make)
    {
        echo "Database $db_name created.<br>";
    }
    else
    {
        echo "Failure creating $db_name.<br>";
        echo "Reason: " . mysql_error() . "<br>";
    }
    unset($_GET['user']);
}
else
{
    echo "No name given yet.<br>";
}
?>
<html>
<form>
Database name:
<input type="text" name="user" value="">
<input type="submit" value="Submit">
</form>
</html>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cpanel downgrade MYSQL 4.1.X to MySQL 4.0.xx	Webhosting-live	Web Hosting Forum	1	01-Sep-2006 03:54
HTML Form to PHP File - Help Requested	vigilantweather	MySQL / PHP Forum	15	07-Aug-2006 20:22
Help! Some basal questions about MFC	xutingnjupt	MS Visual C++ / MFC Forum	1	05-Dec-2004 04:38
[Tutorial] MySQL Basics	nniehoff	MySQL / PHP Forum	15	23-Mar-2003 20:42

How to create a MYSQL Database with a HTML form?

Re: How to create a MYSQL Database with a HTML form?

Re: How to create a MYSQL Database with a HTML form?

Re: How to create a MYSQL Database with a HTML form?

Re: How to create a MYSQL Database with a HTML form?

Re: How to create a MYSQL Database with a HTML form?

Re: How to create a MYSQL Database with a HTML form?

Re: How to create a MYSQL Database with a HTML form?

Re: How to create a MYSQL Database with a HTML form?

Re: How to create a MYSQL Database with a HTML form?