Won't complete the form.

Anon

Ok, I don't know whats wrong here but for some reason data I'm entering into a form isn't getting to POST script. Here's the form:

<form method="POST" action="ecp.php">
  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
    <tr>
      <td width="100%">
      <p align="center"><b><font face="Arial" size="2">Employee Login</font></b></td>
    </tr>
    <tr>
      <td width="100%"><font face="Arial" size="2">Full Name:</font></td>
    </tr>
    <tr>
      <td width="100%"><font face="Arial">
      <input type="text" name="employee" size="20"></font></td>
    </tr>
    <tr>
      <td width="100%"><font face="Arial" size="2">Password:</font></td>
    </tr>
    <tr>
      <td width="100%"><font face="Arial">
      <input type="password" name="password" size="20"></font></td>
    </tr>
  </table>
  <p align="center"><font face="Arial">
  <input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></font></p>
</form>

To check if $employee has anything in it from the POST I did an IF ELSE statement as follows in ecp.php:

if ( $employee == "" ) { //DO NOTHING! } else { print 'It Worked!'; }

I even tried if ( $employee == NULL ) still nothing, I dont understand why $employee wouldn't be sent to the form, its worked before 🙁

Anyone have the slightest as to what could be causing this?

lucianoes

You showed us the form, but didn't show us the code in ecp.php. The form looks fine to me, so my suspicion falls on ecp.php.

    Luciano ES
    Santos, SP - Brasil

Anon

OK, well, i took out all the extra stuff to see if itll do the first command, its not. After the form (see above) this is what ecp.php is:

include('cnt.php');

$result = mysql_query("SELECT id,employee,pass,level,email,phone,theme FROM staffconfig WHERE employee='.$employee.'");

print $id;
print ' ';
print $employee;
print ' ';
print $pass;
print ' ';
print $level;
print ' ';
print $email;
print ' ';
print $phone;
print ' ';
print $theme;
print ' ';

include('cnt.php'); is the connection script.
When the page loads, the only thing that shows is the $employee var and I'm typing the name exactly as it is in the table, even copy/pasted it and still nothing, also put '.$employee.' and still nothing, i dont understand whats wrong....

lucianoes

I am a newbie and I could be wrong, but I think I know what is wrong.

If you use hard quotes, you're looking for the literal string instead of its interpolation value. So instead of

$result = mysql_query("SELECT id,employee,pass,level,email,phone,theme FROM staffconfig WHERE employee='.$employee.'");

I would say

$result = mysql_query("SELECT id,employee,pass,level,email,phone,theme FROM staffconfig WHERE employee=$employee");

$result = mysql_query("SELECT id,employee,pass,level,email,phone,theme FROM staffconfig WHERE employee=\".$employee.\"");

BTW, do you really need those two concatenion dots surrounding the variable?

Good luck,
Luciano ES
Santos, SP - Brasil

zalath

Depends on the variable. If it is an array, it seems to be necessary.