Пример #1
0
 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;
         }
     }
 }
Пример #2
0
 public function UserProfile()
 {
     $this->conn = TalentMeDB::getConnection();
 }
Пример #3
0
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)) {
Пример #4
0
//                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)
{
Пример #5
0
 public function Chat()
 {
     $this->conn = TalentMeDB::getConnection();
 }
Пример #6
0
 public function Group()
 {
     $this->conn = TalentMeDB::getConnection();
 }
Пример #7
0
 public function Backend()
 {
     $this->conn = TalentMeDB::getConnection();
 }