How to create database, tables using PHP

Anon

I have connection to MySQL server...
I have server's
-IP
-login
-pass

I need to create a simple database that will have only one table.....

Database should be called :

cataly

and table should look like this:

CREATE TABLE aktualnosci (
akt_id int(10) NOT NULL auto_increment,
akt_title varchar(50),
akt_1zdanie varchar(50),
akt_aktualnosc text,
akt_data_str varchar(30),
akt_year varchar(4),
akt_month varchar(2),
akt_day varchar(2),
PRIMARY KEY (akt_id)
);

(I create a MySQL table like above) but how to do it using php???

jc94062

Heres a script I did a while ago to create a table based on the name you enter, its obviously very simple but by adding to the form and putting the field names as variables its fully customizable.
You can delete tables with it as well

<form action="<? echo $PHP_SELF ?>">
<font color="c11b17">Table Name:</font>&nbsp<input type="text" name="name" size="10">
<br>
<input type="submit" name="create" value="Create Table">
<br>
<input type="submit" name="delete" value="Delete Table">
</form>
<?php
include ("../cgi-bin/connect.inc");
if ($create) {
$tables = "CREATE TABLE $name (
id tinyint(4) NOT NULL auto_increment,
name varchar(30),
position char(2) NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id)
)";
$result = mysql_query($tables);
if ($result) {echo "Table $name created";}
else {
echo("<P>Error: " .
mysql_error() . "</P>");
exit(); }
}

if ($delete) {
$tables = "DROP TABLE $name";
$result = mysql_query($tables);
if ($result) {echo "Table $name deleted";}
else {
echo("<P>Error: " .
mysql_error() . "</P>");
exit(); }
}
?>

It should be parse free, but I'm not guaranteing it :-)

gkelley091565

You go get the book named MySQL/PHP Database Applications. It's very good for newbies, but not boring.

written by Jay Greenspan, former producer of Webmonkey.com and Brad Bulger, software engineer with Wired Digital

amazon.com has it for $27.99 at http://www.amazon.com/exec/obidos/ASIN/0764535374/qid=1006738141/sr=2-3/ref=sr_2_7_3/104-6970002-4149513

the publisher's website is www.mandtbooks.com

Sorry, but your question is a broad one!

Gene