php-mysql

<?php
$link = mysqli_connect("10.26.88.20", "username", "passwd", "test", 7779);

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}


$city = "1";


mysqli_query($link,"select 1");
mysqli_query($link,"set names gbk");


/* create a prepared statement */
if ($stmt = mysqli_prepare($link, "SELECT ind FROM test WHERE ind=?")) {


    /* bind parameters for markers */
    mysqli_stmt_bind_param($stmt, "i", $city);


    /* execute query */
    mysqli_stmt_execute($stmt);


    /* bind result variables */
    mysqli_stmt_bind_result($stmt, $id);


    /* fetch value */

    mysqli_stmt_fetch($stmt);

    printf("%s is in district %s\n", $city, $id);


    /* close statement */
    //mysqli_stmt_close($stmt);
} else {
    print "failed\n";
}
    //mysqli_query($link,"begin");
    //mysqli_query($link,"commit");


/* close connection */
mysqli_close($link);