Username to url redirect

Question

I have a base system installed with a table that should read a username and url but i am a complete noob when it comes to PHP this is what ive got if someone could help me out so that when the username is entered it automatically redirects them the url associated with that account thanks.

 <?php 
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password="root"; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="redirect"; // Table name 

// Connect to server and select databse. 
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB"); 

// username and password sent from form 
$myusername=$_POST['myusername']; 

// To protect MySQL injection (more detail about MySQL injection) 
$myusername = stripslashes($myusername); 

$myusername = mysql_real_escape_string($myusername); 
$sql="SELECT * FROM $tbl_name WHERE username='$myusername'"; 
$result=mysql_query($sql); 

// Mysql_num_row is counting table row 
$count=mysql_num_rows($result); 
// If result matched $myusername and $mypassword, table row must be 1 row 
if($count==1){ 
// Register $myusername, $mypassword and redirect to file"login_success.php" 
$_SESSION['username'] = $myusername;  
$result = mysql_query("SELECT redirect FROM members"); 

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { 
   header("Location: " . $row['redirect']); 
} 
exit(); 
} 
else { 
echo "Wrong Username or Password"; 
} 
?>

Edit: Quick Update basically this has a text entry box which when filled with the correct phrase of password it will redirect you to a external url which is saved with the name on a database. I dont know how to get it so that the redirect happens properly from a text box if anyone has a tutorials on this id enjoy it

Basically I have 1 domain i want them to type in a code and get redirected to a subdomain but there will be a massive list of them — albaslayer, Jan 27 '15 at 12:44
**Important Note:** Never use mysql_* functions. They are [deprecated](http://php.net/manual/en/migration55.deprecated.php#migration55.deprecated.mysql). Use `mysqli` or `PDO` instead. See [this](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php) question. — Anoop S, Jan 27 '15 at 13:07
I'm struggling to see why you are implementing a service which authenticates user access to a publicly available resource. — symcbean, Jan 27 '15 at 13:11
okay lets say its not a username its a phrase to make it easy for a user to redirect to a subsite unique to that phrase for example you type apple it takes you to apple you type banana it takes you to banana etc etc — albaslayer, Jan 27 '15 at 14:13

score 0 · Answer 1 · answered Jan 27 '15 at 12:39

0

if(isset($_SESSION['username'])){
    header("location: http://yoururl/" .$_SESSION['username']);
}

answered Jan 27 '15 at 12:39

Christian Hagdorn

403
4
6

thats fine if i want to redirect to the main site i want to redirect to a link inside the database associated with the username – albaslayer Jan 27 '15 at 12:41

kheengz · Accepted Answer · 2015-01-27T14:19:45.727

-1

 <?php
    if($_POST){

        $host="localhost"; // Host name 
        $username="root"; // Mysql username 
        $password="root"; // Mysql password 
        $db_name="test"; // Database name 
        $tbl_name="redirect"; // Table name 

        // Connect to server and select databse. 
        $con = mysqli_connect($host, $username, $password, $db_name);

        // username sent from the form 
        $myusername = $_POST['myusername']; 
        // To protect MySQL injection (more detail about MySQL injection) 
        $myusername = stripslashes($myusername); 
        $sql = "SELECT * FROM redirect WHERE username='$myusername' LIMIT 1"; 

        $result = mysqli_query($con, $sql);
        // Mysqli_num_row is counting table row 
        $count = mysqli_num_rows($result);
        // If result matched $myusername, table row must be 1 row 
        if($count === 1){
            $_SESSION['username'] = $myusername; 
            $row = mysqli_fetch_array($result, MYSQLI_ASSOC);   
            //redirect to file url from database
            header("Location: " . $row['url']); 
        }else{
            echo 'Invalid Username';
        }
    }else{
?>  

    <html lang="en">
    <head>
        <title>My App</title>
    </head>
    <body>
        <form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
            <input type="text" name="myusername"/>
            <input type="submit" value="submit"/>
        </form>
    </body>
    </html>
<?php } ?>

this should work out...

edited Jan 27 '15 at 14:19

answered Jan 27 '15 at 12:45

kheengz

945
10
9

id | username | url | – albaslayer Jan 27 '15 at 12:47
sorry to be a pain do you think you could add in the html input format for this I think this will work i just am unsure how to test it as i said im a noob when it comes to php – albaslayer Jan 27 '15 at 13:12
ok let me assume the name of your php page is called index.php – kheengz Jan 27 '15 at 13:29
Deprecated: mysql_real_escape_string(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\Index\redirect.php on line 18 – albaslayer Jan 27 '15 at 13:53
i know why it does'nt sorry you have to delete this line $myusername = mysql_real_escape_string($myusername); – kheengz Jan 27 '15 at 13:54
Notice: Undefined index: myusername in C:\wamp\www\Index\redirect.php on line 14 – albaslayer Jan 27 '15 at 14:07
if i may ask what is the name of the page u r working on now? is it redirect.php or index.php? – kheengz Jan 27 '15 at 14:15
I managed to fix it by changing the tablenames it was accessing works like a dream now thanks alot for your help – albaslayer Jan 27 '15 at 14:18
i noticed something else on the form tag
replace that line with this
– kheengz Jan 27 '15 at 14:22
if it did work out for you... remember to rate me up so i can have more reputation... – kheengz Jan 27 '15 at 14:26

adarsh hota · Answer 3 · 2015-01-27T12:57:12.313

-1

Replace this with yours.

$result = mysql_query("SELECT redirect FROM members where username = '.$myusername.'");

edited Jan 27 '15 at 12:57

answered Jan 27 '15 at 12:47

adarsh hota

315
11
23

Quick Update basically this has a text entry box which when filled with the correct phrase of password it will redirect you to a external url which is saved with the name on a database. I dont know how to get it so that the redirect happens properly from a text box if anyone has a tutorials on this id enjoy it – albaslayer Jan 27 '15 at 12:52

Username to url redirect

3 Answers3