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); } }