Sunday, April 8, 2018
Saturday, April 7, 2018
Friday, April 6, 2018
What Is File Class In Java.
This Is PPT About What Is File Class In Java.
In This PPT All The Description Of The File Class And All The Methods Are Given.
In This PPT All The Description Of The File Class And All The Methods Are Given.
Download Here File Class PPT
Thursday, April 5, 2018
What is buffer reader class in java ppt
This PPT is about what is buffer reader class in java in this ppt all the method of the buffer reader class are given and given all the brief description.
Following are the link for download buffer reader class ppt in java
Download Here Buffer Reader Class PPT
Following are the link for download buffer reader class ppt in java
Download Here Buffer Reader Class PPT
Wednesday, April 4, 2018
Select Insert Update Delete In Php MySQL Example - MySQL
following are the database and table design
<?php
$con=mysqli_connect('localhost','root','','my_db');
if(isset($_POST['insert']))
{
extract($_POST);
$insert="insert into stud(no,name,city) values('".$no."','".$name."','".$city."')";
$insert_data=mysqli_query($con,$insert);
if($insert_data==true)
{
echo "recored added";
}
else
{
echo "recored not added";
}
}
$select="select * from stud";
$select_data=mysqli_query($con,$select);
if(isset($_GET['delete']))
{
$delete= "delete from stud where id=".$_GET['delete'];
$delete_data=mysqli_query($con,$delete);
if($delete_data==true)
{
echo "recored deleted";
}
else
{
echo "recored not deleted";
}
}
if(isset($_GET['edit']))
{
$view = mysqli_fetch_array(mysqli_query($con,'select * from stud where id='.$_GET['edit']));
}
if(isset($_POST['update']) && isset($_GET['edit']))
{
$update_query = 'update stud set no="'.$_POST['no'].'",name="'.$_POST['name'].'",city="'.$_POST['city'].'" where id='.$_GET['edit'];
//echo $update_query;
if(mysqli_query($con,$update_query))
{
echo "recored updated";
}
else
{
echo mysqli_error($con);
exit();
}
}
mysqli_close($con);
?>
<!DOCTYPE html>
<html>
<head>
<title>bhavesh</title>
</head>
<body>
<form action="" method="post">
<div>No:
<input type="number" name="no" value="<?php echo(isset($_GET['edit']) && isset($view['no']))? $view['no'] : ''; ?>">
</div>
<div>Name:
<input type="text" name="name" value="<?php echo(isset($_GET['edit']) && isset($view['name']))? $view['name'] : ''; ?>">
</div>
<div>city:
<input type="text" name="city" value="<?php echo(isset($_GET['edit']) && isset($view['city']))? $view['city'] : ''; ?>">
</div>
<div>
<input type="submit" name="<?php echo (isset($_GET['edit']) && isset($view['no'])) ? 'update' : 'insert'; ?>" value="<?php echo (isset($_GET['edit']) && isset($view['no'])) ? 'update' : 'insert'; ?>">
<input type="reset" name="select" value="RESET">
</div>
</form>
<div>
<table>
<tr>
<th>no</th>
<th>name</th>
<th>city</th>
</tr>
<?php while ($row= mysqli_fetch_assoc($select_data)) {
?>
<tr>
<td>
<?php echo $row['no'] ?>
</td>
<td>
<?php echo $row['name'] ?>
</td>
<td>
<?php echo $row['city'] ?>
</td>
<td><a href="insert.php?edit=<?php echo $row['id']; ?>">Edit</a>
<a href="insert.php?delete=<?php echo $row['id'];?>">Delete</a></td>
</tr>
<?php }?>
</table>
</div>
</body>
</html>
Following are the output of the above program.
Tuesday, April 3, 2018
How to Select Data From MySQL Database Table Using PHP
PHP Code File:-
This program is about how to insert record into the database using html form.<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "my_db";
$con = new mysqli($servername, $username, $password, $dbname);
if ($con->connect_error) {
die("Connection failed: " . $con->connect_error);
}
$select= "select * from my_login";
$result = $con->query($select);
?>
HTML Code File:-
<thead>
<tr>
<th>No</th>
<th>First Name</th>
<th>Last Name</th>
<th>Username</th>
<th>Action</th>
</tr>
</thead>
<?php
$i=1;
while($row = $result->fetch_assoc()) { ?>
<tbody>
<tr>
<th scope="row">
<?php echo $i++; ?>
</th>
<td>
<?php echo $row["name"] ?>
</td>
<td>
<?php echo $row["email"] ?>
</td>
<td>
<?php echo $row["password"] ?>
</td>
</tr>
<?php } ?>
</tbody>
</table>
Monday, April 2, 2018
How to Insert Data Into MySQL Database Table Using PHP -
PHP Code File:-
This program is about how to insert record into the database using html form.<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "my_db";
$con = new mysqli($servername, $username, $password, $dbname);
if ($con->connect_error) {
die("Connection failed: " . $con->connect_error);
}
if(isset($_POST['submit']))
{
extract($_POST);
if($pass == $cpass)
{
$sql = $insert="INSERT INTO my_login(name, email, password) VALUES ('".$name."','".$email."','".$pass."')";
if ($con->query($sql) === TRUE)
{
echo "New record created successfully";
}
else
{
echo "Error: " . $sql . "<br>" . $con->error;
}
}
else
{
echo "<script>alert('p And cp are not same')</script>";
}
}
$select= "select * from my_login";
$result = $con->query($select);
?>
HTML Code File:-
<form action="" data-parsley-validate="" method="post" novalidate="">
<div class="form-group">
<label for="userName">User Name*</label>
<input type="text" name="name" parsley-trigger="change" required="" placeholder="Enter user name" class="form-control" id="userName" data-parsley-id="4">
</div>
<div class="form-group">
<label for="emailAddress">Email address*</label>
<input type="email" name="email" parsley-trigger="change" required="" placeholder="Enter email" class="form-control" id="emailAddress" data-parsley-id="6">
</div>
<div class="form-group">
<label for="pass1">Password*</label>
<input id="pass1" type="password" name="pass" placeholder="Password" required="" class="form-control" data-parsley-id="8">
</div>
<div class="form-group">
<label for="passWord2">Confirm Password *</label>
<input data-parsley-equalto="#pass1" name="cpass" type="password" required="" placeholder="Password" class="form-control" id="passWord2" data-parsley-id="10">
</div>
<div class="form-group">
<div class="checkbox">
<input id="remember-1" type="checkbox" data-parsley-multiple="remember-1" data-parsley-id="13">
<label for="remember-1"> Remember me </label>
</div>
</div>
<div class="form-group text-right m-b-0">
<button class="btn btn-primary waves-effect waves-light" name="submit" type="submit">
Submit
</button>
<button type="reset" class="btn btn-default waves-effect waves-light m-l-5">
Cancel
</button>
</div>
</form>
Subscribe to:
Posts (Atom)