PHP/MYSQL Bulk Actions

mezangath · 06-15-2009, 09:10 AM

HTML Code:

<form action="update_bulk.php" method="post" />
<input type="text" name="ud_points" value="Points"/>
<input type="submit" value="Quick Edit" />

And for each member they get:

HTML Code:

<input type='checkbox' name='ud_id' value='$id' />

Now, this form is being sent to update_bulk.php witch look like this:

PHP Code:


			
$ud_id=$_POST['ud_id'];

$ud_points=$_POST['ud_points'];



require_once('mysql.php');



$query="UPDATE members SET points='$ud_points' WHERE id='$ud_id'";

mysql_query($query);

Now, i'm a real noob when it comes to PHP/Mysql, so i could really use some help with this PHP/Mysql action.

What i want is for the script to update the points value of all id's sent to it.
Not only paste in the same number but to add the value, so if i write 20 in ud_points i want it to add those to existing value.

Anyone who has a clue?

anthwinter · 06-27-2009, 12:42 AM

Hey

What you could do is retrieve the value from the table, then store it in a variable. then you can use PHP to add the to variables together and then submit this back into the table

use something like:

$getpoints="SELECT points FROM members WHERE id='$ud_id'";
mysql_query($getpoints);

while ($row = mysql_fetch_array($getpoints)) {
$currentpoints = $row['points'];
}

$newpoints = $ud_points + $currentpoints;

$query="UPDATE members SET points='$newpoints' WHERE id='$ud_id'";
mysql_query($query);

Lonny Earl · 06-27-2009, 05:48 AM

author of Zend Technologies’ PHP 101 series for
PHP beginners (http://www.zend.com/php5/abs/), and has extensive experience
deploying PHP and MySQL in a variety of different environments (including
corporate intranets, high-traffic Internet web sites, and mission-critical thin client
applications).

06-15-2009, 09:10 AM	#1
mezangath Silver Member Join Date: Mar 2009 Location: Stockholm, Sweden Posts: 108	PHP/MYSQL Bulk Actions Hi there, I have a database for managing points of members. The database is constructed by \|id (primary, unique, AI) \| name \| rank \| points \| class \|123 \|name1\|Officer\|20 \|Warrior The list consists of about 30 different id's for each member added to the list. What i want to do is to create bulk actions. So i can mark several/all members and add a set of points to existing points. The form i use is: HTML Code: <form action="update_bulk.php" method="post" /> <input type="text" name="ud_points" value="Points"/> <input type="submit" value="Quick Edit" /> And for each member they get: HTML Code: <input type='checkbox' name='ud_id' value='$id' /> Now, this form is being sent to update_bulk.php witch look like this: PHP Code: `$ud_id=$_POST['ud_id']; $ud_points=$_POST['ud_points']; require_once('mysql.php'); $query="UPDATE members SET points='$ud_points' WHERE id='$ud_id'"; mysql_query($query);` Now, i'm a real noob when it comes to PHP/Mysql, so i could really use some help with this PHP/Mysql action. What i want is for the script to update the points value of all id's sent to it. Not only paste in the same number but to add the value, so if i write 20 in ud_points i want it to add those to existing value. Anyone who has a clue? __________________ Nerdrage Mezangath Web

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

06-27-2009, 12:42 AM	#2
anthwinter New Member Join Date: Jun 2009 Posts: 2	Hey What you could do is retrieve the value from the table, then store it in a variable. then you can use PHP to add the to variables together and then submit this back into the table use something like: $getpoints="SELECT points FROM members WHERE id='$ud_id'"; mysql_query($getpoints); while ($row = mysql_fetch_array($getpoints)) { $currentpoints = $row['points']; } $newpoints = $ud_points + $currentpoints; $query="UPDATE members SET points='$newpoints' WHERE id='$ud_id'"; mysql_query($query);

06-27-2009, 05:48 AM	#3
Lonny Earl Banned Join Date: Apr 2009 Posts: 41	author of Zend Technologies’ PHP 101 series for PHP beginners (http://www.zend.com/php5/abs/), and has extensive experience deploying PHP and MySQL in a variety of different environments (including corporate intranets, high-traffic Internet web sites, and mission-critical thin client applications).