function main()
{
require '../includes/connect.php';
$mainTickerSQL = "SELECT * FROM tickers";
$ticker_result = mysqli_query($connect, $mainTickerSQL);
while ($row = mysqli_fetch_array($ticker_result)) {
$companyTicker = $row['ticker'];
$fileURL = createURL($companyTicker);
$companyTextFile = "../TextFiles/" . $companyTicker . ".txt";
$file = getCsvFile($fileURL, $companyTextFile);
fileToDatabase($companyTextFile, $companyTicker);
}
}
function main()
{
$mainTickerFile = fopen("tickerMaster.txt", "r");
$myfile = fopen("tableName.txt", "w");
while (!feof($mainTickerFile)) {
$companyTicker = fgets($mainTickerFile);
$companyTicker = trim($companyTicker);
$fileURL = createURL($companyTicker);
$companyTxtFile = "txtFiles/" . $companyTicker . ".txt";
getCSVFile($fileURL, $companyTxtFile);
$tableName = fileToDatabase($companyTxtFile, $companyTicker);
fwrite($myfile, $tableName . "\n");
}
fclose($myfile);
}
function main()
{
$refresh = false;
$companyTicker = $_GET['ticker'];
$companyTicker = strtoupper($companyTicker);
$fileURL = createURL($companyTicker);
$companyTextFile = "../TextFiles/" . $companyTicker . ".txt";
$file = getCsvFile($fileURL, $companyTextFile);
fileToDatabase($companyTextFile, $companyTicker);
}
function main()
{
// session_start();
$user = $_SESSION['username'];
require '../includes/connect.php';
$mainTickerSQL = "SELECT * FROM {$user}tickers";
$ticker_result = mysqli_query($connect, $mainTickerSQL);
if ($ticker_result = false) {
echo "No Tickers";
return false;
}
if ($ticker_result === FALSE) {
die(mysqli_error($connect));
// TODO: better error handling
}
while ($row = mysqli_fetch_array($ticker_result)) {
$companyTicker = $row['ticker'];
$fileURL = createURL($companyTicker);
$companyTextFile = "../TextFiles/" . $companyTicker . ".txt";
$file = getCsvFile($fileURL, $companyTextFile);
fileToDatabase($companyTextFile, $companyTicker);
}
}
