0

Hi
is it possible to display database values in a .html form using php.

This is my .html form and I want to display values from mysql in the form fields.

<!DOCTYPE html>
<html>
<head>
    <title>Bursary application</title>
</head>
<body>
<form action="config.php" method="post">
<div>
    <p></p>
    <label for="surname">Surname:</label><input id="surname" type="text" name="surname" value="<?php echo $surname;?>">
    </div>
<div>
    <label for="names">Names:</label><input id="names" type="text" name="names" value="<?php echo $name;?>">
    </div>
<div>
    <label for="birthdate">Date Of Birth:</label><input id="birthdate" type="date" name="birthdate" value="<?php echo $birthdate;?>"><br><br>
</div>
<div>
    <label for="email">Email</label><input id="email" type="email" name="email" value="<?php echo $email;?>"><br><br>
</div>
<div>
    <label for="gender">Gender:</label></div>
<div>
    <label for="gender">Male</label><input id="gender" type="radio" name="gender" value="Male">
    </div>
<div>
    <label for="gender">Female</label><input id="" type="radio" name="gender" value="Female">
    </div>
<div>    <label for="postad">Postal Address:</label><input id="postad" type="text" name="postad" value="">
</div>
<div>    <label for="residential">Residential Address:</label><input id="residential" type="text" name="residential" value="">
</div>
<div>    <label for="homephone">Phone(Home):</label><input id="homephone" type="tel" name="homephone" value="">
</div>
<div>    <label for="workphone">Phone(Work):</label><input id="workphone" type="tel" name="workphone" value="">
</div>
<div>    <label for="mobile">Phone(Cell):</label><input id="mobile" type="tel" name="mobile" value="">
</div>
    <div>
    <label for="image">Email:</label><input id="image" type="file" name="image" value="">
        </div>
<input type="submit" value="apply" name="apply">
</div>
</form>
</body>
</html>
5
Contributors
17
Replies
59
Views
3 Years
Discussion Span
Last Post by drjohn
Featured Replies
  • 1
    diafol 3,720   3 Years Ago

    You can certainly re-use a form. No issue with that. You just need to change the action value. If you've got the form in its own include file, you can do this: ## form include file (formfile.php) ## <?php $fields = ['surname','names','birthdate','email', 'gender', 'postad']; //etc foreach($fields as $field) $$field = … Read More

0

You can display php in normal html files by addinng to your htaccess file:

AddType application/x-httpd-php .html .htm
0

If I place the .htaccess file in a directory will it manipulate all the files there.

0

SHow your .htaccess file and your directory structure

0
AddType application/x-httpd-php .html .htm
Attachments struct.JPG 30.42 KB
0

Strange. Looks OK to me. Sorry, anybody else?

-1

It is imposible to run PHP in a .html file. But as we are students of how to code we can try different ways. You should use iframe to include the php within the html page.

Edited by safeer008

Votes + Comments
bad advice
0

@safeer008. It is not, I assure you. You do not need to resort to using an iframe for anything like this.

The link you provide is a general one, that leads me to think that the site may be yours or you are affiliated with it. If you do not wish to be called out for spamming, please link to relevant pages. That was not relevant.

0

Here's my output, just to prover that it can be done, regardless of what safeer seems to think:

Directory Structure

dir.pmg_.PNG

.htaccess content

htaccess.PNG

me.html content (pure php)

content.png

browser output

output.png

0

Hi Diafol,
When I do it the way you did it, 'echo Hello' it works perfectly but putting it in the value attribute of the form it doesn't.
Anyway I'm trying to use the same HTML form to create a profile as well as to update it. Would you advise on that?

1

You can certainly re-use a form. No issue with that. You just need to change the action value.

If you've got the form in its own include file, you can do this:

form include file (formfile.php)

<?php
    $fields = ['surname','names','birthdate','email', 'gender', 'postad']; //etc

    foreach($fields as $field)
        $$field = (!isset($row[$field])) ? '' : $row[$field];

    $action = (isset($update)) ? 'updateUser.php' : 'createUser.php';
?>
<form action="<?=$action?>" method="post">
<!-- rest of form -->
</form>

If you want a create form. Just do...

include 'formfile.php';

If you want an update form:

// $row from your DB query
$update = true;
include 'formfile.php';

There are many variations on a theme, but I've found that keeping a consistent look and feel to a create and update form is a good thing.

0

Great thanks you're a blessing. You've been really helpful.

0

PHP variables etc do not show up in a file named something.html, unless you go through all the things they mention above. Which is not actually the right way to work.

The correct way is to name your file as a .php file, and of course to connect to your database and retrieve the info needed using a query, then assign the returned data to variables. Or if you are reusing a form, start with the form named as a .php file.

Then all this playing with .htaccess becomes totally unnecessary.

Edited by drjohn

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.