How to pick up the database name and table name from the URL in PHP?

Question

I am new to PHP. I need a help regarding the methods of extracting DB name and table name from the given URL name. For example, let's say, I have an URL like the one below:

/test.php?db=...&table=.../

How to extract the DB name and table name from this URL using PHP and use the result for other query purposes.

parse_url and parse_str() will help you. php.net/manual/en/function.parse-url.php php.net/manual/en/function.parse-str.php — Pekka
– Pekka, Commented Jun 17, 2012 at 11:02
I know, you are just getting started and figure out the basics. But you should know that there are are lot of security aspects to consider when you pass a user entry (from the URL) into your database. Maybe start reading here en.wikipedia.org/wiki/SQL_injection — pixelistik
– pixelistik, Commented Jun 17, 2012 at 11:14

score 2 · Accepted Answer · 2012-06-17 11:46:43Z

2

If you mean how to parse an existing URL for it's parameters:

parse_url() and parse_str() will help you strip the components of the url. You will primarily be looking at the following

$elements = parse_url($url);
$kvps = $elements->query;
$db = parse_str($kvps['db']);
$table = parse_str($kvps['table']);

But, if you mean how to GET variables from the current page before render:

<?php

$dbname = $_GET['db'];
$tablename = $_GET['table'];

?>

And yea, there are major security risks involved in opening up 'direct' access to your database this way. Best to obfuscate / encapsulate / wrap your functions in tasks like index.php&addUser=tim instead of index.php&insert=tim&db=boofar&table=users&dbuser=root&dbpassword=secure.

If you're just learning, what you're doing is fine, as long as you realize why it's wrong. If you're coding for production, you really need an alternate solution.

edited Jun 17, 2012 at 11:46

answered Jun 17, 2012 at 11:03

user1416258

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

4 Comments

bharath119 Over a year ago

Similar to that..but I have to get the values from URL.How to do that?

user1416258 Over a year ago

Use parse_url() as @Pekka has suggested.

pixelistik Over a year ago

$_GET are the values from the URL query string.

Pekka Over a year ago

@Geoist feel free to incorporate parse_url() and parse_str() into your answer... people too lazy to answer, adding a comment instead, forfeit their rights :)

Jeroen · Accepted Answer · 2012-06-17 11:06:42Z

1

There are two ways to pass variables or data to another page.

GET (via the URL) and POST (usually a form submission)

You can alway get via $_GET http://php.net/manual/en/reserved.variables.get.php

or

$_POST http://nl.php.net/manual/en/reserved.variables.post.php

answered Jun 17, 2012 at 11:06

Jeroen

1,6383 gold badges24 silver badges50 bronze badges

Collectives™ on Stack Overflow

How to pick up the database name and table name from the URL in PHP?

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related