How to replace variable name and variable value from string?

Question

I have a Google Forms Prefilled URL

$input = "https://docs.google.com/forms/d/e/1FAIpQLSe8aZbfXa2IRRzK6hPTDKvAf_Oa8chTMrX8wkkYcuVHGs-vuA/viewform?usp=pp_url&entry.1064398956=NAME&entry.1318807391=TELEPHONE";
$pars = parse_url($input);
$values = $pars["query"];
$values = str_replace("entry.", "", $values);
$values = str_replace("usp=pp_url&", "", $values);

With this code I get values as

1064398956=NAME&1318807391=TELEPHONE

Because the numbers (entry id) are always different, I use default values (like NAME, TELEPHONE), and these would be storaged to mySQL database like this:

Id  ||  NAME       || VALUE
================================
1   || 1064398956  || 1318807391

To upload a row to that mysql database I have the query:

    INSERT INTO TABLE (ID, NAME, VALUE) VALUES (1, $NAME, $VALUE)

Based on the following string, how i can find values $NAME and $VALUE?

1064398956=NAME&1318807391=TELEPHONE

Edit the PHP code in a text editor? It's not clear to me what you mean or what you're asking here. — David
– David, Commented Dec 5, 2017 at 17:58
@userxöa You should put that comment in the question. It's completely different from what you asked, there are no PHP variables in that string. — Barmar
– Barmar, Commented Dec 5, 2017 at 18:12
The comment by @mario should work for you. Have you tried it? 3v4l.org/8CstD You then can iterate over $output and use the key as the var name and the value as you would. — chris85
– chris85, Commented Dec 5, 2017 at 18:36

userxöa · Accepted Answer · 2017-12-05 18:44:31Z

1

The @mario and @chris85 solution that worked:

$string = '1064398956=NAME&1318807391=TELEPHONE';
parse_str($string, $output);
print_r(array_flip($output));

answered Dec 5, 2017 at 18:44

userxöa

6310 bronze badges

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

Comments

zguillez · Accepted Answer · 2017-12-05 18:27:33Z

0

This code will switch the var name whit the value ($VALUE variable with 'NAME' value)

function get_var_name($vars, $var)
{
  foreach ($vars as $name => $value) {
    if ($value === $var) {
      return $name;
    }
  }
  return false;
}

$NAME = "VALUE";
$$NAME = get_var_name(get_defined_vars(), $NAME);

echo $VALUE; // will print 'NAME'

answered Dec 5, 2017 at 18:27

zguillez

513 bronze badges

1 Comment

Utkarsh Dixit Over a year ago

Multiple variables can have the same value as another.

Collectives™ on Stack Overflow

How to replace variable name and variable value from string?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related