Steven's Blog

Autodesk AutoCAD : Cara Mematikan ACWebbrowser

2024-06-27T11:03:00.003+08:00

Cara Mematikannya :

https://forums.autodesk.com/t5/maya-forum/what-is-acwebbrowser-exe-and-how-do-i-disable-it/td-p/6285733

Debian : Python programming using Virtual Environment

2024-05-22T12:26:00.010+08:00

In Debian 12, to install modules like Flask, we have to create a virtual environment first.

To achieve this goal, we need a command to install pip3 on Debian 12. The command is as follows:

apt install python3-pip

To install the virtual environment, you can do this via the command:

apt instal python3-venv

This is the basic source code for Flask programming :

 from flask import Flask  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def halaman1():  
   return 'Web dari Virtual Environment'  
 if __name__ == '__main__':  
   aplikasi.run(host='0.0.0.0',port=8547,debug=True)

Python : Using Modules to Consume JSON Data from RESTful APIs

2024-04-17T16:27:00.004+08:00

This is the source code for creating a RESTful API server that will send data in JSON format over the network.

 from flask import Flask, render_template, request, url_for, redirect, jsonify  
 from jinja2 import Template, Environment, FileSystemLoader  
 import csv  
 import sys  
 import json  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/data')  
 # ini adalah source code untuk membuat server RESTFUL API yang akan mengirimkan data dalam bentuk JSON di jaringan  
 def halaman1():  
   data = {}  
   with open('/home/steven/proyekFlask/latihan15/templates/file2.csv','r') as file:  
     pembacaCSV = csv.DictReader(file)  
     for rows in pembacaCSV:  
       key = rows['nomer']  
       data[key] = rows  
     return jsonify(data)  
 if __name__ == '__main__':  
   aplikasi.run(host="0.0.0.0",port=8543,debug=True)

The following source code is used to consume JSON data sent by the RESTful API server. The RESTful API server is also created using the Python language.

 from flask import Flask  
 from flask_restful import Resource, Api  
 from flask_cors import CORS  
 import requests  
 aplikasi = Flask(__name__)  
 CORS(aplikasi)  
 # ini adalah program komputer untuk mengkonsumsi data JSON yang di kirimkan oleh server lain  
 @aplikasi.route('/', methods=['GET'])  
 def tampilData():  
   r = requests.get('http://1.1.3.4:8543/data')  
   return r.json()  
 if __name__ == '__main__':  
   aplikasi.run(host="0.0.0.0",port=8544,debug=True)

Next, we will learn everything about flask_restful. So that we can learn various things related to RESTful API.

Python : Learning to Connect Between the OS Module and Flask

2024-03-28T10:07:00.015+08:00

We will start to integrate Flask with other Python programming code, in this case between Flask and the OS module.

For the first one, we learn to use the OS module.

 import os  
 alamatFolder = os.getcwd()  
 print("Lokasi Folder Saat ini : ", alamatFolder)

 from flask import Flask, render_template, request, url_for, redirect  
 from jinja2 import Template, Environment, FileSystemLoader  
 import mariadb  
 import sys  
 import os  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def halaman1():  
   return render_template("halaman4.html")  
 if __name__ == '__main__':  
   aplikasi.run(host="0.0.0.0",port=8543,debug=True)

This is the initial source code for displaying a message box from JavaScript, using a server made with Flask.

 <!DOCTYPE html>  
 <html>  
      <head>  
           <meta name="viewport" content="width=device-width, initial-scale=1">  
           <style>  
                .button {  
                     background-color: #04AA6D;  
                     border: none;  
                     color: white;  
                     padding: 15px 32px;  
                     text-align: center;  
                     text-decoration: none;  
                     display: block;  
                     font-size: 16px;  
                     margin: 10px 10px;  
                     cursor: pointer;  
                     -webkit-transition-duration: 0.4s;  
                     transition-duration: 0.4s;  
                }  
                .button2:hover {  
                     box-shadow: 0 12px 16px 0 rgba(0,0,0,0.24), 0 17px 50px 0 rgba(0,0,0,0.19)  
                }  
           </style>  
      </head>  
      <body>  
           <button class="button button2" type="button" onclick="tampilkanPesan()">Uji Coba OS dan Flask</button>  
           <script>  
                function tampilkanPesan() {  
                     alert("Menampilkan Kotak Pesan")  
                }  
           </script>  
      </body>  
 </html>

We will try to build data delivery over the network using a RESTful API. In building the server and backend RESTFUL API, we use the Python programming language. We will use JavaScript to build the UI. JavaScript will also be used to consume JSON data sent through the RESTFUL API. JavaScript will be used to build AJAX technology.

 import json  
 from flask import Flask  
 import mariadb  
 import sys  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 # di bawah ini adalah source code untuk mengirimkan data dalam bentuk JSON ke jaringan dan ditampilkan di browser  
 def restApi1():  
   return json.dumps({'nama':'alesandro','e-mail':'alesandro@toto.com'})  
 if __name__ == '__main__':  
   aplikasi.run(host="0.0.0.0",port=8543,debug=True)

The following is the source code for reading a text file. The results of the reading will then be displayed on the web page. Alternatively, the results of the reading can be sent using a RESTful API. Once the reading results are converted to JSON, they will be displayed on the web page using AJAX.

Python

 from flask import Flask, render_template, request, url_for, redirect  
 from jinja2 import Template, Environment, FileSystemLoader  
 import mariadb  
 import sys  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def halaman1():  
   file = open('/home/steven/proyekFlask/latihan15/templates/file1.txt','r')  
   angka1 = file.read()  
   file.close()  
   return render_template("halaman5.html", angka1 = angka1)  
 if __name__ == '__main__':  
   aplikasi.run(host="0.0.0.0",port=8543,debug=True)

HTML

 <!DOCTYPE html>  
 <html>  
      <head>  
      </head>  
      <body>  
           <p>{{ angka1 }}<p>  
      </body>  
 </html>

JavaScript : Combining Python with Javascript to Run Python Source Code on an HTML Page

2024-03-27T09:09:00.003+08:00

We are currently learning how to combine Python and Javascript programming code to run a command on a web page.

 from flask import Flask, render_template, request, url_for, redirect  
 from jinja2 import Template, Environment,FileSystemLoader  
 import mariadb  
 import sys  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def halaman1():  
   return render_template("halaman2.html")  
 if __name__ == '__main__':  
   aplikasi.run(host="0.0.0.0",port=8543,debug=True)

 <!DOCTYPE html>  
 <html>  
      <head>  
           <meta name="viewport" content="width=device-width, initial-scale=1">  
           <style>  
                .button {  
                     background-color: #04AA6D;  
                     border: none;  
                     color: white;  
                     padding: 15px 32px;  
                     text-align: center;  
                     text-decoration: none;  
                     display: block;  
                     font-size: 16px;  
                     margin: 10px 10px;  
                     cursor: pointer;  
                     -webkit-transition-duration: 0.4s;  
                     transition-duration: 0.4s;  
                }  
                .button2:hover {  
                     box-shadow: 0 12px 16px 0 rgba(0,0,0,0.24), 0 17px 50px 0 rgba(0,0,0,0.19);  
                }  
           </style>  
      </head>  
      <body>  
           <button class="button button2" onclick="document.getElementById('cetakTanggal').innerHTML = Date()">Uji Coba Javascript 1</button>  
           <p id="cetakTanggal"></p>  
      </body>  
 </html>

Python : Basic Source Code to Create a Web Page Link to Display a Table

2024-03-26T08:25:00.009+08:00

This source code will be further developed to display a table containing data from MariaDB.

This is the Python source code to connect two HTML pages through a web link :

 from flask import Flask, render_template, request, url_for, redirect  
 from jinja2 import Template, Environment, FileSystemLoader  
 import mariadb  
 import sys  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def halaman1():  
   return render_template("halaman1.html")  
 @aplikasi.route('/halaman2')  
 def halaman2():  
   return render_template("halaman2.html")  
 if __name__ == '__main__':  
   aplikasi.run(host='0.0.0.0',port=8543,debug=True)

This is the source code for the first HTML page :

 <!DOCTYPE html>  
 <html>  
      <head>  
           <meta name="viewport" content="width=device-width, initial-scale=1">  
           <style>  
           </style>  
      </head>  
      <body>  
           <h1>Halaman 1</h1>  
                <a href="{{ url_for('halaman2')}}">Halaman 2</a>  
      </body>  
 </html>

This is the source code for the second HTML page :

 <!DOCTYPE html>  
 <html>  
      <head>  
           <meta name="viewport" content="width=device-width, initial-scale=1">  
      </head>  
      <body>  
           <h1>Halaman 2</h1>  
           <a href="{{ url_for('halaman1')}}">Halaman 1</a>  
      </body>  
 </html>

Python : Python Source Code for Menu Page, Data Entry Form, and Table Page for Data Display

2024-03-20T09:17:00.011+08:00

This is the menu page to display the data input menu, the data edit menu, and the menu to display a table containing the data.

This is the source code for the menu page. The menu page is at the forefront and serves as a gateway to access various features in the application.

 <!DOCTYPE html>  
 <html>  
      <head>  
           <meta name="viewport" content="width=device-width, initial-scale=1">  
           <style>  
                .vertical-menu {  
                     width: 200px;  
                }  
                .vertical-menu a{  
                     background-color: #eee;  
                     color: black;  
                     display: block;  
                     padding: 12px;  
                     text-decoration: none;  
                }  
                .vertical-menu a:hover {  
                     background-color: #ccc;  
                }  
                .vertical-menu a.active{  
                     background-color: #04AA6D;  
                     color: white;  
                }  
           </style>  
      </head>  
      <body>  
           <h1>Vertical Menu</h1>  
           <div class="vertical-menu">  
                <a href="{{ url_for('halaman1')}}" class="active">Halaman Menu</a>  
                <a href="{{ url_for('halaman2')}}">Halaman Simpan Data</a>  
                <a href="{{ url_for('halaman3')}}">Halaman Edit Data</a>  
                <a href="{{ url_for('halaman4')}}">Halaman Tabel Data</a>  
           </div>  
      </body>  
 </html>

This is the source code for the data input page. There is also a button to display a table containing the data stored in the MariaDB table. There is also a button to return to the Menu page.

 <!DOCTYPE html>  
 <html>  
      <head>  
           <meta name="viewport" content="width=device-width, initial-scale=1">  
           <style>  
                input[type=text], select {  
                     width: 100%;  
                     padding: 12px 20px;  
                     margin: 8px 0p;  
                     display: inline-block;  
                     border: 1px solid #ccc;  
                     border-radius: 4px;  
                     box-sizing: border-box;  
                }  
                input[type=submit] {  
                     width: 100%;  
                     background-color: #4CAF50;  
                     color: white;  
                     padding: 14px 20px;  
                     margin: 8px 0;  
                     border: none;  
                     border-radius: 4px;  
                     cursor: pointer;  
                }  
                input[type=submit]:hover {  
                     background-color: #45a049;  
                }  
                div {  
                     border-radius: 5px;  
                     background-color: #8ecaed;  
                     padding: 20px;  
                }  
           </style>  
      </head>  
      <body>  
           <h1>Halaman Input Data</h1>  
           <div>  
                <form action="http://1.1.3.9:8543/halaman2" method="POST" id="formSimpanDataSurat" name="formSimpanDataSurat">  
                     <label for="kodedatanomersurat1">Kode Data Nomer Surat</label>  
                     <input type="text" id="kodedatanomersurat1" name="kodedatanomersurat1" placeholder="Isikan Kode Data Nomer Surat">  
                     <label for="tanggalsurat1">Tanggal Surat</label>  
                     <input type="text" id="tanggalsurat1" name="tanggalsurat1" placeholder="Isikan Tanggal Surat">  
                     <label for="nomersurat1">Nomer Surat</label>  
                     <input type="text" id="nomersurat1" name="nomersurat1" placeholder="Isikan Nomer Surat">  
                     <label for="perihalsurat1">Perihal Surat</label>  
                     <input type="text" id="perihalsurat1" name="perihalsurat1" placeholder="Isikan Perihal Surat">  
                     <input type="submit" name="tombolPerintah" value="Simpan Data">  
                     <input type="submit" name="tombolPerintah" value="Tampilkan Tabel Data">  
                     <input type="submit" name="tombolPerintah" value="Kembali Ke Halaman Menu">  
                </form>  
           </div>  
      </body>  
 </html>

This is the HTML source code to display a table containing data from the MariaDB server.

 <!DOCTYPE html>  
 <html>  
      <head>  
           <style>  
                #dataNama {  
                     font-family: Arial, Helvetica, sans-serif;  
                     border-collapse: collapse;  
                     width: 100%;  
                }  
                #dataNama td, #dataNama th {  
                     border: 1px solid #ddd;  
                     padding: 8px;  
                }  
                #dataNama tr:nth-child(even){background-color: #f2f2f2;}  
                #dataNama tr:hover {background-color: #dataNama}  
                #dataNama th{  
                     padding-top: 12px;  
                     padding-bottom: 12px;  
                     text-align: left;  
                     background-color: #04AA6D;  
                     color: white;  
                }  
           </style>  
      </head>  
      <body>  
           <table id="dataNama">  
                <!--- Ini adalah source code untuk membuat header table ---->  
                {% if hasil1 %}  
                <tr>  
                     {% for key in hasil1[0] %}  
                          <th>{{ key }}</th>  
                     {% endfor %}  
                </tr>  
                {% endif %}  
                <!----- ini adalah source code untuk membuat isi tabel  ------>  
                {% for isitabel in hasil1 %}  
                <tr>  
                     {% for value in isitabel.values()%}  
                          <td>{{ value }}</td>  
                     {% endfor %}  
                </tr>  
                {% endfor %}  
           </table>  
      </body>  
 </html>

This is the source code written in Python. This source code is used to control and run the features on the three web pages above.

 from flask import Flask, render_template, request, url_for, redirect  
 from jinja2 import Template, Environment, FileSystemLoader  
 import mariadb  
 import sys  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def halaman1():  
   return render_template("halaman1.html")  
 @aplikasi.route('/halaman2', methods=['GET','POST'])  
 def halaman2():  
   if request.method == 'POST':  
     if request.form['tombolPerintah'] == 'Simpan Data':  
       kodeDataNomerSurat1 = request.form.get('kodedatanomersurat1')  
       tanggalSurat1 = request.form.get('tanggalsurat1')  
       nomerSurat1 = request.form.get('nomersurat1')  
       perihalSurat1 = request.form.get('perihalsurat1')  
       koneksi = mariadb.connect(user="steven",password="kucing",host="1.1.3.9",port=3306,database="saham")  
       kursor = koneksi.cursor()  
       kursor.execute("INSERT INTO nomersurat(kodedatanomersurat,tanggalsurat,nomersurat,perihalsurat) VALUES (%s,%s,%s,%s)",(kodeDataNomerSurat1,tanggalSurat1,nomerSurat1,perihalSurat1))  
       koneksi.commit()  
       koneksi.close()  
       return redirect(url_for('halaman1'))  
     # elif request.form['tombolPerintah'] == 'Tampilkan Tabel Data':  
     elif request.form['tombolPerintah'] == 'Tampilkan Tabel Data':  
       koneksi = mariadb.connect(user="steven",password="kucing",host="1.1.3.9",port=3306,database="saham")  
       kursor = koneksi.cursor(dictionary=True)  
       kursor.execute("SELECT kodedatanomersurat,tanggalsurat,nomersurat,perihalsurat FROM nomersurat")  
       hasil = kursor.fetchall()  
       return render_template("halaman4.html",hasil1=hasil)  
     # elif request.form['tombolPerintah'] == 'Kembali Ke Halaman Menu':  
     elif request.form['tombolPerintah'] == 'Kembali Ke Halaman Menu':  
       return redirect(url_for('halaman1'))  
   return render_template("halaman2.html")  
 @aplikasi.route('/halaman3')  
 def halaman3():  
   return render_template("halaman3.html")  
 @aplikasi.route('/halaman4')  
 def halaman4():  
   return render_template("halaman4.html")  
 if __name__ == '__main__':  
   aplikasi.run(host="0.0.0.0",port=8543,debug=True)

Python : Source Code of The Menu For Accessing The Data Entry Page

2024-03-15T09:10:00.007+08:00

This is the HTML source code for a vertical menu. The menu contains a list of actions that can be performed on the data.

 <!DOCTYPE html>  
 <html>  
      <head>  
           <meta name="viewport" content="width=device-width, initial-scale=1">  
           <style>  
                .vertical-menu{  
                     width: 200px;  
                }  
                .vertical-menu a{  
                     background-color: #eee;  
                     color: black;  
                     display: block;  
                     padding: 12px;  
                     text-decoration: none;  
                }  
                .vertical-menu a:hover {  
                     background-color: #ccc;  
                }  
                .vertical-menu a.active {  
                     background-color: #04AA6D;  
                     color: white;  
                }  
           </style>  
      </head>  
      <body>  
           <h1>Vertical Menu</h1>  
           <div class="vertical-menu">  
                <a href="{{ url_for('halaman1')}}" class="active">Halaman Menu</a>  
                <a href="{{ url_for('halaman2')}}">Halaman Simpan Data</a>  
                <a href="#">Halaman 3</a>  
                <a href="#">Halaman 4</a>  
                <a href="#">Halaman 5</a>  
           </div>  
      </body>  
 </html>

This is the HTML source code for creating a form that will be used to fill data into the Mariadb server.

 <!DOCTYPE html>  
 <html>  
 <head>  
      <style>  
           input[type=text], select{  
                width: 100%;  
                padding: 12px 20px;  
                margin: 8px 0;  
                display: inline-block;  
                border: 1px solid #ccc;  
                border-radius: 4px;  
                box-sizing: border-box;  
           }  
           input[type=submit] {  
                width: 100%;  
                background-color: #4CAF50;  
                color: white;  
                padding: 14px 20px;  
                margin: 8px 0;  
                border: none;  
                border-radius: 4px;  
                cursor: pointer;  
           }  
           input[type=submit]:hover{  
                background-color: #45a049;  
           }  
           div{  
                border-radius: 5px;  
                background-color: #8ecaed;  
                padding: 20px;  
           }  
      </style>  
 </head>  
 <body>  
      <h1>Halaman Input Data</h1>  
      <di>  
           <form action="http://1.1.3.10:8543/halaman2" method="POST" id="formSimpanDataSurat" name="formSimpanDataSurat">  
                <label for="kodedatanomersurat1">Kode Data Nomer Surat</label>  
                <input type="text" id="kodedatanomersurat1" name="kodedatanomersurat1" placeholder="Isikan Kode Data Nomer Surat">  
                <label for="tanggalsurat1">Tanggal Surat</label>  
                <input type="text" id="tanggalsurat1" name="tanggalsurat1" placeholder="Isikan Tanggal Surat">  
                <label for="nomersurat1">Nomer Surat</label>  
                <input type="text" id="nomersurat1" name="nomersurat1" placeholder="Isikan Nomer Surat">  
                <label for="perihalsurat1">Perihal Surat</label>  
                <input type="text" id="perihalsurat1" name="perihalsurat1" placeholder="Isikan Perihal Surat">  
                <input type="submit" name="tombolPerintah" value="Simpan Data">  
                <input type="submit" name="tombolPerintah" value="Kembali Ke Halaman Menu">  
           </form>  
      </div>  
 </body>  
 </html>

This is the Python source code for displaying a menu, data entry page, and executing the data entry command from the form to the Mariadb database.

 from flask import Flask, render_template, request, url_for, redirect  
 from jinja2 import Template, Environment, FileSystemLoader  
 import mariadb  
 import sys  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def halaman1():  
   return render_template("halaman1.html")  
 @aplikasi.route('/halaman2', methods=['GET','POST'])  
 def halaman2():  
   if request.method == 'POST':  
     if request.form['tombolPerintah'] == 'Simpan Data':  
       kodeDataNomerSurat1 = request.form.get('kodedatanomersurat1')  
       tanggalSurat1 = request.form.get('tanggalsurat1')  
       nomerSurat1 = request.form.get('nomersurat1')  
       perihalSurat1 = request.form.get('perihalsurat1')  
       koneksi = mariadb.connect(user="steven",password="kucing",host="1.1.3.10",port=3306,database="saham")  
       kursor = koneksi.cursor()  
       kursor.execute("INSERT INTO nomersurat(kodedatanomersurat,tanggalsurat,nomersurat,perihalsurat) VALUES (%s,%s,%s,%s)",(kodeDataNomerSurat1,tanggalSurat1,nomerSurat1,perihalSurat1))  
       koneksi.commit()  
       koneksi.close()  
       return redirect(url_for('halaman1'))  
     elif request.form['tombolPerintah'] == 'Kembali Ke Halaman Menu':  
       return redirect(url_for('halaman1'))  
     # return redirect(url_for('halaman1'))  
   return render_template('halaman2.html')  
 if __name__ == '__main__':  
   aplikasi.run(host="0.0.0.0",port=8543,debug=True)

Python : This is An Example of Source Code That Inspires How to Create Menus and Links.

2024-03-14T10:35:00.007+08:00

This is the source code for displaying a menu that already uses CSS. This source code example is taken from a source on the internet.

HTML Source Code

HTML Source Code For Page 1

 <!DOCTYPE html>  
 <html>  
      <head>  
      </head>  
      <body>  
           <p><a href="{{ url_for('halaman2')}}">Coba anda lihat form ini</a></p>  
      </body>  
 </html>

HTML Source Code For Page 2

 <!DOCTYPE html>  
 <html>  
      <head>  
      </head>  
      <body>  
           <form method="post">  
                <button type="submit">Uji Coba</button>  
           </form>  
      </body>  
 </html>

Python Code :

 from flask import Flask, request, url_for, redirect, render_template  
 from jinja2 import Template, Environment, FileSystemLoader  
 import mariadb  
 import sys  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def halaman1():  
   return render_template('halaman1.html')  
 @aplikasi.route('/halaman2', methods=['GET','POST'])  
 def halaman2():  
   if request.method == 'POST':  
     # lakukan sesuatu ketika form di kumpulkan  
     # dialihkan untuk mengakhiri penanganan POST  
     # pengalihan bisa ke route yang sama atau ke sesuatu yang lain  
     return redirect(url_for('halaman1'))  
   # tampilkan form nya, form nya tidak di kumpulkan  
   return render_template('halaman2.html')  
 if __name__ == '__main__':  
   aplikasi.run(host='0.0.0.0',port=8543,debug=True)

Python : Learning How To Create A Menu And Link It To Routes To Open Different Pages.

2024-03-14T10:06:00.007+08:00

This is the source code for an HTML page containing a menu

HTML Code :

 <!DOCTYPE html>  
 <html>  
      <head>  
           <meta name="viewport" content="width=device-width, initial-scale=1">  
           <style>  
                .vertical-menu{  
                     width: 200px;  
                }  
                .vertical-menu a{  
                     background-color: #eee;  
                     color: black;  
                     display: block;  
                     padding: 12px;  
                     text-decoration: none;  
                }  
                .vertical-menu a:hover {  
                     background-color: #ccc;  
                }  
                .vertical-menu a.active {  
                     background-color: #04AA6D;  
                     color: white;  
                }  
           </style>  
      </head>  
      <body>  
           <h1>Vertical Menu</h1>  
           <div class="vertical-menu">  
                <a href="#" class="active">Halaman Utama</a>  
                <a href="#">Halaman 1</a>  
                <a href="#">Halaman 2</a>  
                <a href="#">Halaman 3</a>  
                <a href="#">Halaman 4</a>  
           </div>  
      </body>  
 </html>

Python Code :

 from flask import Flask, render_template, request  
 from jinja2 import Template, Environment, FileSystemLoader  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def tampilHalaman():  
   return render_template("halaman1.html")  
 if __name__ == '__main__':  
   aplikasi.run(host="0.0.0.0",port=8543,debug=True)

Python : Exercises on Using Dictionaries in Python

2024-02-21T10:57:00.036+08:00

The following are exercises on using Dictionaries in Python that have been completed today.

file14.py

 kamusku = {}  
 kamusku['nama'] = "Steven Nathaniel"  
 kamusku['usia'] = 1  
 print (kamusku)

file15.py

 kamusku = {}  
 print(kamusku)  
 print(type(kamusku))

file16.py

 informasi = {'nama':'steven','usia':15,'lokasi':'Athena'}  
 print(informasi)  
 print(type(informasi))

file17.py

 informasi = dict({'nama':'steven','usia':15,'lokasi':'Athena'})  
 print(informasi)  
 print(type(informasi))

file18.py

 namaKota = ('Samarinda','Athena','Balikpapan')  
 kamusKu = dict.fromkeys(namaKota)  
 print(kamusKu)

file19.py

 namaKota = ('Balikpapan','Samarinda','Jakarta')  
 negara = 'Indonesia'  
 kamus = dict.fromkeys(namaKota,negara)  
 print(kamus)

file20.py

 namaKota = ('Balikpapan','Samarinda','Jakarta')  
 negara = 'indonesia'  
 kamus = dict.fromkeys(namaKota,negara)  
 print(len(kamus))

file21.py

 tahunPembuatanMobil = {'Kijang': 1997, 'Lancer': 1995, 'Accord': 1999}  
 print(tahunPembuatanMobil.values())

file22.py

 dataRoti = {'merekRoti': 'Sari Roti', 'tanggalProduksi': 22, 'bulanProduksi': 'Februari'}  
 print(dataRoti['merekRoti'])

file23.py

 dataRoti = {'merekRoti': 'Sari Roti', 'tanggalProduksi': 22, 'bulanProduksi': 'Februari'}  
 print('merekNasi' in dataRoti)

file24.py

 dataRoti = {'merekRoti': 'Sari Roti', 'tanggalProduksi': 22, 'bulanProduksi': 'Februari'}  
 print(dataRoti.get('merekRoti'))

file25.py

 dataRoti = {}  
 dataRoti["namaRoti"] = "Roti Bakar Kepiting"  
 print(dataRoti)

file26.py

 dataRoti = {}  
 dataRoti['namaRoti'] = "Roti Bakar Mentega"  
 dataRoti['jumlahRoti'] = 10  
 print(dataRoti)

file27.py

 dataRoti = {'namaRoti':"Roti Bakar Mentega", 'jumlahRoti':9}  
 print(dataRoti)  
 dataRoti['jumlahRoti'] = 11  
 print(dataRoti)

file28.py

 dataRoti = {'namaRoti':"Roti Goreng Mentega",'kemasanRoti':"Plastik"}  
 print(dataRoti)  
 dataRoti['kemasanRoti'] = "Kayu"  
 print('kemasanRoti' in dataRoti)

file29.py

 dataRoti = {'merekRoti':"Bondy", 'jumlahLembar':10}  
 dataRoti.update(merekRoti='Holland', jumlahLembar=50, penggunaanKulit='Kulit')  
 print(dataRoti)

file30.py

 dataRoti = {'merekRoti':'Bondy','bulanPembuatan':'Februari','lokasiToko':'Gunung Sari'}  
 del dataRoti['bulanPembuatan']  
 print(dataRoti)

This is a source code that almost successfully displays data from the database into a table format.

This is the source code for the Python section.

 import mariadb  
 import sys  
 from jinja2 import Template, Environment, FileSystemLoader  
 from flask import Flask, render_template, request  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def tampilkanData():  
   koneksi = mariadb.connect(user="steven",password="kucing",host="1.1.3.7",port=3306,database="saham")  
   kursor = koneksi.cursor(dictionary=True)  
   kursor.execute("SELECT idnama1,namaawal1,namaakhir1 FROM nama1")  
   hasil = kursor.fetchall()  
   koneksi.commit()  
   koneksi.close()  
   return render_template("halaman6.html",hasil=hasil)  
 if __name__ == '__main__':  
   aplikasi.run(host="0.0.0.0", port=8543, debug=True)

This is the source code for the HTML section.

 <!DOCTYPE html>  
 <html>  
      <head>  
      </head>  
      <body>  
           <h1>Tampilkan Tabel</h1>  
           <table>  
                {% for hasil_item in hasil %}  
                     {% for key, value in hasil_item.items() %}  
                          <tr>  
                               <th>{{ key }}</th>  
                          </tr>  
                          <tr>  
                               <td>{{ value }}</td>  
                          </tr>  
                     {% endfor %}  
                {% endfor %}  
           </table>  
      </body>  
 </html>

This is the working source code to display the contents of a dictionary from the results of a database query. The data is displayed on an HTML page. This is an example of source code that uses HTML and Python.

HTML :

 <!DOCTYPE html>  
 <html>  
      <head>  
      </head>  
      <body>  
           {{ hasil1[0] }}  
      </body>  
 </html>

This is an example of an HTML source code that displays the entire contents of a dictionary.

 <!DOCTYPE html>  
 <html>  
      <head>  
      </head>  
      <body>  
           {{ hasil1 }}  
      </body>  
 </html>

The following are variations of HTML source code that will display different data results.

 <!DOCTYPE html>  
 <html>  
      <head>  
      </head>  
      <body>  
           {% for hasil2 in hasil1 %}  
                {% for key, value in hasil2.items() %}  
                     {{ value }}  
                {% endfor %}  
           {% endfor %}  
      </body>  
 </html>

 <!DOCTYPE html>  
 <html>  
      <head>  
      </head>  
      <body>  
           {% for hasil2 in hasil1 %}  
                {{ hasil2.keys() }}  
           {% endfor %}  
      </body>  
 </html>

This is the source code that successfully displays data in an HTML table correctly.

 <!DOCTYPE HTML>  
 <HTML>  
      <HEAD>  
      </HEAD>  
      <BODY>  
           <table>  
                <!----- Ini adalah source code untuk membuat header table ----->  
                     {% if hasil1 %}  
                     <tr>  
                          {% for key in hasil1[0] %}  
                               <th> {{ key }} </th>  
                          {% endfor %}  
                     </tr>  
                     {% endif %}  
                <!--- Ini adalah source code untuk membuat isi tabel -->  
                {% for isitabel in hasil1 %}  
                <tr>  
                     {% for value in isitabel.values() %}  
                          <td>{{ value }}</td>  
                     {% endfor %}  
                </tr>  
                {% endfor %}  
           </table>  
      </BODY>  
 </HTML>

This is a combination of querying the correct database and displaying the correct table (using CSS).

Python Code :

 from flask import Flask, render_template, request  
 from jinja2 import Template, Environment, FileSystemLoader  
 import mariadb  
 import sys  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def tabelData():  
   koneksi = mariadb.connect(user="steven",password="kucing",host="1.1.3.7",port=3306,database="saham")  
   kursor = koneksi.cursor(dictionary=True)  
   kursor.execute("SELECT idnama1,namaawal1,namaakhir1 FROM nama1")  
   hasil = kursor.fetchall()  
   return render_template("halaman11.html",hasil1=hasil)  
 if __name__ == '__main__':  
   aplikasi.run(host="0.0.0.0", port=8543, debug=True)

HTML Code :

 <!DOCTYPE html>  
 <html>  
 <head>  
      <style>  
           #dataNama {  
                font-family: Arial, Helvetica, sans-serif;  
                border-collapse: collapse;  
                width: 100%;  
           }  
           #dataNama td, #dataNama th {  
                border: 1px solid #ddd;  
                padding: 8px;  
           }  
           #dataNama tr:nth-child(even){background-color: #f2f2f2;}  
           #dataNama tr:hover {background-color: #dataNama}  
           #dataNama th{  
                padding-top: 12px;  
                padding-bottom: 12px;  
                text-align: left;  
                background-color: #04AA6D;  
                color: white;  
           }  
      </style>  
 </head>  
 <body>  
      <table id="dataNama">  
           <!------- Ini adalah source code untuk membuat header table -------->  
                {% if hasil1 %}  
                <tr>  
                     {% for key in hasil1[0] %}  
                          <th> {{ key }} </th>  
                     {% endfor %}  
                </tr>  
                {% endif %}  
                <!--- ini adalah source code untuk membuat isi tabel -->  
                {% for isitabel in hasil1 %}  
                <tr>  
                     {% for value in isitabel.values() %}  
                          <td>{{ value }}</td>  
                     {% endfor %}  
                </tr>  
                {% endfor %}  
      </table>  
 </body>  
 </html>

Python: Source Code That Successfully Displays Data in a Table

2024-02-19T10:22:00.012+08:00

This is the basic source code that can display data from a MariaDB table.

This is the source code that has successfully displayed data into an HTML table.

This is source for python :

 from flask import Flask, render_template, request  
 from jinja2 import Template, Environment, FileSystemLoader  
 import mariadb  
 import sys  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def tabelData1():  
   return render_template("halaman2.html",)  
 @aplikasi.route('/tampilData',methods=['POST'])  
 def tampilkanData():  
   if request.method=='POST':  
     if request.form['tombolPerintah'] == 'Tampilkan Data':  
       koneksi = mariadb.connect(user="steven",password="kucing",host="1.1.3.13",port=3306,database="saham")  
       kursor = koneksi.cursor(dictionary=True)  
       kursor.execute("SELECT idnama1,namaawal1,namaakhir1 FROM nama1")  
       hasil = kursor.fetchall()  
       # print(hasil)  
       # Tampilkan isi Baris pertama dari tabel  
       idnama1 = hasil[0]["idnama1"]  
       namaawal1 = hasil[0]["namaawal1"]  
       namaakhir1 = hasil[0]["namaakhir1"]  
       # Tampilkan isi Baris kedua dari tabel  
       idnama2 = hasil[1]["idnama1"]  
       namaawal2 = hasil[1]["namaawal1"]  
       namaakhir2 = hasil[1]["namaakhir1"]  
       return render_template("halaman2.html", IdNama1 = idnama1, NamaAwal1 = namaawal1, NamaAkhir1 = namaakhir1, IdNama2 = idnama2, NamaAwal2 = namaawal2, NamaAkhir2 = namaakhir2)  
       koneksi.commit()  
       koneksi.close()  
 if __name__ == '__main__':  
   aplikasi.run(host='0.0.0.0',port=8543,debug=True)

This is source code for HTML page :

 <!DOCTYPE html>  
 <html>  
      <head>  
      </head>  
      <body>  
           <h3>Tabel Menampilkan Data</h3>  
                <form action="http://1.1.3.13:8543/tampilData" method="POST" id="formMenampilkanData" name="formMenampilkanData">  
                          <table>  
                               <thead>  
                                    <tr>  
                                         <th>ID Nama</th>  
                                         <th>Nama Awal</th>  
                                         <th>Nama Akhir</th>  
                                    </tr>  
                               </thead>  
                               <tbody>  
                                         <tr>  
                                              <td>{{ IdNama1}}</td>  
                                              <td>{{ NamaAwal1 }}</td>  
                                              <td>{{ NamaAkhir1 }}</td>  
                                         </tr>  
                                         <tr>  
                                              <td>{{ IdNama2 }}</td>  
                                              <td>{{ NamaAwal2 }}</td>  
                                              <td>{{ NamaAkhir2 }}</td>  
                                         </tr>  
                               </tbody>  
                          </table>  
                          <input type="submit" name="tombolPerintah" value="Tampilkan Data">  
                </form>  
      </body>  
 </html>

This is a link that contains an example of how to create a loop, in an effort to display data in a table.

Next, we will try to be able to create a table using this looping function.

This source code successfully displays data based on the looping results, but the data is still in the form of a list, not data that can be separated by rows and columns.

We will use the Dictionary concept to collect data from Mariadb. The data is the result of a query process from Mariadb. The Dictionary will be tried to be used to build a table on an HTML page.

This is an example of a link that can help you display data in an HTML table.
This link is suitable for learning in depth about dictionaries.

Wifi Sharing : How to Share a WiFi Connection Using a Cheap USB Dongle Like Tenda and Totolink

2024-02-13T16:32:00.004+08:00

Here are the steps on how to share internet from a laptop or PC using a USB WiFi Dongle. This will allow other devices to connect to the internet as well.

netsh wlan set hostednetwork mode=allow ssid=nasipecel key=makan1234 keyusage=temporary
netsh wlan start hostednetwork
netsh wlan show hostednetwork
netsh wlan set hostednetwork mode=disallow
netsh wlan stop hostednetwork
netsh wlan show settings
netsh wlan show profiles
netsh wlan delete profile name="swisscom"
netsh wlan delete profile name=* i=*
netsh wlan show drivers
https://stackoverflow.com/questions/18182084/cant-start-hostednetwork
https://support.airserver.com/support/solutions/articles/43000532725-how-can-i-enable-the-wireless-autoconfig-service-the-wireless-autoconfig-service-wlansvc-is-not-
https://youtu.be/2pvK-6321ig?si=tKonB-Tn-LIvcTTX

Python Flask : Getting Ready to Make a Table

2024-02-13T12:01:00.003+08:00

The source code below is to start finding ways to create a table on a web page. The data for the table is taken from a MariaDB database query.

 from jinja2 import Template, Environment, FileSystemLoader  
 from flask import Flask, render_template, request, json, jsonify  
 import mariadb  
 import sys  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def formUtama():  
   return render_template("halaman1.html")  
 @aplikasi.route('/tampilData',methods=['POST'])  
 def tampilkanData():  
   if request.method=='POST':  
     koneksi = mariadb.connect(user="steven",password="kucing",host="1.1.3.9",port=3306,database="saham")  
     kursor= koneksi.cursor(dictionary=True)  
     kursor.execute("SELECT kodedata,tanggalpendataan,kodebarang,NIP,namabarang,kodebagian,namadivisi,merekprinter,serialprinter,macaddress,jenistinta,namapengguna FROM daftartintaprinter2")  
     hasil = kursor.fetchall()  
     # di bawah ini untuk menampilkan baris data yang urutan 1  
     kodedata1 = hasil[0]["kodedata"]  
     tanggalpendataan1 = hasil[0]["tanggalpendataan"]  
     kodebarang1 = hasil[0]["kodebarang"]  
     nip1 = hasil[0]["NIP"]  
     namabarang1 = hasil[0]["namabarang"]  
     kodebagian1 = hasil[0]["kodebagian"]  
     namadivisi1 = hasil[0]["namadivisi"]  
     merekprinter1 = hasil[0]["merekprinter"]  
     serialprinter1 = hasil[0]["serialprinter"]  
     macaddress1 = hasil[0]["macaddress"]  
     jenistinta1 = hasil[0]["jenistinta"]  
     namapengguna1 = hasil[0]["namapengguna"]  
     # di bawah ini untuk menampilkan baris data yang urutan 2  
     kodedata2 = hasil[1]["kodedata"]  
     tanggalpendataan2 = hasil[1]["tanggalpendataan"]  
     kodebarang2 = hasil[1]["kodebarang"]  
     nip2 = hasil[1]["NIP"]  
     namabarang2 = hasil[1]["namabarang"]  
     kodebagian2 = hasil[1]["kodebagian"]  
     namadivisi2 = hasil[1]["namadivisi"]  
     merekprinter2 = hasil[1]["merekprinter"]  
     serialprinter2 = hasil[1]["serialprinter"]  
     macaddress2 = hasil[1]["macaddress"]  
     jenistinta2 = hasil[1]["jenistinta"]  
     namapengguna2 = hasil[1]["namapengguna"]  
     koneksi.commit()  
     koneksi.close()  
     return render_template("halaman3.html", kodeData1 = kodedata1, tanggalPendataan1 = tanggalpendataan1, kodeBarang1 = kodebarang1, NIP1 = nip1, namaBarang1 = namabarang1, kodeBagian1 = kodebagian1, namaDivisi1 = namadivisi1, merekPrinter1 = merekprinter1, serialPrinter1 = serialprinter1, macAddress1 = macaddress1, jenisTinta1 = jenistinta1, namaPengguna1 = namapengguna1, kodeData2 = kodedata2, tanggalPendataan2 = tanggalpendataan2, kodeBarang2 = kodebarang2, NIP2 = nip2, namaBarang2 = namabarang2, kodeBagian2 = kodebagian2, namaDivisi2 = namadivisi2, merekPrinter2 = merekprinter2, serialPrinter2 = serialprinter2, macAddress2 = macaddress2, jenisTinta2 = jenistinta2, namaPengguna2 = namapengguna2 )  
 if __name__ == '__main__':  
   aplikasi.run(host='0.0.0.0',port=8543,debug=True)

Getting Started with PHP Programming

2024-02-07T09:56:00.007+08:00

Getting Started with PHP Programming

Resuming Our PHP Learning Journey in Laravel. Below is a simple source code example to get you started with learning PHP programming again.

Flask: Printing Database Query Results to an HTML Table

2024-01-30T11:51:00.010+08:00

In this example, I am trying to query a MariaDB database. Then I am trying to display the results on a web page. However, for the first step, I will try to display the query results to the terminal. The following is the source code for printing database query results to the terminal:

 import mariadb  
 import sys  
 koneksi = mariadb.connect(user="steven",password="kucing",host="1.1.3.6",port=3306,database="saham")  
 kursor = koneksi.cursor(dictionary=True)  
 kursor.execute("SELECT idnama1,namaawal1,namaakhir1 FROM nama1")  
 hasil = kursor.fetchall()  
 print(hasil[0])

The following source code successfully prints the query results from the MariaDB database to the terminal.

 import mariadb  
 import sys  
 koneksi = mariadb.connect(user="steven",password="kucing",host="1.1.3.7",port=3306,database="saham")  
 kursor = koneksi.cursor(dictionary=True)  
 kursor.execute("SELECT idnama1,namaawal1,namaakhir1 FROM nama1")  
 hasil = kursor.fetchall()  
 print(hasil[1])

 import mariadb  
 import sys  
 koneksi = mariadb.connect(user="steven",password="kucing",host="1.1.3.7",port=3306,database="saham")  
 kursor = koneksi.cursor(dictionary=True)  
 kursor.execute("SELECT idnama1,namaawal1,namaakhir1 FROM nama1")  
 hasil = kursor.fetchall()  
 idnama1A = hasil[0]["idnama1"]  
 print(idnama1A)

The following is the source code for rendering an HTML page using Flask.

Python 3 : The Class

2024-01-11T10:53:00.004+08:00

 class kelas1:  
   def __init__(self, nama, usia):  
     self.nama = nama  
     self.usia = usia  
   def __str__(self):  
     return "Tampilkan nama : %s , usia : %s" % (self.nama, self.usia)  
 isian = kelas1("Steven", 17)  
 print(isian)

This is the Initial Source Code for Learning About Classes in Python Programming.

Understanding classes in Python programming will be useful for understanding how to create tables using Flask Table.

A class is a group of functions.

We want to learn how to inherit in classes in Python programming. We can only inherit within the same class, which is inheritance between functions.

This Blog will be Written in a Language Other Than Indonesian

2023-11-12T10:52:00.085+08:00

There will be a change in the language used on this blog, from Indonesian to a language other than Indonesian. In this blog, I will write about various things.

I have successfully compressed the size of a .jpeg photo file using the following software:

https://saerasoft.com/caesium/

And in one article, I will try to achieve a target of 800 words or more. What I have learned in the past two days is about the applications Snackvideo and Bigo Live. The applications SnackVideo and Bigo seem to be more lenient than TikTok in terms of regulations. As a result, there are not many violations in both of these applications. Some users who perform live streaming on Bigo have moved their live streaming activities to the Line application. Perhaps this is because the rules on the Line application are more lenient than on Bigo. This is a rule related to the issue of nudity. In the Bigo app, in some live rooms, there are live room administrators who will remove viewers who only watch without giving any gifts to the host of the live room.

Today I have successfully changed the address of my blog to .web.id. I have also successfully connected it to AdSense. I am always learning how to make the links from my blog to be on various websites. In the afternoon, I studied about writing programming code using the Python programming language. The Python programming code was run in the Docker application. I have also successfully set up Google Analytics on this blog. I have already submitted this blog to Bing Webmaster and Yandex Webmaster, so this blog is also indexed in both of those search engines.

Building Docker Image

Here is the command to build a Docker image. Type the following command in the terminal of the host computer that has Docker :

sudo docker image build -t python-flask2 /home/steven/proyekPython/latihan1

Here is the command to find out who the user is in the specified Docker image:

sudo docker run --entrypoint "" python-mariadb1  whoami

The following command will remove a Docker image that has already been built :

sudo docker image rm <nama-repository>

The following command will list all containers that have been created :

sudo docker ps -a

Instructions for deleting a container :

sudo docker container rm (ID Container)

Example :

sudo docker container rm 9c9b1210e0c0

Instructions for running a Docker image on a Lokinet network :

sudo docker run -p 0.0.0.0:8543:8543 python-flask1

command to stop a running container :

sudo docker container stop (ID Container)

Example :

sudo docker container stop b4d3e8d5fe4a

Instructions to run a docker image on multiple ports simultaneously:

sudo docker run -p 0.0.0.0:3306:3306 -p 0.0.0.0:8543:8543 -t python-mariadb1

Here is the source code for a web project using the Python programming language in Docker, which also includes the help of the Jinja2 library, Blueprint :

At the beginning, I will write the programming code for the Docker file, this programming code can also give commands to Docker to create a templates folder.

 FROM python  
 USER 0  
 WORKDIR /home  
 # RUN cd /home  
 RUN mkdir ./templates  
 EXPOSE 3306 8543  
 RUN pip install flask  
 RUN pip install Jinja2  
 RUN pip install mariadb  
 COPY file4.py ./  
 COPY file1.html ./templates  
 CMD ["python3", "./file4.py"]

Here is the source code for the HTML template that becomes the user interface of our program :

 <!DOCTYPE html>  
 <html lang="en">   
   <head>  
     <meta charset="utf-8">  
     <title>{{title}}</title>  
   </head>  
   <body>  
     <h1>Selamat Datang Di {{kota}}</h1>  
   </body>  
 </html>

Here is the Python source code for running a program that can display text on a web page. With the help of Jinja templates and routing from blueprints.

 from jinja2 import Environment, FileSystemLoader  
 from flask import Flask, render_template  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def halamanPertama():  
   return render_template("file1.html",title="New Found Land",kota="Land")  
 if __name__ == '__main__':  
   aplikasi.run(host='0.0.0.0',port='8543',debug='True')

Latihan 2

The following source code is the Docker file for Exercise 2 :

 FROM python  
 USER 0  
 WORKDIR /home  
 RUN mkdir ./latihan2  
 RUN mkdir ./latihan2/templates  
 EXPOSE 3306 8543  
 RUN pip install flask  
 RUN pip install Jinja2  
 RUN pip install mariadb  
 COPY file1.py ./latihan2  
 COPY file1.html ./latihan2/templates  
 CMD ["python3", "./latihan2/file1.py"]

The HTML file for the following application interface:

 <!DOCTYPE html>  
 <html>  
   <head>  
   </head>  
   <body>  
     <p>Kode Data : {{kodedata}}</p>  
     <p>Tanggal Pendataan : {{tanggalpendataan}}</p>  
     <p>Bagian/Sub Bagian : {{bagiansubbagian}}</p>  
     <p>Kode Barang : {{kodebarang}}</p>  
     <p>Merek Printer : {{merekprinter}}</p>  
   </body>  
 </html>

Here is the Python source code for creating the core application of the program we made

 import mariadb  
 import sys  
 import json  
 from jinja2 import Environment, FileSystemLoader  
 from flask import Flask, render_template  
 aplikasi = Flask(__name__)  
 try:  
   koneksi = mariadb.connect(user="steven",password="kucing",host="1.1.3.9",port=3306,database="saham")  
 except mariadb.Error as e:  
   print(f"Gagal Terkoneksi Ke : {e}")  
   sys.exit(1)  
 kursor = koneksi.cursor()  
 kursor.execute("SELECT kodedata,tanggalpendataan,bagiansubbagian,kodebarang,merekprinter FROM daftartintaprinter")  
 hasil = kursor.fetchall()  
 for data in hasil:  
   kodedata = data[0]  
   tanggalpendataan = data[1].strftime("%Y-%m-%d")  
   bagiansubbagian = data[2]  
   kodebarang = data[3]  
   merekprinter = data[4]  
 f = lambda s: f"dict({','.join(f'{k}={k}' for k in s.split(','))})"  
 kamusHasil = eval(f('kodedata,tanggalpendataan,bagiansubbagian,kodebarang,merekprinter'))  
 @aplikasi.route('/')  
 def halamanUtama():  
   return render_template("file1.html", **kamusHasil)  
 if __name__ == '__main__':  
   aplikasi.run(host='0.0.0.0', port=8543, debug=True)

The following is a link to a lesson on how data transfer can happen in Flask and Jinja :

https://pythonbasics.org/flask-template-data/

Latihan 5

The following source code is the Docker file for Exercise 5 :

 FROM python  
 USER 0  
 WORKDIR /home  
 RUN mkdir ./latihan5  
 RUN mkdir ./latihan5/templates  
 EXPOSE 3306 8543  
 RUN pip install flask  
 RUN pip install Jinja2  
 RUN pip install mariadb  
 COPY file1.py ./latihan5  
 COPY murid1.html ./latihan5/templates  
 COPY hasil1.html ./latihan5/templates  
 CMD ["python3", "./latihan5/file1.py"]

Here, we write the code to create a simple form, which later can be used for data transfer experiments using Flask and Jinja.

murid1.html

 <!DOCTYPE html>  
 <html>  
   <head>  
   </head>  
   <body>  
     <form action = "http://1.1.3.2:8543/hasil" method = "POST">  
       <p>Nama : <input type="text" name="Nama"/></p>  
       <p><input type = "submit" value = "submit"></p>  
     </form>  
   </body>  
 </html>

The following is the source code to receive data input from the murid1.html page and then display the input results to the hasil1.html page.

file1.py

 from flask import Flask, render_template, request  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def murid():  
   return render_template('murid1.html')  
 @aplikasi.route('/hasil',methods = ['POST','GET'])  
 def hasil():  
   if request.method == 'POST':  
     hasil = request.form  
     return render_template("hasil1.html",hasil = hasil)  
 if __name__ == '__main__':  
   aplikasi.run(host='0.0.0.0', port=8543, debug=True)

The following is the source code to display the results of the data entry activity performed in the form on the murid1.html page.

hasil1.html

 <!DOCTYPE html>  
 <html>  
   <head>  
   </head>  
   <body>  
     <table border=1>  
       {% for key, value in hasil.items() %}  
       <tr>  
         <th>{{ key }}</th>  
         <td>{{ value }}</td>  
       </tr>  
       {% endfor %}  
     </table>  
   </body>  
 </html>

In the following source code, we have successfully displayed the results of the input data that was performed in the HTML form in JSON format. We will use the JSON data transfer format because we will be using a RESTful API.

Latihan 6

Dockerfile

 FROM python  
 USER 0  
 WORKDIR /home  
 RUN mkdir ./latihan6  
 RUN mkdir ./latihan6/templates  
 EXPOSE 3306 8543  
 RUN pip install flask  
 RUN pip install Jinja2  
 RUN pip install mariadb  
 COPY file1.py ./latihan6  
 COPY form1.html ./latihan6/templates  
 CMD ["python3", "./latihan6/file1.py"]

file1.py

 from flask import Flask, render_template, request, jsonify, json  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def formulirIsiData():  
   return render_template('form1.html')  
 @aplikasi.route('/tampilData',methods = ['POST'])  
 def tampilkanData():  
   if request.method == 'POST':  
     # tampilkanData = request.form  
     # nama = request.form['nama']  
     # return print (tampilkanData)  
     # di bawah ini adalah kode yang berhasil dijalankan  
     # mencetak langsung ke json yang bisa di baca oleh browser  
     # return jsonify(tampilkanData.to_dict())  
     return jsonify(nama=request.form['nama'])  
 if __name__ == '__main__':  
   aplikasi.run(host='0.0.0.0',port=8543, debug=True)

file1.html

 <!DOCTYPE html>  
 <html>  
   <head>  
   </head>  
   <body>  
     <form action="http://1.1.3.3:8543/tampilData" method="POST">  
       <p>Nama  : <input type="text" name="nama"/></p>  
       <p>Alamat : <input type="text" name="alamat"/></p>  
       <p><input type="submit" value="submit"></p>  
     </form>  
   </body>  
 </html>

Latihan 9

In this exercise, we successfully input data using Flask. Then, we take each data that was filled in the textbox and display it to the jinja2 template. All processes are done by clicking a button.

file1.py

 from jinja2 import Template  
 from flask import Flask,render_template,request,json,jsonify  
 aplikasi = Flask(__name__)  
 @aplikasi.route('/')  
 def formUtama():  
   return render_template("halaman1.html")  
 @aplikasi.route('/tampilData', methods = ['POST'])  
 def tampilkanData():  
     if request.method == 'POST':  
       text1 = request.form.get('text1')  
       text2 = request.form.get('text2')  
       return render_template("halaman2.html", tampilText1=text1, tampilText2=text2)  
 # source code nya ini sudah bagus untuk menerima inputan dari form  
 if __name__ == '__main__':  
   aplikasi.run(host='0.0.0.0',port=8543,debug=True)

halaman1.html

 <!DOCTYPE html>  
 <html>  
   <head>  
     <style>  
       input[type=text], select{  
         width: 100%;  
         padding: 12px 20px;  
         margin: 8px 0;  
         display: inline-block;  
         border: 1 px solid #ccc;  
         border-radius: 4px;  
         box-sizing: border-box;  
       }  
       input[type=submit]{  
         width: 100%;  
         background-color: #4CAF50;  
         color: white;  
         padding: 14px 20px;  
         margin: 8px 0;  
         border: none;  
         border-radius: 4px;  
         cursor: pointer;  
       }  
       input[type=submit]:hover {  
         background-color: #45a049  
       }  
       div {  
         border-radius: 5px;  
         background-color: #f2f2f2;  
         padding: 20px;  
       }  
     </style>  
   </head>  
   <body>  
     <h3>Formulir Data Printer</h3>  
     <div>  
       <form action="http://1.1.3.6:8543/tampilData" method="POST" id="formPrinter" name="formPrinter">  
         <label for="text1">Text 1</label>  
         <input type="text" id="text1" name="text1" placeholder="Isikan kata 1">  
         <input type="text" id="text2" name="text2" placeholder="Isikan kata 2">  
         <input type="submit" Value="submit">  
       </form>  
     </div>  
   </body>  
 </html>

halaman2.html

 <!DOCTYPE html>  
 <html>  
   <head>  
   </head>  
   <body>  
     <p>{{ tampilText1 }}</p>  
     <p>{{ tampilText2 }}</p>  
     <!--- source code nya ini sudah bagus untuk menampilkan hasil inputan dari form  -->  
   </body>  
 </html>