Script ASP - Counters: Click counter with db - Morpheusweb.it - Webmaster resources: programming, asp script, using asp, file asp, asp, asp post, database asp, asp login, vb asp, asp access, asp download, asp script, formmail, area riservata, paginazione, scripts asp, mailform, asp script download

ABOUT >
WORKS >
CONTACT ME >
>

Home Page
> Script ASP
> Script ASP Counters
> Click counter with db

Click counter with db

Counter of click on a determined link.
It memorizes the information about the clicks in a database.



					
					Clicks are saved in a database.

					The database is on the root, and has two fields: ID (counter) and click (numeric). 

					<% 

					database = "click.mdb" 

					strConn = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & server.mappath(database) 

					SQL = "INSERT INTO click (count) values(1) WHERE ID = " & request.querystring("codice") 

					Set rs = Server.CreateObject("ADODB.Recordset") 

					rs.Open SQL, strConn 

					response.redirect ( Request.Querystring("url") ) 

					%>