Path: C:\
<?php
ini_set('max_execution_time',259200);
ini_set ('memory_limit','-1');
error_reporting(E_ALL);
ini_set('display_errors', 'On');
date_default_timezone_set('America/Sao_Paulo');
$dt_ato = date("Y-m-d H:i");
function getUserIP()
{
$client = @$_SERVER['HTTP_CLIENT_IP'];
$forward = @$_SERVER['HTTP_X_FORWARDED_FOR'];
$remote = $_SERVER['REMOTE_ADDR'];
if(filter_var($client, FILTER_VALIDATE_IP))
{
$ip = $client;
}
elseif(filter_var($forward, FILTER_VALIDATE_IP))
{
$ip = $forward;
}
else
{
$ip = $remote;
}
return $ip;
}
$user_ip =getUserIP();
require_once("../conexao_srvtms_auxiliar.php");
require_once("../conexao_srvtms.php");
$resultado=sqlsrv_query($conn, "SELECT id_Agenda as idx
FROM dbo.tbdAgenda
ORDER BY id_Agenda ",array(),array("Scrollable"=>"buffered"));
$aux_0='I';
while($row = sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC))
{
$idx=$row['idx'];
echo $idx.'<br>';
$query = sqlsrv_query($conn2,"INSERT INTO [dbo].[sitAgenda]
([id_Agenda]
,[tp_Situacao]
,[ip_Inclusao]
,[dt_Inclusao]
)
VALUES (
" .$idx. "
,'I'
,'".$user_ip."'
,'".$dt_ato."'
)");
}
?>