Skip to main content

Membuat Website CRUD Hari-1

Author

Relate search :  Membuat, Website, CRUD, Create, Update, Delete, Read, PHP, Mysql, Xampp.

CRUD adalah singkatan dari Create, Read, Update, Delete. CRUD harus di pakai apabila ingin membuat website yang dinamis, CRUD di lakukan di dalam database, tetapi pengorperasiannya di lakukan di dalam bahasa pemrograman, dalam tutorial hari pertama saya menggunakan bahasa pemrograman web yang paling banyak di pakai yaitu PHP (Personal Home Page/ Hypertext Preprocessor) , dan database yang saya gunakan adalah DBMS MYSQL, dalam website CRUD kita akan melakukan operasi membuat, membaca, mengupdate, dan menghapus data yang ada di dalam database. kebanyakan website CRUD umum di gunakan untuk website sistem informasi.

hal-hal pertama yang harus di lakukan dalam membuat website crud adalah :

1. Webserver : Apache , Nginx , IIS.
2. Database Management Sistem : Mysql, Postgresql, Oracle.
3. File Transfer Protocol : Filezilla
4. Editor text : Notepad++, Sublime, Dreamweaver, AptanaStudio dll
5. Web Browser  : Chrome, Mozilla Firefox ( dianjurkan ) .

NB :  untuk nomer 1 sampai 3 , kita bisa ganti dengan software penyedia service developing web seperti XAMPP, WAMPP dll. pada software ini sudah di sediakan software yang di gunakan untuk support operate testing web.

pada tutorial ini saya menggunakan XAMPP, browser Chrome, dan editor text AptanaStudio ,di anjurkan pembaca menggunakan software yang sama untuk memudahkan pemahaman dan meminimalisir kesalahan. untuk mengetahui cara install xampp silahkan kunjungi disini . 

langkah pertama untuk membuat website CRUD adalah menentukan idenya , pada tutorial kali ini saya akan mencontohkan website untuk pendataan identitas sekolah.

langkah kedua adalah membuat databasenya. berikut langkah-langkahnya : 

1. jalankan xampp, buka chrome browser : ketikkan http://localhost/phpmyadmin 


2. selanjutnya buatlah databasenya, klik tab database, masukkan nama databasenya, pada contoh saya kasih nama "sekolah". lalu klik create.



3. lalu buat table nya, masukkan nama table dan jumlah table, pada contoh saya kasih nama "data_siswa" dengan jumlah kolom 10. klik GO.


4. masukkan nama kolom dan kriterianya sesuai table berikut..

Nama Kolomtipeket
idintPrimary key , AI
namalengkapvarchar(20)
tanggallahirdate
tempattext
tempattinggalvarchar(20)
namaayahvarchar(20)
namaibuvarchar(20)
namasekolahvarchar(20)
nomerhpbigint
tanggalmasukdatetime



5. setelah melakukan langkah di atas, akhirnya kita telah menyelesaikan tahap pembuatan website CRUD di hari pertama, untuk selanjutnya kita akan masuk ke tahap introducing php di "Membuat Website CRUD Hari-2".

NOTE : 3xpl01t memberikan tawaran bagi pembaca yang ingin order membuat website, bisa order ke kami , untuk tata caranya bisa masuk ke link berikut. 

Mau pasang iklan di blog?. klik Disini

Sekian artikel saya, Semoga Bermanfaat. Wassalamualaikum Wr Wb

Stay fools to Stay Hungry
NB : Artikel ini di peruntukkan untuk pendidikan semata. hal-hal negatif yang di lakukan oleh pengguna tutorial , bukan tanggung jawab penulis.
Pasuruan, Pasuruan City, East Java, Indonesia

Popular posts from this blog

Automatic API Documentation Swagger in Golang #GolangDev

Author Bill Tanthowi Jauhari
pixabay.com In this article, I'll explain how to generate an API blueprint instantly using SwagGo in Golang. API blueprint is a document that contains a bunch of API endpoints, its slickly same as documentation but less description, it's allow another programmer to read and see all the available endpoint and try it out with sandbox feature. Swagger is one of the most used API blueprints right now, it's available in free but limited usage. if you wanna use the free credit, you need to understand YAML notation, you can read the example notation in swagger official documentation. but again, it's really hard and takes an expensive time to arranges all the notation to achieve a good API blueprint. fortunately, there are tools in Golang that allow us to generate the YAML notation and automatically generate the blueprint page with only using markup notation, and it's FREE unlimited for self-host, insane right? SwagGo tools are available here , the documentation is very cl...
Read More »

Playing with Hooks in Gorm #GolangDev

Author Bill Tanthowi Jauhari
Pixabay Hello everyone, I would like to share some tricks in gorm, the Idea of this tricks is to execute a command or code statement in the middle of an ORM operation, if you ever know about trigger in the query language, then hooks is just kinda like that. Hooks could execute statement in some events such as: beforeCreate, beforeUpdate, afterCreate,  and afterUpdate . those event is similar as a trigger,  when the trigger is executed in DBMS layer, hooks are executed in the application layer. In my real case, my current company has different convention of naming database column, so when I try to implement ORM, a lot of columns such as created_at, updated_at and deleted_at can't be generated automatically. also if you have a custom UUID you could pass the value UUID generator into hooks before the insert is executed. for more detail let's jump into code : # Explanation Above code containing model struct, and several methods from gorm to serve model, TableName method used to d...
Read More »

Create MVC Pattern Using Echo Framework #GolangDev

Author Bill Tanthowi Jauhari
pixabay.com Hi, Back again. today I am gonna share about Go Language, yes it is a new programming language that really fast growing this day, so many startup using it, especially in indonesia, there is a Gojek, Dana, Tiket and many more. Go Lang is a programming language found by google engineer, this language is a multi paradigm language, you could use it as functional programming or treat it like an OOP bases. Echo is an framework that use Golang as a main language, to use a fast and reliable backend/web apps, as you know Golang has a really fast performance than other language, one of the reason is because its compiled not interpreted, so the Echo claim that its 10x faster. insane right ? Actually I didn't test the performance yet, but yeah for newbie like me in golang its not the main thing that you must understand, so the thing that we should know is how we actually can do with Golang.  I am person with MVC bases, before jump to golang, I have experience with La...
Read More »