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

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

Posted a 'reply on the PHP forum.

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?

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

Posted a 'new message on the PHP forum.

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;&nbsp;&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>

How can I select duplicate rows in MySQL

Mon, 08 Sep 2008 20:27:17 -0700

Posted the message 'How can I select duplicate rows in MySQL' on the Database & SQL forum.

I need to select all the duplicate rows in a MySQL table. The table contains 3 columns:

ID - unique primary key
Name
Description

I want to select all records with duplicate values in the name field, so the output would be like:

1 Bill operations
4 Bill receiving
7 Tom operations
8 Tom customer service
...etc

Any help would be greatly appreciated. I'm new to this, so be kind!

mail() function returns backslash escape characters

Sat, 09 Aug 2008 10:07:18 -0700

Posted the message 'mail() function returns backslash escape characters' on the PHP forum.

When I use the mail()function, the resulting email that is sent contains escape characters in front of apostrophes, etc.

Example: I don\'t know why an apostrophe causes escape backslashes to appear in the message being sent.

I'm new to PHP, so I'd really appreciate it if someone would help me out with getting around this problem.

Thanks in advance.

peterv6's Feed - Programmer's Heaven

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

passing php variable to html - is it possible?

How can I select duplicate rows in MySQL

mail() function returns backslash escape characters