Guest User

Untitled

a guest
Oct 21st, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. function validTable($table){
  2. global $db;
  3. $dbh = $this->connect();
  4. $sql = $dbh->prepare('SHOW TABLES
  5. FROM `'.$db->db_name.'`
  6. WHERE
  7. `Tables_in_'.$db->db_name.'` LIKE 'prefix_%'');
  8. $sql->execute();
  9. $return = false;
  10. foreach($sql->fetchAll(PDO::FETCH_ASSOC) as $row){
  11. if($table === $row['Tables_in_'.$db->db_name]){
  12. $return = $row['Tables_in_'.$db->db_name];
  13. break;
  14. }
  15. }
  16. return $return;
  17. }
  18.  
  19. $tableName = 'prefix_tableName' //potentially compromised table name
  20. $validTable = validTable($tableName);
  21. if($validTable !== false){
  22. $sql = $dbh->prepare('SELECT * FROM '.$validTable);
  23. //do other stuff
  24. } else {
  25. //error
  26. }
Add Comment
Please, Sign In to add comment