Research & amp; Update MySQL with Form

I wonder whether someone can help me please.

I’m trying to put together a form that I can use to search for member details from a mySQL database, retrieve the results so that they appear in pre-determined text boxes on the same form and make updates to send back to the database.

The code I’m using is as follows:

PHP

<?php
require("phpfile.php"); 

// Opens a connection to a MySQL server 

$connection=mysql_connect ("hostname", $username, $password);
if (!$connection) { die('Not connected : ' . mysql_error());} 

// Set the active MySQL database 

$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
die ('Can't use db : ' . mysql_error());
} 

$email = $_POST['email'];
$sql = mysql_query("SELECT * FROM userdetails WHERE emailaddress like '%$emailaddress%'"); 

while($row = mysql_fetch_array($sql))
{
echo $row['forename'];
echo $row['surname'];
echo "
"; } ?>

HTML FORM




Untitled Document


Search:

<input name="surname" type="text" id="surname" value="" />

I’m using the email address to search for the desired record, but the problem I’m having is that all of the records are retrieved rather than the one I have entered the details for, and the results don’t appear in the forename and surname fields on the form.

Could someone perhaps please show me what I’m doing wrong

Kind regards

… but if you press submit button to update white email it should look like this:

if(isset($_REQUEST['submit'])) {
$fname = mysql_real_escape_string($_POST['forename']);
$sname = mysql_real_escape_string($_POST['surname']);
$emai= mysql_real_escape_string($_POST['email']);
mysql_query(UPDATE `table` SET `forename` = $fname, `surname` = $sname, `email`=$email WHERE id = `id`);
}
Hello, buddy!责编内容来自:Hello, buddy! (源链) | 更多关于

阅读提示:酷辣虫无法对本内容的真实性提供任何保证,请自行验证并承担相关的风险与后果!
本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » 后端存储 » Research & amp&semi; Update MySQL with Form

喜欢 (0)or分享给?

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录