MySQL (Part 8)

http://phpmysql-academy.blogspot.in/

Example: 1

connection.php

    <?php

    error_reporting(0);
    $connect = mysql_connect("localhost", "root", "admin") or die(mysql_error());


    mysql_select_db("phpacademy1") or die(mysql_error());

    echo "Connected Succesfully!.<br><br>";


    ?>


Example: 2

member.php


    <?php

    session_start();

    if($_SESSION['username'])
    echo "Welcome, " .$_SESSION['username']."!<br><a href='logout.php'>Logout</a><br> ";
    else
    die ("You must be logged in!");

    ?>



Example 3

mysql8.php


    <?php

    //File Name of the video is (mysql_part6_854 x 480)

    //connect include
    require("connection.php");

    //extract data
    /*$extract = mysql_query("SELECT * FROM people1 ORDER BY id ASC") or die(mysql_error());
    $numrows = mysql_num_rows($extract);

    echo "<form action='mysql_update1.php' method='POST'>
           <select name='peoplename'>";

    while ($row = mysql_fetch_assoc($extract))
    {
        $id        = $row['id'];
        $firstname = $row['firstname'];
        $lastname  = $row['lastname'];

        echo "
        <option value='$id'>$firstname </option>
        ";
     }

    echo "</select>
          <input type='text' name='tochange'>
          <input type='submit' name='submit' value='change'>
          </form>
          ";*/





    // this is for delete data
    $extract = mysql_query("SELECT * FROM people1 ORDER BY id ASC") or die(mysql_error());
    $numrows = mysql_num_rows($extract);

    echo "<form action='mysql_delete1.php' method='POST'>
           <select name='todelete'>";

    while ($row = mysql_fetch_assoc($extract))
    {
        $id        = $row['id'];
        $firstname = $row['firstname'];
        $lastname  = $row['lastname'];

        echo "
        <option value='$id'>$firstname $lastname </option>
        ";
     }

    echo "</select>
          <input type='submit' name='submit' value='Delete'>
          </form>";

    ?>


Example 3


mysql_delete.php


    <?php

    //File Name of the video is (mysql_part8_854 x 480)

    //connect include
    require("connection.php");

    // this is for delete data
    $todelete = $_POST['todelete'];
    $delete = mysql_query("DELETE FROM people1 WHERE id='$todelete'");


    /*$tochange = $_POST['tochange'];

    if ($peoplename&&$tochange)
    {

    $change = mysql_query("UPDATE people1 SET firstname='$tochange' WHERE id='$peoplename'");


    }*/

    ?>



Example 4

mysql_update.php


    <?php

    //File Name of the video is (mysql_part7_854 x 480)

    //connect include
    require("connection.php");

    $peoplename =$_POST['peoplename'];
    $tochange =$_POST['tochange'];

    if ($peoplename && $tochange)
    {

    $change =mysql_query("UPDATE people1 SET firstname='tochange' WHERE id='$peoplename'");


    }

    ?>



Example5

mysql_update1.php


    <?php

    //File Name of the video is (mysql_part8_854 x 480)

    //connect include
    require("connection.php");

    $peoplename = $_POST['peoplename'];

    $tochange = $_POST['tochange'];

    if ($peoplename&&$tochange)
    {

    $change = mysql_query("UPDATE people1 SET firstname='$tochange' WHERE id='$peoplename'");


    }

    ?>