Fwd: INSERT PHP 7

From: Flor Avila <favila(at)gepesat(dot)com>
To: pgsql-es-ayuda(at)lists(dot)postgresql(dot)org
Subject: Fwd: INSERT PHP 7
Date: 2021-03-05 17:48:49
Message-ID: CAF_04JEwebL5kpXRO5Ad4sP0PXs+qyibyifU_Xn79QKZ=qEg6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Agradecere si me brindan una respuesta a mi consulta.
Gracias,
Flor

---------- Forwarded message ---------
De: Flor Avila <favila(at)gepesat(dot)com>
Date: jue, 4 mar 2021 a las 11:59
Subject: INSERT PHP 7
To: <pgsql-es-ayuda(at)postgresql(dot)org>, <pgsql-es-ayuda(at)lists(dot)postgresql(dot)org>

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

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Daniel Carrero 2021-03-05 18:10:41 Re: INSERT PHP 7
Previous Message Anthony Sotolongo 2021-03-05 17:42:17 Re: Tiempo entre cambio de valores