Yo tuve un problema también con PHP y una consulta muy grande- Y tuve que
aplicar un chunk, aunque mi problema era con codeigniter pero se puede
tratar de lo mismo.
Saludos!
_________________
····· ¢Ð@ŋı€łg ·····
¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬
"Ningún hombre es más grande que el que se vence a sí mismo por cumplir con
su deber.."
Eugenio María De Hostos
[Imprima sólo si es necesario, cuidemos nuestro planeta]
On Thu, Mar 4, 2021 at 1:59 PM Flor Avila <fav...@gepesat.com> wrote:
> Buenos dias,
> Tengo una base de datos con postgres11 ahi hay una tabla historica que
> necesito hacer insert desde un programa php7, lo que sucede es que cuando
> hago insert no lo realiza y no se porque, les comento que antes se
> realizaba este insert desde un programa visual basic 6 en donde se tenia
> que usar dos string xq por lo grande del insert no soportaba y era asi:
> ws_execute = ""
> ws_execute = "INSERT INTO history.gpn_history (gps_id, history_lat,
> history_lon, history_date, history_altitude, history_angle, history_speed,
> history_command,
> history_quality, history_street, history_d01, history_d02, history_d03,
> history_d04, history_d05, history_d06, history_d07, history_d08,
> history_d09, history_d10,
> history_d11, history_d12, history_d13, history_d14, history_d15,
> history_d16, history_d17, history_d18, history_d19, history_d20,
> history_a01, history_a02,
> history_a03, history_a04, history_a05, history_a06, history_a07,
> history_a08, history_a09, history_a10, history_a11, history_a12,
> history_a13, history_a14,
> history_a15, history_a16, history_a17, history_a18, history_a19,
> history_a20)
> values ('" & ws_gps_id & "', " & ws_gpn_lat & ", " & ws_gpn_lon & ", '" &
> wd_gpn_date, 0, " & CStr(wi_gpn_angle) & ", " & CStr(wi_gpn_speed), 'BP05',
> " & CStr(wi_gpn_quality) '& ", " & ws_d01
> ws_execute1 = ""
> ws_execute1 = ", '" & ws_gps_model & "', '" & ws_d01 & "', '" & ws_d02 &
> "', '" & ws_d03 & "', '" & ws_d04 & "', '" & ws_d05 & "', '" & ws_d06 & "',
> '" & ws_d06 & "', '" & ws_d08 & "', '" & ws_d09 & "', '" & ws_d10 & "', '"
> & ws_d11 & "', '" & ws_d12 & "', '" & ws_d13 & "', & ws_d14 & "', '" &
> ws_d15 & "', '" & ws_d16 & "', '" & ws_d17 & "', '" & ws_d18 & "', '" &
> ws_d19 & "', '" & ws_d20 & "', " & NULL, NULL, NULL, NULL, " & ws_a05 & ",
> NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
> NULL, NULL, NULL)"
>
> Congpnb.Open "gpnext22", "postgres", "Gepesat2012"
> Set RShisb = Congpnb.Execute(ws_execute & ws_execute1)
>
> en php7 no se si tambien debo de usar dos string pero no se como se hace,
> el string que tengo en php 7 es:
> $query = "INSERT INTO history.gpn_history (gps_id, history_lat,
> history_lon,
> history_date, history_altitude, history_angle, history_speed,
> history_command, history_quality, history_street,
> history_d01, history_d02, history_d03, history_d04, history_d05,
> history_d06, history_d07, history_d08, history_d09, history_d10,
> history_d11, history_d12, history_d13, history_d14, history_d15,
> history_d16, history_d17, history_d18, history_d19, history_d20,
> history_a01, history_a02, history_a03, history_a04, history_a05,
> history_a06, history_a07, history_a08, history_a09, history_a10,
> history_a11, history_a12, history_a13, history_a14, history_a15,
> history_a16, history_a17, history_a18, history_a19, history_a20)
> values ('$xid', $ws_gpn_lat, $ws_gpn_lon, '$xdate', 0, $xangle, $xspeed,
> 'BP05', $xquality, '$xmodel',
> '$xd01', '$xd02', '$xd03', '$xd04', '$xd05', '$xd06', '$xd07', '$xd08',
> '$xd09', '$xd10',
> '$xd11', '$xd12', '$xd13', '$xd14', '$xd15', '$xd16', '$xd17', '$xd18',
> '$xd19', '$xd20',
> '$xa01', '$xa02', '$xa03', '$xa04', '$xa05', '$xa06', '$xa07', '$xa08',
> '$xa09', '$xa10',
> '$xa11', '$xa12', '$xa13', '$xa14', '$xa15', '$xa16', '$xa17', '$xa18',
> '$xa19', '$xa20');";*/
> ws_execute1 = ws_execute1 & ", '" & ws_gps_model & "', '" & ws_d01 & "',
> '" & ws_d02 & "', '" & ws_d03 & "', '" & ws_d04 & "', '" & ws_d05 & "', '"
> & ws_d06 & "', '" & ws_d06 & "', '" & ws_d08 & "', '" & ws_d09 & "', '" &
> ws_d10 & "', '" & ws_d11 & "', '" & ws_d12 & "', '" & ws_d13 & "', '"
> ws_execute1 = ws_execute1 & ws_d14 & "', '" & ws_d15 & "', '" & ws_d16 &
> "', '" & ws_d17 & "', '" & ws_d18 & "', '" & ws_d19 & "', '" & ws_d20 & "',
> "
> ws_execute1 = ws_execute1 & " NULL, NULL, NULL, NULL, " & ws_a05 & ",
> NULL, NULL, NULL"
> ws_execute1 = ws_execute1 & ", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
> NULL, NULL, NULL, NULL, NULL)"
> ////
> $result = pg_query($congpnext22, $query) or die('ERROR INSERT HISTORICO
> 22: ' . pg_last_error());
> $cmdtuples = pg_affected_rows($result);
> echo $cmdtuples . " datos grabados 22.";
>
> Agradecere que me puedan ayudar.
> Saludos,
> Flor de Maria Avila Elias
>
