The most viewed items
Today, I set up and configure one router, one access point, one Epson printer (network), one Canon printer (network) and one finger print (network) for the office of Automotion Company.
TNW provides web development service and business email service for April Zaw Min Com., Ltd.
April Zaw Min Company Limited was organized and established since September 2017 and located at No.1214, Min Ye Kyaw Swar Road, North Dagon (Myothid), Yangon, Myanmar. April Zaw Min Company Limited has been registered at Ministry of Labour and has been recruiting under License No. 071/2019.
Amog Tech Co., Ltd makes next two years extension with TNW (Web Service & ICT Solutions) for their company Web Service and Business Email Service. I want to say "Thank You So Much" for their extension with TNW(Web Service & ICT Solutions).
I provide Web Development Service and Business Email Service for Core Choice Group Company Ltd. I want to say "Thank You" for their confidence in TNW (Web Service & ICT Solutions).
Core Choice Group Company Ltd is doing business about Recruitment, HR Consulting, Printing Service, Screen Printing Ink, Corporate Gift, Promotion Items and HR Outsourcing. Please click here to enter their website.
TNW is searching for those who have good talent and are willing to get new challenges and opportunities in Marketing Field.
Responsibilities
- You must use your own ability to get new customers for TNW (Web Service & ICT Solutions).
Requirements
- You must have good personality and attitude.
You must have knowledge about using internet and email.
- You must have marketing knowledge.
- You must have basic knowledge about Digital Marketing.
Benefits
- You will get up to 30% of the commission.
This step is a little bit more complex. In this step, we also check the User Id already exists or not. But, not too difficult. I hope you will be ok.
1. Create html form.
2. Connect to server.
3. Check form is filled or not.
4. Check the User Id already exists or not.
5. Insert data into table.
<?php
@$server = 'localhost';
@$username = 'root';
@$password = ' ';
@$db = 'TNW';
@$conn = mysqli_connect($server, $username, $password, $db);
if($conn){
if(isset($_POST['UserId']) && isset($_POST['FirstName']) && isset($_POST['LastName']) && isset($_POST['UserName'])&& isset($_POST['Password'])){
$userid = $_POST['UserId'];
$firstname = $_POST['FirstName'];
$lastname = $_POST['LastName'];
$username = $_POST['UserName'];
$password = $_POST['Password'];
//check form is filled or not
if(!empty($userid) && !empty($firstname) && !empty($lastname) && !empty($username) && !empty($password)){
//check userid already exists or not
$query = "SELECT `UserId` FROM `username` WHERE `UserId` = '".$userid."'";
$query_run = mysqli_query($conn, $query);
$row = mysqli_num_rows($query_run);
if($row == 1){
echo 'User Id already exists. Please choose another User Id.';
}else{
//insert data into table
$query = "INSERT INTO `username` VALUES('".$userid."', '".$firstname."', '".$lastname."',
'".$username."', '".$password."')";
$query_run = mysqli_query($conn, $query);
if($query_run){
echo 'Data is successfully inserted into table.';
}else{
echo 'Inserting Error!';
}
}
}else{
echo 'Please fill all fields.';
}
}
}else{
echo 'Error in Server connection!';
}
?>
<html>
<head>
<title>Inserting Data into table</title>
<style>
.tnwform{
padding: 20px;
}
</style>
</head>
<body>
<form action="inserting_data_into_tabel_3.php" method="POST" class="tnwform">
<label for="UserId">User Id</label>
<input type="text" name="UserId"><br /><br />
<label for="FirstName">First Name</label>
<input type="text" name="FirstName"><br /><br />
<label for="LastName">Last Name</label>
<input type="text" name="LastName"><br /><br />
<label for="UserName">User Name</label>
<input type="text" name="UserName"><br /><br />
<label for="Password">Password</label>
<input type="password" name="Password"><br /><br />
<input type="submit" value="Submit">
</form>
</body>
This step is a litter bit complex. But, not too difficult. I hope you will be ok.
1. Create html form.
2. Connect to server.
3. Check form is filled or not.
4. Insert data into table.
<?php
@$server = 'localhost';
@$username = 'root';
@$password = ' ';
@$db = 'TNW';
@$conn = mysqli_connect($server, $username, $password, $db);
if($conn){
if(isset($_POST['UserId']) && isset($_POST['FirstName']) && isset($_POST['LastName']) && isset($_POST['UserName']) && isset($_POST['Password'])){
$userid = $_POST['UserId'];
$firstname = $_POST['FirstName'];
$lastname = $_POST['LastName'];
$username = $_POST['UserName'];
$password = $_POST['Password'];
if(!empty($userid) && !empty($firstname) && !empty($lastname) && !empty($username) && !empty($password)){
$query = "INSERT INTO `username` VALUES('".$userid."', '".$firstname."', '".$lastname."',
'".$username."', '".$password."')";
$query_run = mysqli_query($conn, $query);
if($query_run){
echo 'Data is successfully inserted into table.';
}else{
echo 'Inserting Error!';
}
}else{
echo 'Please fill all fields.';
}
}
}else{
echo 'Error in Server connection!';
}
?>
<html>
<head>
<title>Inserting Data into table</title>
<style>
.tnwform{
padding: 20px;
}
</style>
</head>
<body>
<form action="inserting_data_into_tabel_2.php" method="POST" class="tnwform">
<label for="UserId">User Id</label>
<input type="text" name="UserId"><br /><br />
<label for="FirstName">First Name</label>
<input type="text" name="FirstName"><br /><br />
<label for="LastName">Last Name</label>
<input type="text" name="LastName"><br /><br />
<label for="UserName">User Name</label>
<input type="text" name="UserName"><br /><br />
<label for="Password">Password</label>
<input type="password" name="Password"><br /><br />
<input type="submit" value="Submit">
</form>
</body>
</html>
<?php
$server = 'localhost';
$username = 'root';
$password = ' ';
$db = 'TNW';
$conn = mysqli_connect($server, $username, $password, $db);
if($conn){
$query = "INSERT INTO `username` VALUES(1, 'Thet', 'Naing', 'thet', 'password1'),
(2, 'Michael', 'Win', 'win', 'password2'),
(3, 'Mya', 'Mya', 'myamya', 'password3')";
$query_run = mysqli_query($conn, $query);
if($query_run){
echo 'Successfully inserted data into table.';
}else{
echo 'Inserting error or Data already exits.';
}
}else{
echo 'Connecting to a database Error.';
}
?><?php
$server = 'localhost';
$username = 'root';
$password = '';
$db = 'TNW';
$conn = mysqli_connect($server, $username, $password, $db);
if($conn){
$query = "DROP TABLE `username`";
$query_run = mysqli_query($conn, $query);
if($query_run){
echo 'Successfully deleted a table.';
}else{
echo 'Deleting a table Error.';
}
}else{
echo 'Connecting to a database Error.';
}
?><?php
$server = 'localhost';
$username = 'root';
$password = '';
$db = 'TNW';
$conn = mysqli_connect($server, $username, $password, $db);
if($conn){
$query = "CREATE TABLE `username`(
UserId int(30) NOT NULL AUTO_INCREMENT PRIMARY KEY,
FirstName varchar(30) NOT NULL,
LastName varchar(30) NOT NULL,
UserName varchar(30) NOT NULL,
Password varchar(50) NOT NULL
)";
$query_run = mysqli_query($conn, $query);
if($query_run){
echo 'Successfully created a table.';
}else{
echo 'Creating a table Error.';
}
}else{
echo 'Connecting to a database Error.';
}
?><?php
$server = 'localhost';
$username = 'root';
$password = '';
$db = 'TNW';
$conn = mysqli_connect($server, $username, $password, $db);
if($conn){
echo 'Successfully connected to a database -' .$db. '.';
}else{
echo 'Connecting to a database Error.';
}
?>
<?php
$server = 'localhost';
$user = 'root';
$password = '';
$conn = mysqli_connect($server, $user, $password);
if($conn){
$query = "DROP DATABASE `TNW`";
$query_run = mysqli_query($conn, $query);
if($query_run){
echo 'Successfully deleted a Database.';
}else{
echo 'Deleting a database Error.';
}
}else{
echo 'Connection Error';
}
?>