April 6, 2012 at 6:33 am
for example if a user is using a website in that if a user is typing a word for search in that website itself and he can find result
it has to stored in a table what kind of word did the user searched and VisitorIPAddress from where he is acessing this website
April 6, 2012 at 12:17 pm
sivag (4/6/2012)
for example if a user is using a website in that if a user is typing a word for search in that website itself and he can find resultit has to stored in a table what kind of word did the user searched and VisitorIPAddress from where he is acessing this website
Well... if you want to monitor that kind of activity and you "own" such a website you have to write down that information to a table as it happens, init?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 6, 2012 at 12:20 pm
I'm actually a little fuzzy what is being asked..
CEWII
April 6, 2012 at 12:42 pm
OP wants to track by user, by ip address the search word(s) a visitor to his website uses.
Obviously, the search page will need to write this information to a search audit table of some osrt in order to track this information.
April 7, 2012 at 1:50 am
how to create log file and plz tell me what is log file here iam using website for advertising ads
in this iam having search button to search ads if the user user is searching a ads he type the words in a text box and when he press the search button mean the user will see the related ads if the user is click the related ads mean it will open a new tab and it will show the ads website.
and here i just want to create three table
one to identify the ipaddress of the user
and i just want to store the words typed by the user for search and also the result displayed for that
and also i just want to know how many time the a advertisement was viewed my alluser when they are clicking the advertisement
an advertisement will adsid and filename where the ads will be stored
April 7, 2012 at 2:48 am
You could call a stored procedure from your app with the search keyword, the user and the IP address and store the values in the audit table.
An alternative would be a server side trace.
April 7, 2012 at 2:48 am
sivag (4/7/2012)
how to create log file and plz tell me what is log file here iam using website for advertising adsin this iam having search button to search ads if the user user is searching a ads he type the words in a text box and when he press the search button mean the user will see the related ads if the user is click the related ads mean it will open a new tab and it will show the ads website.
and here i just want to create three table
one to identify the ipaddress of the user
and i just want to store the words typed by the user for search and also the result displayed for that
and also i just want to know how many time the a advertisement was viewed my alluser when they are clicking the advertisement
an advertisement will adsid and filename where the ads will be stored
If you require assistance with your entire project, you should probably pay someone - we are unpaid volunteers, not a charity. If you have specific questions, please ask them.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply