Make MYSQL Table a PHP Variable

[Scruffy]

Hi,

 

I was wondering if anyone knows if there is away to make the selection of table from MYSQL to be a php variable.

 

Example is below:

 

$id = $_GET['id'];
$query_tester= "SELECT * FROM `$id` WHERE db_title = '$id'";

 

Thanks for your help!

[MadTechie]

I'm kinda unsure of the actual question here!

selection of table from MYSQL to be a php variable.

The table used is the same one in the SQL statement!

 

 

[Scruffy]

I have a large database with multiple tables in it. I would like to use a variable from the current page URL to select the correct table from the database.

 

I'm not sure if that helps explain it or not. Sorry I'm terrible at explaining coding.

[roopurt18]

<?php
$table_name = array_key_exists( 'tablename', $_GET ) ? $_GET['tablename'] : '';
if( ! preg_match( '/^[a-zA-Z0-9_]+$/', $table_name ) ) throw new Exception( '$table_name is invalid: ' . var_export( $table_name, true ) );

$select_stmt = "
    SELECT *
    FROM `{$table_name}`
    WHERE 1=1
";
?>

[Scruffy]

Thanks! It seems to work!