MySQL (Part 4)

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


    while ($row = mysql_fetch_assoc($extract))
    {


    }

    ?>