Miscellaneous Code
  Home arrow Miscellaneous Code arrow MySQL and PHP simple voting class
Codewalker Forums 
  Tutorials  
Database Articles  
Miscellaneous  
Navigation Usability  
PEAR Articles  
Programming Basics  
Server Administration  
XML Tutorials  
  Reviews  
Database Book Reviews  
Linux Book Reviews  
Miscellaneous Reviews  
PHP Book Reviews  
PHP Software Reviews  
Server Admin Reviews  
SQL Tool Reviews  
  Code Gallery  
Content Management Code  
Contest Code  
Counters Code  
Database Code  
Date Time Code  
Discussion Board Code  
Email Code  
File Manipulation Code  
GUI Code  
Link Farm Code  
Miscellaneous Code  
Search Code  
Site Navigation Code  
User Management Code  
Mobile Linux 
App Generation ROI 
IBM® developerWorks 
Download TestComplete 
Forums Sitemap 
Weekly Newsletter 
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MISCELLANEOUS CODE

MySQL and PHP simple voting class
By: Codewalkers
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 7
    2002-06-28

    Table of Contents:

    Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Voting class for posting votings to your homepage, simple to use. Requires MySQL

    By : ShiVAs

    <?php
    class Voting {

    var $db_host; // duomen&#371; baz&#279;s adresas.
    var $db_user; // duomen&#371; baz&#279;s vartotojo vardas.
    var $db_password; // duomen&#371; baz&#279;s slaptažodis.
    var $db_name; // duomen&#371; baz&#279;s vardas.
    var $db_table; // duomen&#371; baz&#279;s lentel&#279;s vardas.

    // j&#363;s&#371; klas&#279;s kodas.

    function Voting($db_host,$db_user,$db_password,$db_name,$db_table)
    {
    // dabar gautus duomenis &#303;rašysim &#303; vidinius klas&#279;s kintamuosius

    $this->db_host=$db_host; // neapsigaukit, po -> pries db_host ženklo "$" nereikia
    $this->db_user=$db_user;
    $this->db_password=$db_password;
    $this->db_name=$db_name;
    $this->db_table=$db_table;

    }


    function CreateTable()
    {
    // D&#279;mesio, duomen&#371; bazei, bei lentelei naudojami tie parametrai kuriuos perdav&#279;te kurdami klas&#281;, t.y. perdav&#279;te konstruktoriui.

    // jungiam&#279;s prie duomen&#371; baz&#279;s serverio
    $db=mysql_connect($this->db_host,$this->db_user,$this->db_password);

    // pasirenkame duomen&#371; baz&#281; su kuria dirbsime
    mysql_select_db($this->db_name,$db);

    // o dabar sukursime pa&#269;ia lentel&#281;.
    // &#303; kintamaj&#303; $sql &#303;rašysime SQL sakin&#303; kuris sukuria m&#363;s&#371; lentel&#281;.

    $sql="CREATE TABLE ".$this->db_table." ( id int(11) NOT NULL auto_increment, maminis_id int(11) NOT NULL default '0', atsakymo_nr int(11) NOT NULL default '0', tekstas varchar(255) NOT NULL default '', starto_data bigint(20) NOT NULL default '0', pabaigos_data bigint(20) NOT NULL default '0', balsai tinyint(4) NOT NULL default '0', PRIMARY KEY (id), KEY id_2(id) )";

    // kaip matome, mes naudojame tok&#303; lentel&#279;s vard&#261; kok&#303; pasi&#279;m&#279;me per konstruktori&#371;.

    // pats k&#363;rimas - užklausa siun&#269;iama &#303; server&#303;

    if(!mysql_query($sql,$db))
    return -2; // -2 pas mus bus DB klaida

    // uždarome ryš&#303; su serveriu.
    mysql_close($db);
    }

    function AddPoll($klausimas, $atsakymai)
    {

    if(empty($klausimas))
    return -1; // klaida, klausimas tuš&#269;ias.

    if(sizeof($atsakymai)<2) // vietoj sizeof() galima naudoti count() - laisvas pasirinkimas
    return -1; // klaida, atsakym&#371; negali b&#363;ti mažiau nei 2

    // jungiam&#279;s prie duomen&#371; baz&#279;s serverio
    $db=mysql_connect($this->db_host,$this->db_user,$this->db_password);

    // pasirenkame duomen&#371; baz&#281; su kuria dirbsime
    mysql_select_db($this->db_name,$db);

    $atsakymu=sizeof($atsakymai); // kiek tur&#279;sime atsakym&#371;

    // paruošiame klausim&#261; d&#279;jimui &#303; duomen&#371; baz&#281;
    $klausimas=addslashes(htmlspecialchars($klausimas));

    // pasiimam dabartin&#303; laik&#261; nuo UNIX epochos sekund&#279;mis
    $laikas=time();

    // Dabar &#303;terpiame klausim&#261; &#303; lentel&#281;
    if(!mysql_query("INSERT INTO ".$this->db_table." (id, maminis_id, atsakymo_nr, tekstas, starto_data, pabaigos_data, balsai) VALUES ('','0','0','$klausimas','$laikas','0','0')",$db))
    return -2; // pas mus -2 bus duomen&#371; baz&#279;s klaida.

    // taigi, klausimas &#303;terptas, pasiimam jo id.
    $klausimo_id=mysql_insert_id();

    // dabar suksim cikl&#261; kol &#303;terpsime visus atskymus.

    for($i=0;$i<sizeof($atsakymai);$i++)
    {
    $atsakymas=addslashes(htmlspecialchars($atsakymai[$i])); // paruošiam atsakymo tekst&#261; d&#279;jimui &#303; DB.

    if(!mysql_query("INSERT INTO ".$this->db_table." (id, maminis_id, atsakymo_nr, tekstas, starto_data, pabaigos_data, balsai) VALUES ('','$klausimo_id','".($i+1)."','$atsakymas','0','0','0')",$db))
    return -2; // klaida - gryžtam.
    }

    // uzdarome ryš&#303; su serveriu.
    mysql_close($db);

    return 0; // viskas gerai, apklausa &#303;terpta.
    }

    function Vote($anketos_id, $balso_nr) {

    // v&#279;l jungiam&#279;s prie serverio
    $db=mysql_connect($this->db_host,$this->db_user,$this->db_password);

    // pasirenkame duomen&#371; baz&#281; su kuria dirbsime
    mysql_select_db($this->db_name,$db);

    if(!$result=mysql_query("UPDATE ".$this->db_table." SET balsai=balsai+1 WHERE id='$anketos_id'",$db))
    return -2; // klaida
    else {
    if(!$result=mysql_query("UPDATE ".$this->db_table." SET balsai=balsai+1 WHERE maminis_id='$anketos_id' AND atsakymo_nr='$balso_nr'",$db))
    return -2; // klaida
    else {
    return 0; // viskas gerai, balsas užskaitytas
    }
    }

    }

    function GetResults() {

    // v&#279;l jungiam&#279;s prie serverio
    $db=mysql_connect($this->db_host,$this->db_user,$this->db_password);

    // pasirenkame duomen&#371; baz&#281; su kuria dirbsime
    mysql_select_db($this->db_name,$db);

    // dabar pasiimsime iš duomen&#371; baz&#279;s paskutin&#303; užduot&#261; klausim&#261;

    if(!$result=mysql_query("SELECT id, tekstas, starto_data, balsai FROM ".$this->db_table." WHERE maminis_id='0' ORDER BY id DESC LIMIT 1",$db))
    return -2; // klaida
    else {
    $klausimas=mysql_fetch_row($result);
    mysql_free_result($result); // atlaisvinam rezultatus.

    $klausimo_id=$klausimas[0];
    $grazinimui=$klausimas; // priskiriame klausimo informacija kintamajam kur&#303; gražinsime.

    $grazinimui[2]=date("Y-m-d",$grazinimui[2]); // laika sekund&#279;mis nuo UNIX epochos paver&#269;iame &#303; mums suprantama dat&#261;.

    $result=mysql_query("SELECT atsakymo_nr, tekstas, balsai FROM ".$this->db_table." WHERE maminis_id='$klausimo_id' ORDER BY atsakymo_nr ASC",$db);
    $grazinimui[]=mysql_num_rows($result); // iš kart po klausimo informacijos seks atsakym&#371; skai&#269;ius, kad mes lengviau gal&#279;tume atspausdinti rezultatus.
    while($arow=mysql_fetch_row($result))
    {
    $grazinimui[]=$arow[0];
    $grazinimui[]=$arow[1];
    $grazinimui[]=$arow[2];
    // taip parašyta tik tam kad j&#363;s suprastum&#279;te kas vyksta, o vyksta atsakym&#371; informacijos kabinimas prie jau m&#363;s&#371; turimo "array" kintamojo galo
    }

    mysql_free_result($result); // atlaisvinam rezultatus
    }

    return $grazinimui; // graziname array'ju.
    }

    }
    ?>

    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

    More Miscellaneous Code Articles
    More By Codewalkers

     

    IBM® developerWorks developerWorks - FREE Tools!


    NEW! Calling all CC Power Users – and those that would like to be!

    Join this Rational Talks to You teleconference, featuring Paul Boustany and Mark Krasovich, to speak to the experts about becoming a Rational ClearCase power user. Get a chance to ask your questions and learn tips and tricks for using Rational ClearCase in Agile development
    FREE! Go There Now!


    NEW! Evaluate Rational Host Access Transformation Services (HATS) Toolkit V7.1

    Visit IBM developerWorks to download a free trial of the Rational Host Access Transformation Services (HATS) Toolkit. The HATS toolkit provides a set of plug-ins for the IBM Rational Software Delivery Platform to help you easily extend your legacy applications. HATS makes your 3270 and 5250 applications available as HTML through the most popular Web browsers, while converting your host screens to a Web look and feel and it also enables you to develop new Web, portal, and rich-client applications.
    FREE! Go There Now!


    NEW! Evaluate WebSphere Extended Deployment Compute Grid V6.1

    Visit IBM developerWorks to download a free trial version of WebSphere Extended Deployment Compute Grid, which lets you schedule, execute, and monitor batch jobs. Because online transaction processing and batch jobs execute simultaneously on the same server resources, you can avoid costly duplication of resources. Compute Grid supports job types of Java transactional batch, compute-intensive and a new type called "native execution", which enables non-Java workloads to run on distributed end points.
    FREE! Go There Now!


    NEW! IBM Enterprise Modernization Sandbox for System z

    IBM Enterprise Modernization solutions help organizations evolve core IT systems towards modern architectures and technologies—reducing the burden of maintenance and freeing up resources to develop new business requirements and capabilities. With the IBM Enterprise Modernization Sandbox for System z you can evaluate IBM Enterprise Modernization solutions focused on five key areas: Assets, Architectures, Skills, Processes and Infrastructures, and Investment. Each solution is based upon real customer experiences and offers a proven path to get you started with your modernization projects.
    FREE! Go There Now!


    NEW! IBM Rational AppScan Standard Edition V7.7

    Secure your Web applications with IBM Rational AppScan Standard Edition V7.7, previously known as Watchfire AppScan. This Web application security testing tool automates vulnerability assessments and scans and tests for common Web application vulnerabilities. Visit IBM developerWorks to download a free trial of IBM Rational AppScan Standard Edition V7.7.
    FREE! Go There Now!


    NEW! Info 2.0: Harnessing the power of Web 2.0 and Enterprise Mashups

    Listen to this webcast to get an overview of Info 2.0 and a technical demo of how to quickly build an enterprise mashup. IBM's Info 2.0 technology leverages emerging Web 2.0 technologies such as mashups, feeds, AJAX, and JSON in order to simplify assembly of information using feeds and services. Come learn about the technical elements of Info 2.0 including the Feed Generation framework, Mashup Engine, and mashup assembly components. Learn how to pull information from databases, departmental information, and the Web to create mashups critical to your company’s success. We will also discuss best practices to help you get started.
    FREE! Go There Now!


    NEW! Rational Talks to You: Grady Booch on Architecture

    Join this Rational Talks to You teleconference on November 29 at 1:00 pm ET to participate in an interactive discusssion with Grady Booch around architecture and reuse. Get your questions answered!
    FREE! Go There Now!


    NEW! Rational Talks to You: Scott Ambler on being agile in a global development environment

    Join this Rational Talks to You teleconference on December 6 at 1:00 pm ET to participate in an agile application development discussion and get your questions answered on using IBM Rational Method Composer in a distributed environment.Get your questions answered!
    FREE! Go There Now!


    NEW! Trial download: IBM Rational Tester for SOA Quality V7.0.1

    Get a free trial download of the latest version of IBM Rational Tester for SOA Quality V7.0.1, a functional and regression testing tool that enables the creation, comprehension, modification and execution of testing GUI-less Web services.
    FREE! Go There Now!


    NEW! Try the IBM SOA Sandbox for Connectivity

    Visit IBM developerWorks to try the IBM SOA Sandbox for connectivity. The SOA Sandbox for connectivity provides a trial environment with the tooling and components to help you explore how to effectively connect your infrastructure and integrate all of the people, processes and information in your company. Use the hosted sandbox to explore SOA techniques that streamline connecting existing IT assets together, as well as learn how to connect them to new business logic.
    FREE! Go There Now!



    All FREE IBM® developerWorks Tools!

    MISCELLANEOUS CODE ARTICLES

    - A Web App Based on a Model for the CodeIgnit...
    - Completing a Model for the CodeIgniter PHP F...
    - Validating Input Data with the CodeIgniter P...
    - Deleting Database Records with the CodeIgnit...
    - Inserting Database Records with a CodeIgnite...
    - Fetching Database Rows with a Model for the ...
    - Model Data and Validation Rules for a Generi...
    - Building a Generic Model for the CodeIgniter...
    - upload image to database sql
    - Random Password Generator
    - BCroot, get the root of a number with BC fun...
    - Find pi in a high precision
    - [PHP5] FORMCHECKER : data validation
    - SPL and ITERATOR : examples
    - Xml with Rss Feeds





    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 1 Hosted by Hostway
    For more Enterprise Application Development news, visit eWeek