| 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/_work/ |
Upload File : |
<?
// CopyDARStextTo_darsrawtext.php
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
$thisFile=__FILE__; $thisLine=__LINE__; include('application.phpinc');
$headTitle = '_CST_ - Copy DARS text to darsrawtext table';
$pageTitle = '_CST_<br>Copy DARS text to darsrawtext table';
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageHeader.phpinc');
$sectionTitle = '_CST_ - section_Copy DARS text to darsrawtext table';
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionHeader.phpinc');
// Get the DARS info.
$query = "
SELECT darsId,
darsText
FROM `dars`
ORDER BY darsId
";
$darsResult = query_do($query);
$darsResultCount = $_SESSION['qry']['count'];
if (!$darsResultCount) {
$darsRow = '';
$thisFile=__FILE__; $thisLine=__LINE__; include('common/pageHeader.phpinc');
$f_error = 'error_message_goes_here.<span class="d_s_fl"> '.basename(__FILE__).':'.__LINE__.'</span><span class="d_s_fp"> '.__FILE__.':'.__LINE__.'</span>';
$thisFile=__FILE__; $thisLine=__LINE__; include('common/displayErrorsAndMessages.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('common/pageFooter.phpinc');
}
mysql_data_seek($darsResult, 0);
// Loop through all DARS.
while ($darsRow = mysql_fetch_assoc($darsResult)) {
$f_darsId = $darsRow['darsId'];
$f_darsText = $darsRow['darsText'];
// Test for existance of DARS.
$query = "
SELECT darsId,
darsText
FROM `darsrawtext`
WHERE darsId = ".$f_darsId."
";
$darsrawtextResult = query_do($query);
$darsrawtextResultCount = $_SESSION['qry']['count'];
if ($darsrawtextResultCount) {
// DELETE the current entry.
$query = "
DELETE
FROM `darsrawtext`
WHERE darsId = ".$f_darsId."
";
#$darsrawtextDelete = query_do($query);
}
// INSERT the DARS text.
$query = "
INSERT
INTO `darsrawtext` (
darsId,
darsText
) VALUES (
".$f_darsId.",
'".mysql_safe($f_darsText)."'
)
";
$darsrawtextInsert = query_do($query);
echo "INSERTing darsText for darsId $f_darsId.<br>\n";
}
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionFooter.phpinc');
debugTrackEnd();
#setDebugOn();
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageFooter.phpinc');
?>