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.

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.

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.

<?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

dkings101:

<?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>

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.

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

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

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

@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.

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.

bonduu01: 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.

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

Hello Mr bonduu01 I am Steven, I am really interested in build a tracking site through your guide. I want to build a tracking site and I really need your help in that. I will be so happy if you could help me out of the problem I'm facing. This is my email ( stphenmike00@gmail.com ) and also my skype ( stephen.mike9 ) I will be so happy to read your reply...

No long story

Go to phpMyAdmin and create a table with the following fields

id
tracking_number
ship_date
estimated_date
shipment_type
content
receiver_name
receiver_address
item_location
telephone
status


Once you have created the table fields, create a form on your web page where users can input their tracking number and click track

I will give you the PHP script to retrieve the content from the table row with the specified tracking number for just N5,000

I would have given you links to such website I have created but the owners paid me not to do so

If you are interested you know what to do

i need a javascript of this nature, with code users will be redirected 'show.html' page....pls can someone help me with the script....??

i have just finish developing a courier service website.
if you are interested in this web application, i can give you access to the demo admin or user account. it is easily customizable to fit your actual needs.
my email is josiahaccounts@gmail.com

Please am interested in building a courier tracking site and my question is this, if i use a web builder to bulid a courier site, how do i add tracking to the site i build?

cool

vccghana:
its easy to create this tracking site using php, mysql and html you can watch the video below to see how to create courier website with tracking without any knowledge of php


https://www.youtube.com/watch?v=lntPLy9UgaQ


you can download the video and see sample site of the shipping website at

http://vccghana.com/how-to-create-an-online-shipping-website-tracking

e-mail me lets talk next2design@gmail.com

switchmax8:
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

Please can we get in touch?

eazydon:


Please can we get in touch?

i have a fully functional courier webapp which can also be customize for your specific needs.

if you are interested, contacted 08024496403 whatsapp only.

eazydon:


Please can we get in touch?

Pls forget all this bullish. This guy is a scammer. He also goes by the name EFE PETER or Peter Mensah and his fake website. He just took my money! Pls share. You can read more by visiting link below. Thanks.

http://vccghana-scam..com/

tracker:


Pls forget all this bullish. This guy is a scammer. He also goes by the name EFE PETER or Peter Mensah and his fake website. He just took my money! Pls share. You can read more by visiting link below. Thanks.

http://vccghana-scam..com/

Actually I was able to sort out the issue. Built my own shipping site with complete tracking. I didn't contact him again. I'm sorry about your business with him, how long ago was that bro?

So so disappointed...my fellow Nairalanders, everything is not and should not be about money.
Visit foreign blogs and see how helps are easily and freely ditched out. I am not saying don't try to make money, but we grow by offering help, when we really can without hassles.
If the big tech companies withdrew their scripts and codes and stuffs, I wonder where Nigeria would be on the map, talk-less of most of you out there.
I refused to be advice on benchmarks for charging or when to ask for money, but guys use your heads! IT is all about more and more development, money would naturally come!

tracker:


Pls forget all this bullish. This guy is a scammer. He also goes by the name EFE PETER or Peter Mensah and his fake website. He just took my money! Pls share. You can read more by visiting link below. Thanks.

http://vccghana-scam..com/

i just red a blog post that he is not a scam http://vccghana-scams..com

Creating a shipping or tracking website isn't as difficult as most people think, it is a matter of research. I could remember when i got the Job to create a shipping website for a company in the U.S , yes it took me time but i did my research and was able to create something really creative.

I am the creative director at WWW.BRONZEDESIGNS.COM.NG; we design and develop websites, build applications, we develop brands and business strategies, and we are professional graphic designers. I would not mind to teach you on how to go about this;
Portfolio: Harrysondaniels.info
Email: contactme@harrysondaniels.info,
Phone: 07038364163

if you still need our services please email;
info@bronzedesigns.com.ng
Phone: 07082990087

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

https://www.youtube.com/watch?v=zW8uNTO1_LQ

get the complete script and guide on how to create the site at http://www.drtools1.com/2016/08/how-to-create-shipping-and-courier.html

dkings101:
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.

You really have a long way to go, just keep calm and download the book "php and mysql Web development (4th/5th edition)" --- in it lies your answer.

I do it, check mine 2 shipping tracking companies site with the inside panel totally manageable by the owner, just type in the Order Number window 001test and see the tracking example
http://www.universaluniteddelivery.com/tracking/
http://www.unitednationsdelivery.org/tracking/
If you need something like this, my email tasha@smartfreshdesign.com
Cheers!

you can now create courier tracking website with wordpress watch the video below on how to create courier tracking site with wordpress


https://www.youtube.com/watch?v=pOHl2e6bgAE


visit this link for the complete tutorial http://pauljumbo.com/how-to-create-courier-tracking-website-with-wordpress