insert database field into form field

slyvsspy

Hello,

What I am trying to do is insert the email field out of our mysql database into a hidden email field on a form. Here is the code:

printf("<input type=\"hidden\" name=\"email\" value=\"".$row['email']."\" />";

Can anyone see what I am doing wrong? It pops up with the error::

Parse error: parse error, unexpected ';' in /home/virtual/site12/fst/var/www/html/login.php on line 19

Thanks for any help!

stolzyboy

that looks ok to me but why not just hop out of php like this

<?
other php stuff
?>
<input type="hidden" name="email" value="<? echo $row['email']; ?>">
<?
more php stuff
?>

DigitalExpl0it

somthing like this wont work?

<?
//Mysql Connection here

//While....Statement {
?>

<input type="hidden" name="email" value="<? echo $row["email"]; ?>">
<?
}
?>

stolzyboy

Originally posted by DigitalExpl0it
somthing like this wont work?
<?
//Mysql Connection here

//While....Statement {
?>

<input type="hidden" name="email" value="<? echo $row["email"]; ?>">"; 
<?
}
?>
[/B]

you have the right idea, but he would end up having crap showing up, since you left the "; at the end

stolzyboy

LOL, you edited it 😃

slyvsspy

Below I will show you my code. The reason that I don't believe those ways will work is because I am in the middle of an "IF" statement while this is going on!

Here is the complete code::

<?php

if ($submit) :

 $db=mysql_connect("localhost","xxxxx","xxxxx") or die ("cant connect"); 

 mysql_select_db("xxxxxx_com",$db) or die ("cant change");

 $result=mysql_query("select * from joborder where  user='$username'",$db) or die ("cant do it");

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

       if ($row["pass"]==$password) {

printf("Welcome " .$row['fname']." of ".$row['organization']."!");

printf("<form method=\"post\" action=\"sendmail.php\">");

printf("Email: <input name=\"email\" type=\"text\" /><br />");

printf("Work Order:<br />");

printf("<textarea name=\"message\" rows=\"15\" cols=\"40\">");

printf("</textarea><br />");

printf("<input type=\"submit\" value=\"Submit\" />");

printf("</form>");
}

}

else:

?>
<body link="#0000FF" vlink="#0000FF" alink="#0000FF">
<form method=post action="<?echo $PHP_SELF?>">

<h2 align="center"><font color="#FF0000" face="Arial, Helvetica, sans-serif">Welcome
to the EyeOpener Login!</font><font color="#FF0000"><br>
</font> </h2>

<table width="487" height="128" border=0 align="center" cellpadding=2 cellspacing=0>
<tr>
<td width="92"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Username:</strong></font></td>
<td width="235"><input type="text" name="username" size=15></td>
<td width="148" rowspan="4"><div align="center">
<p> </p>
<p><img src="logo.jpg" width="300" height="117"></p>
</div></td>
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif"><strong>Password:</strong></font></td>
<td><input type="password" name="password" size=15></td>
<tr>
<td></td>
<td valign="top"><input type="submit" name="submit" value="Log In"></td>
<tr>
<td> </td>
<td valign="top">  </td>

<tr> 
  <td colspan="2"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">Do 
      You Need To<br>
      <a href="register.php">Register</a>? </font></div></td>
  <td>&nbsp;</td>

</table>

</form>

<? endif; ?>

Do you see my dilemma?

stolzyboy

you have no dilemma, you just aren't using PHP's nice way of NOT
having to be like Perl, you can jump in and out whenever you
want

here is your inner if statement

<?
if ($row["pass"]==$password) {
?>
Welcome <? echo $row['fname']; ?> of <? echo $row['organization']; ?>!
<form method="post" action="sendmail.php">
Email: <input name="email" type="text" /><br />
Work Order:<br />
<textarea name="message" rows="15" cols="40"></textarea><br />
<input type="submit" value="Submit" />
</form>
<?
}
?>