«Home

How To Create A Shipping Tracking On Website.?

Hi peeps. Am building a shipping company website and am having problems on how to track the info or data from my mysql. How can I view the tracking record I already create in mysql on my website. Which script should I run? I might not be asking the question precisely but for eg. I input my tracking number on fedex, track and it brings out my shipping history. How can I do that? I need help.

Avatar
Newbie
11 answers

its easy to create courier and shipping website with tracking using already made script you only need to get a domain and and host and upload the script

steps to create online courier and tracking website

buy and domain and hosting account preferably anonymous hosting account

login your cpanel account

create mysql database plus users and connect it

upload the sql to phpmyadmin

finally upload the script to file manger and edit the contents, color and logo

watch video on how to create courier website with tracking

you can get the complete already made script here http://www.drtools1.com/2016/08/how-to-create-shipping-and-courier.html

0
Avatar
Newbie

Dear Sir.

Please i saw you post an it is exactly what i have been looking for.

I wish to know how to go about this.

If you can give me some guide it will be very helpful to me and i will highly appreciate your support.

Thanks for understanding

0
Avatar
Newbie

I am available, I understand what you want and can do it, I am a web programmer and available to meet all your web needs whatsoever.

I have a website am currently involved with, almost done and it mirrors what you want, if you are free and would like to check out how to track goods please visit this link: http://example.bondwebsolutions.com/fsl

At the top header, click on admin link, then use this password: admin = username and password = batsignal; you would see a form to create new tracking information. Fill out the form and click Send Now, After that a page shows you want you just inputted, make sure you note your track number and write it down.

Then try to navigate to the home page of the fsl website where you see track icon, actually you can track from any page.

input your tracking number, then click track, your tracking information is displayed.

Let me know if this is what you want.

0
Avatar
Newbie

@cygital: the general rule is to *never* trust user supplied data. the way you are passing $location into your query is insecure and prone to SQL injection attacks. but am sure it was just a proof-of-concept. the Op should read up on prepared statements.

0
Avatar
Newbie

Poster,

I have a full developed php/mysql script for parcel/container delivery that has real-time tracking,it auto-generate tracking number for parcel or container it does not have third party API.

contact me and lets talk if you need or be precise in your problem that needs solution igtechnologyng@gmail.com is my email address

0
Avatar
Newbie

Very easy...I don't know why the admin keeps removing my replies, I am a programmer by profession, I can use C# and php very well, to build a website like fedex/ups i.e. a website like that can't be done here, it needs a bit of coding and also the right creation of tables and authentications.

My name is Peter Bond and am for real, Pls admin.don't hide my reply.

contact me asap and I will teach you how to do it.very easy.

contact info:bonduu@bondwebsolutions.com

0
Avatar
Newbie

please dkings101 can i have your email address or phone number i just travel to malaysia recently so i will need to do some business with you. thanks

0
Avatar
Newbie

1. If you are interested in grabing data based on supplied location "location" it could be other number

then you have to probably do this

assuming you have a form that send location and usertable

// location must not be empty

if(empty($_POST['location'])){

echo 'Sorry, I can not continue without location';

//stop processing

exit;

}

//collect input from html form

$location = $_POST['location'];

$usertable = $_POST['usertable'];

//You must have done your connection to database just like in the above

$query = "select * from $usertable where Location = '$location'";

continue from there as you script is now

2. If you whant to run multiple query

repeat these lines of code

$query = 'SELECT * FROM ' . $usertable;

$result = mysql_query($query);

if($result) {

while($row = mysql_fetch_array($result))

echo $row['Date/Time'] . " " . $row['Event']. " ". $row['Location']. " " . $row['Details'];

echo "

";

}

you can diferentiate the variable like may be $qry if you already have $query

here is what I mean

$query = 'SELECT * FROM ' . $usertable;

$result = mysql_query($query);

if($result) {

while($row = mysql_fetch_array($result))

echo $row['Date/Time'] . " " . $row['Event']. " ". $row['Location']. " " . $row['Details'];

echo "

";

}

$qry = "SELECT Details FROM $usertable";

$result2 = mysql_query($qry);

if($result2) {

while($row2 = mysql_fetch_array($result2))

echo $row2['Details'];

echo "

";

}

I strongly suggest you download PHP manual(www.php.net) if you don't have it already. It will make things easier for you.

Happy coding! It is already late in my office I have to go.

0
Avatar
Newbie

<?php

//Connect To Database

$hostname='ee456874958my.db.6147569.hostedresource.com';

$username='ee456874958my';

$password='Lovely2';

$dbname='ee456874958my';

$usertable='3456746my';

mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');

mysql_select_db($dbname);

$query = 'SELECT * FROM ' . $usertable;

$result = mysql_query($query);

if($result) {

while($row = mysql_fetch_array($result))

echo $row['Date/Time'] . " " . $row['Event']. " ". $row['Location']. " " . $row['Details'];

echo "

";

}

?>

</body>

</html>

,

Also advice on hw to run multiple query on 1 php file

0
Avatar
Newbie

Thanks for ur reply. So grateful. What I meant was tat storing records on mysql and hw to create a script so as to view it on the webpage or which application u advice. ASP or PHP. Pls bro just enlighten me pls.

0
Avatar
Newbie

1. If what you are trying to do is from your website be able to track history from fedex, then you need to write a scraping script.

2. If on the other hand, you are storing the record when order for shipping is made then just fetch the information from whatever table you stored it and show to the user.

I don't think you will get already made script for any of the above, so you have to create it or outsource it. Programmers (I'm one of them) are available here if you are willing to spend a little buck.

0
Avatar
Newbie
Your answer
Add image

By posting your answer, you agree to the privacy policy and terms of service.