phpBB.de

Code: Alles auswählen

<?php
if ( isset($HTTP_POST_VARS['umfrage_id']) && !empty($HTTP_POST_VARS['umfrage_id']) && isset($HTTP_POST_VARS['value']) && !empty($HTTP_POST_VARS['value']) )
{
	$umfrage_id = $HTTP_POST_VARS['umfrage_id'];
	$value = $HTTP_POST_VARS['value'];

	//
	// Connect to Database
	//
	$db = mysql_connect('localhost', 'name', 'passwort');
	mysql_select_db('datenbank');

	$sql = "SELECT counter
		FROM umfrage_" . $umfrage_id . "
		WHERE value = " . $value;

	$result = mysql_query($sql);
	while($row = mysql_fetch_object($result))
	{
		$counter = $row->counter;
	}

	mysql_free_result($reslut);
	
	$counter++;


	$sql = "UPDATE umfrage_" . $umfrage_id . "
		SET counter = " . $counter . "
		WHERE value = " . $value;

	$result = mysql_query($sql);

	mysql_free_result($reslut);

	//
	// Close database connection
	//
	mysql_close($db);
}
else
{
	die('Du musst etwas Auswählen...');
}
?>

Code: Alles auswählen

-- 
-- Tabellenstruktur für Tabelle `umfrage_1`
-- 

CREATE TABLE `umfrage_1` (
  `value` bigint(20) NOT NULL default '0',
  `counter` bigint(20) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `umfrage_1`
-- 

INSERT INTO `umfrage_1` VALUES (1, 0);
INSERT INTO `umfrage_1` VALUES (2, 1);
INSERT INTO `umfrage_1` VALUES (3, 0);
INSERT INTO `umfrage_1` VALUES (4, 0);