/    Sign up×
Community /Pin to ProfileBookmark

Setting POST variables

Copy linkTweet thisAlerts:
Mar 08.2010

Hello

I want to create a script that creates POST’s as per a tables contents

Table Structure
ID NAME ACTIVE
1 BOO 1
2 DOO 1
3 KOO 1
4 FOO 1

The above is my table structure. Right now everything is set to active so I would place this as my POST VARS.

$_POST[‘1’]
$_POST[‘2’]
$_POST[‘3’]
$_POST[‘4’]

Now I manually set them on the belief that there would also be 4 ID’s. If one was to become inactive, lets say ID 3 did. Then all that should be displayed is:
$_POST[‘1’]
$_POST[‘2’]
$_POST[‘4’]

How do I achieve this? How can I make it work. I believe I would use some type of while loop with the _POST command. It appears to not work when I do this though.

to post a comment
PHP

4 Comments(s) ↴

Copy linkTweet thisAlerts:
@MindzaiMar 08.2010 — Not sure why you want to set $_POST particularly - it will not be carried over to the next request if that is your thinking - but you should be able to do this by looping over the query results:

[code=php]
$result = mysql_query("SELECT * FROM mytable");
$_POST = array();
while ($row = mysql_fetch_assoc($result)) {
$_POST[$row['ID']] = $row['NAME'];
}[/code]
Copy linkTweet thisAlerts:
@ericatekkaauthorMar 08.2010 — Mmmm so if I had this on the field:

<input type="checkbox" name="1" />

<input type="checkbox" name="2" />

<input type="checkbox" name="3" />

<input type="checkbox" name="4" />

<input type="checkbox" name="6" />

#5 is missing due to being in active

<input type="checkbox" name="7" />

And I used what you mentioned but vise versa.

$result = mysql_query("SELECT * FROM mytable WHERE active = '1'");

$row = array();

while ($row = mysql_fetch_assoc($result)) {

$row['ID'] = $_POST[$row['ID']];

}

I could then do some type of foreach on $row and run a sql for each entry that would work?
Copy linkTweet thisAlerts:
@ericatekkaauthorMar 09.2010 — [code=php]<?php
include "../_includes/config.inc.php";
include "../_includes/db_connect.inc.php";
include "../_includes/read_member_record_by_nick.php";
include "../_includes/validation_functions.php";
include "../_includes/page_top.inc.php";
if(isset($_POST['subtest'])){
$result = mysql_query("SELECT * FROM portal_testnames WHERE active = '1'");
$row = array();
while ($row = mysql_fetch_assoc($result)) {
$row['ID'] = $_POST[$row['ID']];
}
while (list(, $value) = each($row)) {
echo "Value: $value<br />n";
}
foreach($row as $val){

echo $val;

}
}
?>
<table width="100%" border="0" cellpadding="1">
<tr>
<td align="center" valign="top" colspan=2><h3>Tester</h3><br><br></td></tr>
<tr><td style="padding-left:15px;" align='center'>

<?php

?>
<form method="post" action="test.php">
<table border=0 width='10%'>
<?php
$jobs = mysql_query("SELECT * FROM portal_testnames WHERE active = '1'");
while($data3 = mysql_fetch_assoc($jobs))
{
print "<tr>";
print "<td>".$data3['name']."</td><td><input type='checkbox' value='1' name='".$data3['id']."'></td>";
print "</tr>";
}
?>

</table>
<br><br>
<input type="submit" value="Test" name="subtest">
</form>
</td>
</table>

<?php
include "../_includes/db_close.inc.php";
include "../_includes/page_bottom.inc.php";
?>
[/code]

This is a test page i created. it gives you an idea of what im trying to achieve
Copy linkTweet thisAlerts:
@ericatekkaauthorMar 09.2010 — In regards to the foreach and the while loop i was trying two different ways to do this.
×

Success!

Help @ericatekka spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.29,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...