How to pass text input to a php function?

Question

I have the following code on a php page:

<form action="" method="get">
First Name:
<input type="text" name="first"/><br />
Last Name:
<input type="text" name="last"/>
<input type="submit" value="Add">
</form>

It is a form to add a new user to a sqlite database. In another file I have this php function:

function addUser($firstName, $lastName) {
        $sql = "INSERT INTO USERS
            (FIRST, LAST)
            VALUES ('$firstName', '$lastName')";
    return execSQL($sql);
}

So what I want to do is pass the text that a user enters in the text fields to the function (which has been placed in the global scope, but is in a different document). How can I do this?

i dont see where the problem is .. just call the addUser function after you get ur values from the $_GET .. and dont forget to do some validation and filtration — Leo Bali
– Leo Bali, Commented Apr 27, 2014 at 8:26
fill up the "action" part of the form, submit, and then retrieve the values you passed in php using $_GET array... — Sebas
– Sebas, Commented Apr 27, 2014 at 8:26

underscore · Accepted Answer · 2014-04-27 08:27:24Z

1

You FORM method is get so use $_GET.As you mentioned in action your php code and form should be in same page.

<?php

$firstname=''; // Declare your variables first 
$lastname='';  // Declare your variables first 

if(isset($_GET['first']) && isset($_GET['last'])){ // Then validate it
$firstname = $_GET['first'];  
$lastname = $_GET['last'];
 addUser($firstName, $lastName); // Then use your function call
}

?>

answered Apr 27, 2014 at 8:27

underscore

6,9277 gold badges44 silver badges82 bronze badges

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

Comments

user1492867 · Accepted Answer · 2014-04-27 08:27:07Z

0

You probably want to load a new page which calls this function using the variables from the form and then displays a confirmation message. You can get these variables with $_GET['variable name'].

answered Apr 27, 2014 at 8:27

user1492867

1371 silver badge10 bronze badges

Comments

Krish R · Accepted Answer · 2014-04-27 08:28:15Z

0

Try this, You have used get method in your form, so you need to use $_GET.

if(isset($_GET['first']) && isset($_GET['last'])){
   $firstName = $_GET['first'];
   $lastName = $_GET['last'];
   addUser($firstName, $lastName); // passing the value into function
 }

answered Apr 27, 2014 at 8:28

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

Comments

Community · Accepted Answer · 2023-11-21 15:10:29Z

0

Just set the form action to a page which includes:

addUser($_GET['first'], $_GET['last']);

However, this code is vulnerable to SQL injections and should never be used in production. Make sure you at least run it through mysql_escape_string, or preferably switch to PDO and use parameter binding.

https://www.php.net/manual/en/function.mysql-escape-string.php

edited Nov 21, 2023 at 15:10

CommunityBot

11 silver badge

answered Apr 27, 2014 at 8:29

thexacre

7024 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to pass text input to a php function?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related