Subversion Repositories cheapmusic

Rev

Rev 78 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
78 - 1 
<?php
44 - 2 
        ini_set("display_errors", 0);
3 
        ini_set("log_errors", 1);
96 - 4 
        ini_set("error_log", $_SERVER['DOCUMENT_ROOT'] . "/../MyFiles/logs/php_error.log");
44 - 5 
 
6 
	$db_username = 'vh3504_admin';
7 
	$db_password = 'uwe2592';
8 
	$db_name     = 'vh3504_cheapmusic';
9 
 
10 
	// Connect to the database
11 
	$link = mysqli_connect('localhost', $db_username, $db_password, $db_name);
12 
	if (!$link) {
13 
		die('Could not connect: ' . mysqli_error($link));
14 
	}
15 
 
16 
/*
17 
	// Drop table
18 
	$result = mysqli_query($link, 'DROP TABLE barcodes');
19 
	if(!$result) {
20 
		die('Drop failed: '.mysqli_error($link));
21 
	}
22 
 
23 
	// Create the table
24 
	$result = mysqli_query($link, 'CREATE TABLE barcodes(id INT NOT NULL AUTO_INCREMENT, '.
25 
	                      'PRIMARY KEY(id), firstname VARCHAR(30), lastname VARCHAR(30))',$link);
26 
	if(!$result) {
27 
		die('Create table Error: '.mysqli_error($link));
28 
	}
29 
*/
30 
 
31 
    $handle = fopen("barcodes.txt", "r");
32 
    if ($handle) {
33 
        while (($line = fgets($handle)) !== false) {
34 
        	// Insert data
35 
        	$result = mysqli_query($link, $line);
36 
        	if(!$result) {
37 
        		die('Insert failed: ' . mysqli_error($link));
38 
        	}
39 
        }
40 
 
41 
        fclose($handle);
42 
    }
43 
 
44 
	// Close connection
45 
	mysqli_close($link);
46 
?>