Scratch

sparks · 2011-06-30 05:58:09

Hey guys,

I've been working on a cpanal for my site today, there is a dropdown list of registered members with the following code:

Code:

<form name = account search' method = 'post' action = '10807411.php?page=accountFinder'>
        <select name = 'searchType'>";
        mysql_connect("localhost", "******", "******") or die(mysql_error());
        mysql_select_db("********_members") or die(mysql_error());
        $query = "SELECT * FROM membersList ORDER BY id ASC";
        mysql_query($query); 
        $result = mysql_query($query) or die(mysql_error());
        while($row = mysql_fetch_array($result)){
            if($row['extraStatus'] == ''){
                if($row['status'] == 'registered'){
                    $status = '[R]';
                }
                if($row['status'] == 'blocked'){
                    $status = '[b]';
                }
            }    
            else{
                if($row['extraStatus'] == 'moderator'){
                    $status = '[M]';
                }
                else{
                    $status = '[?]';
                }
            }
            echo "<option value = '" . $row['username'] . "'>" . $status . $row['username'] . "</option>";        
        }
        echo "</select>
        <input type = 'submit' name = 'searchUser' value = 'GO'>
        </form>";

Now if you look there you will see that all the members of my site are pulled from the database and stored for selection in a dropdown list with a [ ] preceding each one indicating status.

so for example with the above code an entry would look like so:

[M]sparks

So surely when the form is posted, the value of $_POST['searchType'] should really be '[M]sparks when this code is used on the next page:

Code:

echo "<h2>" . $_POST['searchType'] . "s Account.</h2>";

However, this ends up displaying sparkss account.... the [M] has disappeared!

This is actually exactly what I wanted as the [M] was going to get in the way, but I'm wondering where on earth it went?! are things inside square brackets ignored when they are inside select inputs for forms?

Last edited by sparks (2011-06-30 16:47:41)

sparks · 2011-06-30 16:48:10

I originally posted this in misc but nothing happened so I will try advanced tongue

Last edited by sparks (2011-06-30 16:48:41)

RUMCHEERYPOOPOO · 2011-06-30 18:52:43

your code seems to be correct (although I may be wrong) but I think it's probably your database.

Edit:
I think it's because
$row['extraStatus'] == ''
but
$row['status'] != registered
and/or
$row['status'] != 'blocked'

I may be wrong though

Last edited by RUMCHEERYPOOPOO (2011-06-30 18:55:39)

GP1 · 2011-06-30 21:10:51

I think that it is some thing with the brackets ( [ ] ) because, for some reason, the database deletes that part. maybe it's a comment or something?

johnnydean1 · 2011-07-01 03:27:33

Maybe your database field 'extraStatus' is not equalling ''.

Based on the code, try this.

Code:

<form name = account search' method = 'post' action = '10807411.php?page=accountFinder'>
        <select name = 'searchType'>";
        mysql_connect("localhost", "******", "******") or die(mysql_error());
        mysql_select_db("********_members") or die(mysql_error());
        $query = "SELECT * FROM membersList ORDER BY id ASC";
        mysql_query($query); 
        $result = mysql_query($query) or die(mysql_error());
        while($row = mysql_fetch_array($result)){
                    $status = '[u]';
            if($row['extraStatus'] == ''){
                if($row['status'] == 'registered'){
                    $status = '[R]';
                }
                if($row['status'] == 'blocked'){
                    $status = '[b]';
                }
            }    
            else{
                if($row['extraStatus'] == 'moderator'){
                    $status = '[M]';
                }
                else{
                    $status = '[?]';
                }
            }
            echo "<option value = '" . $row['username'] . "'>" . $status . $row['username'] . "</option>";        
        }
        echo "</select>
        <input type = 'submit' name = 'searchUser' value = 'GO'>
        </form>";

If it says [u]Sparkss then you know its wrong for the above reason.

sparks · 2011-07-01 06:14:25

Good idea, but the fact is that in the DROPDOWN of all the members the [m] does appear! So it has managed to set the status to [M] and ...

OH! It's because <option> name is $status . $row['username'] whilst the value is only set to $row['username']! Tha value is carried through the POST to the next page! How silly of me!

RUMCHEERYPOOPOO · 2011-07-01 10:31:48

Well you didn't need us really smile But I s'pose we got your brain working

sparks · 2011-07-01 10:55:19

It was when I read over jd's example tongue I thought it was something he'd changed but it wasn't!

Scratch

archived forums

#1 2011-06-30 05:58:09

<select> surprise in POST... please explain!

Code:

Code:

#2 2011-06-30 16:48:10

Re: <select> surprise in POST... please explain!

#3 2011-06-30 18:52:43

Re: <select> surprise in POST... please explain!

#4 2011-06-30 21:10:51

Re: <select> surprise in POST... please explain!

#5 2011-07-01 03:27:33

Re: <select> surprise in POST... please explain!

Code:

#6 2011-07-01 06:14:25

Re: <select> surprise in POST... please explain!

#7 2011-07-01 10:31:48

Re: <select> surprise in POST... please explain!

#8 2011-07-01 10:55:19

Re: <select> surprise in POST... please explain!

Board footer