[SOLVED] Wrong Text

[php?]

Now what's the problem?

[uPDATED PROBLEM]

 

*sigh* Well, according to the script below, it should display "Username ($key) is being deleted...done", or "Username ($key) is being accepted...done"

 

But instead it displays something like this: "11 is being deleted" or "11 is being accepted "

 

For some reason $key is being set to the ID number field of the table... not the username field

 

<?php
$con = mysql_connect("localhost","root","");
if (!$con) {
      die('Could not connect: ' . mysql_error());
}

mysql_select_db("mylogin", $con);

$a = mysql_query("SELECT * FROM `pending`");
$b = mysql_num_rows($a);

if($b == '0')
{
echo 'No pending requests at the moment.';
}
else
{
if(!isset($_POST['submit'])) {
      if (!$result = mysql_query("SELECT * FROM pending")) {
            die('MySQL Error: ' . mysql_error());
      }
      echo "<form method=\"POST\"";
      while($row = mysql_fetch_array($result)) {
            echo  "<b>" . $row['Username'];
            echo "</b> ";
            echo "<input type=radio name=\"". $row['ID'] ."\" value=1>Accept"." <input type=radio name=\"". 

$row['ID'] ."\" value=2>Decline<br>";
            echo " <br />";
      }
      echo "<br><input type=submit name=submit value=Submit>";
} else {
      foreach($_POST as $key => $val){
            if($val == 1) {
                  $info = mysql_fetch_array(mysql_query("SELECT * FROM pending WHERE ID='".$key."'"));
                  echo "$key is being accepted...";
                  mysql_query("INSERT INTO accepted SET 
                  Username='".$info['Username']."',
                  Password='".$info['Password']."',
                  Email='".$info['Email']."'"); // Moves user to new table
                  echo "done <br>\n";
            }
            echo "$key is being deleted...";
            mysql_query("DELETE FROM pending WHERE ID='".$key."'");
            echo "done <br>\n";
            /*
            this deletes the user from the table users regardless if you selected
            to accept or deny. If you chose to accept the user, it runs the
            query above first and then this one
            */
      }
}
mysql_close($con);
}

?>

 

 

[php?]

Okay or.... i could make it simple. How would I make it reload the admin.php page when you click submit with a little message above saying 'Requests Updated"

[teng84]

just echo it after the else(last else)  and wait where is the update all i see is delete and select

[php?]

update for what?

[teng84]

you cant use this line  foreach($_POST as $key => $val) because there are lots of post that you don't need eg.. the submit ..button it will be include in your loop

an what do you mean by For some reason $key is being set wrong, and I have no idea why the "submit" is there...

[php?]

Well $key is what that value is... and for some reason its not the name of the username

 

 

Do you suggest that I delete the  foreach($_POST as $key => $val){ or edit it

[teng84]

<?php
$con = mysql_connect("localhost","root","");
if (!$con) {
      die('Could not connect: ' . mysql_error());
}

mysql_select_db("mylogin", $con);

$a = mysql_query("SELECT * FROM `pending`");
$b = mysql_num_rows($a);

if($b == '0')
{
echo 'No pending requests at the moment.';
}
else
{
if(!isset($_POST['submit'])) {
      if (!$result = mysql_query("SELECT * FROM pending")) {
            die('MySQL Error: ' . mysql_error());
      }
      echo "<form method=\"POST\">";
      while($row = mysql_fetch_array($result)) {
            echo  "<b>" . $row['Username'];
            echo "</b> ";
            echo "<input type=radio name='row_s[".$row['ID']."]' value=1>";
		echo "Accept"." <input type=radio name='row_s[".$row['ID']."]' value=2>Decline<br>";
            echo " <br />";
      }
      echo "<br><input type=submit name=submit value=Submit>";
} else {
      foreach($_POST['row_s'] as $key => $val){
//  print_r($_POST['row_s']);//ro check if yuo get thevalues of chk boxes
            if($val == 1) {
                  $info = mysql_fetch_array(mysql_query("SELECT * FROM pending WHERE ID='".$key."'"));
                  echo "$key is being accepted...";
                  mysql_query("INSERT INTO accepted SET 
                  Username='".$info['Username']."',
                  Password='".$info['Password']."',
                  Email='".$info['Email']."'"); // Moves user to new table
                  echo "done <br>\n";
            }
            echo "$key is being deleted...";
            mysql_query("DELETE FROM pending WHERE ID='".$key."'");
            echo "done <br>\n";
            /*
            this deletes the user from the table users regardless if you selected
            to accept or deny. If you chose to accept the user, it runs the
            query above first and then this one
            */
      }
}
mysql_close($con);
}

?>

maybe you could try something like that

[php?]

that solved the "submit" part ... but "16 is being deleted...done" the $key is still wrong =/

 

The number that is listed instead of the username goes up by 1 every time.. if that helps

[teng84]

give me sample output format you want and ill try to figure that out 

[php?]

The format doesn't matter, i can always edit it later

[teng84]

      foreach($_POST['row_s'] as $key => $val){
         $info = mysql_fetch_array(mysql_query("SELECT * FROM pending WHERE ID='".$key."'"));
            if($val == 1) {
                  echo "{$info['Username']} is being accepted...";
                  mysql_query("INSERT INTO accepted SET 
                  Username='".$info['Username']."',
                  Password='".$info['Password']."',
                  Email='".$info['Email']."'"); // Moves user to new table
                  echo "done <br>\n";
            }
            echo "{$info['Username']} is being deleted...";
            mysql_query("DELETE FROM pending WHERE ID='".$key."'");
            echo "done <br>\n";

that?

[php?]

Same thing happens..

 

 

But i noticed that $key is coming up as the ID in the table instead of the Username

[Northern Flame]

lol i just saw ur other post on that other topic asking for help,

now im reading this but I cant really see what your problem is,

can you try to re-explain your problem to me?

[php?]

Alrighty there Mr. Clarification,

 

After I click decline on a username (lets call the username "Mr. Clarification"), it deletes from the database. After it deletes it should display a message that says: 'Mr. Clarification has been deleted...'. In the code $key should be the username. But... instead it gives me a message that says: '18 has been deleted.... And 18 is the ID code of the table that the username should be taken from.

[Northern Flame]

lol alright,

try this:

 

<?php
$con = mysql_connect("localhost","root","");
if (!$con) {
      die('Could not connect: ' . mysql_error());
}

mysql_select_db("mylogin", $con);

$a = mysql_query("SELECT * FROM `pending`");
$b = mysql_num_rows($a);

if($b == '0')
{
echo 'No pending requests at the moment.';
}
else
{
if(!isset($_POST)) {
      if (!$result = mysql_query("SELECT * FROM pending")) {
            die('MySQL Error: ' . mysql_error());
      }
      echo "<form method=\"POST\"";
      while($row = mysql_fetch_array($result)) {
            echo  "<b>" . $row['Username'];
            echo "</b> ";
            echo "<input type=radio name=\"". $row['ID'] ."\" value=1>Accept"." <input type=radio name=\"". 

$row['ID'] ."\" value=2>Decline<br>";
            echo " <br />";
      }
      echo "<br><input type=submit value=Submit>";
} else {
      foreach($_POST as $key => $val){
            if($val == 1) {
                  $info = mysql_fetch_array(mysql_query("SELECT * FROM pending WHERE ID='".$key."'"));
                  echo "$val is being accepted...";
                  mysql_query("INSERT INTO accepted SET 
                  Username='".$info['Username']."',
                  Password='".$info['Password']."',
                  Email='".$info['Email']."'"); // Moves user to new table
                  echo "done <br>\n";
            }
            echo "$key is being deleted...";
            mysql_query("DELETE FROM pending WHERE ID='$key'");
            echo "done <br>\n";
            /*
            this deletes the user from the table users regardless if you selected
            to accept or deny. If you chose to accept the user, it runs the
            query above first and then this one
            */
      }
}
mysql_close($con);
}

?>

[php?]

Lol now it displays no usernames to even delete from *wink* and it doesn't say: no pending requests atm anymore.

[Northern Flame]

lol

alright then, give me a minute,

im going to put this code in my notepad++

and see if I can see where the errors are

[kishan]

u have to use the for loop like this

foreach($_POST['row_s'] as $key => $val)

 

or

in the javascript when the user checks any radio button put a cooresponding value in a hidden variable and in the php check whether if(isset($_POST['checkradio']) && $_POST['checkradio']!='')

{

now do the action ...

}

 

 

in any case as ur making the for-element like ...$rows["ID"] i think in the db it is a integer .......

if u print $key it will u like ...18,1,16...like that (or) make sure either u use a different col-name for name or use $val in php

[Northern Flame]

man im getting a headache,

i cant figure out whats wrong,

anyone else have a solution?

ima try to create a similar sql table 2 urs

so i can see exactly whats going wrong....

but ill do that in the morning 

[php?]

Anyone else have a solution 

[php?]

For some reason the $key is being set as the ID field in the table instead of the Username field

[Northern Flame]

replace the foreach with this:

 

      foreach($_POST['row_s'] as $key => $val){
         $info = mysql_fetch_array(mysql_query("SELECT * FROM pending WHERE ID='".$key."'"));
            if($val == 1) {
                  echo "{$info['Username']} is being accepted...";
                  mysql_query("INSERT INTO accepted SET 
                  Username='".$info['Username']."',
                  Password='".$info['Password']."',
                  Email='".$info['Email']."'"); // Moves user to new table
                  echo "done <br>\n";
            }
            echo "{$info['Username']} is being deleted...";
            mysql_query("DELETE FROM pending WHERE Username='".$info['Username']."'");
            echo "done <br>\n";

[php?]

t is being deleted...done

26 is being deleted...done

 

 

Almost.. but now it displays 26 still =/

[php?]

Oh wait no... for got to edit a part!!!

 

IT works!!!!!! thanks northern

[php?]

Wait.. one last little error.

 

When you click accept

test is being accepted...done

test is being deleted...done

 

it still moves it to the right place.. but it just displays the deleted part for some reason