| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/_Archive/MMDT1145/_Archive/Final/ |
Upload File : |
<?
// InsertData.php
// There are 14 data items to INSERT.
// What tables you created and what the field (column) names in those tables was up to you.
// In order for InsertData.php to work you must set the information below:
// START of data to be setup before running InsertData.php
// Host and database information.
$hostname = "localhost"; // The hostname of your MySQL server (usually localhost).
$database = ""; // The database name.
$username = ""; // The username to use when connecting to the server and database.
$password = ""; // The password for the username above.
// List of tables.
$tableArray = array();
// Each field may be the same or different tables.
// For each field, enter the table name for that field between the " marks below.
$tableArray[0] = "";
$tableArray[1] = "";
$tableArray[2] = "";
$tableArray[3] = "";
$tableArray[4] = "";
$tableArray[5] = "";
$tableArray[6] = "";
$tableArray[7] = "";
$tableArray[8] = "";
$tableArray[9] = "";
$tableArray[10] = "";
$tableArray[11] = "";
$tableArray[12] = "";
$tableArray[13] = "";
// List of fields.
$fieldArray = array();
// For each field, enter the field name for that field between the " marks below.
$fieldArray[0] = "";
$fieldArray[1] = "";
$fieldArray[2] = "";
$fieldArray[3] = "";
$fieldArray[4] = "";
$fieldArray[5] = "";
$fieldArray[6] = "";
$fieldArray[7] = "";
$fieldArray[8] = "";
$fieldArray[9] = "";
$fieldArray[10] = "";
$fieldArray[11] = "";
$fieldArray[12] = "";
$fieldArray[13] = "";
// END of data to be setup before running InsertData.php
$TRACK = "<b>".basename(__FILE__)."</b> (".__FILE__.")\n<ol>\n";
if (strstr($_ENV['Path'],";")) { $s = ";"; } else { $s = ":"; } ini_set('include_path',"/Data_WWW/CST/$s".ini_get('include_path')); // ** Add the DOCUMENT_ROOT to the include_path.
$skipAuthentication = true;
$authorizedGroups="PUBLIC";
$skipAuthentication = true;
include('Application.phpinc');
set_time_limit(10000);
$headTitle = 'InsertData';
$pageTitle = 'InsertData';
if (isset($_SERVER['SERVER_NAME'])) { $thisFile = __FILE__; include('Common/pageHeader.phpinc'); }
if (isset($_SERVER['SERVER_NAME'])) {
echo "<br><b></b><br><br>\n";
} else {
echo "\n\n";
}
// List of data files.
$fileResult = "product-list-1.txt,product-list-2.txt,product-list-3.txt,product-list-4.txt,product-list-5.txt,product-list-6.txt";
$errorExists = false;
// Verify that all files in the list exist.
$fileArray = split(",",$fileResult);
$allFilesExits = true;
foreach($fileArray as $thisFile) {
if (!file_exists($thisFile)) {
$allFilesExits = false;
$errorExists = true;
if (isset($_SERVER['SERVER_NAME'])) {
echo "<b>The file $thisFile does not exist.</b><br>\n";
} else {
echo "The file $thisFile does not exist.\n";
}
}
}
if (!$allFilesExits) {
if (isset($_SERVER['SERVER_NAME'])) {
echo "<br><b>Not all of the data files are copied to the folder. InsertData cannot continue.</b><br>\n";
} else {
echo "\nNot all of the data files are copied to the folder. InsertData cannot continue.\n";
}
}
// Verify that the database information has been set.
if ($hostname == '') {
$errorExists = true;
if (isset($_SERVER['SERVER_NAME'])) {
echo "<br><b>The \$hostname variable is not set. InsertData cannot continue.</b><br>\n";
} else {
echo "\nThe \$hostname variable is not set. InsertData cannot continue.\n";
}
}
$hostname = "localhost"; // The hostname of your MySQL server (usually localhost).
$database = ""; // The database name.
$username = ""; // The username to use when connecting to the server and database.
$password = ""; // The password for the username above.
echo "Continue<br>\n";
if ($errorExists) { exit; }
$productCount = 0;
$fileArray = split(",",$fileResult);
foreach($fileArray as $thisFile) {
if (isset($_SERVER['SERVER_NAME'])) {
echo "<b>\$thisFile=",$thisFile,"</b><br>\n";
} else {
echo "\$thisFile=",$thisFile,"\n";
}
$productData_fh = fopen($thisFile, 'r');
while (($productLine = fgets($productData_fh)) && $productCount < 10000) {
$productCount++;
if (isset($_SERVER['SERVER_NAME'])) {
echo $productCount," ";
} else {
echo $productCount,"\n";
}
}
fclose($productData_fh);
}
if (isset($_SERVER['SERVER_NAME'])) {
} else {
}
if (isset($_SERVER['SERVER_NAME'])) { $thisFile = __FILE__; include('Common/pageFooter.phpinc'); }
?>