Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Location
    UK
    Posts
    22

    New to php/mysql.. how do i do this?

    Hi,

    I am trying to do this kind of thing:

    http://www.prestige-car-leasing.co.u...ial-offers.asp


    Whereby a visitor can click something they are interested in and those details are populated into a web form, with additional options to complete and then email to the sales dept or whatever.

    How do I do this in php/mysql.

    I have already created a database and populated it with data and shown it on web page etc but have come unstuck at doing something clever such is being done on the url above.

    All help greatly received :-)


    Neil

  2. #2
    Join Date
    Apr 2003
    Location
    London, UK
    Posts
    4,695
    well, once you have a unique ID to identify each car/product, there's many ways you can do it, but generally all you'd need to do is:

    Call each of your items by the url such as http://domain.com/cars.php?carID=01

    Then in "cars.php" you would just get the called ID from the url using $_GET

    PHP Code:
    $carID $_GET['carID']; 
    And then use that to select the needed row from your database:

    PHP Code:
    $data mysql_query("SELECT * FROM table_name WHERE carID = '$carID'"); 
    You can then print out the value of each field for that row with a loop:

    PHP Code:
    while($row mysql_fetch_array($data)) {
              
    #print each $row['item']; among your HTML

    Obviously, there's a little more to it than that, you'll want to think about error checking, how you want to display your info and a number of other things, but mabye that'll get you going in the right direction.

  3. #3
    Join Date
    Apr 2004
    Location
    UK
    Posts
    22
    thanks, I not sure if I 100% understand, but will give it go.

    how for example can I pass that cars details e.g make and model into the make and model form fields in cars.php?

  4. #4
    Originally posted by netmotiv8
    thanks, I not sure if I 100% understand, but will give it go.

    how for example can I pass that cars details e.g make and model into the make and model form fields in cars.php?
    build an html form, when they click submit on the form, cars.php gets the data as $_POST['form_field_name'];

    (if you use form method = "post" )

    with that in mind you should be able to find about everything you need at http://www.w3c.org and http://www.php.net

    I've done about 25 custom scripts already getting values out of teh database to populate a form field as a select option, etc. etc... lots of ways to get what you want,

    or you could simply let the user input their own data and use metaphone() function of php to compensate for spelling errors.. (it would see a value of "phord = fword=ford=vord so mispellings that are spelled sounding phonetically the same as the car model and make, etc could easily be used to find data).... it isnt 100% accurate though, so that's kind of over-coding when its a simple matter to make a form with select options.

  5. #5
    Join Date
    Apr 2004
    Location
    UK
    Posts
    22
    Sorry guys, I am not getting head around this. Like I said I am very much a newbie to php/mysql. My level is be able to print and order mysql data on a php page and that about it.

    http://www.prestige-car-leasing.co.u...ial-offers.asp

    As it that example which I came across. In that page they are show a list of cars and when a user clicks on a car they are interested in they are taking to a form which has already had fields completed relating to the car they have selected and this is what I am trying to do

    here is my very basic mock up (apologies for crudeness) http://www.netmotivated.co.uk/projects/mysql/index.php

    this shows the data from the database. Now for each row I want to add a 'more info' link which when clicked takes them to a form like the first link above and passes this data to the appropriate form fields in that form ready for the customer to 'submit'.

    Sorry but a need 'A Dummies guide...'

    I kind of need to see the code required, to learn and understand it.

    Neil

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •