$result = mysql_query("SELECT * FROM table WHERE id = ?");

mysqli_stmt_bind_result($stmt, $result);

<?php
    $host = 'localhost';
    $user = 'root';
    $pass = '1234';
    $data = 'test';

    $mysqli = new mysqli($host, $user, $pass, $data);
    /* check connection */
    if (mysqli_connect_errno()) {
        printf("Connect failed: %sn", mysqli_connect_error());
        exit();
    }

    if ($stmt = $mysqli->prepare("SELECT * FROM sample WHERE t2 LIKE ?")) {
        $tt2 = '%';

        $stmt->bind_param("s", $tt2);
        $stmt->execute();

        $meta = $stmt->result_metadata();
        while ($field = $meta->fetch_field())
        {
            $params[] = &$row[$field->name];
        }

        call_user_func_array(array($stmt, 'bind_result'), $params);

        while ($stmt->fetch()) {
            foreach($row as $key => $val)
            {
                $c[$key] = $val;
            }
            $result[] = $c;
        }

        $stmt->close();
    }
    $mysqli->close();
    print_r($result);
    ?>

$con=mysqli_connect( "$host", "$mysql_u", "$mysql_p","$mysql_db");/*these variables are ur host,username, password and db name*/
    $val="SELECT * FROM table";
    $ex=mysqli_query($con,$val);
    while ($row = mysqli_fetch_assoc($ex)) {

    $ans=$row['col1'];
    ....
    }

$stmt = $mysqli->prepare("SELECT id, label FROM test WHERE id = 1");
$stmt->execute();
$res = $stmt->get_result();
$row = $res->fetch_assoc();

printf("id = %s (%s)n", $row['id'], gettype($row['id']));
printf("label = %s (%s)n", $row['label'], gettype($row['label']));

$result = mysql_query("SELECT * FROM table");

$result = mysqli_query("SELECT * FROM table");

$result = mysql_query("SELECT * FROM table WHERE id = ?");


/* create a prepared statement */
if ($stmt = mysqli_prepare($link, "SELECT col1, col2  FROM table WHERE id = ?")) {

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

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


    /* fetch associative array */
    while ($row = mysqli_fetch_assoc($stmt)) {
        printf ("%s (%s)n", $row["col1"], $row["col2"]);
    }


}else{
    echo "prepared failed";
}