Techlife95

how to upload image in php and store in database with live demo

2020-10-25T23:07:00.000+05:30

How to upload images to PHP and use MySQL

used language: HTML, CSS, and PHP for backend.

Total file: 2 is the first image upload file and the second is to get the image in the database.

Created folder: Here, first is main folder and second subfolder created.

When we upload, the first folder store 2 PHP files, and the second folder stores the image.

Here, an attempt is made to explain how to upload images to a database and retrieve it using PHP.

This is an easy way to upload and display pictures.

When you upload your image, it will store it in a folder.

First, we will create a database like contactdb.

After creating the table. We will create two files, the first file to store the uploaded image and the second PHP file.

upload image code in php

<!-- contact form-->

<?php
$conn=mysqli_connect("localhost","root","");
if(!$conn){
die('could not connect');
}
$db=mysqli_select_db($conn,"contactdb");

if(isset($_POST['submit'])){

$fname=$_POST['txtfname'];
$addr=$_POST['txtaddr'];
$email=$_POST['txtemail'];
$message=$_POST['txtmessage'];

$query="insert into contacttab(fullname,address,email,message)values('$fname','$addr','$email','$message')"or die('could not connect');
$result=mysqli_query($conn,$query);

}
?>
<style>
body{align-items:center;display:flex;justify-content:center;}

*{text-aling:center;box-sizing:border-box;}

form{font-family-sants-sarif;}
}

input,select,texarea
{
width:100px;padding:12px;height:30px;margin:10px;
box-sizing:border-box;margin-top:6px;margin-buttom:24px;
border:1px solid red;
}

input[type=submit]
{
background:red;width:210px;
color:white;
font-size:15px;
}

input,select,textarea,button{
font-family:inherit;
font-size:100%;}

.container{border-radius:5px;
background:blue;
padding:40px;color:white;
input[type=reset]{

</style>

<div class="container">
<h1>Contact Form</h1>
<form method="POST"action="contact.php">
<tr>
<td>Full Name</td><span style="color:red">*</span><br>
<td><input type="text"name="txtfname"placeholder="Full Name"required><br></td>
</tr>
<tr><td>
Address</td><span style="color:red">*</span><br>
<td><textarea name="txtaddr"cols="23"rows="2"placeholder="Your address"required></textarea><br>
</td></tr>
<tr><td>
Email</td><span style="color:red">*</span><br>
<td><input type="email"name="txtemail"placeholder="ex.text@gmal.com"required><br>
</td></tr>
<tr><td>
Message</td><span style="color:red">*</span><br>
<td><textarea name="txtmessage"cols="23"rows="2"placeholder="Message"required></textarea><br>
</td></tr><br>
<input type="submit"name="submit"value="submit"><br>
<input type="reset"class="reset"/>

</form>
</div>

Live Demo

Retrive image

After creating the uploaded file in PHP Now, we will create a retrieved image in the database file. Here, easily explain how to display images in a database.

See the code.

<?php
$conn=mysqli_connect("localhost","root","");
$db=mysqli_select_db($conn,"imgdb");

if(isset($_POST['upload'])){

$name=$_POST['txtname'];
$file_name=$_FILES['image']['name'];
$tmp_name=$_FILES['image']['tmp_name'];
$file_size=$_FILES['image']['size'];

$query="insert into imgtab(name,image)values('$name','$file_name')"or die('something worong');

$result=mysqli_query($conn,$query);

move_uploaded_file($tmp_name,"img/".$file_name);
}

?>

<form action="img.php"method="POST"enctype="multipart/form-data"/>
<label>Name</label>
<input type="text"name="txtname"><br>
<input type="file"name="image"><br>
<input type="submit"name="upload">
</form>

<!-- fetch image -->

<?php

$conn=mysqli_connect("localhost","root","");
$db=mysqli_select_db($conn,"imgdb");

$query="select *from imgtab";
$result=mysqli_query($conn,$query);

while($row=mysqli_fetch_array($result)){

echo $row['name'];
echo"<img src='img/".$row['image']."'width='50px'height='50px';>";

}

?>

Live Demo

Please feel free to contact or comment me if you need any further information.

How to create a contact form in PHP

2020-10-14T23:00:00.001+05:30

How to create a contact form in PHP

The contact form is a basic necessity for every website. The user can contact you if any help.

Today we’ll create a simple contact form using PHP MySQL.

We’ll create an entire form in HTML and CSS and for backend, we use PHP code.

We’ll create a database table.

In the table, we’ll create 5 fields like Id, First name, Email, address, mobile, and message.

We’ll create a PHP file.

Code for database

CREATE TABLE IF NOT EXISTS `contacttab` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `fullname` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `message` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

Now, after creating the table open any text editor whatever you like to use.

Here, used Notepad. You can use Notepad++, sublime text, and another text editor.

For creating the contact form used PHP Language for backend and HTML/CSS for design.

Code for PHP

Preview:

<!-- contact form in php -->

<?php

$conn=mysqli_connect("localhost","root","");


$db=mysqli_select_db($conn,"contactdb");

if(!$conn){


die('could not connect');}

if(isset($_POST['submit'])){

$fname=$_POST['txtname'];


$email=$_POST['txtemail'];


$address=$_POST['txtaddr'];


$mobile=$_POST['txtmobi'];


$message=$_POST['txtmessage'];

$query="insert into contacttab(fullname,address,email,mobile,message)values('$fname','$email','$address','$mobile','$message')";

$result=mysqli_query($conn,$query);
}
?>


<html>
<head>
<style>
body{align-items:center;
display:flex;
justify-content:center;
}

.container{color:white;padding:50px;


background-image:url(backimage2.jpg)}

input[type=submit]{background-color:red;width:400px;color:white;
height:30px;font-size:20px;}
input{width:400px;margin:0px;

height: 35px;
}

textarea{width:400px;height:70px;}

h1{text-align:center;font-size:50px;}
</style>
</head>
<body>

<div class="container">

<h1>Contact Form</h1>

<h4><span style="color:red">*</span>Required</h4>

<form method="POST"action="contact.php">

<tr>
<td>Full Name<span style="color:red">*</span></td><br>

<td><input type="text"name="txtname"placeholder="your Name"required></td><br>
</tr><br>

<tr>
<td>Email<span style="color:red">*</span></td><br>

<td><input type="email"name="txtemail"placeholder="Your Email"required</td><br>

</tr><br>


<tr>
<td>Address<span style="color:red">*</span></td><br>

<td><textarea name="txtaddr"cols="28"rows="3"placeholder="Address"required></textarea></td><br>

</tr><br>


<tr>
<td>Mobile<span style="color:red">*</span></td><br>

<td><input type="text"name="txtmobi"placeholder="Your mobile No."></td><br>
</tr><br>

<tr>
<td>Message<span style="color:red">*</span></td><br>

<td><textarea name="txtmessage"cols="48"rows="3"placeholder="Type Your Message here..."required></textarea></td><br>
</tr><br>

<tr>
<td></td>
<td><input type="submit"name="submit"value="submit"></td><br>
</tr><br>
</form>
</div>

</body>
<html>

In the above code, we used the post method.

When user click on the submit button then all form data will be stored in the database.

PHP's script helps you to store user data in the database.

Also, we’ll validate all fields required for submission.

Demo

simple PDO crud operation in php

2020-09-21T22:47:00.000+05:30

In this tutorial, we will learn PHP CRUD(create, read, update, delete.) operation using PDO extension.

We will learn the Simple CRUD operation with a live demo.

step-1

First, create a database like ‘pdodb.’
After a created database, then after making a table like pdotable.
In the table add value like name, email and password.
Structure for a table

CREATE TABLE IF NOT EXISTS `pdotable` (
`id` int(50) NOT NULL AUTO_INCREMENT,
`name` varchar(110) NOT NULL,
`email` varchar(110) NOT NULL,
`password` varchar(110) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

Step-2

Create a database connection file to connect the database.

Config.php

<?php
define('db_host','localhost');
define('db_user','root');
define('db_data','pdodb');
define('db_pass','');

try{
$conn=new PDO('mysql:host='.db_host.';dbname='.db_data,db_user,db_pass);
}
catch(PDOException $e){
exit('error'.$e->getMessage());
}
?>

Step-3
Now, we will insert Record into the database. So we will need to create a file insert.php file.

Insert.php

PDO Code for inserting data into database

<?php
include'config.php';

if(isset($_POST['submit'])){

$name=$_POST['txtname'];
$email=$_POST['txtemail'];
$password=$_POST['txtpass'];

if(empty($name) || empty($email) || empty($password)){

if(empty($name)){
echo"<span style='color:red'>Name is empty</span><br>";
}

if(empty($email)){
echo "<span style='color:red'>Email is empty</span><br>";
}

if(empty($password)){
echo "<span style='color:red'>Password is empty</span><br>";
}

}else{
$q="insert into pdotable(name,email,password)values(:n,:e,:p)";
$query=$conn->prepare($q);
$query->bindParam(':n',$name,PDO::PARAM_STR);
$query->bindParam(':e',$email,PDO::PARAM_STR);
$query->bindParam(':p',$password,PDO::PARAM_STR);
$query->execute();
}
}
echo"<a href='select.php'>Display data</a>";
?>

<form action=""method="POST">
Name:<br>
<input type="text"name="txtname"><br>

Email:<br>
<input type="email"name="txtemail"><br>

Password:<br>
<input type="password"name="txtpass"><br>

<input type="submit"name="submit"value="insert"><br>
</form>

Live demo

Step-4
In this step, we will fetch data from the database and display it on a page.
We will fetch all records whatever you insert into the database.

Select.php

<table border='0' cellspacing='10px' cellpadding='10px'>
<thead>
<th>Name</th>
<th>Email</th>
<th>Password</th>
<th>action</th>
</thead>
<tbody>
<?php
include'config.php';
$q="select *from pdotable";
$query=$conn->prepare($q);
$query->execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);
if($query->rowCount()>0){
foreach($results as $result){
?>

<tr>
<td><?php echo htmlentities($result->name);?></td>
<td><?php echo htmlentities($result->email);?></td>
<td><?php echo htmlentities($result->password);?></td>
<td><a href="edit.php?id=<?php echo htmlentities($result->id);?>">edit</a>|
<td><a href="delete.php?id=<?php echo htmlentities($result->id);?>">delete</a></td>
</tr>
<?php
}
}
echo"<a href='insert.php'>New record insert</a>";
?>
</tbody>
</table>

Live demo

Step-5
Now, we will edit data from the database.
We will fetch all records and edit then change into the database.
In this, first, we select data from a database and create an edit file the same page.
We will edit data by id wise.

edit.php

PDO Code for editing data into database

<?php 
include'config.php';

if(isset($_POST['edit'])){

$id=$_GET['id'];
$name=$_POST['txtname'];
$email=$_POST['txtemail'];
$password=$_POST['txtpass'];

if(empty($name) || empty($email) || empty($password)){

if(empty($name)){
echo"<span style='color:red'>Name is empty</span><br>";
}

if(empty($email)){
echo "<span style='color:red'>Email is empty</span><br>";
}

if(empty($password)){
echo "<span style='color:red'>Password is empty</span><br>";
}
}else{
$q="update pdotable set name=:n,email=:e,password=:p where id=:id";
$query=$conn->prepare($q);
$query->bindParam(':n',$name,PDO::PARAM_STR);
$query->bindParam(':e',$email,PDO::PARAM_STR);
$query->bindParam(':p',$password,PDO::PARAM_STR);
$query->bindParam('id',$id,PDO::PARAM_STR);

$query->execute();

echo"<script>alert('record update sucessfuly')</script>";
echo"<script>window.location.href='select.php'</script>";
}
}
?>

<?php 
$id=$_GET['id'];
$q="select *from pdotable where id=:id";
$query=$conn->prepare($q);
$query->bindParam(':id',$id,PDO::PARAM_STR);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
if($query->rowCount()>0){
foreach($results as $result){
?>

<form action=""method="POST">
<td>Name</td>
<td><input type="text"name="txtname"value="<?php echo htmlentities($result->name);?>"></td><br>

<td>Email</td>
<input type="email"name="txtemail"value="<?php echo htmlentities($result->email);?>"></td><br>

<td>Password</td>
<input type="password"name="txtpass"value="<?php echo htmlentities($result->password);?>"></td><br>

<?php
}
}
?>
<td><input type="submit"name="edit"value="update"></td>
</form>

Live demo

Step-6
After edit the data same page we create a delete link.
When users click on the delete option then the record has deleted.
We will create a deleted page to delete records and without a redirect, we will include the header function to redirect the same page without going to the delete a page.
The following code shows the delete.php file.

Delete.php

PDO Code for deleting data into database

<?php 
include'config.php';

if(isset($_POST['edit'])){

$id=$_GET['id'];
$name=$_POST['txtname'];
$email=$_POST['txtemail'];
$password=$_POST['txtpass'];

if(empty($name) || empty($email) || empty($password)){

if(empty($name)){
echo"<span style='color:red'>Name is empty</span><br>";
}

if(empty($email)){
echo "<span style='color:red'>Email is empty</span><br>";
}

if(empty($password)){
echo "<span style='color:red'>Password is empty</span><br>";
}
}else{
$q="update pdotable set name=:n,email=:e,password=:p where id=:id";
$query=$conn->prepare($q);
$query->bindParam(':n',$name,PDO::PARAM_STR);
$query->bindParam(':e',$email,PDO::PARAM_STR);
$query->bindParam(':p',$password,PDO::PARAM_STR);
$query->bindParam('id',$id,PDO::PARAM_STR);

$query->execute();

echo"<script>alert('record update sucessfuly')</script>";
echo"<script>window.location.href='select.php'</script>";
}
}
?>

<?php 
$id=$_GET['id'];
$q="select *from pdotable where id=:id";
$query=$conn->prepare($q);
$query->bindParam(':id',$id,PDO::PARAM_STR);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
if($query->rowCount()>0){
foreach($results as $result){
?>

<form action=""method="POST">
<td>Name</td>
<td><input type="text"name="txtname"value="<?php echo htmlentities($result->name);?>"></td><br>

<td>Email</td>
<input type="email"name="txtemail"value="<?php echo htmlentities($result->email);?>"></td><br>

<td>Password</td>
<input type="password"name="txtpass"value="<?php echo htmlentities($result->password);?>"></td><br>

<?php
}
}
?>
<td><input type="submit"name="edit"value="update"></td>
</form>

Live demo

How to creating a registration and login form in PHP MYSQL database

2020-09-16T00:50:00.000+05:30

First, we are creating a user account.
we will need to collect a minimal amount of information from the user.
We will collect the full name, email address and password of the user.

We will use the PHP MYSQL database.

First, we will create a database in PHP MySQL database
we will create a database regidb.Table structure for table `regitab`

CREATE TABLE IF NOT EXISTS `regitab` (

  `u_id` int(8) NOT NULL AUTO_INCREMENT,

  `u_fullname` varchar(50) NOT NULL,

  `u_email` varchar(50) NOT NULL,

  `u_password` varchar(50) NOT NULL,

  PRIMARY KEY (`u_id`)


) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

Dumping data for table `regitab`

INSERT INTO `regitab` (`u_id`, `u_fullname`, `u_email`, `u_password`) VALUES


(1, 'robort', 'text123@gamil.com', '25d55ad283aa400af464c76d713c07ad');

PHP Scripts connect to MYSQL database.

config.php

<?php 

$server='localhost';


$user='root';

$dbname='regidb';

$pass='';

$conn=mysqli_connect($server,$user,$pass,$dbname);

if(!$conn)

die('could not connect');

?>

First, we will create an index.php page.

An index page, we will create hyperlink Login and Sign Up.

Index.php

<html>


<head>

<style>

body{background-image:url(img/background.png);background-repeat:no-repeat;background-position:center;background-size:cover;background-color:black;}

a{float:right;margin:10px;text-decoration:none;}

h1{background-color:red;text-align:center;}

</style>

<body>

<a href="login.php">| Login</a>

<a href="regi.php">Sign Up | </a>

<h1> Learn PHP free</h1>

</body>

</html>

Note: Replace image

If User Not registor then user redirect registarion.

In registration we will store user's full name, Email address and password in database.

regi.php

<?php


error_reporting(0);

include'config.php';

$fnameE=$emailE=$passE="";

session_start();

if($_SERVER['REQUEST_METHOD']=='POST'){

$fname=$_POST['txtfname'];

$email=$_POST['txtemail'];

$pass=md5($_POST['txtpass']);


if(empty($fname) || empty($email) || empty($pass)){

if(empty($fname)){

$fnameE="Name is required";

if(empty($email)){

$emailE="Email is required";

}

if(empty($pass)){

$passE="Password is required";

}else{

$query="insert into regitab(u_fullname,u_email,u_password)values('$fname','$email','$pass')"or die('could not connect');

$result=mysqli_query($conn,$query);

header('location:login.php');

?>


<html>

<head><title>Registartion form</title>

<style>

body{align-items:center;justify-content:center;display:flex;}

.container{background-image:url(img/container.jpg);background-position:center;background-size:contain;padding:20px;}

img{margin-left:auto;margin-right:auto;display:block;

height:150px;

width:150px;

border-radius:50%;
}

input{height:30px;width:250px;}

input[type=submit]{

background-color:blue;color:white;}

</style>

</head>

<body>

<div class="container">

<h1>Registration Form</h1>

<img src="img/avatarl.png">

<h4>Required field<span style="color:red">*</span></h4>

<form method="POST" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']);?>">

<b>Full Name</b><span style="color:red">*<?php echo $fnameE;?></span><br>

<input type="text"name="txtfname"><br>

<p>

<b>Email Address</b><span style="color:red">*<?php echo $emailE;?></span><br>

<input type="email"name="txtemail"><br>

<p>

<b>Password</b><span style="color:red">*<?php echo $passE;?></span><br>

<input type="password"name="txtpass"><br>

<p>

<input type="submit" name="submit"value="Sign Up"><br>

Already registered <a href="login.php">Sign in </a>

</form>

</div>

</body>

</html>

Note: Replace image

If the User already Registred then the user direct login.
login.php

<?php


include'config.php';

$emailE=$passE="";

session_start();

if($_SERVER['REQUEST_METHOD']=='POST'){

$email=$_POST['txtemail'];

$pass=md5($_POST['txtpass']);

if(empty($email) || empty($pass)){

if(empty($email))

$emailE="Email is Required";

if(empty($pass)){

$passE="Password is Required";

}else{

$query="select *from regitab where u_email='$email' and u_password='$pass'";

$result=mysqli_query($conn,$query);

$row=mysqli_fetch_array($result);

if($row>0){

$_SESSION['u_email']='$email';

echo"<script>alert('login successfully');</script>";

echo"<script>window.location.href='home.php'</script>";

}else{

echo"<script>alert('something wrong try again');</script>";

?>

<html>

<head><title>login form</title>

<style>

body{align-items:center;justify-content:center;display:flex;}

.container{background-image:url(img/container.jpg);background-position:center;background-size:contain;padding:20px;border:1px solid;}

img{margin-left:auto;margin-right:auto;display:block;

height:150px;

width:150px;

border-radius:50%;

border:1px solid;

}

input{height:30px;width:250px;}

input[type=submit]{

background-color:blue;color:white;}

h1{text-align:center;}

</style>

</head>
<body>

<div class="container">

<h1>Login form</h1>

<img src="img/avatarr.png">

<form method="POST" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']);?>">

<b>Email address</b><span style="color:red"><?php echo $emailE;?></span><br>

<input type="email"name="txtemail"><br>
<p>

<b>Password</b><span style="color:red"><?php echo $passE;?></span><br>

<input type="password" name="txtpass"><br>

<p>

<input type="submit"name="submit"value="Login"><br>

Not register <a href="regi.php">Sign up</a>

</form>

</div>

</html>

Note: Replace image

After successful login user redirects home page.

home.php

<?php

session_start();

if(!isset($_SESSION['u_email'])){

header('location:index.php');

session_destroy();

?>


<html>

<head><title>Home</title>

<style>

body{background:maroon;margin:0; padding:0}

h1{text-align:center;display:flex;justify-content:center;align-items:center;}

</style>

</head>

<body>

<a href="index.php">Logout</a>

<h1>Welcome to PHP video cource</h1>

</body>

</html>

Live Demo

Registration form

Live Demo

User Login Form

Creating a simple user login system with PHP and MySQL database

2020-07-19T00:18:00.000+05:30

Creating a simple user login system with PHP and MySQL database

Every website has a login and registration page. This is simple and user friendly and beginner registration and login form.
We will simple starting point registration functionality using PHP MySQL database.

In this tutorial we will create a simple user login and registration system using PHP MySQL database. In this tutorial we create five PHP files.

Database name:-slogin
Database table name:- user

we will create following PHP file.
config.php
index.php
registration.PHP
home.php

style.css

First, we will create a database file in MySQL database.

You perform following SQL query to perform user table inside your MySQL database.

slogin.sql database table

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(110) NOT NULL,
  `email` varchar(110) NOT NULL,
  `password` varchar(110) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

User registration inserted values in a table example

1 2	INSERT INTO `user` (`id`, `name`, `email`, `password`) VALUES (1, 'admin', 'test@123gmail.com', '21232f297a57a5a743894a0e4a801fc3');

config.php

<?php

$server='localhost';
$dbname='slogin';
$user='root';
$pass='';

$conn=mysqli_connect($server,$user,$pass,$dbname);
if(!$conn){
die('dababase could not connect'.mysqli_error());
}
$result=mysqli_select_db($conn,$dbname);
?>

Create config file to connect database in PHP MYSQL.

After creating database connections, we need to create a PHP index page that user first open index page. In index page we will create two button login and registration using CSS and HTML.
If the user already registered then, he would click on the sign in a button and new user click on the registration form.
We will create a session to store user name in session.
Create following index file code.

index.php

<html>

<head>
<style>
body{background:lightblue}
.div a{color:white;font_size:44px}
 a{font-size:25px;float:right;padding:10px;text-decoration:none;}
</style>
</head>

<body>
<div class="div">
<div><a href="login.php">sign in</a></div>
<div><a href="regitration.php">sing up</a></div>
</div>
</body>
</html>

Then after we create registration page. We will get user information and store in MySQL database.

In registration form we create simple information filled that users register and then after login.

We will store user text box values like username, email id and password.

We create, validate a password you fill minimum and maximum limit values in password fill.

If the user enters less than four characters, then error generated and a user enter password above eight Then errors generated. If user registration without entering value, then error generated.

If user already registration then we will create on link though user clicking click and direct jump to login page.

Also, we will use to password encryption php function.

registration.php

<?php
include'config.php';
if(isset($_POST['save']))
{
 
 $name=$_POST['name'];
 $email=$_POST['email'];
 $password=md5($_POST['password']);
 
 $query="insert into user(name,email,password)values('$name','$email','$password')"or die('could not connect');
 $result=mysqli_query($conn,$query);
header('location:login.php');
}


?>


<html>
<head>
<link rel="stylesheet"type="text/css"href="style.css">

</head>
<body>

<form action="regitration.php"method="POS>
<h2>Registration</h2>

<tr>
<td>Name</td><br>
<td><input type="text"name="name"placeholder="Your Name"required><br></td>
</tr>

<tr>
<td>Email</td><br>
<td><input type="email"name="email"placeholder="Your Email id"required><br></td>
</tr>

<tr>
<td>Password</td><br>
<td><input type="password"name="password"placeholder="Your Password"minlength="4"maxlength="8"required><br></td>
</tr>

<tr>
<td></td><br>
<td><input type="submit"name="save"value="Register"></td>
</tr>
already account <a href="login.php">sign in</a>
</form>

</body>

</html>

Then after we create a simple login, form where users can enter their username and password. If a username and password do not, on the database, then the error message. If username true and password wrong, even if generate error and login fail. If New user then we will create a registration link to direct user clicking and go to registration form. Let's create a login file and place following PHP code.

<?php
session_start();
include'config.php';
if(isset($_POST['login']))
{
$name=$_POST['name'];
$password=md5($_POST['password']);

$query="select * from user where name='$name' and password='$password'";
$result=mysqli_query($conn,$query);
$data=mysqli_fetch_row($result);
if($data>0){
 $_SESSION['name']=$name;
header('location:home.php');
}else{
echo"<script>alert('try again')</script>";
}
}
?>
<html>
<head>
<link rel="stylesheet"type="text/css"href="style.css">
</head>
<form action="login.php"method="post">
<h2>Login</h2>

<tr>
<td>Name:-</td><br>
<td><input type="text"name="name"placeholder="Your Name"required><br></td>
</tr>

<td>Password</div><br>
<td><input type="password"name="password"placeholder="Your Password"maxlength="8"minlength="4"required><br></td>
</tr>

<td></td><br>
<td><input type="submit"name="login"value="login"></td>
</tr>
No account <a href="regitration.php">Regitration</a>
</form>

</body>
</html>

Then after We will create a home page. Login user redirects home page.

On the home page we will create logout button.

On Home page we will create the session destroy function even if user click on logout button user redirect an index.PHP page.

home.php

<?php
session_start();
if(!isset($_SESSION['name'])){
header('location:index.php');
}
session_destroy();

?>

<html>
<head>
<style>
body{background:#999;display:flex;align-items:center;justify-content:center;}
 a {color:white;top:40px;
    align-self: end;
    margin-left: 950px;
    text-decoration: none;font-size:20px;}
</style>
<body>
<ol>
<li>free cource</li>
<li>free cource download</li>
<li>free video download</li>
<li>free ebook download</li>
</ol>
<a href="home.php">Logout</a>


</body>
</html>

In the last we create a simple css file to some simple registration form and login form designing.

style.css

body{align-items:center;display:flex;justify-content:center;background:#999;}
form{width:250px;border:solid white;padding:30px;background:lightblue;}
*{font-family:sants-serif;box-sizing:border-box;}
a{text-decoration:none;}

If you have any questions, you can ask me by contacting or commenting.

Chrome keyword shortcut window and linux Community question

2020-07-06T23:47:00.001+05:30

Hello friend, today we are discussing about google chrome shortcut key.
Do you know this shortcut key?

The Google chrome shortcut key is very fast work.

You can save your time by using the google chrome shortcut key.

This shortcut key you can use both window and Linux operation system.

Hear all google chrome related shortcut key community question that asks every person who don't know about that shortcut key

Chrome keyword shortcut window and Linux Community question

What is the shortcut key for opening new tab in google chrome ?
How do I make google open in a new tab ?

What is the shortcut key for opening google chrome Incognito mode in new tab ?
Press Ctrl + Shift + n key

How do I opening new google chrome new tab same page ?
Press Ctrl + t key

How do I Reopening previously closed tabs in the order they were closed in google chrome ?
Press Ctrl + Shift + t key

What is shortcut of Jumping to the next open tab in chrome ?
Press Ctrl + Tab key or
Press Alt + page up-Page Down key

How do I Jumping to a specific tab in google chrome ?
Press Ctrl +1 to 9 key

What is shortcut key of Opening your home page in the current tab ?
Press Alt + Home key

How do I see the previous page from your browsing history in the current tab in chrome ?
Press Alt + Left arrow key

How do I see the next page from your browsing history in the current tab in chrome ?
Press Alt + Right arrow key

What is the shortcut key for Closing the current tab in google chrome ?
Press Ctrl + w key or Press Ctrl + F4 key

What is the shortcut key for Closing the current window in google chrome ?
Press Ctrl + Shift + w Key or Press Alt + F4 key

How do I Minimizing the current chrome window ?
Press Alt + Space then n key

What is the shortcut key for Maximizing the current chrome window ?
Press Alt + Space then x key

What is the shortcut key for Quit Google Chrome ?
Press Alt + f then click on x key

What is the shortcut key for Opening the Chrome menu ?
Press Alt + f key or Press Alt + e key

What is the shortcut key for hidding or showing the Bookmarks bar in google chrome ?
Press Ctrl + Shift + b key

Chrome keyword shortcut window and Linux Community question

What is the shortcut key for Opening the Bookmarks Manager in chrome ?
Press Ctrl + Shift + o key

What is the shortcut key for Opening the History page in a google chrome ?
Press Ctrl + h key

How do I Opening the Downloads page in a new tab in google chrome?
Press Ctrl + j key

What is the shortcut key for Opening the Chrome Task Manager ?
Press Shift + Esc key

What is the shortcut key for Seting focus on the first item in the Chrome toolbar ?
Press Shift + Alt + t key

What is the shortcut key for Seting focus on the rightmost item in the Chrome toolbar ?
Click F10 key

What is the shortcut key for Switching focus to unfocused dialog (if showing) and all toolbars ?
Click F6 key

What is the shortcut key for Opening the Find Bar to search the current page in google chrome ?
Press Ctrl + f key or click F3 key

What is the shortcut key for Jumping to the next match to your Find Bar search in google chrome ?
Press Ctrl + g key

What is the shortcut key for Jumping to the previous match to your Find Bar search in google Chrome ?
Press Ctrl + Shift + g key

What is the shortcut key for Opening Developer Tools in google chrome ?
Press Ctrl + Shift + j key

What is the shortcut key for google chrome full screen ?
Click F12 key

What is the shortcut key for google chrome exit full screen ?
Click F12 key

How do I Open the Clear Browsing Data options in a new tab ?
Press Ctrl + Shift + Delete Key

What is the shortcut key for Opening the Chrome Help Center in a new tab ?
Click F1 key

What is the shortcut key for Log in a different user or browse as a Guest in chrome ?
Press Ctrl + Shift + m key

Chrome keyword shortcut window and Linux Community question

What is the shortcut key for Opening a inspect in google chrome ?
Press Alt + Shift + i key

How do I Jump to the address bar in chrome ?
Press Alt + d key or click F6 key

How do I opening Search from anywhere on the page ?
Press Ctrl + k Key or Press Ctrl + e key

What is the shortcut key for refresh google chrome ?
Press Ctrl + F5 key

How do I printing the current page in chrome ?
Press Ctrl + p key

What is the shortcut key for save the current page in chrome ?
Press Ctrl + s key

What is the shortcut key for Reloading the current page ?
Click the F5 key or Press Ctrl + r key

What is the shortcut key for Reloading the current page, ignoring cached content in chrome ?
Press Shift + F5 key or Press Ctrl + Shift + r key

How do I Stoping the page loading in chrome ?
Click Esc key

What is the shortcut key for Browse clickable items moving forward in chrome ?
Click Tab key

What is the shortcut key for Browse clickable items moving backward ?
Press Shift + Tab key

How do I Opening a file from your computer in Chrome ?
Press Ctrl + o key

How do I Display non-editable HTML source code for the current page ?
Press Ctrl + u key

What is the shortcut key for Save current webpage as a bookmark in chrome ?
Press Ctrl + d key

What is the shortcut key for Save all open tabs as bookmarks in a new folder ?
Press Ctrl + Shift + d key

Chrome keyword shortcut window and Linux Community question

What is the shortcut key for zoom in chrome webpage ?
Press Ctrl and + key

What is the shortcut key for zoom out chrome webpage
Press Ctrl and - key

What is the shortcut key for Return everything on the page to default size (no zoom in, no zoom out)?Press Ctrl + 0 key

How do I Scroll up-down a webpage, a screen at a time ?
Press Space,Space+shift key or Press Page up-down key

How to Go to the top of the page in chrome ?
Clicking Home key

How to Go to the bottom of the page in chrome ?
Press End key on keybord

What is the shortcut key for Scrolling horizontally on the page ?
Shift + Scroll your mousewheel

What is the shortcut key for Delete the previous word in a text field ?
Press Ctrl + Backspace key

how to customize scrollbar in blogger ?

2020-07-03T22:57:00.002+05:30

How to scrollbar customize in blogger.

There are very easy to customize your scroll bar in blogger
Follow the step
Step: -1
Sing in your blogger

Step: -2
Click on Theme

Step: -3
You see edit html button, just click the button

Step: -4
Click on code area and press ctrl+f key on your keyboard
And show box in box, type ]]></b:skin> and hit enter.

Step: 5
Just above past this code like
Code past here ]]></b:skin>

Cpy and past this code

::-webkit-scrollbar{width:20px;}
::-webkit-scrollbar-track{background:blue;border-radius:50px;}
::-webkit-scrollbar-thumb{background: red;border-radius:30px;   
box-shadow: 0 0 0px 6px white;
border:3px solid;}





If this code doesn't work, then keep body before webkit like

body::-webkit-scrollbar{width:20px;}
body::-webkit-scrollbar-track{background:blue;border-radius:50px;}
body::-webkit-scrollbar-thumb{background: red;border-radius:30px;   
box-shadow: 0 0 0px 6px white;
border:3px solid;}

For more cusmization yourself as you like. Change width Change background track color Change thumb background-color Change border radius Change box-shadow Change border or without border

For more information

simple crud(Create,Read,Update,Delete) operation in PHP MySQL

2020-06-30T23:13:00.002+05:30

How perform crud operation.

First understand what is crud operation.

Crud operation or crud Application in php is creating, Reading, Updating and deleting simple operation in php mysql database.

Here you easily understand because all PHP crud operation step by step explained.

Step:-1
Start your xampp server and Open any browser.

Step:-2
In url bar type http://localhost/phpmyadmin/ and create database crudp.

Step:- 3
After create table crud and insert data.

Step:- 4
Open your any text editor like notepad, notepade++, etc.

Create file config.php

Step:-5
Save files in C:\xampp\htdocs/your folder

Step-6
Thus, make index.phpfor insert data.

Make select.php file for fetch data into MySQL database.

Make update.php file for Update data into MySQL database.

And last make delete.php file to delete data

Create Database crudp

CREATE TABLE IF NOT EXISTS `crud` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(110) NOT NULL,
  `email` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Database Connection File config.php

<?php
$host='localhost';
$user='root';
$pass='';
$data='crudp';

$conn=mysqli_connect($host,$user,$pass,$data);

if(!$conn)
{
die(mysqli_error());
}

?>

Main Form file index.php


<?php
include'config.php';
if(isset($_POST['insert']))
{
$name=$_POST['name'];
$email=$_POST['email'];

$query=mysqli_query($conn,"insert into crud(name,email)values('$name','$email')");

}
?>

<html>
<head><title>crud operaration</title>
</head>
<body>
<form action="index.php"method="post">
Name:-<input type="text"name="name"placeholder="Your Name"required><br>
Email:-<input type="email"name="email"placeholder="Your Email"required><br>
<p>&emsp;&emsp;&emsp;<input type="submit"name="insert"value="INSERT">
</form>
<a href='select.php'>Display</a>
</body>
</html>

Fetch Data in Mysql Database select.php

<?php
include'config.php';

$query=mysqli_query($conn,"select *from crud order by id desc");

echo"<table border='1';><tr>
<th>ID</th>
<th>NAME</th>
<th>EMAIL</th>
<th>Edit</th>
<th>Delete</th></tr>";

while($row=mysqli_fetch_array($query))
{ 
echo"<tr>";
echo"<td>".$row['id']."</td>";
echo"<td>".$row['name']."</td>";
echo"<td>".$row['email']."</td>";
echo"<td><a href='update.php?id=$row[id]'>Edit</a></td>";
echo"<td><a href='delete.php?id=$row[id]'>Delete</a></td>";
echo"</tr>";
}
echo"</table><p>";
echo"<a href='index.php'>New Record Insert</a>";
?>

Update Data using update.php

<?php
include'config.php';
if(isset($_POST['update']))
{
 
 $id=$_POST['id'];
 $name=$_POST['name'];
 $email=$_POST['email'];
$result=mysqli_query($conn,"update crud set name='$name',email='$email'where id=$id");
header('location:select.php');
}

?>

<?php
$id=$_GET['id'];

$query=mysqli_query($conn,"select *from crud");
while($row=mysqli_fetch_array($query))
{
 $name=$row['name'];
 $email=$row['email'];
}

?>

<html>
<head><title>untitle</title></head>
<body>
<form action="update.php"method="post">
Name:-<input type="text"name="name"placeholder="Update Name"value="<?php echo $name;?>"required><br>
Email:-<input type="email"name="email"placeholder="Update Email"value="<?php echo $email;?>"required><br>
<input type="hidden"name="id"value="<?php echo $_GET['id'];?>"><br>
&emsp;&emsp;&emsp;<input type="submit"name="update"value="Update">
</body>
</html>

Delete The Date delete.php

<?php
include'config.php';
$id=$_GET['id'];
mysqli_query($conn,"delete from crud where id=$id");
header('location:select.php');
?>

How to make comment box in php mysql?

2020-06-28T22:06:00.001+05:30

How to make comment box in php mysql?

How to create designs commentbox in PHP with mysql database.

Database name:-combox
Database table name:-comt
image folder name:-img

Main.php: - In this file user create forms where user filling there information in the text field and create a record.

Comment.php: - when user filling all needed information and finally user click on the button, then users can read records from the database. Filling all data stores in the database.

View.php: - Help of this file very useful because in this file user view their data one or single record from the database. Display the data retrieved from the MySQL database.

Delete.php: - This file is used for deleting a record. It accepts an id parameter and deletes the record with it. Once it executes the delete query it will redirect the user to the comment.php

button.css :- This file is used to design button

Database

CREATE TABLE IF NOT EXISTS `comt` ( `id` int(8) NOT NULL AUTO_INCREMENT, `name` varchar(110) NOT NULL, `comment` text NOT NULL, `img` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

main.php

<!DOCTYPE html> <html> <head><title>comment with profile</title> <link rel="stylesheet" type="text/css" href="button.css"> <style type="text/css"> input:focus::-webkit-input-placeholder{opacity:0;} textarea:focus::-webkit-input-placeholder{opacity:0;} .button{border:none;background:blue;color:white;font-size:25px; cursor: pointer;} .chf{color:maroon;font-size:20px; text-align: center;border: ridge; width: fit-content; background-color: #55e8ca; box-shadow: 9px 6px 13px 0px #0000007d; } </style> </head> <body> <a href="view.php"class="bth">View or Delete</a><p> <form method="POST"action="comment.php"enctype="multipart/form-data"> <div class="chf"> <tr> <td> Name:-&emsp;&ensp;<input type="text" name="name"placeholder="Your Name"required><p> </td> </tr> <tr> <td> Comment:-<textarea name="comment"placeholder="Write your comment"required></textarea><br><br> </td> </tr> <tr> <td> &emsp;&emsp;&emsp;&emsp; Profile:-&emsp;<input type="file" name="file"value='upload'required/><p> </td> </tr> <tr><td><br> &emsp;&ensp;&emsp;&ensp;&emsp;&ensp; <button class="button" name="upload"title="upload your profile">upload<div></button> </td> </tr> </div> </form> </body> </html>

comment.php

<?php //require'view.php'; if(isset($_POST['upload'])) { $conn=mysql_connect("localhost","root","","combox"); if(!$conn) { die('could not connect'.mysql_error()); } mysql_select_db("combox"); $name=$_POST['name']; $file_name=$_FILES['file']['name']; $tmp_name=$_FILES['file']['tmp_name']; $comment=$_POST['comment']; echo'<hr>'; mysql_query("insert into comt(name,comment,img)values('$name','$comment','$file_name')")or die(mysql_error()); move_uploaded_file($tmp_name,"img/".$file_name); mysql_close($conn); //header('location:comment.php'); } ?> <!DOCTYPE html> <html> <head> <style>body{background:#0202025e;}</style> <link rel="stylesheet" type="text/css" href="button.css"> </head> <body> <a href='view.php'class="bth">View Or Delete</a><p> <script>alert('successfully uploaded')</script> </body> </html>

view.php

<!DOCTYPE html> <html> <head> <link rel="stylesheet" type="text/css" href="button.css"> <style type="text/css"> a{text-decoration:none;border: none;color: #ad2525; font-size: larger;} img{border-radius:50%;} </style> </head> <body> <a href='main.php'class="bth">Back To Home</a><p> <div style='background:#83d6d4;width: fit-content;box-shadow: 9px 6px 13px 0px #0000007d;'> </body> </html> <?php //include'comment.php'; $conn=mysql_connect("localhost","root","","combox"); if(!$conn) { die(mysql_error()); } mysql_select_db("combox"); $result=mysql_query("select *from comt"); echo"<table border='1'width='auto'><tr> <th>Id</ih> <th>Profile</th> <th>Name</td> <th>Comment</td> <th>Delete</th> <tr>"; while ($row=mysql_fetch_array($result)) { echo"<tr>"; echo "<td>".$row['id']."</td>";# code... echo"<td><img src='img/".$row['img']."'width='70px'height='50px'></td>"; echo "<td>".$row['name']."</td>"; echo "<td>".$row['comment']."</td>"; echo"<td><button><a href='delete.php?id=$row[id]'>Delete</button></a>"; //echo "<td><img src='img/'width='50px';></td>"; echo"</tr>"; } echo "</table>"; ?>

delete.php

<?php mysql_connect("localhost","root",""); mysql_select_db("combox"); $id=$_GET['id']; mysql_query("delete from comt where id=$id"); header("location:view.php"); ?> ">

button.css

.bth{background:#04f7f7; border:1px groove; color: white;padding: 3px; margin: 3px; font-size: larger; text-decoration: none;box-shadow: 9px 6px 13px 0px #0000007d;}

How to create simple comment box in php ?

2020-06-26T22:39:00.002+05:30

How to create simple comment box in php?

Overview
Database name:-combox

Database table name:-comt

image folder name:-img

Main.php — In this file user create form where user filling there information in the text filed and create record.

Comment.php — when user filling all needed information and finally user click on button then user can reading records from the database. Filling all data stores in the database.

View.php — Help of this file very useful because in this file user view there data one or single record from the database. Display the data retrieved from the MySQL database.

Delete.php — This file is used to deleting a record. It accepts an id parameter and deletes the record with it. Once it executes the delete query it will redirect the user to the comment.php

How to create simple comment box in php ?

Create Database combox and create table comt

CREATE TABLE IF NOT EXISTS `comt` (    `id` int(8) NOT NULL AUTO_INCREMENT,    `name` varchar(110) NOT NULL,    `comment` text NOT NULL,    `img` varchar(50) NOT NULL,    PRIMARY KEY (`id`)  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

Dumping data for table `comt`

INSERT INTO `comt` (`id`, `name`, `comment`, `img`) VALUES (13, 'marco', 'How are you friend?', 'Dont-Angry.jpg'),  (14, 'penso', 'How to make comment box in php?', 'magnifying2.jpg'),  (15, 'diegon', 'Thank for providing this knowledge.', 'ask-me.jpg');

Create file
main.php

main.php file

 <html>
  <head><title>comment with profile</title></head>  <body>  <a href='view.php'>View or Delete</a><p>  <form method="POST"action="comment.php"enctype="multipart/form-data">  Name:-<input type="text" name="name"required><br>  Comment:-<textarea name="comment"></textarea><br><br>  Img:-<input type="file" name="file"value='upload'/><p>  <button name="upload">upload</button>  </form>  </body>    </html>

comment.php

 <?php

 //require'view.php';

 if(isset($_POST['upload']))

 {

 $conn=mysql_connect("localhost","root","","combox");

 if(!$conn)

 {

 die('could not connect'.mysql_error());

 }

 mysql_select_db("combox");

 $name=$_POST['name'];

 $file_name=$_FILES['file']['name'];

 $tmp_name=$_FILES['file']['tmp_name'];

 $comment=$_POST['comment'];

 echo'<hr>';

 mysql_query("insert into comt(name,comment,img)values('$name','$comment','$file_name')")or die(mysql_error()); move_uploaded_file($tmp_name,"img/".$file_name);

 mysql_close($conn);

 //header('location:comment.php');

 echo"<a href='view.php'>View or Delete</a><br>";

 echo"<a href='Comment.php'>Back To Home</a>";

 }

 ?>

view.php file

 <style>  img{border-radius:50%;border: 1px solid #596094}   </style>  //view.php   <?php  //include'comment.php';  $conn=mysql_connect("localhost","root","","combox");   if(!$conn)   {   die(mysql_error());   }   mysql_select_db("combox");   $result=mysql_query("select *from comt");   echo"<a href='main.php'>Back To Home</a><p>";   echo"<table border='1'width='auto'><tr>   <th>Id</ih>   <th>Profile</th>   <th>Name</td>   <th>Comment</td>   <th>Delete</th>   <tr>";   while ($row=mysql_fetch_array($result)) {   echo"<tr>";   echo "<td>".$row['id']."</td>";# code...  echo"<td><img src='img/".$row['img']."'width='70px'height='50px'></td>";   echo "<td>".$row['name']."</td>";   echo "<td>".$row['comment']."</td>";   echo"<td><a href='delete.php?id=$row[id]'>delete</a>";  //echo "<td><img src='img/'width='50px';></td>";  echo"</tr>";   }   echo "</table>";   ?>

delete.php file

  <?php
 mysql_connect("localhost","root","");   mysql_select_db("combox");   $id=$_GET['id'];   mysql_query("delete from comt where id=$id");   header("location:view.php");   ?>

How to insert Image into Database and Display with image name using PHP

2020-06-24T22:38:00.001+05:30

How to insert Image into Database and Display it using PHP MySQL

Simple PHP program how to insert image into database and retrieve image and display it.

Here first we create database and after simple PHP code.

Database name:-image
Table name:-imaget
image folder name:-photo

Create database like...

CREATE TABLE IF NOT EXISTS `imaget` ( `id` int(8) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `photo` longblob NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

Inset data or image code

<?php if(isset($_POST['upload'])) { $conn=mysql_connect("localhost","root","","image");//connect database if(!$conn) //check connection { die('connect'.mysql_error()); } mysql_select_db("image");//select database $name=$_POST['name']; $file_name=$_FILES['file']['name']; $file_type=$_FILES['file']['type']; $file_size=$_FILES['file']['size']; $tmp_name=$_FILES['file']['tmp_name']; mysql_query("insert into imaget(name,photo)values('$name','$file_name')");//insert data into table move_uploaded_file($tmp_name,"photo/".$file_name);//photo is folder name

//html code

<html> <head><title>simple image upload and display</title></head> </body> <form action='image.php'method='post'enctype='multipart/form-data'> Name:-<input type='text'name='name'><br> <input type='file'name='file'value='upload'><br> <input type='submit'name='upload'value='upload'> </form> </body> </html> //Select query to retrieve data into database

<?php $conn=mysql_connect("localhost","root",""); if(!$conn) { die(mysql_error()); } mysql_select_db("image"); $result=mysql_query("select *from imaget");//select data from table echo"<table border=5px><tr> <th>image/Name</th>"; while($row=mysql_fetch_array($result)) { echo"<tr>"; echo"<td>"; echo"<img src='photo/".$row['photo']."'width='45px'>"; echo $row['photo']; echo"</td>"; echo"</tr>"; } echo"</table>"; ?>

how to create simple registration form in php

2020-06-06T22:26:00.001+05:30

Registration form in PHP
PHP registration form
How to insert data in table?
First we create database name 'mydata'
Second we create table name 'employee'
Here we using 5 field name for insert data in MySQL:

<html> <head> <title>registration</title> </head> <form method="post" action="registration.php"> First Name:<br> <input type="text"placeholder="First name" name="FName"> <br>Last Name:<br> <input type="text" placeholder="Last Name" name="LName"> <br>Country Name:<br> <input type="text" placeholder="Country Name"name="Country"> <br>Email Id:<br> <input type="Email"placeholder="Email Id" name="Email"> <br> <br><br> <input type="submit" name="save" value="submit"> </form> </div> </body> </html> <?php $servername='localhost'; $username='root'; $password=''; $dbname = "mydata";/* database name */ $conn=mysqli_connect($servername,$username,$password,"$dbname"); if(isset($_POST['save'])) { $FName = $_POST['FName']; $LName = $_POST['LName']; $Country = $_POST['Country']; $Email = $_POST['Email']; /* insert data in table */ $sql = "INSERT INTO employee (FName,LName,Country,Email) VALUES ('$FName','$LName','$Country','$Email')"; if (mysqli_query($conn, $sql)) { echo "successfully registrastion"; } else { echo "Error: " . $sql ." " . mysqli_error($conn); } mysqli_close($conn); } ?>

Now create table employee and insert following data

CREATE TABLE `employee` ( `Id` int(10) NOT NULL AUTO_INCREMENT, `FName` varchar(50) NOT NULL, `LName` varchar(50) NOT NULL, `Country` varchar(50) NOT NULL, `Email` varchar(50) NOT NULL, UNIQUE KEY `userid` (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=62 ;

Method:2
same database and also you can same table and same insert data into database.
first method and second few are changes.

<html> <head> <title>registrastion</title> </head> <form method="post" action="regi.php"> First Name:<br> <input type="text"placeholder="First name" name="FName"> <br>Last Name:<br> <input type="text" placeholder="Last Name" name="LName"> <br>Country Name:<br> <input type="text" placeholder="Country Name"name="Country"> <br>Email Id:<br> <input type="Email"placeholder="Email Id" name="Email"> <br> <br><br> <input type="submit" name="save" value="submit"> </form> </div> </body> </html> <?php $con=mysqli_connect("localhost","root","","regi"); if(isset($_POST['save'])) { $FName = $_POST['FName']; $LName = $_POST['LName']; $Country = $_POST['Country']; $Email = $_POST['Email']; /* insert data in table */ $sql = "INSERT INTO student (FName,LName,Country,Email) VALUES ('$FName','$LName','$Country','$Email')"; if (mysqli_query($con, $sql)) { echo "successfully registrastion"; } else { echo "error ocurred "; } mysqli_close($con); } ?>

Now create table in mysql

CREATE TABLE `student` ( `id` int(10) NOT NULL AUTO_INCREMENT, `FName` varchar(50) NOT NULL, `LName` varchar(50) NOT NULL, `Country` varchar(50) NOT NULL, `Email` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

starting Tomcat server at localhost has encountered a problem

2020-06-04T11:00:00.000+05:30

Starting Tomcat server at localhost has encountered a problem

Starting Tomcat server at localhost has encountered a problem.
The server cannot be started because one or more of the ports are invalid.

Open the server editor and correct the invalid ports.

Solve this problem and print hello world.

Here easy step given to solve this error.
step-1
Open eclipse

step-2
Click on dynamic web project

step-3
Name your project

Add caption

step-4
Take JSP page in the wizard

Step-5
write any think in body tag like
<body>
hello world
</body>

Step-6
start the server and error occurred.

Step-7
Click on Apache and select your downloaded tomcat server and click on finished.

Step-8
write tomcat installation directory
c:\program files Apache software foundation /tomcat and click on finished

Step-9
Start the server then error occurred.

'Starting Tomcat server at localhost..' has encountered a problem.

The tomcat server configuration at the server / tomcat server at localhost-config is missing. Check the server for errors. Check the server for errors.

Step-10

Open the server.xml file change shutdown port.

Now start the server and run your program.

video1

How do you change the browser address bar tab color When opening your blog website ?

2020-06-02T22:48:00.003+05:30

How do you change the browser address bar tab color When opening your blog website?

You will add a Meta tag to your head page’s with the name theme color and set the site content to any valid CSS color.
When you visit some website then URL address tab color automatically changes.

How has it changed?

Change color in the URL address tab in chrome and other browse may be supported.

Simply add a Meta tag in your website header.

For example

This meta tag is..

For chrome, Firefox another OS and android browser past this code in just past in bellow

After then check your website.
With your chrome or another browser URL address tab color changes when you visit a website.

How to download google text to speech audio

2020-05-17T23:46:00.000+05:30

How to download google text to speech audio

Fist of open your google translate.
You can use to google chrome to search google translate.
After then speech using microphone or type text or paste text.
After then right click on mouse and click on inspect

Open the inspect the right side of translating.
After then click on network as you shown on image.

After click on network .

Go to translate page and click on listen icon.

Automatically including translate_tts?

Double click on translate_tts? or right click on mouse and click on open in new tab.

Listen and click on three dots.

Here you can see download option.

Click on download.
Now your audio file is downloaded.

In this you multiple language text to voice speech download.

Google translates multiple language supported.

So any language easily translates and download voice audio file.

≫

Related topic

≫How to installation Adobe Photoshop ?

≫Do you know in this apps ?

≫Online job or बेरोजगारी 100%

≫WHAT GOES INTO A VIRAL VIDEO?

≫मैं अकेला नहीं हूँ, बल्कि मेरे पास...

Add your branding watermark in YouTube video 2020

2020-05-14T00:45:00.000+05:30

How to add branding watermark to videos on YouTube-2020

Step by step guide to add a branding watermark to your videos on YouTube

How to add Steps by step to add branding watermark on YouTube-video

Follow below steps to add a branding watermark to YouTube video

Step 1

You have to sign in to YouTube.
Click on three lines shown below image.

Step 2

click on your video

Step 3

Select YouTube studio.

Step 4

click on settings

Step 5

Then, you have to select Channel.

Step 6

click on the branding .

Step 7

After then click on choose image and select PNG(Portable Network Graphic), GIF(stands for Graphic Interchange Format)format image.

width 150 and height 150.

Set Display Time.

Select the display time for the branding watermark. There are three categories

End of Time.

Display when video finished before few second.

custom start time

At this time choose your time to display branding.

last is Entire video

The display is branding Entire video.

How to Modify Windows Text to Speech Settings-2020

2020-05-12T01:27:00.001+05:30

Press Ctrl+R key

Open the run command
In run command
Type control panel and hit enter

Click on speech recognition
If you don't find then search speech recognition

Then click on text to speech right bottom side

Now open the new speech properties

Write or past text and click on preview voice
Check with your microphone is connected to your computer.

Set slow, normal and fast speed.

A Speech Recognition bar will display at the top of the screen when Speech Recognition is open

CMD Commands in Windows 7 Complete List

2020-04-24T22:50:00.002+05:30

Cals:-this command is used to display calculator
Control:-this command is used to open control panel
Timedate.cpl:-this command used to display graphics time and date with clock
Cleanmgr:-this command is used to clean unnecessary file
Magnifier:-this command used to display magnifier that used to extra large zoom facility
Osk:- in this command display virtual keyboard
Main.cpl:-this command used to mouse setting box.
Ncpa.cpl:-this command is used to display network connection icon
Notepad:-using this command we can open notepad
Mspaint:-using this command we can open paint
❤How to change color cmd command prompt?
PSr:-this command used to display problem steps recorder
Appwiz.cpl:-this command is used to open uninstall or change program windows
Intl.cpl:-in this command used to change language and region
Resmon:-this command used to display resource monitor
Desk.cpl:-this command used to display screen resolution window
Services.msc:-in this command used to open the services setting
Stikynot:-this command used to display stikynot
Sysdm.cpl or systempropertiescompurname:-this command is used to display system properties
Taskmgr:-this command is used to display window task manager screen
Explorer:-using this command we can open window explorer
Firewall.cpl:-in this command used to open window firewall
Wf.msc:-this command display firewall with advance security
Cls:-this command is used to clear cmd screen
Wuapp:-this command is used to check window update status
Write:-using this command we can open wordpad
Sdclt:- this command is used for data backup and restore window
Color:-this command is used to change color in cmd command prompt ex. color f0
Here f is background color and 0 is text color
Edit:-open ms dos editor tool used to modify text file
Exit:-this command is used to end of cmd command session , close the cmd command
Mem:-this command used to display the memory area
MKDIR: - this command is used to Creates a directory.
MKLINK: - this command is used to Creates Symbolic Links and Hard Links
MODE: - this command is used to Configures a system device.
MORE: - this command is used to Displays output one screen at a time.
MOVE: - this command is used to Moves one or more files from one directory to another
directory.
OPENFILES: - this command is used to Displays files opened by remote users for a file share.
PATH: -Displays or sets a search path for executable files.
PAUSE: - this command is used to Suspends processing of a batch file and displays a message.
POPD: - this command is used to Restores the previous value of the current directory saved by PUSHD.
PRINT: - this command is used to Prints a text file.
PROMPT: - this command is used to Changes the Windows command prompt.
PUSHD: - this command is used to Saves the current directory then changes it.
RD: - this command is used to Removes a directory.
RECOVER: - this command is used to Recovers readable information from a bad or defective disk.
REM: - Records comments (remarks) in batch files or CONFIG.SYS.
REN: - this command is used to Renames a file or files.
RENAME: - this command is used to Renames a file or files.
REPLACE: - this command is used to Replaces files.
RMDIR: - this command is used to removes a directory.
ROBOCOPY: - this command is used to Advance utility to copy files and directory trees
SET: - this command is used to Displays, sets, or removes Windows environment variables.
SETLOCAL: - this command is used to Begins localization of environment changes in a batch file.
SC: - this command is used to Displays or configures services (background processes).
SCHTASKS: - this command is used to Schedules commands and programs to run on a computer.
SHIFT: - this command is used to Shifts the position of replaceable parameters in batch files.
SHUTDOWN: - this command is used to Allows proper local or remote shutdown of machine.
SORT: - this command is used to Sorts input.
START: - this command is used to Starts a separate window to run a specified program or command.
SUBST: - this command is used to Associates a path with a drive letter.
SYSTEMINFO: - this command is used to Displays machine specific properties and configuration.
TASKLIST: - this command is used to Displays all currently running tasks including services.
TASKKILL: - this command is used to Kill or stop a running process or application.
TIME: - this command is used to Displays or sets the system time.
TITLE: - this command is used to Sets the window title for a CMD.EXE session.
TREE: - this command is used to Graphically displays the directory structure of a drive or path.
TYPE: - this command is used to Displays the contents of a text file.
VER: - this command is used to Displays the Windows version.
VERIFY: - this command is used to Tells Windows whether to verify that your files are written correctly to a disk.
VOL: - this command is used to Displays a disk volume label and serial number.
XCOPY: - this command is used to Copies files and directory trees.
WMIC: - this command is used to Displays WMI information inside interactive command shell.

❤How to change color cmd command prompt?

Microsoft DiskPart commands

ACTIVE: - Mark the selected partition as active.
ADD: - Add a mirror to a simple volume.
ASSIGN: - Assign a drive letter or mount point to the selected volume.
ATTRIBUTES: - Manipulate volume or disk attributes.
ATTACH: - Attaches a virtual disk file.
AUTOMOUNT: - Enable and disable automatic mounting of basic volumes.
BREAK: - Break a mirror set.
CLEAN: - Clear the configuration information, or all information, off the disk.
COMPACT: - Attempts to reduce the physical size of the file.
CONVERT: - Convert between different disk formats.
CREATE: - Create a volume, partition or virtual disk.
DELETE: - Delete an object.
DETAIL: - Provide details about an object.
DETACH: - Detaches a virtual disk file.
EXIT: - Exit DiskPart.
EXTEND: - Extend a volume.
EXPAND: - Expands the maximum size available on a virtual disk.
FILESYSTEMS: - Display current and supported file systems on the volume.
FORMAT: - Format the volume or partition.
GPT: - Assign attributes to the selected GPT partition.
HELP: - Display a list of commands.
IMPORT: - Import a disk group.
INACTIVE: - Mark the selected partition as inactive.
LIST: - Display a list of objects.
MERGE: - Merges a child disk with its parents.
ONLINE: - Online an object that is currently marked as offline.
OFFLINE: - Offline an object that is currently marked as online.
RECOVER: - Refreshes the state of all disks in the selected pack.
REM: -Does nothing. This is used to comment scripts.
REMOVE: - Remove a drive letter or mount point assignment.
REPAIR: - Repair a RAID-5 volume with a failed member.
RESCAN: - Rescan the computer looking for disks and volumes.
RETAIN: -Place a retained partition under a simple volume.
SAN: - Display or set the SAN policy for the currently booted OS.
SELECT: - Shift the focus to an object.
SETID: - Change the partition type.
SHRINK: - Reduce the size of the selected volume.
UNIQUEID: - Displays or sets the GUID partition table (GPT) identifier or

master boot record (MBR) signature of a disk.

How to make bootable pan-drive/removable drive

2020-04-11T22:42:00.000+05:30

How to make Bootable pan-drive/removable drive?

Here follow the easy step to make Bootable pan-drive.

Why need Bootable pan-drive ?

When you install operating system like window, Linux and other operating system then need to Bootable if you no have original DVD.

If you have operating system DVD disk, then you directly install it.
But if you don't have Windows/Linux operating system DVD disk and you want to download operating system then need to Bootable pan-drive.

If you have no pan-drive.

Normally buy rewritable or blank DVD disk.

And make Bootable DVD disk same as a pan-drive.

Before Bootable pan-drive need to format your pan-drive.

computer full form most imp ask in exam

How to format pan-drive?

Before format pan-drive Recover all pan-drive data otherwise lost it.
You two ways to format 1.command prompt and 2. direct selection pan-drive in the computer.

How to format pan-drive via the command prompt.

Step-1

Click on start menu.

Write cmd.

run as administrator

Right click on cmd and click on run as administrator

Step-2

Write this command.

1.diskpart( and hit enter).

2.list disk (and hit enter)

(display list of drive.

Select your drive.)

3.select disk x ( and hit enter).

4.clean( and hit enter).

5.create partition primary( and hit enter).

6. format fs=ntfs ( and hit enter).

(It take few time)

7.assing ( and hit enter).

Step-3

Your pan-drive is formatted all data is erased.

How to format pan-drive using direct pan-drive selection in computer without command prompt?

Step-1

Click on the start menu.

Step-2

And right side, click on the computer if you no show computer then searches it.

Step-3

Here to display your pan-drive.

Step-4

Right click on your pan-drive.

Step-5

Choose format option.

Now your pan-drive is ready to use.

After this step completed download ISO (international organization for standardization) image window or any operation system that is free.

Also download rufus(used to create bootable USB drive) software for bootable.

After download this two item ready you make bootable pan-drive.

How make bootable pan-drive?

Step-1

Open the double click on rufus software.

Step-2

Here you select ISO image that is download.

Step-3

Partition scheme MBR (master boot record) or GPT (guide partition table)

Select MBR (master boot record).

MBR (master boot record) is old concept.

Some operating system both support MBR (master boot record) and GPT (guide partition table) like Ubuntu.

If MBR (master boot record) not supported then select GPT (guide partition table)

Click on start button.

Before bootable will be display warning massage.

Click on ok and running process.

It takes some time.

how to create direct download link

After doing completed display massage.

Computer full form most imp ask in the exam

Read it and click on close button.

Now your bootable pan-drive is ready.

How to automatically post update

2020-04-06T22:35:00.000+05:30

How to automatically post updates?
You can set the automatic update post when you like.

Set date in blogger to automatically update.

Here follows the below step

Sing in blog

↣Step-1

Click on new post

Image-1

↣Step-2

Writing you post
Give title

Create label

Click on schedule

Here you see two radio buttons

The default radio button is automatic

Click on ‘set date and time’

Select date what you are posting updates.

Whenever you post an upload on blogger any date automatically uploads which is set date.

Set date and time, then click on update/save button.

Show in below image

Image-2

↣step-3

Now your post ready to automatically update whichever you set the date and time.

Show the bellow image

Whatever you set date that day automatically update/upload, post in blogger automatically.
Until then, stay it schedule.

≫ ब्लॉग वेबसाइट में ट्रैफिक कैसे बढाए?part-2

≫ ब्लॉग वेबसाइट में ट्रैफिक कैसे बढाए?part-3

कोरोना जैसा खतरनाक वायरस कैसे फैलता है?

2020-04-02T23:33:00.001+05:30

क्या आप जानते हैं कि कोरोना जैसा खतरनाक वायरस कैसे फैलता है?

एक वायरस कुछ ऐसा है जो इस तरह से फैलता है।

चीन के वुहान में स्थित कोरोना ने आज दुनिया की सैर की है।

कारण यह था कि किसी को भी इस तरह के खतरनाक वायरस संक्रमण का पता ही नहीं चला, क्योंकि बीमारी का पता नहीं चल सकता था।

मान लीजिए कि चीन में कोई व्यक्तिको कोरोना हो जाता है और ऐसे वायरस को नजरअंदाज कर देता है और उसको मालूम हि नहि चलता कि उसलो कोरोना हुआँ है।

वह एक व्यक्ति कम से कम दस अन्य लोगों से मिलेगा।

तो अगले दिन, उस व्यक्ति के कारण दस लोग संक्रमित हो गए।

अब कल्पना करें कि अगर प्रति व्यक्ति कम से कम दस लोग मिले तो कितने लोग संक्रमित हो गए?

1 * 10 = 10

10* 10 = 100

इसलिए अगर हर दस में से एक व्यक्ति कुल 100 लोगों को संक्रमित करता है।

अब अगर उस व्यक्ति को कम से कम 10 अन्य लोग मिले तो कितना?

1 * 10 = 10

10 * 10 = 100

100 * 100 = 10,000

दोस्तों देखें कि आपको यह नंबर एक आदमी कहां से कहा पहोच गया।

यह इतनी तेजी से होता है कि किसी को पता नहीं चलता।

अभी तक केवल दस लोगों ने इस पर ध्यान दिया है।

आपको आश्चर्य है कि एक दिन में कितने लोगों से मिलने की उम्मीद है।

नंबर दस को सिर्फ समझने के लिए लिया जाता है।

अगर हम इसे बढ़ाते हैं, तो 10,000 लोग कोरोना वायरस से संक्रमित दस अन्य लोगों से संक्रमित होंगे।

यह इतनी तेजी से हुआ कि किसी को पता भी नहीं चला।

क्या होगा यदि दस हजार लोगों में से हर एक अन्य दस के संपर्क में आए?

सोचें कि संख्या कहाँ तक पहुँचती है।

इस प्रकार पूरी दुनिया चीन से कोरी से संक्रमित हो गई।

कोरोना के कारण, चीनीमे जो अन्य देशोंके लोग थे कोरोना के कारण अपने अपने देश गए।

ऐसे लोग किसी ऐसे व्यक्ति के संपर्क में आए हैं जो कोरोना वायरस के संपर्क में था।

चीनीमे अन्य देश के लोग व्यापार, शिक्षा या अन्य कारणों से चीन गए।

यह सोचें कि कोई भी चीन नहीं गया, लेकिन अब जो व्यक्ति अपने देश से चीन गया था, वह दूसरे देश में उस देश में आ गया है और अगर वह व्यक्ति इस व्यक्ति के संपर्क में आता है, तो वह व्यक्ति अब संक्रमित होता है।

अब वह शख्स देश गया और कई लोगों से मिला।

उनके देश की सरकार शायद नहीं जानती थी।

इस तरह से, कोरोना वायरस एक देश से दूसरे देश में और एक देश से तीसरे और अधिकांश देशों में फैलता गया।

कोरोना ज्यादातर देशों में होता गया।

कोरोना फैल रहा है और डॉक्टर, वैज्ञानिक वैक्सीन और बड़े समय के आविष्कारक आज कोरोना वायरस के उन्मूलन के लिए हर संभव प्रयास कर रहे हैं।

लेकिन यह कोरोना दिन-ब-दिन बढ़ता रहा।

साथ ही, पृष्ठ को यह नहीं पता है कि कोरोना वायरस से कितने लोग संक्रमित हुए हैं।

लॉकडाउन यह जानने का एकमात्र तरीका है कि लोग अपने घरमे रहि दुसरो को संक्रमित होने बचाए।

जिन देशों में यह कोरोना पहुंचा, वहां सरकार ने पूरे देश में ताला लगा दिया।

अब उन देशों में जहां केवल कुछ लोग ही संक्रमित हैं, ऐसे कोरोना वायरस के शीर्ष देशों की स्थिति देखने लगी और उनके देशों का विन्यास शुरू हो गया, इसलिए कुछ देश ऐसे खतरनाक वायरस से कम संक्रमित हैं।

लेकिन संक्रमित लोगों के संपर्क में आने वालों को यह पता चलने लगा कि यदि व्यक्ति संक्रामित व्यक्ति के सम्पकमे आते गए और कोरोना वायरस बढ़ता रहा।

यदि जब कोरोना जिस देश से निकलता है, तो उस देश ने पहले ही अपना देश लोकडाउन कर दिया होता तो?

उनकी सरकार ने पहले ही एलान कर दिया होता तो , ताकि देसम के लोग अपने देश नहीं जाएंगे और दूसरे देशों के लोग नहीं जाएंगे?

यदि हां, तो क्या कोरोना वायरस पूरी दुनिया में फैलता?

चलिए उस देश को अपने देश में भेजते हैं, यदि वह देश पहुँच गया, तो क्या उस देश को पहले ही जांच करके अपने घर भेजा होता तो?

माना कि देश की सरकार ने इस जांच का आदेश नहीं दिया, लेकिन व्यक्ति ने स्वेच्छाए ऐसा किया होता तो।

आज जिस तरह से कोरोना दुनिया भर में फैलता नहि ।

पहली बार, अधिकांश देश लॉकडाउन से गुजरे।

लॉकडाउन एक रेगिस्तान दुनिया भर में लॉकडाउन के साथ शुरू हुआ।

पहली बार, एक ऐसे वायरस की खोज की गई, जिसने दुनिया को घर से निकाल दिया।

यह पहला कोरोना वायरस है जो दुनिया के लोको घरोमे केद कर दिया।

यदि एक देश पर्याप्त है, तो अन्य देश उस देश की मदद के लिए आगे आएंगे, लेकिन इन सभी देशों में कौन मदद कर सकता है?

हां, जब वायरस चीन पहुंचा, तो लोको कोरोना पहुंचीं जहां हर देश मदद करने की योजना बना रहे थे।

अब, पूरी दुनिया लॉकडाउन में है।

से शहर, शहर से शहर, और तालाबंदी करने वाले घर।

एक देश से दूसरे देश में कोई मत जाओ और एक देश से दूसरे को अपने देश में मत आने दो।

एक राज्य से दूसरे राज्य में न जाएं और उस व्यक्ति को उस राज्य से आने न दें।

एक जिले से दूसरे जिले में न जाएं और उस जिले के व्यक्ति को आने न दें।

एक तालुक से दूसरे तालुका में न जांए और दूसरे को आने न दे ।

एक शहर के एक व्यक्ति को दूसरे शहर में नहीं जाना चाहिए और उसे उस शहर में नहीं आना चाहिए।

एक क्षेत्र से दूसरे क्षेत्र में न जाएं और दूसरे व्यक्ति को न आने दें।

घर मत जाओ या किसी को घरमे मत आने दो।

आज विश्व घरमे बंद हो गया।

घर रहें और सुरक्षित रहें।

घर से बेहतर सुरक्षित जगह कोई और नहीं है।

लोग अपने घर में रहते हैं, इसलिए जिस व्यक्ति में कोरोना वायरस का प्रभाव है, वह किसी अन्य स्वस्थ व्यक्ति के संपर्क में नहीं आएगा और प्रसार को रोका जा सकता है।

इसीलिए सभी को सलाह दी जाती है कि जरूरत पड़ने पर घर पर रहें या बाहर न जाएं।

वह व्यक्ति जहां वह व्यक्ति होता है, वह व्यक्ति दूसरे व्यक्ति के संपर्क में नहीं आता और ईस वाईरस को रो फेलते हुए रोका जा सकता है।

घर पर रहें स्वस्थ रहें।

C# objective type question

2020-03-31T23:47:00.000+05:30

___method is used to add element in hashtabe.

⇛Add()

___ method is used to remove and return element in stack.

⇛Pop()

ADO stand for :-

⇛ACTIVEX DATA OBJET

___known as smart fields.

⇛Properties

CTS stand for:-

⇛COMMON TYPE SYSTEM

___class will prevent inheritance.

⇛Sealed

Form is ___type of control.

⇛Container

___is default event of button.

⇛Click

___is default property of textbox.

⇛Name

full name of JIT:-

⇛JUST IN TIME

Default value of interval property of timer is___

⇛1 second/1000milisecond

For to check connection state___property of connection is used.

⇛State

For to connect with sqlserver___namespace.

⇛Sqlclient

___method is used to close the connection.

⇛Close()

___ is the externsion of user control file.

⇛.ascx

___ event will occur whenever the user control loads

⇛Load

Section 1 for crystal report includes__

⇛Report header

Section 2 for crystal report includes___

⇛Page header

Section 3 for crystal report includes___

⇛Details

The built library of NET framework is known as___

⇛FCL(framework class library)

__component of .net provides connectivity with database.

⇛Ado.net

__method is used to find the length of string

⇛Length()

__method is used to convert string into integer.

⇛System.Int32()

___keyword is used to use predefined library of .net.

⇛Using

The operation of converting returning type to value type is known as…

⇛unboxing

class has __ default access modifier for the class member.

⇛private

One name many forms means?

⇛Polymorphism

The __ has get and set method for the attributes.

⇛Properties

full form of MDI:-

⇛MULTIPLE DOCUMENT INTERFACE

To display image which control is used?

⇛Imageurl

More than one method in a class having same name and different signatures then it is called__

⇛Overloading

To activate timer __ method is used.

⇛Start()

Which method of command class is used to excecute select query?

⇛ExcecuteReader()

Which property is used to set caption of a button?

⇛text

___namespace is used to connect sqlserver in ado.net

⇛System.Data.SqlClient

___is the bridge between data source and dataset

⇛DataAdapter

Which method of command class is used to execute insert query?

⇛ExecuteNonQuery

___keyword is used to include namespace

⇛Using

___is used to implement multiple inheritance.

⇛interface

___property of the lable is sued to automatically resize to display.

⇛Autosize

____control is used to view the crystal report.

⇛Crystalreportviewer

Which method is used to display message on the screen?

⇛show()

LINQ stand for:-

⇛LANGUAGE INTERGRATED QUERY

what is also known as a bridge between data set and database ?

⇛DataAdapter

Which contrl is used to dispay nodes in hierarchical format?

⇛Treeview

Which keyword is used to define indexer?

⇛This

A___ cass connot be used as a base class.

⇛Sealed

A delegate is a ___type variable that holds the reference to a method.

⇛pointer

MSIL stand for:-
⇛MICROSOFT INTERMEDIATE LANGUAGE

Which control is used to display a pup-up menu when user wants to display the functionality related to the control?

⇛contexmenuStrip

__ is a virtual and local relational database that is used for temporary storage of recored?

⇛Dataset

which object is used to read data in a sequential manner?

⇛DataReader

DataReader supports___architecture.

⇛Connect

Which control provides a powefull and flexible way to display data in a babular format?

⇛DataGridview

In c#,which applications are light weight programs run inside the dos promt/window?

⇛Console

Which keyword is used to split a class definition?

⇛Partial

___is a process of convertiong the object type to the value type.

⇛unboxing

Which method is used to call messageBox?

⇛Show()

Which namespace is require for DLEDb data connection?

⇛System.Data.OLEDbclient

In__ tool of windows IDI, where we can manage the files of program?

Solution Explorer__

⇛ properties of form is sued to convert SDI(simple document interface) form of MDI(multiple document interface) form

Which method is used to execute sql query?

⇛ExecuteNonQuery()

Which key is used to execute the program step one by one in debug window?

⇛F11

___method is used to call dialogue box in c sharp.net?

⇛showDialogue()

___keyword is used to declared constant variable in C sharp.

⇛const

OLEDB stand for:-

⇛OBJECT LINKING AND EMBEDDING DATABASE.

Note:-bug or mistake in this objective type question peace contact or comment 🙏

Related topic

JAVA objective type question

2020-03-31T23:31:00.000+05:30

JAVA objective type question

Here explained computer science and programming objective type question, that is most used in practice/competitive programming/company interview exam.

You find all exam paper questions and to answer and if you have any doubt without fearing contact us.

java

JAVA objective type question

Where is creating java programming language ?

⇛At sun Microsystems

The _______cannot be used as name for a variable, class or method.

⇛Keyword

JFC stand for:-

⇛JAVA FOUNDATION CLASSES

How many bits are stored when creating long type variable ?

⇛64bits

___ array is a collection of variable.

⇛One dimension array

Which array represent variable ?

⇛Multi-dimension array .

JAVA objective type question

Which type of class is not inherited in java ?

⇛Constructor object class

FCL stand for:-

⇛FRAMEWORK CLASS LIBRARY

How many argument passing in replace()function()?

⇛Two

Which package is imported when we ___use StringBuffer class?

⇛Java.lang

How many type of specified in java ?

⇛Four

___ specifies class that member can be access by any other code.

⇛Public

__ member can only access by other member of it’s class

⇛Private

A class within other class is know as__

⇛Nested class

Type of nested class.

⇛Static

⇛Non static

JAVA objective type question

____access to all of the variable and method of it’s outer class

⇛Non static nested class

Non static nested class also know as…

⇛Inner class

full form of JWT:-

⇛ABSTRACT WINDOW TOOLKIT

To inherit a class which key word is used?

⇛Extends

__ inheritance does not support when has single sub class in java.

⇛Multiple inheritance

How many type of in heritance in java?

⇛Three

full form of CLR:-

⇛COMMON LANGUAGE RUN-TIME

All exception types subclass o the ___class.

⇛Throwable

Exception is __error to handing it.

⇛Runtime

Array index is out of range with exception is generated?

⇛Bounces

JAVA objective type question

full form of IDE:-

⇛INTEGRATED DEVELOPMENT ENVIRONMENT

Which method is sued to stop thread for some time?

⇛Stop()

___is linked to a physical device.

⇛Stream

There are __type of stream in java?

⇛Two

JAVA objective type question

full form of API:-

⇛APPLICATION PROGRAMMING INTERFACE

__is single sequential flow of control

⇛Thread

____does not have its own address space.

⇛Thread

Which method of graphics class is used to draw circle in an applet?

⇛The method drawoval()

Which are two methods executed only one time in applet life cycle?

⇛Init ()

Which method is used to graphics class object as argument in applet?

⇛Paint ()

JAVA objective type question

Which method loaded by the browser ?

⇛Init()

GUI stand for:-

⇛GRAPHICS USER INTERFACE

How cdan we achieve multiple inheritance in java ?

⇛Interface using

Which block get executed compulsory whether exception is caught or not?

⇛Finally

Which method are used to inset element in vector object?

⇛Add()

Which mehod are used to get the location of mouse pointer in swing?

⇛getLocation()

JAVA objective type question

which layoutManager are used to arrange components as row and column ?

⇛GridLayout

JRE stand for:-

⇛JAVA RUN-TIME ENVIRONMENT

Which package contains JFrame class in java?

⇛Javax.swing

How many space occupied by short type variable?

⇛16bits/2byte

Give name of a constructer for thread.

⇛setName()

write command to run applet

⇛dataoutputstream

JAVA objective type question

which method is used to graphic class object as argument?

⇛Paint()

JVM stand for:-

⇛JAVA VIRTUAL MACHINE

The syntax of main() method of java program is___

⇛Public static void main(String[]args)

NOTE: -BUG OR MISTAKE IN THIS OBJECTIVE TYPE QUESTION PEACE contact

Related topic

NETWORKING full form

2020-03-31T23:13:00.000+05:30

Networking

Osi:- open system interconnection

Mta:- mail transfer agent

Igrp:- interior gateway routing protocol

Ospf:- open shortest path first

Cia:-confidentiality integrity and availability

Cctv:-closed circuit television

Csma/ca:-carrier-sense multiple access/collision avoidance

Lan:-local area network

Tcp/ip:- transmission control protocol/internet protocol

Cddi:-copper distributed data interface

Fdm:-frequency division multiplexing

Tdm:-time division multiplexing

Wdm:- wavelength – division multiplexing

Cdm:- code division multiplexing

http:- hypertext transfer protocol

ftp:- file transfer protocol

smtp:- simple mail transfer protocol

rarp:- reverse address resolution protocol

bgp:- border gateway protocol

mmc:- Microsoft management console

rip:- routing information protocol

ospf:- open shortest path first

pptp:- point to point tunneling protocol

l2tp:- layer2 tunneling protocol

vpn:- virtual private network

gprs:- general packet radio service

udp:- user datagram protocol

iete:- internet engineering task force

tftp:- trivial file transfer protocol

rfe:- request for comments

fddi:- fiber distributed data interface

rtp:- real-time transport protocol

sip:- session initiation protocol

udp:- user datagram protocol

operating system queries

2020-03-31T22:48:00.000+05:30

Queqe at ticket windows is example of __ type scheduling algorithm.

⇛Round robin

SJN stand for:-

⇛ SHORTEST JOB NEXT

In paging , we divide the programs into equal sized blocks called __ and the main memory is divided into equal sized blocks known as__

⇛Page frames

__ command is used to change name of the file.

⇛Ren(rename)

BASE stand for:-

⇛BOURN AGAIN SHELL

__command is used to convert whole file from small letter to capital.

⇛Tr (translate)

__ command is used to move the file to another directory.

⇛Mv (move)

CLI stand for:-

⇛COMMAND LINE INTERFACE

Case statement starts with case and ends with __

⇛esac

__ shell variable is used to get total number of positional parameters.

⇛$1,$2,$0,$#

LILO full form:-

⇛LINUX LOADER

To add new user __ command are use in linux.

⇛Useradd/username/adduser

full form KDE:-

⇛K-DESKTOP ENVIRONMENT

__ command is used to initialize an x-session

⇛Startx

To delete old user __ command are used in linux.

⇛Userdel

full form of WINE:- WINE IS NOT AN EMULATOR

__ is a meaning of sudo

⇛Superuserdo

The fcfs implementation is based on fifo queue(T/F)

⇛T

PMT full form:-

⇛PREFERENCE MANAGEMENT TOOL

Bill joy was developed the “c shell” in __ year.

⇛1977

SMT stand for:-

SIMULTANEOUS MULTITHREADING

The first fit algorithm is fastest algorithm because it searches as little as possible(T/F)

⇛T

__ command is display all the user are currently logged into the system.

⇛W

GRUB stand for:-

⇛G-RAND UNIFIED BOOTLOAD

__ command user can change the last modification time and last access time of the file.

⇛A time(access time)

full form for MBR:-

⇛ MASTER BOOT RECORD.

__ command is used to delete the file.

⇛Rm(remove)

full form of OD :-

⇛OCTAL-DUMP

The finger command is display the information about the user who are the currently logged in(T/F)

⇛F

IFS full form:-

⇛INTERNAL FIELD SEPARATOR

Round robin is a non-preemptive process scheduling algorithm.(T/F)

⇛F

GNOME stand for:-

⇛ GNU NETWORK OBJECT MODEL ENVIRONMENT

BSD stand for:- BERKELEY SOFTWARE DISTRIBUTION

The hiden files can be listed out with __ command.

⇛Dir/ah

LDAP stand for:- LIGHTWEIGHT DIRECTORY ACCESS PROTOCOL

__ redirection operator is used to append content to a file.
⇛>>

GUI stand for:-

⇛ GRAPHICAL USER INTERFACE