PHP Classes

File: votingfiles/create_tables.php

Recommend this page to a friend!
  Classes of MarPlo  >  PHP AJAX Voting Script  >  votingfiles/create_tables.php  >  Download  
File: votingfiles/create_tables.php
Role: Auxiliary script
Content type: text/plain
Description: php code to create mysql tables
Class: PHP AJAX Voting Script
Store up or down user votes in MySQL or files
Author: By
Last change:
Date: 3 years ago
Size: 919 bytes


Class file image Download

// if SVOTING is 'mysql', create tables, else, output mesage to set 'mysql'
if(SVOTING == 'mysql') {
// Table that stores the users who voted in current day
$sqlc[$obVot->votusers] = "CREATE TABLE `$obVot->votusers` (`day` INT(2), `voter` VARCHAR(15), `item` VARCHAR(200) NOT NULL DEFAULT '') CHARACTER SET utf8 COLLATE utf8_general_ci";

// Table to store items that are voted
$sqlc[$obVot->votitems] = "CREATE TABLE `$obVot->votitems` (`item` VARCHAR(200) PRIMARY KEY NOT NULL DEFAULT '', `vote` INT(10) NOT NULL DEFAULT 0, `nvotes` INT(9) NOT NULL DEFAULT 1) CHARACTER SET utf8 COLLATE utf8_general_ci";

// traverse the $sqlc array, and calls the method to create the tables
foreach($sqlc AS $tab=>$sql) {
$obVot->sqlExecute($sql) !== false) echo "<h4>The '$tab' table was created</h4>";
else echo
'Set "mysql" value to SVOTING, in voting.php';