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()
{
$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);
}
}
