The most viewed posts

Registry Reviver

How to clean up Windows Computer

About Desktop Icons in Windows Computer

Driver Booster

CCleaner

some (JavaScript Array Method)

Myanmar font and keyboard for Windows

Advanced System Care

How to sell IT materials in zilastar.com

Web Development Services

The most viewed items

Desktop Hard Disk

Dell Inspiron 5559

HP ProBook 430

SONY Playstation Portable

Laptop RAM

External Hard Disk

Laptop

ZilaStar ICT Oct 25 2019, 17:21:39

Web service extension for www.myathtutkhaung.com

Today, Myanmar Astrologer U Myat Htut Khaung makes his personnel website extension with TNW (Web Service & ICT Solutions) for another one year.


ZilaStar ICT Oct 21 2019, 21:24:00

Automotion Company Office Network

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.


ZilaStar ICT Jun 26 2019, 17:49:43

April Zaw Min Com., Ltd

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.


ZilaStar ICT Jun 26 2019, 16:27:17

Services extension for Amog Tech Com Ltd.

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).


ZilaStar ICT Jun 26 2019, 06:45:26

Core Choice Group Com Ltd.

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.


ZilaStar ICT Jun 26 2019, 06:40:47

Freelance Marketing Executive

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.

 


ZilaStar ICT Jun 25 2019, 19:35:29

Inserting data into table (eg.3)

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>


ZilaStar ICT Jun 24 2019, 18:00:27

Inserting data into table (eg.2)

 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>


ZilaStar ICT Jun 24 2019, 09:30:40

Inserting data into table (eg.1)

<?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.';
}
?>


ZilaStar ICT Jun 23 2019, 19:13:57

Deleting table in a database

<?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.';
}
?>


ZilaStar ICT Jun 22 2019, 19:05:36

Creating table in a database

<?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.';
}
?>


ZilaStar ICT Jun 21 2019, 19:51:07

Connecting to a database

<?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.';
}
?>


Page : 16 of 30
To Contact
Available Services
Terms and Conditions