<?php
$conn = sqlsrv_connect( $serverName, $connectionInfo);
$strsql = "SELECT FIRST_NM, LAST_NM, DT_OF_BIRTH FROM EMPLOYEE_DTL WHERE FIRST_NM = ? ";
$stmt = sqlsrv_query( $conn, $strsql, array($first_name));
$user_info = sqlsrv_fetch_array( $stmt);
sqlsrv_free_stmt($stmt);
sqlsrv_close( $conn);
?>

<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "db_name");
/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$first_nm = "From request user input";

/* create a prepared statement */
$stmt =  $mysqli->stmt_init();
if ($stmt->prepare("SELECT FIRST_NM, LAST_NM FROM EMPLOYEE_DTL WHERE FIRST_NM = ? ")) {

    /* bind parameters for markers */
    $stmt->bind_param("s", $first_nm);

    /* execute query */
    $stmt->execute();

    /* bind result variables */
    $stmt->bind_result($FIRST_NM);
    $stmt->bind_result($LAST_NM);

    /* fetch value */
    $stmt->fetch();

    echo("First name: %s and last name: %s\n", $FIRST_NM, $LAST_NM);

    /* close statement */
    $stmt->close();
}

/* close connection */
$mysqli->close();
?>

Post your comments:
Your Name:
Security check:
Your Comment: 1500 chars