Shipping tracking Link output to google search from MYSQL Database
-
This line
$output = "Tracking Number: $tracking_number
Order Number: $sales_order_number
Parts: $parts";I need whatever $tracking_number outputs to become a hyperlink for google search with the outputted number search.
Example
The database outputs
Tracking Number: 923489234 <=This number needs to be a blue hyperlink link to google search with that number search
Order Number: 234324
Parts: 30405324Once that tracking number is search in google, google determines what carrier it is saves me allot of trouble. I wish it was this simple $output = "Tracking Number: $tracking_number link google.com/search?q=$tracking_number any ideas guys. Thanks
The rest of my code is below if you want to view it.
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\_numberOrder Number: $sales_order_number
Parts: $parts";
}
}else{
$output = "No results";
}
}
?>Google shows URL's from the sites it has crawled. To become part of the search-results, they URL's must be submitted to Google. Ask Google to recrawl your URLs - Search Console Help[^]
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
-
Google shows URL's from the sites it has crawled. To become part of the search-results, they URL's must be submitted to Google. Ask Google to recrawl your URLs - Search Console Help[^]
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
somebody said to add this but it does not seem to be working
$output += "
Search"; -
somebody said to add this but it does not seem to be working
$output += "
Search";Of course it didn't. Google doesn't read your code. If your link appears on the web, and that location is indexed, then that URL will be indexed.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
-
Of course it didn't. Google doesn't read your code. If your link appears on the web, and that location is indexed, then that URL will be indexed.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
I think we are getting crossed here on what I need. I have a searchable database that I created, when you enter the order number it outputs this information Tracking Number: Order Number: Parts: ----------------------- Ok lets say my database yielded these results Tracking Number: 123219843 Order Number: 9432 Parts: 234923 Since the database yielded Tracking Number: 123219843 I need to have that number thrown over to google to be searched by google. so it needs to become a link. I dont want to have to phyiscally copy and paste the tracking number into google.
-
I think we are getting crossed here on what I need. I have a searchable database that I created, when you enter the order number it outputs this information Tracking Number: Order Number: Parts: ----------------------- Ok lets say my database yielded these results Tracking Number: 123219843 Order Number: 9432 Parts: 234923 Since the database yielded Tracking Number: 123219843 I need to have that number thrown over to google to be searched by google. so it needs to become a link. I dont want to have to phyiscally copy and paste the tracking number into google.
-
somebody said to add this but it does not seem to be working
$output += "
Search";What do you mean by "not working"? If it generates a link that looks like:
<a href="https://www.google.com/search?q=123219843">Search</a>
then it should work: Search Depending on the tracking code, it might not find the results you want. But it will open a Google search for the tracking code.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
What do you mean by "not working"? If it generates a link that looks like:
<a href="https://www.google.com/search?q=123219843">Search</a>
then it should work: Search Depending on the tracking code, it might not find the results you want. But it will open a Google search for the tracking code.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
well i tried inserting this code
$output += "
Search";into
$output = "Tracking Number: $tracking_number
Order Number: $sales_order_number
Parts: $parts";and it keeps crashing my search box.
I don't know what "crashing my search box" means. I notice you're overwriting the
$outputvariable for each record. Does your search only ever return a single result?
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
I don't know what "crashing my search box" means. I notice you're overwriting the
$outputvariable for each record. Does your search only ever return a single result?
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
correct. i tried doing this
$output = "Tracking Number: $tracking_number
$output += "
Search";Order Number: $sales_order_number
Parts: $parts";but it did not work
How about:
$output = "Tracking Number: $tracking_number<br /><a href=\"https://google.com/search?q=$tracking\_number\\">Search</a><br />Order Number: $sales_order_number<br />Parts: $parts";
NB: You need to escape the quotes inside the string. PHP: Strings - Manual[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
How about:
$output = "Tracking Number: $tracking_number<br /><a href=\"https://google.com/search?q=$tracking\_number\\">Search</a><br />Order Number: $sales_order_number<br />Parts: $parts";
NB: You need to escape the quotes inside the string. PHP: Strings - Manual[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
that did it thanks so much
