<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'WELCHgrape55';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'dasr';
mysql_select_db($dbname);

$bedfile_field = array ( 'bedfile_id','experiment_id','method_id','genome_id','filetype','name','upload_date','expiration','header','descr');
$bedfile_field = join(',',$bedfile_field);
$rawbed_field = array('rawbed_id','bedfile_id', 'filepath');
$rawbed_field = join(',', $rawbed_field);


## bedfile_id = 5
$bedfile_id = 5;
$q = "INSERT INTO bedfile_real (bedfile_id,filetype,name,upload_date,header,descr) VALUES ('$bedfile_id','rawbed','chr1_Stat5_MH',NOW(),'real bed file','visibility=4 itemRgb=On')";
mysql_query($q) or die (mysql_error());
$myFile = "../testing/DB_Data/Type_A_sequence_reads/chr1.bed";
$q="insert into rawbed_real 
(bedfile_id,filepath) 
values 
('$bedfile_id','$myFile')";
mysql_query($q) or die (mysql_error());

?>