Thursday, April 26, 2018

What Is Layout In Android

XML-Based Layouts in Android. In Android, an XML-based layout is a file that defines the different widgets to be used in the UI and the relations between those widgets and their containers


Download PPT Here

Tuesday, April 24, 2018

What Is API In Android

There are many types of APIs. One of the most common types of APIs are Web APIs; these APIs, otherwise known as Web Services, provide an interface for web applications, or applications that need to connect to each other via the Internet to communicate.




Download PPT Here

Sunday, April 22, 2018

What is manifest file in android?


Every application must have an AndroidManifest.xml file (with precisely that name) in its root directory. The manifest presents essential information about the application to the Android system, information the system must have before it can run any of the application's code.


Download PPT Here

What Is Domain Name System And IP-Bench Marking In SQL Server

this PPT is about what is domain name system and ip bench marking in sql server 



Download PPT Here

Friday, April 20, 2018

Sunday, April 15, 2018

What Is Architectural Component Of Data ware House And Data mining

This PPT Is About What Is Architectural Component Of The Data Warehouse And Data mining.

Into This PPT All Brief Description About Architectural Component Are Given.


Download PPT Here 

Friday, April 13, 2018

What Is Location Based Service In Android

This PPT Is About What Is Location Based Service In Android.

In This PPT Brief Description About Location Based Service Given.

Download PPT Here 

Monday, April 9, 2018

Type Of SQL Server Editions.

This PPT Is About How Many Type OF SQL Server Edition And Give Brief Description About All The Editions.

Download PPT Here 

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.

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 

Wednesday, April 4, 2018

Select Insert Update Delete In Php MySQL Example - MySQL


following are the database and table design


Select-Insert-Update-Delete-In-Php-MySQL-Example - MySQL


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



Select-Insert-Update-Delete-In-Php-MySQL-Example - MySQL

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:-



<table class="table m-0">

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




Generate Even Numbers in a Range In PHP.

$start = 1; $end = 20; for ($i = $start; $i <= $end; $i++) {     if ($i % 2 == 0) {         echo $i . " is even.<br>";   ...