Membuat Database dengan PHP

Hello sahabat blogger, saya mau sedikit share, saya dulu pernah mengalami suatu kondisi dimana saya harus membuat database di suatu server tetapi database server itu tidak bisa dibuka menggunakan SSH semacam putty atau program semacam SQL yog dan di server itu tidak ada menu untuk PHPMyAdmin.

Saya bingung bagaimana caranya, akhirnya saya coba menggunakan script PHP yang saya upload ke server tersebut. Saya akan coba share scriptnya.

1. Saya membuat tampilannya terlebih dahulu

    Script HTML :

<form action="" method="POST">
<table width="500px" border="0">
<tr>
<td width="25%">Host</td>
<td width="3%">:</td>
<td width="72%"><input type="text" name="dbhost"></td>
</tr>
<tr>
<td>Username</td>
<td>:</td>
<td><input type="text" name="dbuser"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input type="text" name="dbpassword"></td>
</tr>
<tr>
<td>Database Name</td>
<td>:</td>
<td><input type="text" name="dbhname"></td>
</tr>
<tr>
<td>&nbsp</td>
<td>&nbsp</td>
<td><input type="submit" name="createdb" value="Create Database"><input type="reset" name="reset" value="Reset"></td>
</tr>
</table>
</form>

2. Mulai membuat script PHP

<?php
if(isset($_POST['createdb'])){
$host = $_POST['dbhost'];
$user = $_POST['dbuser'];
$password = $_POST['dbpassword'];
$name = $_POST['dbname'];
$connect = mysql_connect($host,$user,$password) or die(mysql_error());
$proses=mysql_query("create database '".$name."'",$connect) or die(mysql_error());
if(!$connect){echo "Connection failed!";}
if($connect){echo "Create Database Success..."}else{echo "Create Database Failed..."}
}

mysql_close($connect); ?>

Pada bagian Action Form diatas nilainya kosong dikarenakan aksi dari form tersebut terdapat di 1 file tang sama jadi bernilai kosong. Langkah terakhir adalah menggabungkan kedua script diatas menjadi 1 file yang bisa kita beri nama "createdb.php" lalu disimpan di server yang mau kita akses. Kalau ingin download Source Code lengkapnya, silahkan KLIK DISINI. Sampai disitu dulu sahabat blogger, saya sambung di lain kesempatan. Terima Kasih dan Sampai Jumpa....

Selanjutnya...

Upload & Resize Gambar di PHP

Hallo sobat blogger, kali ini saya mau share nih gmana caranya upload gambar di php. Tidak lama-lama, langsung saja kita tembak ke sasaran....

Ini struktur tabel nya....

CREATE TABLE IF NOT EXISTS `data_gambar` (
`id_gambar` int(11) NOT NULL AUTO_INCREMENT,
`gambar` varchar(100) NOT NULL,
`gambar_kecil` varchar(100) NOT NULL,
`tanggal_upload` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_gambar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Setelah kita selesai membuat tabel di database, kemudian kita membuat file phpnya...

ini file koneksinya..... (koneksi.php)

<?php

$host = "localhost";
$user = "root";
$password = "elektro";
$database = "member";
$con = mysql_connect($host,$user,$password)or die(mysql_error());
if($con == TRUE)
mysql_select_db($database)or die(mysql_error());
?>

setelah file koneksinya, kita buat file utamanya..... (upload_gambar.php)

<?php
include 'koneksi.php';

$idir = "foto/"; // Path To Images Directory
$tdir = "foto/tumb/"; // Path To Thumbnails Directory
$twidth = "250"; // Maximum Width For Thumbnail Images
$theight = "250"; // Maximum Height For Thumbnail Images

$url = $_FILES['imagefile']['name']; // Set $url To Equal The Filename For Later Use
if ($_FILES['imagefile']['type'] == "image/jpg" || $_FILES['imagefile']['type'] == "image/jpeg" || $_FILES['imagefile']['type'] == "image/pjpeg" ) {
$file_ext = strrchr($_FILES['imagefile']['name'], '.'); // Get The File Extention In The Format Of , For Instance, .jpg, .gif or .php

$sameName = 1; // Menyimpan banyaknya file dengan nama yang sama dengan file yg diupload
$handle = opendir($idir);
while(false !== ($file = readdir($handle))){ // Looping isi file pada directory tujuan
// Apabila ada file dengan awalan yg sama dengan nama file di uplaod
if(strpos($file,$_FILES['imagefile']['name']) !== false)
$sameName++; // Tambah data file yang sama
}
/* Apabila tidak ada file yang sama ($sameName masih ‘0') maka nama file pakai
* nama ketika diupload, jika $sameName > 0 maka pakai format “namafile($sameName).ext */

$newName = empty($sameName) ? $url : $url.'('.$sameName.')'.$file_ext;

$copy = copy($_FILES['imagefile']['tmp_name'], "$idir" . "$newName"); // Move Image From Temporary Location To Permanent Location

if ($copy) { // If The Script Was Able To Copy The Image To It's Permanent Location
print 'Image uploaded successfully.<br />'; // Was Able To Successfully Upload Image
$simg = imagecreatefromjpeg("$idir" . "$newName"); // Make A New Temporary Image To Create The Thumbanil From
$currwidth = imagesx($simg); // Current Image Width
$currheight = imagesy($simg); // Current Image Height
if ($currheight > $currwidth) { // If Height Is Greater Than Width
$zoom = $twidth / $currheight; // Length Ratio For Width
$newheight = $theight; // Height Is Equal To Max Height
$newwidth = $currwidth * $zoom; // Creates The New Width
} else { // Otherwise, Assume Width Is Greater Than Height (Will Produce Same Result If Width Is Equal To Height)
$zoom = $twidth / $currwidth; // Length Ratio For Height
$newwidth = $twidth; // Width Is Equal To Max Width
$newheight = $currheight * $zoom; // Creates The New Height
}
$dimg = imagecreate($newwidth, $newheight); // Make New Image For Thumbnail
imagetruecolortopalette($simg, false, 256); // Create New Color Pallete
$palsize = ImageColorsTotal($simg);
for ($i = 0; $i < $palsize; $i++) { // Counting Colors In The Image
$colors = ImageColorsForIndex($simg, $i); // Number Of Colors Used
ImageColorAllocate($dimg, $colors['red'], $colors['green'], $colors['blue']); // Tell The Server What Colors This Image Will Use
}
imagecopyresized($dimg, $simg, 0, 0, 0, 0, $newwidth, $newheight, $currwidth, $currheight); // Copy Resized Image To The New Image (So We Can Save It)
imagejpeg($dimg, "$tdir" . "$newName"); // Saving The Image
imagedestroy($simg); // Destroying The Temporary Image
imagedestroy($dimg); // Destroying The Other Temporary Image
print 'Image thumbnail created successfully.'; // Resize successful

$nama_gambarasli = "$tdir"."$newName";
$nama_gambarkukecil = "$idir"."$newName";

//proses simpan
$sql="insert into data_gambar(gambar,gambar_kecil) values('$nama_gambarasli','$nama_gambarkecil')";
$query=mysql_query($sql) or die (mysql_error());
if($query){
echo "Data Berhasil disimpan.";
}

} else {
print '<font color="#FF0000">ERROR: Unable to upload image.</font>'; // Error Message If Upload Failed
} else {
?>
<script>
alert('ERROR: Wrong filetype (has to be a .jpg or .jpeg)');
</script>
<?php
print '<font color="#FF0000">ERROR: Wrong filetype (has to be a .jpg or .jpeg. Yours is '; // Error Message If Filetype Is Wrong
print $file_ext; // Show The Invalid File's Extention
print '.</font>';
}

?>

Wah cukup jelas kan sobat bloger, tinggal langsung simpan semua file tersebut dalam satu direktori / folder dan akses melalui web server lokal....
Nantikan sharing kita selanjutnya ya....jangan lupa tinggalkan komentar ya...

Selanjutnya...