#!/usr/local/bin/php

<?php

    ini_set("display_errors", true);
    error_reporting(E_ALL ^ E_NOTICE);

    // requirements

    // your database's name (i.e., username_project1)
    define("DB_NAME", "chandras_stud");

    // your database's username
    define("DB_USER", "chandras_stud");

    // your database's password
    define("DB_PASS", "foobar");

    // database server - localhost in this case
    define("DB_SERVER", "localhost");

    // connect to database server
    if (($connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS)) === FALSE)
        echo ("Could not connect to database server (" . DB_SERVER . ").");

    // select database
    if (mysql_select_db(DB_NAME, $connection) === FALSE)
        echo ("Could not select database (" . DB_NAME . ").");

    $handle = fopen("students.csv", "r");
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
       echo "Student ".$data[0].", aged ".$data[1].", studies ".$data[3]." at ".$data[2]."\n";
       $sql = sprintf("INSERT INTO students VALUES('%s', %d, '%s', '%s')", $data[0], $data[1], $data[2], $data[3]);
       mysql_query($sql);
    }

?>

