Systeme like dislike

LES BALISES DE CODE

-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 16, 2014 at 11:16 AM
-- Server version: 5.5.24-log
-- PHP Version: 5.3.13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `test`
--

-- --------------------------------------------------------

--
-- Table structure for table `tutorials`
--

CREATE TABLE IF NOT EXISTS `tutorials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `details` text COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `like_num` bigint(10) NOT NULL,
  `dislike_num` bigint(10) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=Active, 0=Inactive',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tutorials`
--

INSERT INTO `tutorials` (`id`, `title`, `details`, `image`, `like_num`, `dislike_num`, `created`, `modified`, `status`) VALUES
(1, 'Upload image and create thumbnail using PHP', 'This short tutorial will explain how you upload images and create thumbnail of the images using PHP.', 'upload-image-create-thumbnail-using-php.png', 5, 1, '2014-12-15 00:00:00', '2014-12-15 09:08:56', 1),
(2, 'Create Custom Shortcode in WordPress', 'WordPress introduced Shortcode API in version 2.5. Shortcode is a set of functions for creating macro codes.', 'wordpress-shortcode.png', 6, 3, '2014-12-15 00:00:00', '2014-12-16 05:23:20', 1);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

<?php
class Tutorial{
	
	function __construct(){
		//db details
		$db_host = 'localhost';
		$db_user = 'root';
		$db_pass = '';
		$db_name = 'new_vote';
		
		//connect db
		$con = mysql_connect($db_host, $db_user, $db_pass);
		
		//select db
		mysql_select_db($db_name, $con);
	}
	
	function get_rows($id = ''){
		if($id != ''){
			//fetch single row
			$query = mysql_query("SELECT * FROM tutorials WHERE id = $id");
			$data = mysql_fetch_assoc($query);
		}else{
			//fetch all rows
			$query = mysql_query("SELECT * FROM tutorials");
			while($row = mysql_fetch_assoc($query)){
				$data[] = $row;
			}
		}
		return $data;
	}
	
	function insert($data = array()){
		$data_array_num = count($data);
		$columns = "";
		$values = "";
		$i=0;
		foreach($data as $key=>$val){ 
			$i++;
			$sep = ($i == $data_array_num)?"":", ";
			$columns .= $key.$sep;
			$values .= $val.$sep;
		}
		$insert = mysql_query("INSERT INTO tutorials ($columns) VALUES ($values)");
		return $insert?TRUE:FALSE;
	}
	
	function update($data = array(), $conditions = array()){
		$data_array_num = count($data);
		$cols_vals = "";
		$condition_str = "";
		$i=0;
		foreach($data as $key=>$val){
			$i++;
			$sep = ($i == $data_array_num)?'':', ';
			$cols_vals .= $key."='".$val."'".$sep;
		}
		foreach($conditions as $key=>$val){
			$i++;
			$sep = ($i == $data_array_num)?"":" AND ";
			$condition_str .= $key."='".$val."'";
		}

		$update = mysql_query("UPDATE tutorials SET $cols_vals WHERE $condition_str");
		return $update?TRUE:FALSE;
	}
}
?>