php - Connecting/directing user to its page -

i want make web facebook, twitter, etc. every user has own page. is there easy way without bothering internet security.

from search on net, thought php, mysqli, html5,css way do. don't know how can done. first try....

i made database , put

uid..username...password..uurl(userurl)

-- phpmyadmin sql dump -- version 4.1.14 -- http://www.phpmyadmin.net -- -- host: 127.0.0.1 -- erstellungszeit: 11. jul 2016 um 14:12 -- server version: 5.6.17 -- php-version: 5.5.12  set sql_mode = "no_auto_value_on_zero"; set time_zone = "+00:00";   /*!40101 set @old_character_set_client=@@character_set_client */; /*!40101 set @old_character_set_results=@@character_set_results */; /*!40101 set @old_collation_connection=@@collation_connection */; /*!40101 set names utf8 */;  -- -- datenbank: `demos` --  -- --------------------------------------------------------  -- -- tabellenstruktur für tabelle `users` --  create table if not exists `users` (   `uid` int(11) not null auto_increment,   `username` varchar(50) not null,   `password` varchar(50) not null,   `uurl` varchar(200) not null,   primary key (`uid`),   unique key `username` (`username`) ) engine=innodb  default charset=latin1 auto_increment=4 ;  -- -- daten für tabelle `users` --  insert `users` (`uid`, `username`, `password`, `uurl`) values (2, 'test', '098f6bcd4621d373cade4e832627b4f6', 'de2bef8b980f92e688c369c45af82584'), (3, 'demo1', 'fe01ce2a7fbac8fafaed7c982a04e229', '082b82c6e8fcfba13ac0abebcd391a5e');  /*!40101 set character_set_client=@old_character_set_client */; /*!40101 set character_set_results=@old_character_set_results */; /*!40101 set collation_connection=@old_collation_connection */; 

login.php

<?php     session_start();     include("connection.php"); //establishing connection our database      $error = ""; //variable storing our errors.     if(isset($_post["submit"]))     {         if(empty($_post["username"]) || empty($_post["password"]))         {             $error = "both fields required.";         }else         {             // define $username , $password             $username=$_post['username'];             $password=$_post['password'];              // protect mysql injection             $username = stripslashes($username);             $password = stripslashes($password);             $username = mysqli_real_escape_string($db, $username);             $password = mysqli_real_escape_string($db, $password);             $password = md5($password);              //check username , password database             $sql="select uid users username='$username' , password='$password'";             $result=mysqli_query($db,$sql);             $row=mysqli_fetch_array($result,mysqli_assoc);              //if username , password exist in our database create session.             //otherwise echo error.              if(mysqli_num_rows($result) == 1)             {                 $_session['username'] = $username; // initializing session                 header("location: home.php"); // redirecting other page             }else             {                 $error = "incorrect username or password.";             }          }     }  ?> 

i think need change ...

            if(mysqli_num_rows($result) == 1)             {                 $_session['username'] = $username; // initializing session                 header("location: home.php"); // redirecting user page.... 

but don't know how can it.

any help? or better idea? can post more code if required...