run a "report" on a member

[searls03]

Ok, so I want to basically be able to update multiple member statuses at once......basically I want to display a list of members that will have a textbox by them to enter data..........then I can type in each of the data that I need and it will update each and every profile with the correct data for that member.....can anyone help me figure a way to do this.....

[Maq]

Assuming you're extracting these members from a DB, when you display the members just associate the text box with the unique id.

[searls03]

That is actually what I basically need help with...........cause it is going to grab my userid I am sure and I need it not to do this......

[EmperorJazzy]

That is actually what I basically need help with...........cause it is going to grab my userid I am sure and I need it not to do this......

 

Your user database would contain unique identifiers for each user correct?

 

As you build the output to the screen, set the value of the text box to the unique identifier for that user line.

 

....value="' . echo $query['unique'] . '"

[cunoodle2]

searls03, as I have mentioned numerous times with your posts in the past.  If you ask better questions you will get better answers.  Show us what query/code you are using.  Then address all of the following questions..

 

1.  What error messages (if any) are you getting?

2.  What is it ACTUALLY doing?

3.  What do you EXPECT it to do?

4.  Ideally provide a sample data set.

 

There are probably more posts on your threads then anyone else due to all of the vagueness and the back and forth on all comments.

[searls03]

look, I am sorry alright.....I don't have a code for it right now.....that is sorta what I was hoping to get some help on............I am in the finishing stages of the website and this is one of the last things I need to get working...........so I am hoping someone can help me come up with a code that could get me STARTED......and I could hopefully go from there.......

[Maq]

First you need to extract the information from your database, so start here:

http://us2.php.net/mysql_query

[searls03]

thank you........I will tell you when I do.....

[searls03]

ok, I know how to extract data from database, so how do I make it so that each result is with specific id?

[Maq]

ok, I know how to extract data from database, so how do I make it so that each result is with specific id?

Each member should have a unique id, probably an auto-incremented one, just associate it with the text box.

[searls03]

ok, so here is what displays the search results..........I also need to know how to make this one form with one submit button show up.............it keeps on associating it with my id........can you help me associate it with the right id?

[Maq]

ok, so here is what displays the search results..........I also need to know how to make this one form with one submit button show up.............it keeps on associating it with my id........can you help me associate it with the right id?

Sure, post your code.

[searls03]

oh, sorry, I had it copied and everything......

<form method="post" action="scoutmanager.php">
<input type="hidden" name="submitted" value="true" ?/>

<table width="896" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="127" bgcolor="#F7E496" class="adfd" scope="col"><strong>Property</strong></td>
    <td width="181" bgcolor="#F7E496" scope="col"><strong>Value</strong></td>
    <td width="588" bgcolor="#F7E496" scope="col"> </td>
    </tr>
  <tr>
    <td bgcolor="#F7E496"><select name="category">
      <option value="name">Name</option>
      <option value="address">Address</option>
      <option value="phone">Phone Number</option>
      <option value="username">Username</option>
    </select></td>
    <td bgcolor="#F7E496"><input type="text" name ="criteria" /></td>
    <td bgcolor="#F7E496"><input type="submit" /></td>
    </tr>
  <tr>
    <td bgcolor="#F7E496"> </td>
    <td bgcolor="#F7E496"> </td>
    <td bgcolor="#F7E496"> </td>
  </tr>
  <tr>
    <td bgcolor="#F7E496"> </td>
    <td bgcolor="#F7E496"> </td>
    <td bgcolor="#F7E496"> </td>
  </tr>
  </table>
</form>

<?php
if (isset($_POST['submitted'])) {
include('connect1.php');
$category = $_POST['category'];
$criteria = $_POST['criteria'] ;
$query = "SELECT * FROM members WHERE $category LIKE '%".$criteria."%'";
$result = mysqli_query($dbcon, $query) or die('error getting data');
$num_rows = mysqli_num_rows($result);
echo "$num_rows results found";
echo "<table width=\"896\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr bgcolor=\"#F7E496\"><td bgcolor=\"#F7E496\"><strong>ID</strong></td> <td bgcolor=\"#F7E496\"><strong>Merit Badges</strong></td> <td  bgcolor=\"#F7E496\"><strong></strong></td><td bgclor=\"#F7E496\"></td></tr>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
echo "<tr><td>";

echo $row['name'];
echo "</td><td>";
echo "<form action=\"scout.php\" method=\"post\">
  <p>
    <input name=\"badges\" id=\"badges\" type=\"text\" value=\" $badges\"/>
    <span class=\"adfa\"> <br /> (enter a ,[comma] then [space] then merit badge name)
    </span>
  </p>
  <label for=\"rank\"></label>
  <select name=\"rank\" id=\"rank\">
    <option value=\"Scout\">Scout</option>
    <option value=\"Tenderfoot\">Tenderfoot</option>
    <option value=\"Second Class Scout\">Second Class Scout</option>
    <option value=\"First Class Scout\">First Class Scout</option>
    <option value=\"Star Scout\">Star Scout</option>
    <option value=\"Life Scout\">Life Scout</option>
    <option value=\"Eagle Scout\">Eagle Scout</option>
    <option value=\"\" selected=\"selected\">$rank></option>
  </select>"
;
echo "<hr />";
echo "</td></tr>";
echo "<input type=\"hidden\" name=\"userid\" id=\"userid\">";
echo "<input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Save\" />
  </p>";
echo "</form>";
}
echo "</table>";

}
?> 

[searls03]

btw, this is what does the posting:

<?php
session_start(); // Must start session first thing
/*
Created By Adam Khoury @ [url=http://'http://www.flashbuilding.com/']www.flashbuilding.com[/url]
-----------------------June 20, 2008-----------------------
*/
// Here we run a login check
if (!isset($_SESSION['id'])) {
echo 'Please <a href="login.php">log in</a> to access your account';
exit();
}
//Connect to the database through our include
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];

// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' limit 1");
while($row = mysql_fetch_array($sql)){
$userid = $row['userid'];

}



// Process the form if it is submitted
if ($_POST['rank']) {
	$badges = $_POST['badges'];
$rank = $_POST['rank'];
$sql = mysql_query("UPDATE members SET   badges='$badges', rank='$rank', userid='$userid'");
printf("Records updated: %d\n", mysql_affected_rows())
;


exit();
} // close if post
?>

[searls03]

any help?????????????

[searls03]

come on, I need this page and my registration page working is all then I am done I do believe............

[searls03]

anything?

[Nuxius]

Thank you for refreshing this for me Maq

[searls03]

yep.....

[searls03]

so I have it so it updates correct person now.......it only will display my id associated stuff in each $badges box for everyone.....:

<?php
if (isset($_POST['submitted'])) {
include('connect1.php');
$category = $_POST['category'];
$criteria = $_POST['criteria'] ;
$query = "SELECT * FROM members WHERE $category LIKE '%".$criteria."%'";
$result = mysqli_query($dbcon, $query) or die('error getting data');
$num_rows = mysqli_num_rows($result);
echo "$num_rows results found";
echo "<table width=\"896\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr bgcolor=\"#F7E496\"><td bgcolor=\"#F7E496\"><strong>name</strong></td><td bgcolor=\"#F7E496\" ><strong>Merit Badges</strong></td><td  bgcolor=\"#F7E496\"><strong>Rank</strong></td><td bgclor=\"#F7E496\"></td></tr>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {$color = ($color == 'white')?'#fffccc':'white';
echo "<tr bgcolor='$color'><td>
<input type=\"hidden\" name=\"userid\" id=\"userid\" value=".$row['userid'].">";
echo $row['name'];
echo "
</td><td>
<form action=\"scout.php\" method=\"post\">
  
    <textarea name=\"badges\" id=\"badges\" cols=\"40\" rows=\"3\" type=\"textarea\">$badges</textarea></td><td>
    <span class=\"adfa\"> 
    </span>

  
  <label for=\"rank\"></label>
  <select name=\"rank\" id=\"rank\">
    <option value=\"Scout\">Scout</option>
    <option value=\"Tenderfoot\">Tenderfoot</option>
    <option value=\"Second Class Scout\">Second Class Scout</option>
    <option value=\"First Class Scout\">First Class Scout</option>
    <option value=\"Star Scout\">Star Scout</option>
    <option value=\"Life Scout\">Life Scout</option>
    <option value=\"Eagle Scout\">Eagle Scout</option>
    <option value=\"\" selected=\"selected\"$rank></option>

</td><td>



  ";

}
echo"
<input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Save\" />
</td></tr>";
echo "</form>";
echo "</table>";

}
?>               

[searls03]

ok, I guess it is also only updating mine too......

[searls03]

help?

[searls03]

don't I need like a loop or something that runs the submit?