<?php
//if(isset($_POST["employee_id"])) {
//$id=$_POST["employee_id"];
$stmt = $con -> prepare ( "SELECT name,address,gender,designation,age FROM tbl_employee WHERE id = 119" ) ;
/*Verificamos que la preparación fue correcta*/
if ( $stmt ) {
/*Si el campo id es VARCHAR cambias la "i" por una "s" en bind_param*/
//$stmt->bind_param("i", $id);
$stmt -> execute ( ) ;
/*Aquí pasamos $stmt a nuestra función para que cree el arreglo asocitativo*/
$arrResultado = get_result( $stmt ) ;
} else {
$arrResultado = array ( "error" => $stmt -> error ) ; }
//}
/*Esta es la función que menciono en el punto 2*/
function get_result( $Statement ) {
$Statement -> store_result ( ) ;
for ( $i = 0 ; $i < $Statement -> num_rows ; $i ++ ) {
$Metadata = $Statement -> result_metadata ( ) ;
while ( $Field = $Metadata -> fetch_field ( ) ) {
$PARAMS [ ] = & $RESULT [ $i ] [ $Field -> name ] ;
}
$Statement -> fetch ( ) ;
}
return $RESULT ;
}
PD9waHAKCi8vaWYoaXNzZXQoJF9QT1NUWyJlbXBsb3llZV9pZCJdKSkgIHsKICAgIC8vJGlkPSRfUE9TVFsiZW1wbG95ZWVfaWQiXTsKICAgICRzdG10ID0gJGNvbi0+cHJlcGFyZSgiU0VMRUNUIG5hbWUsYWRkcmVzcyxnZW5kZXIsZGVzaWduYXRpb24sYWdlIEZST00gdGJsX2VtcGxveWVlIFdIRVJFIGlkID0gMTE5Iik7CgogICAgLypWZXJpZmljYW1vcyBxdWUgbGEgcHJlcGFyYWNpw7NuIGZ1ZSBjb3JyZWN0YSovCiAgICBpZiAoJHN0bXQpIHsKICAgICAgICAvKlNpIGVsIGNhbXBvIGlkIGVzIFZBUkNIQVIgY2FtYmlhcyBsYSAiaSIgcG9yIHVuYSAicyIgZW4gYmluZF9wYXJhbSovCiAgICAgICAgLy8kc3RtdC0+YmluZF9wYXJhbSgiaSIsICRpZCk7CiAgICAgICAgJHN0bXQtPmV4ZWN1dGUoKTsKICAgICAgICAvKkFxdcOtIHBhc2Ftb3MgJHN0bXQgYSBudWVzdHJhIGZ1bmNpw7NuIHBhcmEgcXVlIGNyZWUgZWwgYXJyZWdsbyBhc29jaXRhdGl2byovCiAgICAgICAgJGFyclJlc3VsdGFkbyA9IGdldF9yZXN1bHQoJHN0bXQpOyAgICAgIAogICAgfWVsc2V7CiAgICAgICAgJGFyclJlc3VsdGFkbz1hcnJheSgiZXJyb3IiPT4kc3RtdC0+ZXJyb3IpOwogICAgfQogICAgZWNobyBqc29uX2VuY29kZSgkYXJyUmVzdWx0YWRvKTsKLy99IAoKCi8qRXN0YSBlcyBsYSBmdW5jacOzbiBxdWUgbWVuY2lvbm8gZW4gZWwgcHVudG8gMiovCmZ1bmN0aW9uIGdldF9yZXN1bHQoICRTdGF0ZW1lbnQgKSB7CiAgICAkUkVTVUxUID0gYXJyYXkoKTsKICAgICRTdGF0ZW1lbnQtPnN0b3JlX3Jlc3VsdCgpOwogICAgZm9yICggJGkgPSAwOyAkaSA8ICRTdGF0ZW1lbnQtPm51bV9yb3dzOyAkaSsrICkgewogICAgICAgICRNZXRhZGF0YSA9ICRTdGF0ZW1lbnQtPnJlc3VsdF9tZXRhZGF0YSgpOwogICAgICAgICRQQVJBTVMgPSBhcnJheSgpOwogICAgICAgIHdoaWxlICggJEZpZWxkID0gJE1ldGFkYXRhLT5mZXRjaF9maWVsZCgpICkgewogICAgICAgICAgICAkUEFSQU1TW10gPSAmJFJFU1VMVFsgJGkgXVsgJEZpZWxkLT5uYW1lIF07CiAgICAgICAgfQogICAgICAgIGNhbGxfdXNlcl9mdW5jX2FycmF5KCBhcnJheSggJFN0YXRlbWVudCwgJ2JpbmRfcmVzdWx0JyApLCAkUEFSQU1TICk7CiAgICAgICAgJFN0YXRlbWVudC0+ZmV0Y2goKTsKICAgIH0KICAgIHJldHVybiAkUkVTVUxUOwp9IAoKCnZhcl9kdW1wKCRhcnJSZXN1bHRhZG8pOw==