mysql - PHP voting system - ensure a person can only vote once -

-

I am working on a voting system and I am sure someone can vote only once. I saw the IP handle but I read that there are some IPs in places such as universities, so if a person votes, then most universities are out of voting. Currently I use cookies, which is good till people do not know I am using cookies. Then it becomes easy to delete the cookie and vote again. Is there a reliable way to store a user's vote and to ensure that they can not vote again? This is my current voting script: 

  & lt ;? Php included ("config.php"); // Checks the URL for any GET variable and removes them. $ Url = $ _POST ['url']; $ Arr = Explosion ("?", $ Url, 2); $ Url = $ arr [0]; // ensures that no person went to /vote.php if (empty ($ _ POST ['url'])) {Print '& lt; Script & gt; Window.location = "errorpage"; & Lt; / Script & gt; '; } Else {// Unique ID number for specific match up is $ Idnumber = $ _POST ['id']; // Check to see if there is a cookie with unique mailup ID name. If (! $ _COOKIE [$ idnumber])) {// If voted, go back and display the already voted error Print '& lt; Script & gt; Window.location = "'. $ Url.'? Error = Voted ';  gt;';} Else {// If the user does not have a cookie, then set it to end in 1 year in. the Setkyuki ( "$ idnumber", "1", Strtotem ( '1 year')); // a_vote or sets variable b_vote $ VoteRow = $ _POST [ 'concealment']]; // column name for array allow $ allowable values ​​= array ( "a_vote", "b_vote"); // if not $ Votro a_vote or b_vote, go to the error page. if (! In_array ($ voteRow, allowing $)) {Print '& lt; script & gt; window.location = "errorpage"; & lt; / script & gt; ';} Else {// current vote joins and adds a new value. Foreign currency ($ db- & quot; query ( "SELECT go from $ $ voteRow votes Milan = $ idnumber ' "$ row as) {$ votes = $ row [$ voteRow];} $ Newvotes = $ votes + 1; // update query to send new votes amount to $ Sql ​​=" UPDATE` vote `sET $ voteRow =: newvotes WHERE 'matchup` =: id"; $ statement = $ db- & gt; prepare ($ sql); $ Stetment- & gt; bind value ( "Nuvots" $ Nuvots); $ Statement- & gt; Bind value (": id", $ idnumber); $ Count = $ statement- & gt; carry about (); $ Db = null; // Vote on the success page. Print '& lt; Script type = "text / javascript" & gt; window.location = " '. $ Url.'? vote = success '; & lt; / script & gt;';}}}? & Gt;

< / Html>

Comments

Post a Comment

Popular posts from this blog

import - Python ImportError: No module named wmi -

-
I followed the instructions for downloading WMI for Python When I try to run the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = wmi.WMI (): if Raw_input ("restart% s?"% S.Caption) .upper () == "Y": s.StartService () I got the error < Code> traceback (most recent call end): file ". \", Line 1, edit: I am using Python 2.7.6 EDIT2: I am running 64-bit Windows 2008 R2, and I've downloaded WMI-1.4.9.zip (md5). I removed the content and put it in D: Python \ Tools \ Scripts I executed dragon setup.py.install I said D : \ Python \ tools \ scripts to% PATH% and when I execute the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = Wmi.WMI (): If raw_input ("Restart% s?"% S. Caption). () == "Y": s.StartService () error me Gets traceback (most recent call final): File ". See \", line 1, &
Read more

Editing Python Class in Shell and SQLAlchemy -

-
I am working on the terminal on a shell script after this tutorial SQLAlchemy tutorial. I need to type gt; & Gt; & Gt; Sqlalchemy import column, integer, string & gt; & Gt; & Gt; Class user (base): __tablename__ = 'users' id = column (integer, primary_key = true) name = column (string) absolute name = column (string) password = column (string) def __repr __ (self): return "& lt ; User (name = '% s', absolute name = '% s', password = '% s') & gt; "% (Self.name, self.fullname, self.password) After the problem I have typed the password = column (string) I hit twice and changed .... >> I then took everything back but then an error was thrown because the class already exists ... I am not completely sure how to fix it. How do I open that slip in the shell script and edit it (Add DF to DRR) The error thrown below: / user / giripeters / TFSQLLX / Lib / python2.7 / site-packages / sqlalchemy / ext / decla
Read more

c# - MySQL Parameterized Select Query joining tables issue -

-
I am using parameterized select questions in conjunction with my program and it works entirely, When I try to join the table Everything I have done is a small fraction: using (MySqlCommand cmd = new MySqlCommand (paramQuery) ToSql (), Connection)) /etc/ paramQuery.ToSql () Equal: "Select TableOne ID, Tableon, Department, Tablet. One by name table, Table 2 h Yes TableOnEID = @Pharmak "* / for (Int Index = 0; Index and Lt; ParamariX Parameter (.c calculation; Index ++) Cmd.Parameters.AddWithValue (paramQuery.Parameters (). ElementAt (index). , ParamQuery.Parameters (). ElementAt (index) .Value); / * ParamQuery.Parameters (). ElementAt (index) .k = "@most 0" paramQuery.Parameters (). ElementAt (index) .Value = "tableTwo.ID" * / MySqlDataReader Reader = cmd.ExecuteReader (); While (reader.Read ()) {// do stuff} } One of the tables I attempt to join is For the table, two with the same id for all. Is there something that I'm doing wrong?
Read more