CodeIgniter Subfolder .htaccess setup

When you are going to setup  CodeIgniter in live sufolder. There you need to create .htaccess file.

RewriteEngine on
RewriteCond $1 !^(index\.php|images|robots\.txt)
RewriteCond %{REQUEST_FILENAME} !-f 
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /admin/index.php?/$1 [L]

Most Popular

How to get table count for all tables in a database in Mysql?

Following Example shows you how to get tables list from database using PHP CODE. <?php $dbname = 'mysql_dbname'; if (!mysql_connect('localhost', 'root', '')) {     echo 'Could not connect to mysql';     exit; } $sql = "SHOW TABLES FROM $dbname";$result = mysql_query($sql); if (!$result) {     echo "DB Error, could not list tables\n";     echo 'MySQL Error: ' . mysql_error();     exit; } while ($row = mysql_fetch_row($result)) {     echo "Table: $row[0] \n"; } mysql_free_result($result);?>
Keep reading

Store Procedure

Reduced network traffic and latency, boosting application performance. Stored procedure execution plans can be reused, staying cached in SQL Server’s memory, reducing server overhead. Client execution requests are more efficient. For example, if an application needs to INSERT a large binary value into an image data column not using a stored procedure, it must convert the binary value to a character string (which doubles its size), and send it to SQL Server. When SQL Server receives it, it then must convert the character value back to the binary format. This is a lot of wasted overhead. A stored procedure eliminates this issue as parameter values stay in the binary format all the way from the application to SQL Server, reducing overhead and boosting performance. Stored procedures help promote code reuse. While this does not directly boost an application’s performance, it can boost the productivity of developers by reducing the amount of code required, along with reducing ...
Keep reading

Disable/enable a form element using jQuery?

There are two ways to disable/enable form elements. Set the 'disabled' attribute to true or false: // Disable #x $('#x').attr('disabled', true); // Enable #x $('#x').attr('disabled', false); Add or remove the 'disabled' attribute: // Disable #x $("#x").attr('disabled', 'disabled'); // Enable #x $("#x").removeAttr('disabled');
Keep reading