passing php variable to html - is it possible?

Fri, 12 Jun 2009 19:33:17 -0700

In the code listed below, I want to be able to pass the value from the varibles in the sql select statement to the html page below. (Note: the only one I'm trying is the $company variable, I'll do the rest when I get that to work.) The problem is that no matter what I use in the value clause in the html, it doesn't evaluate the variable to the value. Can anyone help me out? I'm new to this, so I'm pretty sure I'm doing something silly to cause this.

Code:

<?php
$link  = mysql_connect('xxxxxxxxxxx.net:4444', 'xxxxxx', 'pw','db');
if (!$link) {
	 printf("Connect failed: %s\n", mysql_error());
	 exit();
} else {
// select the database
   $db_selected = mysql_select_db('testdb', $link);
   if (!$db_selected) {
      die ('Select db failed: testdb: ' . mysql_error());
   }
// Perform Query
   $query ="select * from leadsTable";
   $result = mysql_query($query);
   $rows=mysql_num_rows($result);
   if (!$result) {
      $message  = 'Invalid query: ' . mysql_error() . "\n";
      $message .= 'Whole query: ' . $query;
      die($message);
   } else {
      while ($newArray = mysql_fetch_array($result, MYSQL_ASSOC)) {
             $id  = $newArray['id'];
             $company = $newArray['company_name'];
             $contact = $newArray['contact'];
             $phone = $newArray['phone'];
             $fax = $newArray['fax'];
             $street = $newArray['street'];
             $city = $newArray['city'];
             $state = $newArray['state'];
             $zip = $newArray['zip'];
             $job_type = $newArray['job_type'];
             $license_class = $newArray['license_class'];
             $experience = $newArray['experience'];
             $date_found = $newArray['date_found'];
             $date_of_contact = $newArray['date_of_contact'];
             $notes = $newArray['notes'];
             echo "ID is ".$id.
                  "<br/>Company: ".$company.
                  "<br/>Contact: &nbsp ".$contact.
                  "<br/>Phone: &nbsp  &nbsp ".$phone.
                  "<br/>Fax: &nbsp  &nbsp  &nbsp  &nbsp ".$fax.
                  "<br/>Street: &nbsp  &nbsp ".$street.
                  "<br/>City: &nbsp  &nbsp  &nbsp  &nbsp ".$city.
                  "<br/>State: &nbsp  &nbsp  &nbsp ".$state.
                  "<br/>Zip: &nbsp  &nbsp  &nbsp  &nbsp ".$zip.
                  "<br/>Job Type: &nbsp ".$job_type.
                  "<br/>License: $nbsp  ".$license_class.
                  "<br/>Experience: ".$experience.
                  "<br/>Date Found: ".$date_found.
                  "<br/>Date of Contact: ".$date_of_contact.
                  "<br/>Notes: $nbsp ".$notes.
                  "<br/>------------------------------<br/>";
      }
   echo "Rows returned: ". $rows;
   }
}
//mysql_free_result($result);
?>
<head>
<title>Update Leads Table</title>
</head>
<body>
<!--align="center" will center the form -->
<table width="300" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form name="form1" method="post" action="update_leads_table.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="4"><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
;nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;
Update Lead</strong></td>

This php echo statement displays the value I'm looking for!

<? echo "company $company<br>"; ?>
</tr>
<tr>
<td width="78">Company</td>
<td width="40">:</td>
<td width="294"><input name="company" type="text" value="$company"></td>
<td> Date Found : </td>
<td><input name="date_found" type="text" id="date_found"></td>
</tr>
</table>
</td>
</form>
</tr>
</table>

</body>
</html>

Re: passing php variable to html - is it possible?

Tue, 16 Jun 2009 00:08:36 -0700

You are forgetting to tell the parser that the Value is a PHP variable...

change

<input name="company" type="text" value="$company">

<input name="company" type="text" value="<?php echo $company; ?>">

Re: passing php variable to html - is it possible?

Tue, 16 Jun 2009 00:08:54 -0700

You are forgetting to tell the parser that u have switched to PHP ...

change

<input name="company" type="text" value="$company">

<input name="company" type="text" value="<?php echo $company; ?>">

Re: passing php variable to html - is it possible?

Tue, 16 Jun 2009 03:27:45 -0700

Thank you very much! I'm new to this, so I'll make sure to remember this in the future!

'passing php variable to html - is it possible?' Thread RSS Feed

passing php variable to html - is it possible?

Re: passing php variable to html - is it possible?

Re: passing php variable to html - is it possible?

Re: passing php variable to html - is it possible?