Web Hosting Vodahost    

Home Take The Royal Tour! Order Now Features Prices
Go Back   Web Hosting > VodaHost Web Hosting Support > mySQL & PHP

Notices

mySQL & PHP Discussions, information and help with mySQL and PHP.

Reply
 
LinkBack Thread Tools
  #1  
Old 06-24-2008, 06:41 PM
Private
 
Join Date: Jun 2008
Posts: 2
Default Web Query from SQL DB

Hi
I am going to create the Web page for Order Status ( it's very critical for Custmer Satisfaction ). My Web is being hosted by Blue Voda now and my SQL DB is in my store. In the form, customer is supposed to enter customer name and last name, then customer can see whether his order is still pending or done in my web site. It's very simple procedure but I don't know how to define the system and how it works. Would you let me know how I have to define the system and code in Blue Voda and my computer in store ? Thanks in advance.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2  
Old 06-24-2008, 07:09 PM
navaldesign's Avatar
General & Forum Moderator
 
Join Date: Oct 2005
Location: Italy
Posts: 9,346
Default Re: Web Query from SQL DB

Hm.. Which store that is ? How do you update the database with the Order Status ?

No specific answer can be given unless we know the details. Generally speaking, it would be necessary to know:
1. If customerdetails are stored in the same or different tables in the DB
2. If different, two queries are necessary: a first one to retrieve the user ID, from Name and Last NAme, and a second one, to retrieve the order details, using the userID for the query.

As i said, without setails no helpful answer can be given. In any case, the practical part requires at least some php knowledge.
__________________
Navaldesign
Logger Lite: Low Cost, Customizable, multifeatured Login script
Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old 06-24-2008, 10:43 PM
Private
 
Join Date: Jun 2008
Posts: 2
Default Re: Web Query from SQL DB

Thanks for your answer.
It may be in same DB or in separate DB. Because it's just information data, I don't need to check the password. And this program will not update the record in the DB. My intention is to just show current pending orders which is not done yet in the web, where customer enter their ID and Last name. It sounds like I have to code programs and put into my Server which is in connection with my Web hosting server( Blue Voda ). I need your further assistance so as to get more info. Appreciate in advance.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4  
Old 06-24-2008, 10:54 PM
navaldesign's Avatar
General & Forum Moderator
 
Join Date: Oct 2005
Location: Italy
Posts: 9,346
Default Re: Web Query from SQL DB

You can use ABVFP and a simple form made in BV to input the customer and Order details easily in the DB. The second part, would be as follows:
a. You create a form that the client uses to type his ID (Name or other, but, in any case, a field among those stored in the database)
b. You then submit the form to another page, with a script embedded in it. This script "grabbs" the customer details and queries the database. Ir accordingly displays the data on the screen.
It is not a hard script, if you have a minimum of knowledge, but could take you hours (or even days) if you know nothing about php.
__________________
Navaldesign
Logger Lite: Low Cost, Customizable, multifeatured Login script
Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 03:59 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC7
2005-2009 VodaHost Web Hosting Your Perfect Web Host - All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176