private function init() { // Create connection TalentMeDB::$conn = mysqli_connect($this->servername, $this->username, $this->password); // Check connection if (TalentMeDB::$conn->connect_error) { die("Connection failed: " . TalentMeDB::$conn->connect_error); } /* Attempt to select 'talentme_db' as database. If it does not exist, create it. */ if (TalentMeDB::$conn->select_db($this->dbname)) { // select_db returns true if found, false if not found $result = TalentMeDB::$conn->query("SELECT DATABASE()"); $row = $result->fetch_row(); // echo "Current database is " . $row[0] . "\n"; $result->close(); } else { // database $dbname not found, create a new one // echo "No database by the name '$this->dbname' found.\n"; // Create database $sql = "CREATE DATABASE " . $this->dbname; if (TalentMeDB::$conn->query($sql) === TRUE) { TalentMeDB::$conn->select_db($this->dbname); // echo "New database '$this->dbname' created successfully.\n"; $this->createUserTable(TalentMeDB::$conn); $this->createGroupTable(TalentMeDB::$conn); $this->createUserGroupTable(TalentMeDB::$conn); $this->createChatLineTable(TalentMeDB::$conn); } else { // echo "Error creating database: " . TalentMeDB::$conn->error; } } }
public function UserProfile() { $this->conn = TalentMeDB::getConnection(); }
require 'init_database.php'; header('content-type: application/json; charset=utf-8'); header("access-control-allow-origin: *"); $conn = TalentMeDB::getConnection(); // get the q parameter from URL $q = $_REQUEST["q"]; $parserTokens = preg_split("/[\\ \n\\,]+/", $q); if (strlen($q) < 1) { echo "Search term too short"; } else { $json_objs_users = searchForUsers($parserTokens); $json_objs_groups = searchForGroups($parserTokens); $searchResult = array('user' => $json_objs_users, 'group' => $json_objs_groups); echo json_encode($searchResult); } TalentMeDB::close(); function searchForUsers($parserTokens) { global $conn; $sql = "SELECT user_email, first_name, last_name, skills, profile_img, objective FROM UserTable"; $result = $conn->query($sql); if ($result->num_rows != 0) { //echo "Found $result->num_rows users!<br>"; $json_objs_userlist = array(); $data = array(); while ($row = $result->fetch_assoc()) { $searchString = $row["first_name"] . " " . $row["last_name"] . " " . $row["skills"]; $searchTokens = preg_split("/[\\ \n\\,\\:]+/", $searchString); foreach ($parserTokens as $token) { foreach ($searchTokens as $searchToken) { if (in_array($row, $json_objs_userlist)) {
// success: function(response){ // console.log(response); //// alert(response); // } // }); // // } </script> <body onload="adjustScroll()"> <?php require 'init_database.php'; //thee data connection file $conn = TalentMeDB::getConnection(); //get connection object // if(isset($_GET['sender_data'])) // { // $result = json_decode($_GET['sender_data']); // $senderEmail = $result->user_email; //the sender email // $senderGroupId = $result->group_id; //the sender group Id // $senderName = 'Naina Raut'; //the sender name // } $senderEmail = '*****@*****.**'; //the sender email $senderName = 'Naina Raut'; //the sender name //send the current message to DB function sendMessage($sentMsg, $senderChatId, $senderEmail, $groupId) {
public function Chat() { $this->conn = TalentMeDB::getConnection(); }
public function Group() { $this->conn = TalentMeDB::getConnection(); }
public function Backend() { $this->conn = TalentMeDB::getConnection(); }