4 replies
  • WEB DESIGN
  • |
There is a script on the top left hand side on these two websites Tyres - Up to 40% Cheaper & FREE Mobile Fitting - UK's No.1 - etyres and UK Tyres Online: Cheap Car Tyres Shop | Blackcircles.com where visitors are able to perform searches for tires, and eventually make an order.

How is such a script built? Is it an excel database?

How does it work?

Any info you can provide would be appreciated.

Thank you.

Stewart
  • Profile picture of the author jminkler
    Excel is not a database, it is a spreadsheet.

    Access is a Database much like Oracle, MySQL, or Postgres. Though, I would not put Access in nearly the same ballpark.

    So, on to your question.

    This script has two parts, and is fairly complex, so try to stick with me

    First the HTML form itself. There is some magic going on here. Notice how all the fields arent available at the start. As you pick the first element, the available options appear for only that first selection. At each phase, a call from Javascript back to the server end requests the available options for the next step with what was already entered. The server side script then asks the database something like .. (in plain english)

    select for me the 'z' tire information from the tires table where the user has selected 'x' and 'y' already

    in database language it may look something like

    select t.size from tires t where t.width = '30' and profile = 0;

    The server then responds back to the javascript code and updates the drop down with only the proper selections (noticed the pause in between selecting different options), when the next selectionis made, another call to the server is made.

    When the user is finished, this form is then submit back to the server all "complete" to do a search on the tires that match all the criteria. The server again calls the database to get a list of all tires that match, and the server code then is built so that it can display the proper HTML that the browser can understand.

    These systems, can be somewhat complex, but are pretty trivial for an experienced programmer.
    {{ DiscussionBoard.errors[3378473].message }}
    • Awesome reply. Thanks for investing your time to help me out. It helps me to understand the scale of the job when approaching programers.

      I forgot to mention that they have a shopping cart built into the script so the visitor can make an online purchase.

      How would that be incorperated into the script. The site will be built on Wordpress.

      Thank you.

      Stewart
      {{ DiscussionBoard.errors[3386652].message }}
      • Profile picture of the author jminkler
        Originally Posted by Stewart Alexander View Post

        Awesome reply. Thanks for investing your time to help me out. It helps me to understand the scale of the job when approaching programers.

        I forgot to mention that they have a shopping cart built into the script so the visitor can make an online purchase.

        How would that be incorperated into the script. The site will be built on Wordpress.

        Thank you.

        Stewart
        Wordpress is not a hammer you nail everything with.
        {{ DiscussionBoard.errors[3386758].message }}
        • Profile picture of the author Revenant45
          Originally Posted by jminkler View Post

          Wordpress is not a hammer you nail everything with.
          Amen.

          All I see (especially on this forum) is people trying to save money by DIY web solutions and wonder why it looks "homebrew" and "unpolished". Wordpress is by NO MEANS a web development tool.

          It is a freakin' BLOG CMS that is open source. Drag and drop web kits ARE NO SUBSTITUTION for real web development. There is no plugin/theme for every little thing.

          The best Wordpress/Joomla/Drupal developers actually know a programming language or two. People need to get clue and quit looking for the easy solution all the time.
          {{ DiscussionBoard.errors[3388905].message }}

Trending Topics