MySQL (Part 5)

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



mysql.php


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

    //write some data
    //$date = date("Y-m-d");
    //$write = mysql_query("INSERT INTO people1 VALUES ('','Muthu','Media','1985-03-15','M')");


    //update data
    //$update  = mysql_query("UPDATE people1 SET dob='1989-11-16' WHERE id='6'");

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

    echo "Last person to be inserted into table was....<br>";

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


    echo "Text ";

    }

    ?>






Example 4


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

    //write some data
    //$date = date("Y-m-d");
    //$write = mysql_query("INSERT INTO people1 VALUES ('','Muthu','Media','1985-03-15','M')");


    //update data
    //$update  = mysql_query("UPDATE people1 SET dob='1989-11-16' WHERE id='6'");

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

    echo "Last person to be inserted into table was....<br>";

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

    if ($gender=="F")
        $gender = "Female";
    else
        $gender = "Male";

    echo "$firstname $lastname  was born $dob and is $gender  <br> ";

    }

    ?>