人气值:<script src="hits.aspx?id=$Hits$"></script> 次
hits.aspx 代码:
string newsid = Request.QueryString["id"];
OleDbConnection conn = connection.conn();
//更新浏览次数
OleDbCommand comm = new OleDbCommand("Update Content Set Hits=Hits+1 Where ID='" + newsid + "'", conn);
conn.Open();
comm.ExecuteNonQuery();
//读取浏览次数
OleDbCommand comm1 = new OleDbCommand("Select Hits From Content Where HtmlUrl='" + newsid + "'", conn);
OleDbDataReader dr = comm1.ExecuteReader();
if (dr.Read())
{
Response.Write(&"document.write('&" + dr["Hits"].ToString() + "&');&");
}
conn.Close();
hits.aspx 代码:
string newsid = Request.QueryString["id"];
OleDbConnection conn = connection.conn();
//更新浏览次数
OleDbCommand comm = new OleDbCommand("Update Content Set Hits=Hits+1 Where ID='" + newsid + "'", conn);
conn.Open();
comm.ExecuteNonQuery();
//读取浏览次数
OleDbCommand comm1 = new OleDbCommand("Select Hits From Content Where HtmlUrl='" + newsid + "'", conn);
OleDbDataReader dr = comm1.ExecuteReader();
if (dr.Read())
{
Response.Write(&"document.write('&" + dr["Hits"].ToString() + "&');&");
}
conn.Close();
浙公网安备 33010602011771号