Subversion Repositories cheapmusic

<?php
        ini_set("display_errors", 0);
        ini_set("log_errors", 1);
        ini_set("error_log", $_SERVER['DOCUMENT_ROOT'] . "../MyFiles/logs/php_error.log");

        $db_username = 'vh3504_admin';
        $db_password = 'uwe2592';
        $db_name     = 'vh3504_cheapmusic';

        // Connect to the database
        $link = mysqli_connect('localhost', $db_username, $db_password, $db_name);
        if (!$link) {
                die('Could not connect: ' . mysqli_error($link));
        }

/*
        // Drop table
        $result = mysqli_query($link, 'DROP TABLE barcodes');
        if(!$result) {
                die('Drop failed: '.mysqli_error($link));
        }

        // Create the table
        $result = mysqli_query($link, 'CREATE TABLE barcodes(id INT NOT NULL AUTO_INCREMENT, '.
                              'PRIMARY KEY(id), firstname VARCHAR(30), lastname VARCHAR(30))',$link);
        if(!$result) {
                die('Create table Error: '.mysqli_error($link));
        }
*/

    $handle = fopen("barcodes.txt", "r");
    if ($handle) {
        while (($line = fgets($handle)) !== false) {
                // Insert data
                $result = mysqli_query($link, $line);
                if(!$result) {
                        die('Insert failed: ' . mysqli_error($link));
                }
        }

        fclose($handle);
    }

        // Close connection
        mysqli_close($link);
?>