Php page with html form inside execute php code before form is completed

Question

This might be a stupid problem but i'm new to this (this is a homework ^^) and i can't find a solution :) i have a .php file with an html form plus some php code to execute a query and insert the values from the form in my DB. And it works, but every time the page is loaded the php code is executed and this insert in the DB a "blank" line, because obviously the form was not filled yet. This is the code

<html>
<head>
  <meta charset="utf-8">
  <meta name="generator" content="AlterVista - Editor HTML"/>
  <title></title>
</head>
<body>

<form action="myPage.php" method="post"> 
ID: <input type="text" name="id" /> <br /> 

<input type="submit" name="Submit" value="Go" /> <br />
</form>

<?php
$user = "DB";
$password = "";
$host = "";
$database = "my_DB";
$connessione = mysql_connect($host, $user, $password);

@mysql_select_db($database, $connessione) or die( "Unable to select database");

$id = $_REQUEST['id'];
$query = "INSERT INTO myTable (ID) VALUES ('".$id."')";
mysql_close();
?>

</body>
</html>

Is there a way to execute the php code only once the "Go" button on the form is executed?

That's exactly what's supposed to happen: php working before page being rendered — Damien Pirsy
– Damien Pirsy, Commented Feb 17, 2014 at 16:58
yeah i supposed xD, but there's a way to execute a piece of php code just "after" something happens? (like completion of form) — r4id4
– r4id4, Commented Feb 17, 2014 at 16:59
you could use a die() statement to stop the code from executing again also it is advisable to keep your processing scripts(connection,insert) in a sepearate file — Dev Man
– Dev Man, Commented Feb 17, 2014 at 17:04

BurningLights · Accepted Answer · 2015-06-02 13:03:32Z

0

Try:

if(isset($_POST['Submit']))  {
    $user = "DB";
    $password = "";
    $host = "";
    $database = "my_DB";
    $connessione = mysql_connect($host, $user, $password);

    @mysql_select_db($database, $connessione) or die( "Unable to select database");

    $id = $_REQUEST['id'];
    $query = "INSERT INTO myTable (ID) VALUES ('".$id."')";
    mysql_query($query, $connessione);
    mysql_close();
}

edited Jun 2, 2015 at 13:03

BurningLights

2,4071 gold badge17 silver badges22 bronze badges

answered Feb 17, 2014 at 17:02

hanleyhansen

6,4578 gold badges39 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

r4id4 Over a year ago

tried it but never execute the code even after the submit button is pressed!should i change other code?

r4id4 Over a year ago

EDIT: now it worked i wrote "Submit" instead of "submit"

lxndr · Accepted Answer · 2014-02-17 17:01:19Z

0

PHP will work before the page is rendered. You need to set up a condition to stop the PHP you don't want running until you submit the form.

if(isset($_POST['myform'])) {
    // process the form
}else{
    // html for form goes here
}

Hope that helps.

answered Feb 17, 2014 at 17:01

lxndr

7031 gold badge11 silver badges25 bronze badges

Comments

giorgio · Accepted Answer · 2014-02-17 17:02:29Z

0

Assuming the form points to the script itself, there are numerous options :) Among others:

This first example just checks if a form was posted. If a normal (GET) request is received, it will do nothing, because it will not fall into your if-clause

// your form here
if($_SERVER['REQUEST_METHOD'] == 'POST') {
    // your php code
}

And this example checks if a variable with the name 'Submit' has been posted, and if so, if it has the value 'Go' in it. It is a slightly stricter check, but in your current example behaviour is exactly the same (so you can pretty much choose which one you like most ;))

// your form here
if(array_key_exists('Submit', $_POST) && $_POST['Submit'] == 'Go') {
    // your php code
}

answered Feb 17, 2014 at 17:02

giorgio

10.2k2 gold badges30 silver badges41 bronze badges

1 Comment

r4id4 Over a year ago

i've tried both. The first still execute, the second never execute ;( i pasted it just after <?php if(.. and closed here }?>

Collectives™ on Stack Overflow

Php page with html form inside execute php code before form is completed

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related