在这里需要一些帮助 - 我有一个向用户提供数据的表格:用户可以选择更新表格。如果表格已更新,我想生成一封包含该(更新)数据的电子邮件。到目前为止清楚吗?
当我运行代码时,它确实会更新数据库,但发送以下错误 -
Fatal error: Function name must be a string in C:xampphtdocsmlacmlac_member2.php on line 226
好的 - 这是相关代码(我省略了其余部分,因为它不会对此问题添加任何内容):
<?php
if (isset($_GET['view']))
{
$user = sanitizeString($_GET['view']);
$data = "SELECT * FROM names WHERE id='$user'";
$result=mysql_query($data) or die(mysql_error());
while($row=mysql_fetch_array($result)){
?>
.html
<caption>Personal Record</caption>
<tr>
<th>ID</th>
<td><?php
echo $row['id'];
?></td>
</tr>
<tr>
<th>Name</th>
<td><?php
echo $row['name'];
?></td>
</tr>
<tr>
<th>E-Mail</th>
<td><?php
echo $row['email'];
?></td>
</tr>
<tr>
<th>Main Telephone</th>
<td><?php
echo $row['maintel'];
?></td>
</tr>
<tr>
<th>Mobile Telephone</th>
<td><?php
echo $row['mobtel'];
?></td>
</tr>
<tr>
<th>Organisation</th>
<td><?php
echo $row['organisation'];
?></td>
</tr>
<tr>
<th>Group Leader</th>
<td><?php
echo $row['group_leader'];
?></td>
</tr>
<tr>
<th>Supervisor</th>
<td><?php
echo $row['supervisor'];
?></td>
</tr>
<tr>
<th>Volunteer</th>
<td><?php
echo $row['volunteer'];
?></td>
</tr>
<tr>
<th>Assessor</th>
<td><?php
echo $row['assessor'];
}
}
?></td>
</tr>
</table>
<br />
<form method="post" action="update.php">
<input name="Submit1" type="submit" value="Edit" style="width: 67px" /></form>
<p> </p>
[/html]
<?php
$to='xy@sth.com';
$subject='Test Script';
$name=$row('name');
$email=$row('email');
$phone=$row('mobtel');
$message=("Name: ").$name. ("rn") . ("Email: ") .$email . ("rn") . ("Phone: ") .$phone;
mail($to,$subject,$message);
?>
如果有人能帮忙,我将不胜感激。
问候
$row
不是一个函数,它是一个数组(我猜)。
$name=$row['name'];
$email=$row['email'];
$phone=$row['mobtel'];
$name=$row['name'];
$email=$row['email'];
$phone=$row['mobtel'];
巴兹梅加卡帕说的没错...并删除以下行中的参数。
$message="Name: ".$name. "rn" . "Email: " .$email . "rn". "Phone: ".$phone;
如果要在邮件中添加标题,请尝试如下操作
$headers1 = "MIME-Version: 1.0rn";
$headers1 .= "Content-type: text/html; charset=iso-8859-1rn";
$headers1 .= "From: $fromurlrn";
@mail($to, $subject , $message, $headers1);