• 0

how to redirect to an url

Asked by Un0m3,

 Share

Question

Neowinian

Un0m3

Posted
Posted

My code is to look up a record in a database and go to a target(http://  whatever-is-selected  .com).
You see the target field in the $fetch statement. The option, menu, selection, row display work fine
but noone seems to know the correct method to relocate to the url. This is offline for personal use.

  

<!DOCTYPE><html><head><title>email menu</title></head>
<body><center>
<form name="form" method="post" action="">
<?php
$con=mysqli_connect("localhost","root","","homedb");
//============== check connection
if(mysqli_errno($con))
{echo "Can't Connect to mySQL:".mysqli_connect_error(); exit; }
else
{echo "Connected to mySQL</br>";}
//This creates the drop down box
echo "<select name= 'target'>";
echo '<option value="">'.'--- Select lookup account---'.'</option>';
$query = mysqli_query($con,"SELECT target FROM emailtbl");
$query_display = mysqli_query($con,"SELECT * FROM emailtbl");
while($row=mysqli_fetch_array($query))
{echo "<option value='". $row['target']."'>".$row['target']
.'</option>';}
echo '</select>';
?>
<p><p>
<CENTER>then

<input type="submit" name="submit" value="Submit"/>
</form>
<?php
if(isset($_POST['target']))
{
$name = $_POST['target'];
$fetch="SELECT id, target, called, username, password, purpose, emailused,lastused, count FROM emailtbl WHERE target = '".$name."'";
$result = mysqli_query($con,$fetch);
if(!$result)
{echo "Error:".(mysqli_error($con));}
//display the table
echo '<table border="1">'.'<tr>'.'<td bgcolor="#ccffff align="center">'. 'lookup menu'. '</td>'.'</tr>';
echo '<tr>'.'<td>'.'<table border="1">'.'<tr>'.'
<td bgcolor="#CFB53B align="center">'.'id'.'</td>'.'
<td bgcolor="#CFB53B align="center">'.'target'.'</td>'.'
<td bgcolor="#CFB53B align="center">'.'called'.'</td>'.'
<td bgcolor="#ccffff align="center">'.'username'.'</td>'.'
<td bgcolor="#ccffff align="center">'.'password'.'</td>'.'
<td bgcolor="#ccffff align="center">'.'purpose'. '</td>'.'
<td bgcolor="#ccffff align="center">'.'emailused'.'</td>'.'
<td bgcolor="#CFB53B align="center">'.'lastused'.'</td>'.'
<td bgcolor="#CFB53B align="center">'.'count'. '</td>'.'</tr>';
while($data=mysqli_fetch_row($result))
{echo ("<tr><td>$data[0]</td><td>$data[1]</td><td>$data[2]</td><td>$data[3]</td>
<td>$data[4]</td><td>$data[5]</td><td>$data[6]</td><td>$data[7]</td><td>$data[8]</td></tr>");}
echo '</table>'.'</td>'.'</tr>'.'</table>';
$id="id";
$target="target";
$count="count";
$lastused="lastused";
$sql = "UPDATE emailtbl SET lastused=NOW(), count=$count + 1 WHERE id=$id";
if ($con->query($sql) === TRUE) { echo "Record updated successfully"; }
else { echo "Error updating record: " . $con->error; }
}
?>
<p>
<button onclick="myFunction('<?php echo $target;?>')">go to url</button>
<?php
?>
</body></html>

 

 

scr01.png

 

scr02.png

 

scr03.png

 

scr04.png

Link to comment
https://www.neowin.net/forum/topic/1421829-how-to-redirect-to-an-url/
Share on other sites

3 answers to this question

Recommended Posts

  • 0
Proficient

+Mud W1ggle Subscriber²

Posted
  • Subscriber²
Posted

  

https://www.php.net/manual/en/function.header.php

 

POST the URL back to itself, and then use an isset command to issue a location header

 

some pseudo code for you

 

put this at the top of your PHP code. so it gets executed first

  

if (isset($_POST['url'])) {
	header($_POST['url']);
	die(); // shouldnt be necessary, but safe code is good code
}

 

Sorry I dont have time right now to be more specific in the code, but this should help you

  • +Matthew S. and hellowalkman
  • Like 2
  • 0
Grand Master

+Matthew S. Subscriber²

Posted
  • Subscriber²
Posted 
<button onclick="myFunction('<?php echo $target;?>')">go to url</button>

You'll need to change your code, looks like your trying to use JavaScript here, change this to a postable form like you did for the submit and use the method posted by @Mud W1ggle, 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing