Styjun

I have made this function to take values from the form and overwrite the config/database.php.

 function configure_database() 
 // write database.php
 $data_db = file_get_contents('./uploads/database.php');
 // session_start();
 $data_db = str_replace('%DATABASE%', $_SESSION['dbname'], $data_db);
 $data_db = str_replace('%USERNAME%', $_SESSION['username'], $data_db);
 $data_db = str_replace('%PASSWORD%', $_SESSION['password'], $data_db);
 $data_db = str_replace('%HOSTNAME%', $_SESSION['hostname'], $data_db);
 file_put_contents('./application/config/database.php', $data_db);
 $this->run_blank_sql();
 

and it successfully overwrites the config/database.php. at the last of the function I have written the $this->run_blank_sql(); which calls the run_blank_sql() I have written this function to run the SQL in uploads directory.

function run_blank_sql() 
 $this->load->database();
 // Set line to collect lines that wrap
 $templine = '';
 // Read in entire file
 $lines = file('./uploads/install.sql');
 // Loop through each line
 foreach ($lines as $line) 
 // Skip it if it's a comment
 if (substr($line, 0, 2) == '--' 
 

But it gives me that error.

the configure_database() overwrites these values successfully.

'hostname' => '%HOSTNAME%',
 'username' => '%USERNAME%',
 'password' => '%PASSWORD%',
 'database' => '%DATABASE%',
 'dbdriver' => 'mysqli',

To

'hostname' => 'localhost',
'username' => 'root',
'password' => *****,
'database' => 'studentPortal',
'dbdriver' => 'mysqli',

It says clearly in

that No Database Selected

I think, You need to specify

$db['default']['database'] = "YOUR_DB"; 

in /application/config/database.php

Wherever you are running the drop (I don't see that in your code) is the problem. You're dropping a table but are not specifying the schema where that table is.

Even if you have only one table called category you need to be specific about what schema it lives in. Change your drop statement to be: drop table schema.category.

This hasn't got anything to do with the $db['default']['database'] = "YOUR_DB"; in the configuration. It's just standard SQL