<?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(); ?>