The correct way to avoid SQL injection attacks, no matter which database you use, is to separate the data from SQL, so that data stays data and will never be interpreted as commands by the SQL parser.

The PHP configuration file, php.ini, is the final and most immediate way to affect PHP's functionality. The php.ini file is read each time PHP is initialized.in other words, whenever httpd is restarted for the module version or with each script execution for the CGI version.

Controllers Page

1) What is PHP? PHP stands for Hypertext Preprocessor. It is an open source server-side scripting language which is widely used for web development. It supports many databases like MySQL, Oracle, Sybase, Solid, PostgreSQL, generic ODBC etc.

*SQL CREATE TABLE ` user ` ( ` user_id ` int ( 11 ) NOT NULL , ` user_name ` varchar ( 50 ) NOT NULL , ` user_email ` varchar ( 50 ) NOT NULL , ` user_password ` varchar ( 50 ) NOT NULL , ` user_age ` int ( 11 ) NOT NULL , ` user_mobile ` int ( 11 ) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = latin1 ;

Controller file   function import()     {         $filename = $_FILES["file"]["tmp_name"];         if ($_FILES['file']['size'] > 0) {             $file              = fopen($filename, "r");             $is_header_removed = FALSE;             while (($importdata = fgetcsv($file, 1000…

public function register_user()     {                 if ($this->input->post()) {             $this->form_validation->set_rules('first_name', 'First Name', 'required|is_unique[user.first_name]');             $this->form_validation->set_rules('last_name', 'Last Name', 'r…