<?php
session_start();
require '../config.php';
require '../functions.php';
if (!$_SESSION['is_logged_in']) {
if (!redirect_signin()) {
die('Something went wrong on the friend_search page.');
}
}
$search_query = $_GET['search_query'];
// for($i =0; $i < sizeof($search_query); $i++){
// $search_query_regex .= "[" . $search_query[$i] . "]";
// }
$search_query_like = '%' . $search_query . '%';
$connect = mysql_connect($db_hostname, $db_username, $db_password);
if (!$connect) {
die('Connection to mysql failed, error : ' . mysql_error());
}
if (!mysql_select_db($db_db)) {
die('Cannot connect to db : $db_db, ' . mysql_error());
}
if (!empty($search_query)) {
$registered_users_sql = "SELECT username \n FROM registered_users \n WHERE username LIKE '{$search_query_like}'\n LIMIT 10";
$registered_users = mysql_query($registered_users_sql);
while ($user = mysql_fetch_assoc($registered_users)) {
$json_user['username'] = $user["username"];
$json_user_response[] = $json_user;
}
$search_arr = array("users" => $json_user_response);
} else {
<?php require 'functions.php'; redirect_signin(); ?>
