| Server IP : 80.241.246.6 / Your IP : 216.73.216.188 Web Server : Apache/2.4.25 (Debian) System : Linux kharagauli 4.9.0-19-amd64 #1 SMP Debian 4.9.320-2 (2022-06-30) x86_64 User : www-data ( 33) PHP Version : 7.0.33-0+deb9u12 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/kharagauli_new/Citizens_feedback/addprograms/ |
Upload File : |
<?php
die('FAIL!!!');
include '../admin/conf.php';
function savaTable($file,$changeCol=0,$changeData=false){
global $baza;
$Rows=explode(chr(10),file_get_contents($file));
$h=""; $qq=array();
foreach($Rows as $Row){
if($h=='') $h=$Row;
else{
$Row=explode(chr(9),trim($Row));
if(count($Row)==2){
$data=trim($Row[1]);
if($changeData){
$data=explode(',',trim($data,'()'));
$d0=explode('|',trim(trim($data[$changeCol]),"'"));
$dd=array();
foreach($d0 as $dv)
$dd[]=$changeData[$dv]['num'];
$dd="'".implode(',',$dd)."'";
$data[$changeCol]=$dd;
$data="(".implode(',',$data).")";
}
$qq[$Row[0]]['data']=$data;
}
}
}
if(count($qq)>0)
foreach($qq as $i=>$q){
$sql=$h.' '.trim($q['data'],',');
$ptk=mysqli_query($baza,$sql);
if($ptk) {
$qq[$i]['num']=mysqli_insert_id($baza);
unset ($qq[$i]['data']);
} else die(mysqli_error($baza).'<br>'.$sql);
}
return($qq);
}
$Questions=savaTable('Questions.txt');
echo "<br><br>Questions = ";
print_r($Questions);
$Questionnaire=savaTable('Questionnaire.txt',1,$Questions);
echo "<br><br>Questionnaire = ";
print_r($Questionnaire);
/*
$ProgramClasses=savaTable('ProgramClasses.txt');
echo "<br><br>ProgramClasses = ";
print_r($ProgramClasses);
$Programs=savaTable('Programs.txt',0,$ProgramClasses);
echo "<br><br>Programs = ";
print_r($Programs);
*/