<![CDATA[Code The World — Simple Voting Script]]> https://codetheworld.com/viewtopic.php?id=63 Sun, 15 Jun 2008 16:29:40 +0000 PunBB <![CDATA[Simple Voting Script]]> https://codetheworld.com/viewtopic.php?pid=167#p167 Here's an example simple voting script.

It is a great thing to have if you have multiple pages and use includes for the pages (Like you use PHP Switches (EG: Your URL: index.php?action=about)) as it is highly adaptable. I created it with simplicity in mind. Now you dont have to have PHP Switches in order for this to work.

If you want to use it with PHP Switches (EG: Your url is http://site.com/scripts.php?id=cms) You would do this:

<?php
require('vote_functions.php');
startvoting("SWITCH","GET");
?>

Now, "SWITCH" needs to be replaced with the you guessed it, PHP Switch, as in if your URL is index.php?action=w/e you put in "action" or if its index.php?id=w/e youd put in "id" in place of "SWITCH". What does the "GET" mean? It simply tells it, to get the current information it should get or where it should store it in can be gotten from $_GET['SWITCH'].

Now without the PHP Switch you would do:

<?php
require('vote_functions.php');
startvoting("PAGE","NONE");
?>

Now you would replace "PAGE" with whatever you would like such as "script1" or "page1" or "w/e". and "NONE" means there is nothing special it has to get from the URL.

Here is the code:

db.sql:

DROP TABLE IF EXISTS `voting_ratings`;

CREATE TABLE `voting_ratings` (
  `page` text NOT NULL,
  `ip` text NOT NULL,
  `time` text NOT NULL,
  `rating` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

vote_settings.php:

<?php

   // Edit from here!

   

   $voting['host'] = 'localhost'; // This is your MySQL Host it is usually always localhost

   $voting['db_user'] = ''; // Put your MySQL User

   $voting['db_name'] = ''; // Put your MySQL DB

   $voting['db_pass'] = ''; // Put your MySQL User Password 

   

   // This is the end of the Settings you need to set.
   

   mysql_connect($voting['host'], $voting['db_user'], $voting['db_pass']) or die("<p align=\"center\">Error Connecting to MySQL Server</p>");

   mysql_select_db($voting['db_name']) or die("<p align=\"center\">Error selecting MySQL DB</p>");

?>

vote_functions.php:

   // Include the settings file.
   require('vote_settings.php');

   

   // DO NOT EDIT BELOW THIS LINE UNLESS YOU KNOW WHAT YOU AR DOING ;)
   

   // This is the main function >:)

   function startvoting($page,$type) {

      // What type is it? If its GET lets do it =D

      if($type=='GET') {

         $temp = $_GET[$page];

         $page = $temp;

            if(isset($_POST['vote']))

            {



               $ip = $_SERVER['REMOTE_ADDR'];

               $result = mysql_query("Select * from voting_ratings where page='$page'");

                  while($row = mysql_fetch_array($result)) {

                  $voting['check']=stripslashes($row['ip']);

                  }

               if($voting['check']==null)

                  {

                  $time = date('n/j/Y');

                  $rating = $_POST['rating'];

                  mysql_query("INSERT INTO voting_ratings (`page`,`ip`,`time`,`rating`) VALUES('$page','$ip','$time','$rating')") or die(mysql_error());

                  echo "<p align=\"center\">Thank you! Your rating of $rating has been submitted.</p>";

            }

            else

            { echo "<p align=\"center\">Sorry! You have already voted.</p>"; }

            }

            if(!(isset($_POST['vote'])))

            {

               $result = mysql_query("SELECT * FROM voting_ratings");

                while($row = mysql_fetch_array($result)) {

                 if($row['page']==$page)

                 {

                 $voting['number']++;

                 $voting['current']=stripslashes($row['rating']);

                 $voting['total']=$voting['total']+$voting['current'];

                 }

                }

                

                echo "<div align=\"center\">";

                      if($voting['number']!=null)

                      {

                      $voting['user_rating'] = $voting['total']/$voting['number'];

                      echo "<p align=\"center\">User Rating Average: ",$voting['user_rating']," from ",$voting['number']," votes</p><br />";

                      }

                      else

                      {

                      echo"<p align=\"center\">There are no votes yet! Be the first one!</p>";

                      }

                      echo "<form action=\"\" method=\"POST\">

                      Rating: <select name=\"rating\">

                              <option value=\"1\">1</option>

                              <option value=\"2\">2</option>

                              <option value=\"3\">3</option>

                              <option value=\"4\">4</option>

                              <option value=\"5\">5</option>                             

                             </select>

                              <br />

                      <input type=\"submit\" name=\"vote\" value=\"Submit Rating\"/>

                      </form>

                      </div>";

                      

            }

         }



      if($type=='NONE') {

            if(isset($_POST['vote']))

            {

               $ip = $_SERVER['REMOTE_ADDR'];

               $result = mysql_query("Select * from voting_ratings where page='$page'");

                  while($row = mysql_fetch_array($result)) {

                  $voting['check']=stripslashes($row['ip']);

                  }

               if($voting['check']==null)

                  {

                  $time = date('n/j/Y');

                  $rating = $_POST['rating'];

                  mysql_query("INSERT INTO voting_ratings (`page`,`ip`,`time`,`rating`) VALUES('$page','$ip','$time','$rating')") or die(mysql_error());

                  echo "<p align=\"center\">Thank you! Your rating of $rating has been submitted.</p>";

            }

            else

            { echo "<p align=\"center\">Sorry! You have already voted.</p>"; }

            }

            if(!(isset($_POST['vote'])))

            {

               $result = mysql_query("SELECT * FROM voting_ratings");

                while($row = mysql_fetch_array($result)) {

                 if($row['page']==$page)

                 {

                 $voting['number']++;

                 $voting['current']=stripslashes($row['rating']);

                 $voting['total']=$voting['total']+$voting['current'];

                 }

                }

                

                echo "<div align=\"center\">";

                      if($voting['number']!=null)

                      {

                      $voting['user_rating'] = $voting['total']/$voting['number'];

                      echo "<p align=\"center\">User Rating Average: ",$voting['user_rating']," from ",$voting['number']," votes</p><br />";

                      }

                      else

                      {

                      echo"<p align=\"center\">There are no votes yet! Be the first one!</p>";

                      }

                      echo "<form action=\"\" method=\"POST\">

                      Rating: <select name=\"rating\">

                              <option value=\"1\">1</option>

                              <option value=\"2\">2</option>

                              <option value=\"3\">3</option>

                              <option value=\"4\">4</option>

                              <option value=\"5\">5</option>                             

                             </select>

                              <br />

                      <input type=\"submit\" name=\"vote\" value=\"Submit Rating\"/>

                      </form>

                      </div>";

                      

            }

         }

   }                     

?>

Installation:
1) Create the sql table from the db.sql.
2) save vote_settings.php and vote_functions.php are in the same directory.
3) Open up vote_settings.php and fill out the details (The MySQL user, pass, db, host etc)
4) Put the code(s) in your site as stated above.

NOTE: This script only allows 1 vote per IP wink

]]> Sun, 15 Jun 2008 16:29:40 +0000 https://codetheworld.com/viewtopic.php?pid=167#p167