Membuat Database Dan Tabel Dengan Menggunakan PHP

Posted by : Unknown Rabu, 03 April 2013

Cara Membuat Database Dan Tabel Dengan Menggunakan PHP

<html>
<head>
</head>
<body>
<form name="form" method="post" action="">
<strong>Membuat Database Dan tabel </strong><br>
<table width="320" border="10">
    <tr>
      <td width="130">Nama Database </td>
      <td width="180"><input name="db" type="text" id="db"></td>
    </tr>
    <tr>
      <td>Nama Tabel</td>
      <td><input name="nama" type="text" id="nama"></td>
    </tr>
    <tr>
      <td><p>Field 1 </p></td>
      <td><input name="f1" type="text" id="f1"></td>
    </tr>
    <tr>
      <td><p>Field 2 </p></td>
      <td><input name="f2" type="text" id="f2"></td>
    </tr>
    <tr>
      <td><p>Field 3 </p></td>
      <td><input name="f3" type="text" id="f3"></td>
    </tr>
</table>
<br>
<input name="simpan" type="submit" id="simpan" value="Proses Database">
</form>
<?php

$db=$_POST[db];
$tb=$_POST[nama];
$data1=$_POST[f1];
$data2=$_POST[f2];
$data3=$_POST[f3];

if($_POST[simpan])
{
$connect_db=mysql_connect("localhost","root","");

if(!$connect_db)
{
die("Koneksi ke server gagal".mysql_error());
}

if(mysql_query("CREATE DATABASE $db ", $connect_db))
{
echo " Database Berhasil Dibuat Coy !!!";
}
else
{
echo " Database gagal dibuat Coy !!!";
}
mysql_close($connect_db);

$connect_db=mysql_connect("localhost","root","");

if(!$connect_db)
{
die("Koneksi ke server gagal".mysql_error());
}

mysql_select_db(" $db " , $connect_db);

$tabel=" CREATE TABLE $db.$tb( $data1 INT(15), PRIMARY KEY($data1), $data2 VARCHAR(30), $data3 VARCHAR(25))";

mysql_query($tabel, $connect_db);

mysql_close($connect_db);
}
?>
</body>
</html>