PHP - Global Variables

Question

I am trying to dynamically set database connection credentials based on who logs into a web page. I'm pretty sure it's not working because of the $connectdb variable not being defined. Can someone please check out my code and try to get it working? Thanks!

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

$connectdb="";
class Main extends CI_Controller {
    function __construct() {
        parent::__construct();

        echo $connectdb;
        $this->load->database($connectdb);
        $this->load->helper('url');
        $this->load->library('grocery_CRUD');
    }

    public function index() {
        if ($_POST["username"] == "root") {
            global $connectdb="default";
        }

        if ($_POST["username"] == "user1") {
            global $connectdb="user1";
        }

        if ($_POST["username"] == "user2") {
            global $connectdb="user2";
        }

        $connect = @mysql_connect("localhost", $_POST["username"],      $_POST["password"]);//won't display the warning if any.
        if (!$connect) {
            echo 'Server error. Please try again sometime. CON';
        } else {
            print("<a href=\"http://v-admindb/ci/index.php /main/employees?username=".$_POST["username"]."\">Employees</a>");
            echo "<br>";
            print("<a href=\"http://v-admindb/ci/index.php/main/visitors?username=".$_POST["username"]."\">Visitors</a>");
        }//Just an example to ensure that we get into the function
    // LOAD LIBRARIES
    }

    public function employees() {
        $this->grocery_crud->set_table('employees');
        $output = $this->grocery_crud->render();
        $this->_example_output($output);
    }

    public function visitors() {
        $this->grocery_crud->set_table('visitors');
        $output = $this->grocery_crud->render();
        $this->_example_output($output);
    }

    function _example_output($output = null) {
        $this->load->view('our_template.php',$output);
    }
}

stormdrain · Accepted Answer · 2013-10-03 17:56:49Z

1

A quick read of THE MANUAL will show you it's pretty easy to have multiple database connections. You define the connection parameters in your database.php config file then call the database with the group name.

if($user == 'someguise'){
    $this->load->database('guiseDB');
}

HTH

edited Oct 3, 2013 at 17:56

answered Oct 3, 2013 at 17:33

stormdrain

7,8954 gold badges40 silver badges76 bronze badges

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

2 Comments

user2839568 Over a year ago

That won't work unfortunately. What I need to do is set a variable called $connectdb based on the username from the login screen (using $_POST["username"] ) then use $this->load->database($connectdb) I tried listing multiple if statements inside the constructor but it did not work.

stormdrain Over a year ago

I see now in your code you might be using grocery crud. I went ahead and took the 8 seconds to search google for you: grocerycrud.com/forums/topic/…

cartalot · Accepted Answer · 2013-10-03 22:13:08Z

For something as important as this i would strongly suggest running the form input through CI form validation first. You really should be validating and doing things like limit the number of characters, make sure its letters only, trim whitespace and XSS cleaning - all before you do anything else. (this helps your user as well)

then to get the value from the form - do something like this

$username = $this->input->post( 'username', TRUE ) ;

and work with the one variable $username. the TRUE XSS cleans the value, and then instead of repeating

$_POST["username"] ==

over and over and over, you are just checking $username. also makes the code easier to read. if you need $username in different methods just use:

$this->username = $this->input->post( 'username', TRUE ) ;

and then $this->username will work in any method in the class.

finally consider having a table of users or config list -- and then use a different value to call your database. in other words maybe they log in with the user name: "root" but then its a different name like global $connectdb = "rootadmin"

Collectives™ on Stack Overflow

PHP - Global Variables

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related