contoh codingan membuat absensi web html

if(mysqli_query($conn, $sql)) condition checks whether the insert query executed on database or not.

mysqli_query() function performs a query against a database.

Then $uname, $password values insert to user table and query result will stored into variable $sql.

Insert query syntax is INSERT INTO table_name

When storing user inputs into database we need to execute insert query.

If isset() condition is yes means user input values stored to respective variables. if(isset($_POST)) condition is checks whether the submit value is set or not.Isset() for checking whether a variable is set or not. In $_POST is a global variable in php used for collect form data.Message on webpage by using die() method. If(!$conn) condition checks connection is not correct means it will display error Mysqli_connect() function used for create new connection and its stored into variable $conn.$servername, $username, $password, $database are variables for storing respective values. In php file $ symbol used for declare a variable before variable name and syntax is $variable_name.‘user_records’ on mysql server then create a table with two columns namely username, password. Before writing php file we need to create database with the name.Dbcon.php is a separate file contains database connection, query execution information.

When user filled input field and click on submit form action attribute loads the dbcon.php file.Within tag name attribute used for access in php file, placeholder attribute used for user can identify what type of input needs to enter. Using in three ways for getting username, password as text and submit. tag can display in several ways depends on the attribute type. tag specifies an input field where the user can enter data.In tag we used two attributes action and method, action attribute specifies where to send form data when form is submitted and method have two values GET,POST we are using POST method.Tag is beginning of main coding part because it contain coding of entire website blocks and elements described here. If your not closed anyone of ending tag properly that is also affect the webpage result. Both and tags having their pair end tag, so we need to close the ending tags respectively.As above shown tag is contain information about webpage and some websites when need to use external files those links are declared here.Tag is used to indicate the beginning of HTML document. tag which is instruct the web browser about what version of HTML file written in and it’s not have any ending tag.Connecting html form to database using php

Contoh codingan membuat absensi web html