#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    43
    Rep Power
    4

    Http Listen server


    I will receive link like
    https://my_url/script?onum=123456789&balance=3.40

    I want somehow store from each url specific values to a sql database or forward them to an email

    E.g. Table A Onum | Balance 123456 3.40

    Thank you
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,178
    Rep Power
    4274
    which application language are you using? perl? php?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    43
    Rep Power
    4
    Originally Posted by r937
    which application language are you using? perl? php?
    We havent created anything yet ..i posted here for instructions , how can be done etc etc
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,178
    Rep Power
    4274
    okay, in that case, what you need to know is that you will take the url, analyze it with your application language, and enter the values into the database something like this ---
    Code:
    INSERT
      INTO TableA ( Onum , Balance )
    VALUES ( '$onum' , '$balance' )
    here $onum and $balance are variables that are created by your application language which has analyzed the url and pulled out the appropriate values

    that's how can be done
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo