Send multiple variables to a URL with POST to SQLSRV + php
david alfredo zuñiga soto
david_alfredo_93 at hotmail.com
Wed Feb 24 18:09:18 EST 2016
Hi all, a little help please.
in my app of LiveCode use this sentence: put "tIDUsr=" & IDUsr & "&tPWD=" & PWD & "&tCorreo"&correo into tArgList post tArgLists to URL "http://172.16.2.130:8080/BuscarNombreUsr.php" put it into encodeNombre
Presumably, sent the user id, password and mail my script of php.. but. This only marks | Undefined index: tIDUsr in| and this is for all data sent..
my script php does this..
<?phpinclude 'conexion.php'; # the connection works fine. $IDUsr=$_POST["tIDUsr"]; $nIDUsr=(int)$IDUsr; #convertir la cadena a entero, para comparar con tynit en la bd $PWD=$_POST["tPWD"]; $Correo=$_POST["tCorreo"]; $query = "SELECT Nombre FROM tblusuarios WHERE IDUsuario='$nIDUsr' and Contraseña='$PWD' and Correo='$Correo'"; $stmt4 = sqlsrv_query( $conn, $query); if( $stmt4 === false) { echo "Error in query preparation/execution.\n"; die( print_r( sqlsrv_errors(), true)); } while( $row = sqlsrv_fetch_array( $stmt4, SQLSRV_FETCH_ASSOC)) { echo $row['Nombre']."\n"; } $stmt4 = null; $conn = null;?>
any suggestions ?? thanks for everything
More information about the use-livecode
mailing list