Menu
My question is on the output $tracking_number. I would like the tracking number the database outputs to be a link that popups a new tab in google search and searches Google for that tracking number. Another way of saying it would be $trackingnumber outputs a number from the database to become a link to google search so if the database outputs tracking number 9324832028 that number needs to become a clickable link to google search such as google.com/search?q=9324832028 any help would be appreciated.
<?php
$output = NULL;
if(isset($_POST[‘submit’])){
//Connect to the database
$mysqli = NEW MySQLi(“”,””,””,””);
$search = $mysqli->real_escape_string($_POST[‘search’]);
//Query the database
$resultSet = $mysqli->query(“SELECT * FROM invlist WHERE sales_order_number = ‘$search'”);
if($resultSet->num_rows > 0){
while($rows = $resultSet->fetch_assoc())
{
$tracking_number = $rows[‘tracking_number’];
$sales_order_number = $rows[‘sales_order_number’];
$parts = $rows[‘parts’];
$output = “Tracking Number: $tracking_number<br />Order Number: $sales_order_number<br />Parts: $parts”;
}
}else{
$output = “No results”;
}
}
?>
<form method=”POST”>
<input type=”TEXT” name=”search” />
<input type=”SUBMIT” name=”submit” value=”Search” />
</form>
<?php echo $output; ?>