Membuat CMS sederhana

Welcome to my Journal

This is wpsismadi journal, a free, fully standards-compliant CSS template designed by NodeThirtyThree for Free CSS Templates, released for free under the Creative Commons Attribution 2.5 license. The photos in this design are from PDPhoto.org. You're free to use this template for anything as long as you link back to my site. Enjoy :)

Posted by wpsismadi on December 17, 2008 Read more Comments (0)

Post to:

Buat sendiri Website yuks,..
gampang kok, ga pelu pinter pinter amat untuk buat CMS, cukup sedikt pengetahuan tentang HTML, CSS style, PHP dan Query database
kali ini saya akan tunjukan bagaimana mudahnya membuat website menggunakan Teknologi PHP dan MySQL
Aplikasi PHP yang perlu dipelajari kali ini adalah
Variable, Include, Function, IF, Swicth dan header
Pada bagian MySQL adalah
mysql_connect, mysql_select_db, mysql_querry, mysql_fetch_array dan mysql_nums_row()
dan tentunya 4 perintah SQL, yaitu
Insert, Select, Update dan Delete

CMS yang akan kita buat ini memiliki dua sisi, user dan admin.

Okay,..kita mulai

Jalankan terlebih dahulu Xampp webserver dan siapkan Dreamweaver Web Editor

FILE AND FOLDER
Buat beberapa folder pada direktori berikut

C:/xampp/htdocs/lat1
C:/xampp/htdocs/lat1/admin
C:/xampp/htdocs/lat1/templates
C:/xampp/htdocs/lat1/templates/basic

DATABASE
Buat sebuah databse dengan nama lat1. Gunakan Phpmyadmin (http://localhost/phpmyadmin)

CREATE TABLE IF NOT EXISTS halaman (
kode int(5) unsigned NOT NULL auto_increment,
menu varchar(50) DEFAULT '0' ,
isi varchar(255) ,
PRIMARY KEY (kode)
);

INSERT INTO halaman VALUES("1", "Home", "Isi Home");
INSERT INTO halaman VALUES("2", "About", "isi About");
INSERT INTO halaman VALUES("9", "Gallery", "Isi Gallery");
INSERT INTO halaman VALUES("13", "profile", "isi Profile");

ADMINISTRATOR
Simpan 7 file berikut kedalam folder admin (C:/xampp/htdocs/lat1/admin/)

1.koneksi.php

<?
mysql_connect("localhost","root","");
mysql_select_db("lat1");
?>

2. input.php

<?
echo "<b>Create Page</b><br><br>
<form action=insert.php method=post><table border=0>
<tr><td> menu:</td><td><input type=text name=menu></td></tr>
<tr><td> Isi:</td><td><textarea name=isi></textarea></td></tr>
<tr><td></td><td><input type=submit value=Tambah name=submit></td></tr>
</form></table>";
?>

3.insert.php

<?
include "koneksi.php";
$menu= $_POST['menu'];
$isi = $_POST['isi'];
$submit = $_POST['submit'];
if ($submit)
{$sql=mysql_query("select * from halaman where menu='$menu'");
if(($row=mysql_fetch_array($sql)) && ($menu==$row[menu]))
{ echo "<b>Sudah Ada</b><br> <a href=input.php>Ulangi</a>";
exit; }
else
{ $result=mysql_query("insert into halaman (menu, isi) values ('$menu', '$isi')");
if (!$result)
{ echo "Gagal <br> <a href=input.php>Ulangi</a>";}
}}
header("Location:index.php");
?>

4.index.php

<?
include "koneksi.php";
echo "<a href=input.php>Buat Isi Baru</a> <br><br>
<table border=0 cellspacing=1 cellpadding=3 bgcolor=black>
<tr bgcolor=white><td>Kode</td><td>Menu</td><td>Isi</td><td>Aksi</td></tr>";
$sql=mysql_query("SELECT * FROM halaman ");
while($row=mysql_fetch_array($sql))
{echo "<tr bgcolor=white> <td> $row[kode] </td> <td> $row[menu] </td> <td> $row[isi] </td>
<td><a href=edit.php?pilihmenu=$row[kode]>Edit</a> |
<a href=delete.php?pilihmenu=$row[kode]>Hapus</a></td>";}
echo "</tr></table>";
?>

5.edit.php

<?
include "koneksi.php";
$pilihmenu=$_GET['pilihmenu'];
$menu=$_GET['menu'];
$isi=$_GET['isi'];
$sql=mysql_query("select * from halaman where kode='$pilihmenu'");
$row=mysql_fetch_array($sql);

echo "<b>Edit <b><br>
<form action=update.php method=post>
<table border=0>
<tr><td>Menu</td><td><input type=text name=menu value= $row[menu]></td></tr>
<tr><td>Isi</td><td><textarea name=isi>$row[isi]</textarea></td></tr>
<tr><td><input type=hidden name=kode value=$pilihmenu></td>
<td><input type=submit value=Edit></td></tr>
</table>
</form>";
?>

6.update.php

<?
include "koneksi.php";
$pilihmenu=$_POST['pilihmenu'];
$kode=$_POST['kode'];
$menu=$_POST['menu'];
$isi=$_POST['isi'];
$sql=mysql_query("update halaman set menu='$menu', isi='$isi' where kode='$kode'");
header("Location:index.php");
?>

7.delete.php

<?
include "koneksi.php";
$pilihmenu=$_GET['pilihmenu'];
$sql=mysql_query("delete from halaman where kode='$pilihmenu'");
if (!$sql){echo "data gagal dihapus";}
header("Location:index.php");
?>

WEBSITE
Simpan file berikut kedalam folder lat1 (C:/xampp/htdocs/lat1/)

1.index.php

<?php
include("admin/koneksi.php");
include("templates/basic/index.php");

function fmenu() {
$sql=mysql_query("select * from halaman");
while($menu=mysql_fetch_array($sql))
{echo "<a href=?pilihmenu=$menu[menu]>$menu[menu]</a> | ";}
}

TEMPLATE
Simpan file berikut kedalam folder lat1 (C:/xampp/htdocs/lat1/templates/basic)

1.index.php

<html>
<head>
<title>Basic</title>
<link href="templates/basic/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div class="header">
<span class="logo">Dasar CMS</span> versi 1.0</div>
<div class="menu"><?php fmenu(); ?></div>
<div class="content"> <?php fisi(); ?></div>
<div class="footer">
Dasar CMS<br>
www.dasarcms.web.id <BR>
2008
</div>
</body>
</html>

2.style.css

body {
text-align: center;
padding: 16;
background-color: #0099CC;
}
a, a:link, a:active {
color: #FFFFFF;
}
a:visited, a:hover, a:focus {
color: #FFFFFF;
border: none;
outline: none;
}
.header {
width: 750px;
height: 75px;
background-color: #666666;
}
.menu {
text-align: center;
height: 25px;
width: 750px;
background-color: #000000;
}
.content {
text-align: left;
width: 730px;
background-color: #FFFFFF;
padding-left: 20px;
}
.footer {
width: 700px;
height: 60px;
background-color: #000000;
padding-left: 50px;
}
.logo {
font-size: 36px;
color: #FFFFFF;
}

11.04.2008. 23:29

Rahman J on 28.05.2008. 15:52

Segini ajah nih tuto-nya Bos? Screenshot-nya ada ga?
But, thanks banget buat tulisannya...

padoel on 26.06.2008. 13:35

sayang template nya masih sederhana sekali
kalo mau template yang bagus tampilannya bisa download di http://www.freecsstemplates.org/

pbnzhwjnv on 19.03.2009. 10:59

PULx4E ohyjevmdpxnz, [url=http://citumkniqbfg.com/]citumkniqbfg[/url], [link=http://itlnphtirtra.com/]itlnphtirtra[/link], http://vtinhluhcwvs.com/

gabvpgyex on 15.05.2009. 16:57

89RqMu fqvpidgvhuai, [url=http://oevlfedvgkda.com/]oevlfedvgkda[/url], [link=http://hlgdrfrbxfnt.com/]hlgdrfrbxfnt[/link], http://cxeehchavqlt.com/

xuemcfxooo on 05.07.2009. 22:43

b2lttW hjaqwiynuxei, [url=http://ikkrmsggpwde.com/]ikkrmsggpwde[/url], [link=http://nbwgpgwdripj.com/]nbwgpgwdripj[/link], http://vullxetgwkhp.com/

iseywpzsw on 05.07.2009. 22:55

q5AOet bjxlrinstiud, [url=http://mvwjpiiqqrgl.com/]mvwjpiiqqrgl[/url], [link=http://rmmxlsvuvglo.com/]rmmxlsvuvglo[/link], http://thnxykprzvkd.com/

irfxymnhb on 06.07.2009. 00:44

CLWRGl tbebzpeyglzi, [url=http://okgcmefdfymq.com/]okgcmefdfymq[/url], [link=http://qpdodvqmlanx.com/]qpdodvqmlanx[/link], http://pulebopqwjzj.com/

hwlpoj on 06.07.2009. 00:47

CIC1wb xukwygblbfji, [url=http://uvlhithaxmsg.com/]uvlhithaxmsg[/url], [link=http://gexqvpcerwtb.com/]gexqvpcerwtb[/link], http://geexhtldntxo.com/

tlotjfwa on 06.07.2009. 01:40

9tTpGa yvynpbiizdob, [url=http://ygqgdnwkhprb.com/]ygqgdnwkhprb[/url], [link=http://xeqlyradbqoi.com/]xeqlyradbqoi[/link], http://qwekiqazutba.com/

apnehice on 06.07.2009. 04:49

pLiCop jkxolctzciee, [url=http://elcxbcevhkao.com/]elcxbcevhkao[/url], [link=http://ltlaftvmolib.com/]ltlaftvmolib[/link], http://cgifpwhpxlim.com/

amzmrpvrq on 06.07.2009. 08:02

DimPN8 aovekxhcjggw, [url=http://xugxrqxrcsdi.com/]xugxrqxrcsdi[/url], [link=http://hjxlfklluplt.com/]hjxlfklluplt[/link], http://waisirskzrqe.com/

ypnzny on 06.07.2009. 08:25

1fb8GX svgvllxxqdvn, [url=http://ftvoykbaomrq.com/]ftvoykbaomrq[/url], [link=http://dzdbswpyhnqg.com/]dzdbswpyhnqg[/link], http://ydzyolsdguwb.com/

onsglsr on 06.07.2009. 09:08

aRGwbm fzgmvqnqwgte, [url=http://imsafqoafust.com/]imsafqoafust[/url], [link=http://bhwyoiilifqr.com/]bhwyoiilifqr[/link], http://bqmkqfuafeju.com/

womxfne on 12.10.2010. 06:43

bLzrFn xbimrcijrhne, [url=http://akrbzxpsmkdq.com/]akrbzxpsmkdq[/url], [link=http://kzzsapymvnjr.com/]kzzsapymvnjr[/link], http://hoecbuvilgmp.com/

nova on 21.02.2011. 02:52

keren

Robota Robotics School Franchise pendidikan on 07.03.2011. 22:58

thank dan makasih banyak atas infonya

penginapan di jakarta on 12.03.2011. 02:55

Wah .. makasih ya .. gue mau coba ....

senikomputer on 18.04.2011. 00:27

trims atas info nya...

Slicer on 25.05.2011. 12:13

sip gan.... lumayan bisa buat belajar dari nul.... ini yg lama aq cari2... hehhehee.... ^_^

Ruru on 05.06.2011. 11:36

bagus banget. karena masih dasar jadi pemahamannya lebih mudah. pengembangannya pun fleksibel. terima kasih buanyak

eynoezmy on 06.06.2011. 07:32

nBGHze giqqqyctncor, [url=http://twutxzpdppof.com/]twutxzpdppof[/url], [link=http://lbqdbnprqfgg.com/]lbqdbnprqfgg[/link], http://vbtbrlimjogq.com/

Mussel on 07.06.2011. 01:31

Wah, baru cari dah ketemu...
Thank's bgt!

ryant on 09.06.2011. 03:49

wah keren mas, buat nambah pengetahuan tentang cms ....

ismedia on 01.11.2011. 06:35

Sip... terus berbagi untuk memperbaiki kehidupan..
Saling bernagi sesama webie... semoga penulis selalu beruntung...

f4m4s on 09.11.2011. 04:58

udh ane coba smua script yg dsni kok gagal ya, eh trnyata file koneksi.php nya salah tuh

klo ane pake yg gni

abis tu berhasil.trnyata script yg sebelumnya itu gak terkoneksi dgn database

f4m4s on 09.11.2011. 05:01

gak muncul ya kode php nya?yg ini mksd ane
$server = "localhost";
$user = "root";
$pass = "";
$db = "cms";

mysql_connect($server, $user, $pass);
mysql_select_db($db);

f4m4s on 09.11.2011. 05:04

untuk db kalo ente buat sperti diatas lat1 ya ganti jd lat1.disini ane bkin database namenya cms

Write a comment

* = required field

wpsismadi

Welcome to my Journal

Membuat CMS sederhana

Write a comment

Search

Category

New Artikel

Extra

Technorati

ssInventory

free

New Comments

RSS Feed

Sponsor