Value Increment

overyde · Jul 31, 2003

Hi,
I have a voting page that users need to vote on dofferent aspects on one page. My pronblem is that I need to increment the value in the database by 1. I can call the value from the database and increase the respective value by 1 but I don't know how to repost it?
The code for the voting page and the code for the process follows:

FRATELLI.PHP (VOTING PAGE)
*******************************************************
<html>

<head>
<title>New Page 1</title>
</head>

<body>
<form method="POST" action="addvote.php">

<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="20%" colspan="2">fratelli</td>
<td width="20%" colspan="2"> </td>
</tr>
<tr>
<td width="20%" colspan="2">service</td>
<td width="20%" colspan="2">management</td>
</tr>
<tr>
<td width="10%">Excellent</td>
<td width="10%">

<input type="radio" value="servicea" name="service"></td>
<td width="10%">Excellent</td>
<td width="10%">

<input type="radio" value="managementa" name="management"></td>
</tr>
<tr>
<td width="10%">Good</td>
<td width="10%">

<input type="radio" value="serviceb" name="service"></td>
<td width="10%">Good</td>
<td width="10%">

<input type="radio" value="managementb" name="management"></td>
</tr>
<tr>
<td width="10%">Average</td>
<td width="10%">

<input type="radio" value="servicec" name="service"></td>
<td width="10%">Average</td>
<td width="10%">

<input type="radio" value="managementc" name="management"></td>
</tr>
<tr>
<td width="10%">Poor</td>
<td width="10%">

<input type="radio" value="serviced" name="service"></td>
<td width="10%">Poor</td>
<td width="10%">

<input type="radio" value="managementd" name="management"></td>
</tr>
<tr>
<td width="10%"><input type="submit" value="Submit"></td>
<td width="10%"><input type="reset" value="Reset"></td>
<td width="10%"> </td>
<td width="10%"> </td>
</tr>
</table>
</form
</body>

</html>

ADDVOTE.PHP
**********************************************************
<?php
session_start();

//check for required fields from the form
if ((!$_POST[service]) || (!$_POST[management])) {
header("Location: fratelli.php&quot

;
exit;
}

//connect to server and select database
$conn = mysql_connect("localhost","","&quot

or die(mysql_error());
mysql_select_db("imperial",$conn) or die(mysql_error());

//create and issue the query
$sql = "select servicea, serviceb, servicec, serviced, managementa, managementb, managementc, managementd from place";
$result = mysql_query($sql,$conn) or die(mysql_error());

//get the values of f_name l_name and other details
$servicea = mysql_result($result, 0, 'servicea');
$serviceb = mysql_result($result, 0, 'serviceb');
$servicec = mysql_result($result, 0, 'servicec');
$serviced = mysql_result($result, 0, 'serviced');
$managementa = mysql_result($result, 0, 'managementa');
$managementb = mysql_result($result, 0, 'managementb');
$managementc = mysql_result($result, 0, 'managementc');
$managementd = mysql_result($result, 0, 'managementd');

//Adding 1 to respective field
if ($_POST[service]== "servicea&quot

{
$servicea++;
}
elseif ($_POST[service]== "serviceb&quot

{
$serviceb++;
}
elseif ($_POST[service]== "servicec&quot

{
$servicec++;
}
elseif ($_POST[service]== "serviced&quot

{
$serviced++;
}

if ($_POST[management]== "managementa&quot

{
$managementa++;
}
elseif ($_POST[management]== "managementb&quot

{
$managementb++;
}
elseif ($_POST[management]== "managementc&quot

{
$managementc++;
}
elseif ($_POST[management]== "managementd&quot

{
$managementd++;
}

// create the SQL statement
$sql = "UPDATE place SET servicea = '$servicea', serviceb = '$serviceb', servicec = '$servicec', serviced = '$serviced' where user = 'wazza'";

//prepare message for printing, and user menu
$msg = "<p><b>Service</b></p>";
$msg .= "<p>Excellent: $servicea</p>";
$msg .= "<p>Good: $serviceb</p>";
$msg .= "<p>Average: $servicec</p>";
$msg .= "<p>Poor: $serviced</p>";

$msg .= "<p><b>Management</b></p>";
$msg .= "<p>$managementa</p>";
$msg .= "<p>$managementb</p>";
$msg .= "<p>$managementc</p>";
$msg .= "<p>$managementd</p>";

?>
<html>

<head>
<link rel="STYLESHEET" type="text/css" href="style.css">
<title>Thank-You For Voting</title>
</head>

<body>

<? print "$msg"; ?>
</body>
</html>

Reality is built on a foundation of dreams.

fireburner69 · Jul 31, 2003

You are using words For measuring your site righrt?
For example! You right inside the db the word servicea for Good and serviceb for something else!?
and in the db
you send this code

$sql = "UPDATE place SET
servicea = '$servicea',
serviceb = '$serviceb',
servicec = '$servicec',
serviced = '$serviced'
where user = 'wazza'";

this means that you must have 5 vars and 5 DBrows

You must give everytime vars servicea to d but the user just click on one! Dot so everytime you pass one from the above vars! so probably the db is not being updated cause one of the fields is missing!

Juyst check this and tell me if its right!
If you want any help just post

overyde · Aug 1, 2003

Okay,
In the database, servicea has a number
(the number of times servicea has been voted-
servicea being the "excellent" value
serviceb being the "good" value etc)

So say the database looks like this:
user * servicea * serviceb * servicec * serviced *
**************************************************
wazza* 1 * 5 * 3 * 2 *
**************************************************

I need to increment the value of the respective choice and then display it as a percentage.
i.e. servicea = servicea / (servicea + serviceb + servicec + serviced) * 100

My problem is the increment works but I can't write the value to the database.

P.S. Please ignore the management section as I did not finish writing the code and am just testing the service section first.

Reality is built on a foundation of dreams.

fireburner69 · Aug 1, 2003

Ok so please tell me what the rows represent again
so I can figure it out the math relation betwen them so to show you the 100%

In order to increase a number it would be wize 1st to read it from DB then add one ($data_collected++

and then UPDATE it to db! while you do that put some echos so that you can check out if this is working.

overyde · Aug 1, 2003

That's EXACTLY what I want to do!!!! I need to know how to read it from the db then add one then update it whilst seeing if it's working. That's where my problem is lying!

Each row is a seperate user that has an establishment.
the first column is the user.
the second column = servicea which represents excellent
the third column = serviceb which represents good
the fourth column = servicec which represents average
the fifth column = serviced which represents poor

the data in these field values are numbers.

By the way-thanks for your time

Reality is built on a foundation of dreams.

fireburner69 · Aug 1, 2003

Do something like that

When the user submits a good vote or something like that use this

$query = "SELECT * FROM table WHERE user = '$user'";
$result = mysql_query($query,$db) or die(mysql_error());
$data = mysql_fetch_array($result, MYSQL_ASSOC);
so now you have $data[row]
and you create the increasment
$data[row]++;
$sql = "UPDATE place SET servicea = '$servicea', serviceb = '$serviceb', servicec = '$servicec', serviced = '$serviced' where user = 'wazza'";

Now check this out you can change anything for example
you want to change servicea
do before update
$data[servicea]++;
but head in mind beware of the updates and the db tables
It is better to use id_num which is uniq! and play with this

Sorry but I do now now excacly the structure and the php confs so I am tring to help

)

Hope it helps

overyde · Aug 1, 2003

Just can't get this to work.
Ideally I'd like to get my original script to work as this would be ideal. I just need it write to the dbase.

Reality is built on a foundation of dreams.

fireburner69 · Aug 1, 2003

Ok can you post all the php and html file so I can look at them!

Just paste them both so I can create them and play with them alittle

overyde · Aug 1, 2003

They are both on the top of the forum in the first posting.
They are called fratelli.php and addvote.php

thks

Reality is built on a foundation of dreams.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Value Increment

overyde

Programmer

fireburner69

Programmer

overyde

Programmer

fireburner69

Programmer

overyde

Programmer

fireburner69

Programmer

overyde

Programmer

fireburner69

Programmer

overyde

Programmer

Similar threads

Part and Inventory Search

Sponsor