Pemrograman Web

Membuat Database Aplikasi Website Pembayaran SPP

Membuat Database Aplikasi Website Pembayaran SPP

Membuat Database Aplikasi Website Pembayaran SPP Sebelum membuat database kalian siapkan terlebih dahulu alat/aplikasi pedukung untuk membuat database disini saya menggunakan xampp , apabila belum memiliki aplikasi xampp di komputer kalian silahkan download terlebih dahulu disini dan install di komputer kalian. Langkah pertama buka aplikasi xampp dan jalankan aplikasi nya. Buatlah nama database "db_spp" Kemudian pilih database yang kita buat. 1. Pilih nama database yang kita buat 2. Pilih menu sql 3. Salin / ketikan scrip kode membuat table siswa di sql dibawah ini: CREATE TABLE ` siswa ` ( `nisn` char ( 10 ) NOT NULL , `nis` char ( 8 ) NOT NULL , `nama` varchar ( 35 ) NOT NULL , `id_kelas` int ( 11 ) NOT NULL , `alamat` text NOT NULL , `no_telp` varchar ( 13 ) NOT NULL , `id_spp` int ( 11 ) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci; 4. Pilih kirim Ulangi langkah diatas untuk membuat tabel sesuai soal membuat tabel dabate db_spp seperti : Salin / ketikan scrip kode membuat table spp di sql dib…

About the author

Saya pengajar bidang teknik komputer dan jaringan (TKJ) di sekolah swasta SMK Siliwangi AMS Banjarsari

Posting Komentar

<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/2028843038-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY7ZQQAPw53rsv2lyuurnj9EYul3bA:1769739878159';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d6207233009065628270','//www.kafingamali.my.id/2023/09/membuat-database-aplikasi-pembayaran.html?amp\x3d1','6207233009065628270');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '6207233009065628270', 'title': 'Kafi Ngamali', 'url': 'https://www.kafingamali.my.id/2023/09/membuat-database-aplikasi-pembayaran.html?amp\x3d1', 'canonicalUrl': 'https://www.kafingamali.my.id/2023/09/membuat-database-aplikasi-pembayaran.html', 'homepageUrl': 'https://www.kafingamali.my.id/?amp\x3d1', 'searchUrl': 'https://www.kafingamali.my.id/search', 'canonicalHomepageUrl': 'https://www.kafingamali.my.id/', 'blogspotFaviconUrl': 'https://www.kafingamali.my.id/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'id', 'localeUnderscoreDelimited': 'id', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Kafi Ngamali - Atom\x22 href\x3d\x22https://www.kafingamali.my.id/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Kafi Ngamali - RSS\x22 href\x3d\x22https://www.kafingamali.my.id/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Kafi Ngamali - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/6207233009065628270/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Kafi Ngamali - Atom\x22 href\x3d\x22https://www.kafingamali.my.id/feeds/921344856223364474/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/488fc340cdb1c4a9', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Dapatkan link', 'key': 'link', 'shareMessage': 'Dapatkan link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Bagikan ke Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Bagikan ke X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Bagikan ke Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27id\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '921344856223364474', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6FhQmbveLreHh8rsL1gGdudD2QiijGfSxlm9Jm1fvgzj6DPuBYWXU3i5-nu8DrSAB2ZyE03IwZdV7ho0cKh_ARlLlgPBB5jd0yC8K8Cs-1L9lABpYdYPvg4ow1tNHwMIrDj7qNm7VjZ4Jr9cgmF8_-9UgN7rW58qI7dZ8pJqp4i1TkDHUpqirBPapyuU0/s72-w640-c-h318/database%20spp.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6FhQmbveLreHh8rsL1gGdudD2QiijGfSxlm9Jm1fvgzj6DPuBYWXU3i5-nu8DrSAB2ZyE03IwZdV7ho0cKh_ARlLlgPBB5jd0yC8K8Cs-1L9lABpYdYPvg4ow1tNHwMIrDj7qNm7VjZ4Jr9cgmF8_-9UgN7rW58qI7dZ8pJqp4i1TkDHUpqirBPapyuU0/w640-h318/database%20spp.png', 'pageName': 'Membuat Database Aplikasi Website Pembayaran SPP ', 'pageTitle': 'Kafi Ngamali: Membuat Database Aplikasi Website Pembayaran SPP ', 'metaDescription': ''}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Tautan disalin ke papan klip!', 'ok': 'Oke', 'postLink': 'Tautan Pos'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Khusus', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Membuat Database Aplikasi Website Pembayaran SPP ', 'description': 'Komputer, perangkat keras komputer, jaringan komputer, sistem komputer, komputer gaming,perkembangan komputer,teknik jaringan kompter,  TKJ,TKJT,SMK.', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6FhQmbveLreHh8rsL1gGdudD2QiijGfSxlm9Jm1fvgzj6DPuBYWXU3i5-nu8DrSAB2ZyE03IwZdV7ho0cKh_ARlLlgPBB5jd0yC8K8Cs-1L9lABpYdYPvg4ow1tNHwMIrDj7qNm7VjZ4Jr9cgmF8_-9UgN7rW58qI7dZ8pJqp4i1TkDHUpqirBPapyuU0/w640-h318/database%20spp.png', 'url': 'https://www.kafingamali.my.id/2023/09/membuat-database-aplikasi-pembayaran.html?amp\x3d1', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 921344856223364474}}, {'name': 'widgets', 'data': [{'title': 'Kafi Ngamali (Header)', 'type': 'Header', 'sectionId': 'sec_Header_Title', 'id': 'Header01'}, {'title': 'Looking for something?', 'type': 'BlogSearch', 'sectionId': 'sec_Header_Search', 'id': 'BlogSearch01'}, {'title': 'Notification', 'type': 'LinkList', 'sectionId': 'sec_Under_Header', 'id': 'LinkList06'}, {'title': 'Labels Description', 'type': 'LinkList', 'sectionId': 'sec_Under_Header', 'id': 'LinkList07'}, {'title': 'Under Header Ad', 'type': 'LinkList', 'sectionId': 'sec_Horizontal-Ad', 'id': 'LinkList81'}, {'title': 'Carousel Image 01', 'type': 'Image', 'sectionId': 'sec_Carousel', 'id': 'Image01'}, {'title': 'Carousel Image 02', 'type': 'Image', 'sectionId': 'sec_Carousel', 'id': 'Image02'}, {'title': 'Carousel Image 03', 'type': 'Image', 'sectionId': 'sec_Carousel', 'id': 'Image03'}, {'title': 'Carousel Image 04', 'type': 'Image', 'sectionId': 'sec_Carousel', 'id': 'Image04'}, {'title': 'Above Pinned Post Ad', 'type': 'LinkList', 'sectionId': 'sec_Top_Widgets', 'id': 'LinkList82'}, {'title': 'Above Posts Ad [Desktop]', 'type': 'LinkList', 'sectionId': 'sec_Main_Widgets', 'id': 'LinkList83'}, {'title': 'Postingan Blog', 'type': 'Blog', 'sectionId': 'sec_Main_Widgets', 'id': 'Blog01', 'posts': [{'id': '921344856223364474', 'title': 'Membuat Database Aplikasi Website Pembayaran SPP ', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6FhQmbveLreHh8rsL1gGdudD2QiijGfSxlm9Jm1fvgzj6DPuBYWXU3i5-nu8DrSAB2ZyE03IwZdV7ho0cKh_ARlLlgPBB5jd0yC8K8Cs-1L9lABpYdYPvg4ow1tNHwMIrDj7qNm7VjZ4Jr9cgmF8_-9UgN7rW58qI7dZ8pJqp4i1TkDHUpqirBPapyuU0/w640-h318/database%20spp.png', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': 'Published by'}, {'name': 'timestamp', 'label': 'On'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'in'}]}, {'regionName': 'footer3', 'items': [{'name': 'location', 'label': 'Lokasi:'}]}], 'allBylineItems': [{'name': 'author', 'label': 'Published by'}, {'name': 'timestamp', 'label': 'On'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}, {'name': 'labels', 'label': 'in'}, {'name': 'location', 'label': 'Lokasi:'}]}, {'title': 'Categorized Posts', 'type': 'LinkList', 'sectionId': 'sec_Main_Widgets', 'id': 'LinkList08'}, {'title': 'Post Middle Ads', 'type': 'LinkList', 'sectionId': 'sec_Main_Widgets', 'id': 'LinkList84'}, {'title': 'Table of contents', 'type': 'HTML', 'sectionId': 'sec_Main_Widgets', 'id': 'HTML11'}, {'title': 'Below Posts Ad', 'type': 'LinkList', 'sectionId': 'sec_Bottom_Widgets', 'id': 'LinkList85'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sec_Side_Widgets', 'id': 'PopularPosts01', 'posts': [{'title': 'Penyelesaian Soal UKK TKJ Paket 4 2025', 'id': 2367499118090425019}, {'title': 'Panduan Instalasi Debian 12 di VirtualBox (CD ISO)', 'id': 3338597455117954874}, {'title': 'Administrasi Sistem Jaringan | Evaluasi dan Konfigurasi VPN Server | Sistem Monitoring Jaringan | Keamanan Jaringan', 'id': 1031867973564925028}, {'title': 'Konfigurasi dasar jaringan pada server ', 'id': 7617824423027121315}, {'title': 'Latihan Cisco Packet Tracer: Routing Statis \x26 Dinamis', 'id': 1747769693897327054}]}, {'title': 'Labels', 'type': 'Label', 'sectionId': 'sec_Side_Widgets', 'id': 'Label01'}, {'title': 'Sticky Ad [Desktop]', 'type': 'LinkList', 'sectionId': 'sec_Side_Sticky', 'id': 'LinkList86'}, {'title': 'Take me back', 'type': 'HTML', 'sectionId': 'sec_Error_404', 'id': 'HTML404'}, {'title': 'Labels', 'type': 'Label', 'sectionId': 'sec_Theme_Hidden', 'id': 'Label41'}, {'title': 'Formulir Kontak', 'type': 'ContactForm', 'sectionId': 'sec_Theme_Hidden', 'id': 'ContactForm41'}, {'title': 'Pageviews last month', 'type': 'Stats', 'sectionId': 'sec_Theme_Hidden', 'id': 'Stats41'}]}]);
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header01', 'sec_Header_Title', document.getElementById('Header01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogSearchView', new _WidgetInfo('BlogSearch01', 'sec_Header_Search', document.getElementById('BlogSearch01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList06', 'sec_Under_Header', document.getElementById('LinkList06'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList07', 'sec_Under_Header', document.getElementById('LinkList07'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList81', 'sec_Horizontal-Ad', document.getElementById('LinkList81'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image01', 'sec_Carousel', document.getElementById('Image01'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image02', 'sec_Carousel', document.getElementById('Image02'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image03', 'sec_Carousel', document.getElementById('Image03'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image04', 'sec_Carousel', document.getElementById('Image04'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList82', 'sec_Top_Widgets', document.getElementById('LinkList82'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList83', 'sec_Main_Widgets', document.getElementById('LinkList83'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog01', 'sec_Main_Widgets', document.getElementById('Blog01'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/3314219954-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/828616780-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList08', 'sec_Main_Widgets', document.getElementById('LinkList08'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList84', 'sec_Main_Widgets', document.getElementById('LinkList84'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML11', 'sec_Main_Widgets', document.getElementById('HTML11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList85', 'sec_Bottom_Widgets', document.getElementById('LinkList85'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts01', 'sec_Side_Widgets', document.getElementById('PopularPosts01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label01', 'sec_Side_Widgets', document.getElementById('Label01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList86', 'sec_Side_Sticky', document.getElementById('LinkList86'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML404', 'sec_Error_404', document.getElementById('HTML404'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label41', 'sec_Theme_Hidden', document.getElementById('Label41'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm41', 'sec_Theme_Hidden', document.getElementById('ContactForm41'), {'contactFormMessageSendingMsg': 'Mengirim...', 'contactFormMessageSentMsg': 'Pesan sudah dikirim.', 'contactFormMessageNotSentMsg': 'Pesan tidak dapat dikirim. Coba lagi nanti.', 'contactFormInvalidEmailMsg': 'Alamat email harus valid.', 'contactFormEmptyMessageMsg': 'Bidang pesan harus diisi.', 'title': 'Formulir Kontak', 'blogId': '6207233009065628270', 'contactFormNameMsg': 'Nama', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Pesan', 'contactFormSendMsg': 'Kirim', 'contactFormToken': 'AOuZoY6934Rt9GUnbDK4Y9Slohf1kjAOXQ:1769739878159', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_StatsView', new _WidgetInfo('Stats41', 'sec_Theme_Hidden', document.getElementById('Stats41'), {'title': 'Pageviews last month', 'showGraphicalCounter': false, 'showAnimatedCounter': false, 'showSparkline': true, 'statsUrl': '//www.kafingamali.my.id/b/stats?amp\x3d1\x26style\x3dBLACK_TRANSPARENT\x26timeRange\x3dLAST_WEEK\x26token\x3dAPq4FmAoMbggXSTnqnSFwRrUPBz0duB2uLluRAt6isoS-rfGYobwSXeHI80pvZ4q7qob02-IdtKeyVjYu5b7sqJs_4aC3_7GNA'}, 'displayModeFull'));
</script>
</body>