Request for Input for PHP Script in Linux

I'm currently running a DNS server with a MySQL Backend, and I'm creating scripts to insert data into the MySQL tables.

My question is: Is it possible to have the script run, then request input in the shell to then be put into the script to then be run in a query against the MySQL Server?

For example I have a query to be ran:

INSERT INTO table (domain, type, ttl) VALUES ('$domain', 'TXT', 120);

I want to change the $domain variable on each run of the script and do not want to keep editing the script file.

Thanks for any responses

asked Nov 29, 2017 at 15:19

user6670350

1

While this is presumably something you run from the CLI, you should probably still address the SQL injection hole.

ceejayoz
– ceejayoz

2017-11-29 15:22:22 +00:00
Commented Nov 29, 2017 at 15:22
Do you want to send those params as arguments (like this: php myscript somedomain.com or do you want your script to ask for the domain? If the former is OK, then look into $argv: php.net/manual/en/reserved.variables.argv.php If you want the latter, then I would suggest some console library.

M. Eriksson
– M. Eriksson

2017-11-29 15:22:35 +00:00
Commented Nov 29, 2017 at 15:22
Your example there would function well for my needs. I'll look into that. Thanks for the help. @MagnusEriksson

user6670350
– user6670350

2017-11-29 15:36:48 +00:00
Commented Nov 29, 2017 at 15:36

Add a comment |

Collectives™ on Stack Overflow

Request for Input for PHP Script in Linux [duplicate]

0

Linked

Hot Network Questions