Файловый менеджер - Редактировать - /var/www/html/dhandapaniimports/installmentdetail.php
Назад
<?php $tns2 = "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 111.92.43.75)(PORT = 1521)) (CONNECT_DATA = (SID = XE)))"; if ($conn = oci_connect("PDJ","PDJ", $tns2)) { echo "Connected to DataBase"; } else { echo ("could not connect to DataBase"); exit; } $localconn = new mysqli("localhost","root","Ktp@201*","dhandapani"); // Check connection if ($localconn -> connect_errno) { echo "Failed to connect to MySQL: " . $localconn-> connect_error; exit(); } // $s = oci_parse($conn, $selectsql); $mystmt = "select * FROM CHITMEMBERINSTALLMENTDETAIL where TRUNC (CMIDCREATEDDATE) = TRUNC (SYSDATE) ORDER BY CMIDID ASC"; $minrow = 0; // row number of first row to return $maxrow = 500000; // row number of last row to return $pagesql = "select * from ( select a.*, rownum as rnum from ( $mystmt ) a where rownum <= :maxrow) where rnum >= :minrow"; $s = oci_parse($conn, $pagesql); oci_bind_by_name($s, ":maxrow", $maxrow); oci_bind_by_name($s, ":minrow", $minrow); oci_execute($s); echo "<pre>"; $rows = []; while ($row = oci_fetch_assoc($s)) { unset($row['RNUM']); $rows[] = $row; $keys=array_keys($row); $values = array_values($row); $key_placeholders = implode(',',$keys); $values_placeholders = "'" . implode ( "', '", $values ) . "'"; $alreadyexist = "select * from chitmember_installmentdetail where CMIDID='".$row['CMIDID']."'"; $alreadyresult = mysqli_query($localconn,$alreadyexist); $alreadyexistrow = mysqli_fetch_row($alreadyresult); if(!empty($alreadyexistrow)){ $updaterow = ''; $i=0; end($row); $lastkey = key($row); foreach($row as $key=>$value){ $updaterow .= "'".$key."' = '".$value."'"; if($lastkey != $key){ $updaterow .= ","; } $i++; } $query = "UPDATE chitmember_installmentdetail SET $updaterow WHERE CMIDID = '".$row['CMIDID']."'"; }else{ $query = "INSERT INTO chitmember_installmentdetail (".$key_placeholders.") VALUES (".$values_placeholders.")"; } $result = mysqli_query($localconn,$query); } echo "Imported Successfully";exit();
| ver. 1.4 |
Github
|
.
| PHP 7.4.3-4ubuntu2.29 | Генерация страницы: 0.07 |
proxy
|
phpinfo
|
Настройка