ABOUT HSTS

HTTP Strict Transport Security (HSTS) instructs web browsers to only use secure connections (https://) for all future requests when communicating with a web site. Doing so helps prevent SSL protocol attacks, SSL stripping, cookie hijacking, and other attempts to circumvent SSL protection.

ENABLING HSTS ON LINUX

To enable HSTS for your site, follow these steps:

1. Using SSH, the cPanel File Manager, or the Plesk File Manager, navigate to the document root of your site.
2. Use your preferred text editor to open the .htaccess file.
   
   If the .htaccess file does not already exist, create it.
3. Copy the following line, and then paste it into the .htaccess file:
   

   Header set Strict-Transport-Security "max-age=31536000" env=HTTPS​

4. Save your changes to the .htaccess file. HSTS is now enabled for your site.
   
   When the web server sends this header, any browser that accesses the site over HTTPS will be unable to access the unsecured HTTP site for the specified length of time (in this case, 31,536,000 seconds, or one year). Therefore, as soon as you enable HSTS, you should not stop using SSL on your site. If you do, returning visitors will be unable to access your site.

ENABLING HSTS ON WINDOWS

To enable HSTS for your site, follow these steps:

1. Using the Plesk File Manager, navigate to the document root of your site.
2. Click the web.config file to open it in the file editor.
3. There is a specific location to enter the settings for HSTS, and it is different depending on the existing contents of the web.config file. Please carefully review each of the three scenarios below, and then select the correct one for your situation:
   1. If the web.config file is empty, paste the entire code below into the editor and click Apply:

      <?xml version="1.0" encoding="UTF-8"?>
      <configuration>
          <system.webServer>
              <rewrite>
                  <rules>
                      <rule name="HTTP to HTTPS redirect" stopProcessing="true">
                          <match url=".*" />
                          <conditions>
                              <add input="{HTTPS}" pattern="off" ignoreCase="true" />
                          </conditions>
                           
      <action type="Redirect" url="https://{HTTP_HOST}{REQUEST_URI}" redirectType="Permanent" />
                      </rule>
                  </rules>
                  <outboundRules>
                      <rule name="Add Strict-Transport-Security when HTTPS" enabled="true">
                          <match serverVariable="RESPONSE_Strict_Transport_Security" pattern=".*" />
                          <conditions>
                              <add input="{HTTPS}" pattern="on" ignoreCase="true" />
                          </conditions>
                          <action type="Rewrite" value="max-age=31536000; includeSubDomains; preload" />
                      </rule>
                  </outboundRules>
              </rewrite>
          </system.webServer>
      </configuration>
      ​

   2. If the web.config file is not empty, look for the section. if there is no section, paste in the highlighted green code as shown:

      <?xml version="1.0" encoding="UTF-8"?>
      <configuration>
          <other items>
         </other items>
          <system.webServer>
              <rewrite>
                  <rules>
                      <rule name="HTTP to HTTPS redirect" stopProcessing="true">
                          <match url=".*" />
                          <conditions>
                              <add input="{HTTPS}" pattern="off" ignoreCase="true" />
                          </conditions>
                          <action type="Redirect" url="https://{HTTP_HOST}{REQUEST_URI}"
                              redirectType="Permanent" />
                      </rule>
                  </rules>
                  <outboundRules>
                      <rule name="Add Strict-Transport-Security when HTTPS" enabled="true">
                          <match serverVariable="RESPONSE_Strict_Transport_Security" pattern=".*" />
                          <conditions>
                              <add input="{HTTPS}" pattern="on" ignoreCase="true" />
                          </conditions>
                          <action type="Rewrite" value="max-age=31536000; includeSubDomains; preload" />
                      </rule>
                  </outboundRules>
              </rewrite>
          </system.webServer>
      </configuration>
      ​

   3. Finally, if the web.config file is not empty, and there is a section, paste in the highlighted red code as shown:

      <?xml version="1.0" encoding="UTF-8"?>
      <configuration>
          <other items>
          </other items>
          <system.webServer>
              <other items>
              </other items>
              <rewrite>
                  <rules>
                      <rule name="HTTP to HTTPS redirect" stopProcessing="true">
                          <match url=".*" />
                          <conditions>
                              <add input="{HTTPS}" pattern="off" ignoreCase="true" />
                          </conditions>
                          <action type="Redirect" url="https://{HTTP_HOST}{REQUEST_URI}"
                              redirectType="Permanent" />
                      </rule>
                  </rules>
                  <outboundRules>
                      <rule name="Add Strict-Transport-Security when HTTPS" enabled="true">
                          <match serverVariable="RESPONSE_Strict_Transport_Security" pattern=".*" />
                          <conditions>
                              <add input="{HTTPS}" pattern="on" ignoreCase="true" />
                          </conditions>
                          <action type="Rewrite" value="max-age=31536000; includeSubDomains; preload" />
                      </rule>
                  </outboundRules>
              </rewrite>
          </system.webServer>
      </configuration>
      ​

MORE INFORMATION

For more information about HSTS, please visit https://en.wikipedia.org/wiki/HTTP_Strict_Transport_Security.

Introduction:
Few days ago I received a comment from one of the reader of my blog to show an example on CRUD (Create, Read, Update and Delete) with the database. So in this post we will explore the use of CRUD operation using SQLite database in PhoneGap application.

Description:
CRUD can be described as a process, which helps the user to add, view, search and modify the information inside the database.

Here are the basic steps which demonstrates CRUD operation.

• Create or add new entries
• Read, retrieve, search or view existing entries
• Update, modify or edit existing entries
• Delete, deactivate or destroy existing entries

Before doing any operation on database let’s initialize the database first, either using HTML5 local database concept or using SQLite plugin.

Let’s add the following javascript to initilze the database.

window.openDatabase helps to return the new database object. This method will create a the new SQLite database and also can be use for other data manipulation.

Above method will create the SQLite datebase with unlimited storage capacity. To integrate the SQLite plugin we can follow this post.

Now lets focus on the basic 4 steps of CRUD operation by using the database object already created by above step.

CREATE: Initializing or creating the table. We normally use two keywords CREATE and INSERT for this operation.

Example:

READ: Use to get, search or retrieve entries from a table inside the database.

Example:

UPDATE: This operation is used to update or modify the entries in the table.

Example:

DELETE: This is the last and final method of CRUD operation which is used to delete/drop the entries in table.

Example:

Summary:
I hope the above content will give some idea to start the basic CRUD operation with database and will make the life easy.

Once again, I have a problem with my apache virtual host configuration. (The default configuration is used instead of my specific one).

The problem is not really the misconfiguration but how to solve it.

Does anyone have good advice to do resolve this kind of problem quickly?

Some more pieces of information.

The default conf file is this one:

NameVirtualHost *
<VirtualHost *>
        ServerAdmin webmaster@localhost

        DocumentRoot /var/www/
        <Directory />
                Options FollowSymLinks
                AllowOverride None
        </Directory>
        <Directory /var/www/>
                Options Indexes FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
        </Directory>

        ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
        <Directory "/usr/lib/cgi-bin">
                AllowOverride None
                Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
                Order allow,deny
                Allow from all
        </Directory>

        ErrorLog /var/log/apache2/error.log

        # Possible values include: debug, info, notice, warn, error, crit,
        # alert, emerg.
        LogLevel warn

        CustomLog /var/log/apache2/access.log combined
        ServerSignature On

    Alias /doc/ "/usr/share/doc/"
    <Directory "/usr/share/doc/">
        Options Indexes MultiViews FollowSymLinks
        AllowOverride None
        Order deny,allow
        Deny from all
        Allow from 127.0.0.0/255.0.0.0 ::1/128
    </Directory>

</VirtualHost>

And the virtual host config that doesn't apply is this one:

<VirtualHost *:*>

ProxyPreserveHost On
ProxyPass / http://ip.ip.ip.ip:8088/
ProxyPassReverse / http://ip.ip.ip.ip:8088/
ServerName wiki.mydomain.com

</VirtualHost>

Syntax check

To check configuration files for syntax errors:

# Red Hat-based (Fedora, CentOS) and OSX 
httpd -t 
# Debian-based (Ubuntu) 
apache2ctl -t 
# MacOS 
apachectl -t

List virtual hosts

To list all virtual hosts, and their locations:

# Red Hat-based (Fedora, CentOS) and OSX 
httpd -S 
# Debian-based (Ubuntu) 
apache2ctl -S 
# MacOS 
apachectl -S

We are using VtigerCRM on our local server which provides ldap authentication for http access, also have the customer portal of vtiger on another machine.

When customer portal connects to the server, this authorization problem occurs. The complete error is pasted

Solution 

For your login failure you must turn off your error report in vtigerCRM .

open 

config.inc.php

add or change the error_reporting value 

error_reporting(0);

First let’s look at model and collection architecture in magento. If you look at a magento model class it extends Mage_Core_Model_Abstract which intern extends Varien_Object.The class Mage_Core_Model_Abstract has function like getId(), load(), save(), delete() etc .

Mysql4 resource files, as I mentioned earlier are used to perform database queries on tables. Below will list how we do sql operations inside resource files.

SELECT QUERY

Suppose we have the file Excellence_Test_Model_Mysql4_Test resource file.

<?php
class Excellence_Test_Model_Mysql4_Test extends Mage_Core_Model_Mysql4_Abstract
{
    public function _construct()
    {    
        $this->_init('test/test', 'test_id');
    }
    public function loadByField($field,$value){
    	$table = $this->getMainTable();
    	$where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
    	$select = $this->_getReadAdapter()->select()->from($table,array('test_id'))->where($where);
    	$id = $this->_getReadAdapter()->fetchOne($sql);
    	return $id;
    }
}

And here is the model file Excellence_Test_Model_Test

<?php
class Excellence_Test_Model_Test extends Mage_Core_Model_Abstract
{
	public function _construct()
	{
		parent::_construct();
		$this->_init('test/test');
	}
	public function loadByField($field,$value){
		$id = $this->getResource()->loadByField($field,$value);
		$this->load($id);
	}
}

In this file there are many new functions which have been used. Let’s take them one by one.

In our model file, we have used this function

$id = $this->getResource()->loadByField($field,$value);

$this->getResource() function returns the resource model’s object. So we are simply calling the loadyByField($field,$value) function in the resource model.

getTable() function

Now in our Mysql4 file, in the loadByField() function we have used $table = $this->getMainTable(); .This function returns the table name of the current model, i.e the one defined in the class’s constructor. If you want to get table name of another sql table in magento, we need to the getTable() call e.g

$table = $this->getTable(‘newsletter/subscribe’);

_getReadAdapter() function

Next we have: $where = $this->_getReadAdapter()->quoteInto(“$field = ?”, $value);

Here the first function too see is the $this->_getReadAdapter() function. This function return an object which has function to perform database query, like fetch(), fetchAll(), query(), etc.

Next, in read adapter, we can perform operations like:

1. fetchAll() : returns entire database table in multiple dimensional array as per the select query. e.g if we are executing an sql like “select * from table_name”, we would use the fetchAll() function to get all the values.
2. fetchRow(): returns a single row of the database table as per the select query. e.g if we are executing sql like “select * from table where id = ’1′” would use fetchRow() to get the single row.
3. fetchCol(): returns single column of a database table as per the select query. e.g if query is a select name from table” we would use fetchCol() function.
4. fetchOne(): return since value, i.e single row and single column. e.g if sql query “select count(*) from table” then we would use fetchOne()

The read adapter has many other functions as well, but above are the important functions used.

_quoteInfo() function

Another function we have used is quoteInto(): This function is used to create our where conditions. In this the actual value is substituted into the question mark we have written. For e.g $this->_getReadAdapter()->quoteInto(“user_id = ?”, 3); translates to

“user_id = 3″. Another frequently used variation of quoteInfo() is

$where = $this->_getReadAdapter()->quoteInto("$field IN(?)", array(1,2,3));

this translates to “field in (1,2,3)”

Getting deeper into the quoteInto() function: If we have multiple where conditions we can use

$where = $this->_getReadAdapter()->quoteInto("$field = ? AND ", $value).$this->_getReadAdapter()->quoteInto("$field1 = ? OR ", $value1).$this->_getReadAdapter()->quoteInto("$field2 = ?", $value2);

So this way, we can have multiple where conditions.

Continuing on the loadByField function in our resource model, next we have

$select = $this->_getReadAdapter()->select()->from($table,array(‘test_id’))->where($where);

Here we have created the select query using the select(), and on that called the from() function.

from() function

The from() function takes many different parameters, if you want to fire a simple select * query, you need to only pass the table name like from($table).

But right now, I wanted to select just a single column that is test_id, so I passed an array with column name to select. i.e array(‘test_id’). If we want to select multiple column, we need to array(‘test_id’,’col1’,’col2’). This will create a sql like

“select test_id,col1,col2 from $table”. But support we want a sql query like

“select test_id as id,col1 as column1 from $table” , i would call

from($table,array('id'=>'test_id','column1'=>'col1'));

Note:

If you want to see the exact sql that is generated by your function, you can any time do this

<?php echo $select; ?>

Again, back to the loadByField() function. The last line

<?php
	$id = $this->_getReadAdapter()->fetchOne($sql);
?>

This is already explained, above.

The select() function we used above return a select object which provides us with many more functions to perform all operations on a sql query. The class for the select object is Varien_Db_Select, where you can look into more details for all functions. Let look at a sample php code below.

public function getAll(){
		$table = $this->getMainTable();
		$where = $this->_getReadAdapter()->quoteInto("id = ?", 123);
$select = $this->_getReadAdapter()->select()->from($table)->columns(array('test_id'))->where($where)->limit(10,5)->order('created_time')->group('list_id')->having('list_id > ?',10);		
echo $select;
	}

As we can see all function in the select object, return the select object itself. Due to this we are able to chain the functions.

In this example, I have used almost all the sql select parameters you might require expect joins, which will be covered later.

Let’s take each function one at a time.

1. select() : used to initialize the sql query. This returns the Select object, which is the object on which we do all our operations.
2. from(): table name on which select operation is done. we have seen this in detail above.
3. columns() : here we can specify exactly which columns to select in the query
4. where() : used to give the where condition
5. limit(): takes to parameters. First are how many rows to return and second is offset from where to start. So in current case, it means return 10rows, leaving first 5rows.this uses the LIMIT 10 OFFSET 5 syntax in sql query, rather than LIMIT 10,5
6. order(): you can set how you want to order the result set. Default is ascending order. But if you want to mentioned descending order you do order(array(‘created_time Zend_Db_Select::SQL_DESC))
7. group(): put group by clause in your select query in the specified field.Having(): put having condition for group by clause.

JOINS

Let look at sample function.

public function joinUs()
{
		$table = $this->getMainTable();
		$table2 = $this->getTable('customer/entity');
		$cond = $this->_getReadAdapter()->quoteInto('t1.id = t2.customer_id','');
		$where = $this->_getReadAdapter()->quoteInto('t1.list_id = "?"',123);
		$select = $this->_getReadAdapter()->select()->from(array('t1'=>$table))->join(array('t2'=>$table2), $cond)->where($where);
		echo $select."<br/>";
		$select = $this->_getReadAdapter()->select()->from(array('t1'=>$table))->joinLeft(array('t2'=>$table2), $cond)->where($where);
		echo $select."<br/>";
		$select = $this->_getReadAdapter()->select()->from(array('t1'=>$table))->joinRight(array('t2'=>$table2), $cond)->where($where);
		echo $select."<br/>";
		echo $select."<br/>";
}

This is the output I got in the my pc

SELECT `t1`.*, `t2`.* FROM `aws` AS `t1` INNER JOIN `customer_entity` AS `t2` ON t1.id = t2.customer_id WHERE (t1.list_id = "123")
SELECT `t1`.*, `t2`.* FROM `aws` AS `t1` LEFT JOIN `customer_entity` AS `t2` ON t1.id = t2.customer_id WHERE (t1.list_id = "123")
SELECT `t1`.*, `t2`.* FROM `aws` AS `t1` RIGHT JOIN `customer_entity` AS `t2` ON t1.id = t2.customer_id WHERE (t1.list_id = "123")

So, here you can see clearly how to use joins. I don’t think much explanation is required, the function call are self-explanatory. We can also use joinCross, joinFull, joinNatural as well, if you require it in any query. Please look at Varien_Db_Select class for details.

COUNT,MAX

Again, lets take another sample code

public function countUs(){
		$table = $this->getMainTable();
		$where = $this->_getReadAdapter()->quoteInto("id = ?", 123);
		$select = $this->_getReadAdapter()->select()->from($table)->reset('columns')->columns(new Zend_Db_Expr('count(*)'));
		echo $select.'<br>';
		$select = $this->_getReadAdapter()->select()->from($table)->reset('columns')->columns(new Zend_Db_Expr('max(list_id)'));
		echo $select.'<br>';
	}

This is the output.

SELECT count(*) FROM `aws`
SELECT max("list_id") FROM `aws`

As you can see here, using Expr classes, we do mysql averaging functions.

query() function

In the end, if you have a very complex sql query, you want to execute you can simple use the query function.

$sql = ‘…complex sql…’;

$this->_getReadAdapter()->query($sql);

public function updateUs(){
		$table = $this->getMainTable();
		$where = $this->_getWriteAdapter()->quoteInto('id = ?', 1);
$query = $this->_getWriteAdapter()->update($table, array('product_id'=>2,'file_id'=>3),$where);	
}

Here you can see how to execute the update query.

UPDATE `aws` SET `product_id` = ?, `file_id` = ? WHERE (id = 1)

For delete query, it’s very simple

$this->_getWriteAdapter()->delete($table,$where)->limit(1);

Important Note: Its considered good practice in magento, to execute these sql query in the resource files only. You can get the read adaptor object in model, phtml or any other files and do the above operations in any file. But as good practices, always try to do the query in resource/mysql4 files only.

MySQL database query logging can be enabled/disabled from command line. This will help in debugging database queries.

Enable database query logging

The following CLI command enabled database/mysql query log:

bin/magento dev:query-log:enable

Flush cache

bin/magento cache:flush

After that, browse your Magento site.
The database queries logs are saved in the file var/debug/db.log.

Note:
The database query log file size should be checked. The db.log file can take a lot of space as the file size goes on increasing based on the visit and activity on the Magento site.

By default, all the database queries are logged in the db.log file.
It will also include the call stack for the database query.

Here’s a sample from var/debug/db.log:

## 2024-02-25 16:15:37
## 56786 ## CONNECT
TIME: 0.0134
TRACE: #1 Magento\Framework\DB\Logger\File[Magento\Framework\DB\Logger\LoggerAbstract]#000000002566b81400000000201f09a9#->getStats('connect', '', array(), NULL) called at [vendor/magento/framework/DB/Logger/File.php:67]
#2 Magento\Framework\DB\Logger\File#000000002566b81400000000201f09a9#->logStats('connect', '', array(), NULL) called at [vendor/magento/framework/DB/Logger/LoggerProxy.php:152]
#3 Magento\Framework\DB\Logger\LoggerProxy#000000002566bad400000000201f09a9#->logStats('connect', '') called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:425]
#4 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor[Magento\Framework\DB\Adapter\Pdo\Mysql]#000000002566baef00000000201f09a9#->_connect() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:460]
#5 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor[Zend_Db_Adapter_Abstract]#000000002566baef00000000201f09a9#->query('SELECT `store_we...', array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#6 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor[Zend_Db_Adapter_Pdo_Abstract]#000000002566baef00000000201f09a9#->query('SELECT `store_we...', array()) called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:560]
#7 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor[Magento\Framework\DB\Adapter\Pdo\Mysql]#000000002566baef00000000201f09a9#->_query('SELECT `store_we...', array()) called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:627]
#8 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor[Magento\Framework\DB\Adapter\Pdo\Mysql]#000000002566baef00000000201f09a9#->query(&Magento\Framework\DB\Select#000000002566b82400000000201f09a9#, array()) called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:95]
#9 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor#000000002566baef00000000201f09a9#->query(&Magento\Framework\DB\Select#000000002566b82400000000201f09a9#, array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737]
#10 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor[Zend_Db_Adapter_Abstract]#000000002566baef00000000201f09a9#->fetchAll(&Magento\Framework\DB\Select#000000002566b82400000000201f09a9#, array(), 2) called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:1085]
#11 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor#000000002566baef00000000201f09a9#->fetchAll(&Magento\Framework\DB\Select#000000002566b82400000000201f09a9#) called at [vendor/magento/module-store/App/Config/Source/RuntimeConfigSource.php:101]
#12 Magento\Store\App\Config\Source\RuntimeConfigSource#000000002566bb1600000000201f09a9#->getEntities('store_website', 'code') called at [vendor/magento/module-store/App/Config/Source/RuntimeConfigSource.php:61]
#13 Magento\Store\App\Config\Source\RuntimeConfigSource#000000002566bb1600000000201f09a9#->get('') called at [vendor/magento/framework/App/Config/ConfigSourceAggregated.php:42]
#14 Magento\Framework\App\Config\ConfigSourceAggregated#000000002566bb1c00000000201f09a9#->get('') called at [generated/code/Magento/Framework/App/Config/ConfigSourceAggregated/Proxy.php:95]
#15 Magento\Framework\App\Config\ConfigSourceAggregated\Proxy#000000002566bd0c00000000201f09a9#->get() called at [vendor/magento/module-store/App/Config/Type/Scopes.php:63]
...
...

Exclude Stack Trace in Database Log

This will exclude the stack trace information and will only include the SQL queries.

bin/magento dev:query-log:enable --include-call-stack=false

Sample output in var/debug/db.log

## 2024-02-25 16:28:47^M
## 2648 ## QUERY
SQL: SELECT `main_table`.* FROM `core_config_data` AS `main_table`
AFF: 39
TIME: 0.0077

## 2024-02-25 16:28:48^M
## 2648 ## QUERY
SQL: SELECT `store_website`.* FROM `store_website`
AFF: 2
TIME: 0.0009

## 2024-02-25 16:28:48^M
## 2648 ## QUERY
SQL: SELECT `store_group`.* FROM `store_group`
AFF: 2
TIME: 0.0018

## 2024-02-25 16:28:48^M
## 2648 ## QUERY
SQL: SELECT `store`.* FROM `store`
AFF: 2
TIME: 0.0017

Only Log Slow MySQL Queries

This will log database queries that are slow or take more than a particular time duration (in seconds).

For example, if we want to log database queries that take more than 1.000 seconds then we can set it as follows:

bin/magento dev:query-log:enable --include-all-queries=false --query-time-threshold=1.000

Enable Database Log Manual

bin/magento dev:query-log:enable --help

Description:
  Enable DB query logging

Usage:
  dev:query-log:enable [options]

Options:
      --include-all-queries[=INCLUDE-ALL-QUERIES]    Log all queries. [true|false] [default: "true"]
      --query-time-threshold[=QUERY-TIME-THRESHOLD]  Query time thresholds. [default: "0.001"]
      --include-call-stack[=INCLUDE-CALL-STACK]      Include call stack. [true|false] [default: "true"]
  -h, --help                                         Display this help message
  -q, --quiet                                        Do not output any message
  -V, --version                                      Display this application version
      --ansi                                         Force ANSI output
      --no-ansi                                      Disable ANSI output
  -n, --no-interaction                               Do not ask any interactive question
  -v|vv|vvv, --verbose                               Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug

Disable database query logging

The following CLI command disabled database/mysql query log:

bin/magento dev:query-log:disable

Flush cache

bin/magento cache:flush

Disable Database Log Manual

bin/magento dev:query-log:disable --help

Description:
  Disable DB query logging

Usage:
  dev:query-log:disable

Options:
  -h, --help            Display this help message
  -q, --quiet           Do not output any message
  -V, --version         Display this application version
      --ansi            Force ANSI output
      --no-ansi         Disable ANSI output
  -n, --no-interaction  Do not ask any interactive question
  -v|vv|vvv, --verbose  Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug

Hope this helps. Thanks.

This article shows how to get shopping cart items/products, subtotal and grand total of cart, and shipping and billing address entered while doing checkout in Magento 2.

I will be using both Dependency Injection (DI) and Object Manager in the below example code.

Using Object Manager

– Get products id, name, price, quantity, etc. present in your cart.
– Get number of items in cart and total quantity in cart.
– Get base total price and grand total price of items in cart.
– Get billing and shipping addresses entered during checkout.

Get all items information in cart

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$cart = $objectManager->get('\Magento\Checkout\Model\Cart'); 

// retrieve quote items collection
$itemsCollection = $cart->getQuote()->getItemsCollection();

// get array of all items what can be display directly
$itemsVisible = $cart->getQuote()->getAllVisibleItems();

// retrieve quote items array
$items = $cart->getQuote()->getAllItems();

foreach($items as $item) {
	echo 'ID: '.$item->getProductId().'<br />';
	echo 'Name: '.$item->getName().'<br />';
	echo 'Sku: '.$item->getSku().'<br />';
	echo 'Quantity: '.$item->getQty().'<br />';
	echo 'Price: '.$item->getPrice().'<br />';
	echo "<br />";			
}

Get total items and total quantity in cart

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$cart = $objectManager->get('\Magento\Checkout\Model\Cart'); 

$totalItems = $cart->getQuote()->getItemsCount();
$totalQuantity = $cart->getQuote()->getItemsQty();

Get subtotal and grand total price of cart

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$cart = $objectManager->get('\Magento\Checkout\Model\Cart'); 

$subTotal = $cart->getQuote()->getSubtotal();
$grandTotal = $cart->getQuote()->getGrandTotal();

Get billing and shipping addresses

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$cart = $objectManager->get('\Magento\Checkout\Model\Cart'); 

$billingAddress = $cart->getQuote()->getBillingAddress();
echo '<pre>'; print_r($billingAddress->getData()); echo '</pre>';

$shippingAddress = $cart->getQuote()->getShippingAddress();
echo '<pre>'; print_r($shippingAddress->getData()); echo '</pre>';

Using Dependency Injection (DI)

In the above code in Object Manager, I have used object of class \Magento\Checkout\Model\Cart to fetch shopping cart items and totals. But, we can also use the object of class \Magento\Checkout\Model\Session.

Here is your block class code:

namespace YourCompany\YourModule\Block;
class YourModule extends \Magento\Framework\View\Element\Template
{    
    protected $_cart;    
    protected $_checkoutSession;    
        
    public function __construct(
        \Magento\Backend\Block\Template\Context $context,
        ...
		\Magento\Checkout\Model\Cart $cart,
		\Magento\Checkout\Model\Session $checkoutSession,
        array $data = []
    )
    {
		$this->_cart = $cart;
		$this->_checkoutSession = $checkoutSession;
		
        parent::__construct($context, $data);
    }
    
    public function getCart()
    {		
		return $this->_cart;
    }
	
    public function getCheckoutSession()
    {
		return $this->_checkoutSession;
    }
}

Your .phtml template code:

// Get all items in cart

$quote = $block->getCheckoutSession()->getQuote();
$items = $quote->getAllItems();
 
foreach($items as $item) {
    echo 'ID: '.$item->getProductId().'<br />';
    echo 'Name: '.$item->getName().'<br />';
    echo 'Sku: '.$item->getSku().'<br />';
    echo 'Quantity: '.$item->getQty().'<br />';
    echo 'Price: '.$item->getPrice().'<br />';
    echo "<br />";            
}

// Get total items and total quantity in cart

$totalItems = $quote->getItemsCount();
$totalQuantity = $quote->getItemsQty();

//Get subtotal and grand total price of cart

$subTotal = $quote->getSubtotal();
$grandTotal = $quote->getGrandTotal();

//Get billing and shipping addresses

$billingAddress = $quote->getBillingAddress();
$shippingAddress = $quote->getShippingAddress();

Hope this helps. Thanks.

1.1 Defining your module

Once you've set up Magento and entered it into the root Magento directory, go into app/code/local/. This will be where your module lives on the system. The first folder is your namespace, usually your company name. Then directory underneath this is your module name.

All your module folders will live underneath this module directory. We will create many here, but for starters just create the etc/ and controllers/ directories. We will also create a file called config.xml in this etc/ directory. This is the main, and incredibly important, the configuration file for your module.

Create this folder structure now. Your directory layout should look as follows:

[magentodir]/app/code/local/NAMESPACE/MODULENAME/etc/config.xml

[magentodir]/app/code/local/NAMESPACE/MODULENAME/controllers/

The content of config.xml should be as follows. It adds this module to the rest of the <modules> in the Magento system. And everything is in a module, even the 'core' Magento classes live within modules.

This config.xml specifies the full module name and a version number. The module name, NAMESPACE_MODULE, is derived from the aforementioned folder name. This is a very common pattern in Magento. Take note.

FILE: app/code/local/NAMESPACE/MODULENAME/etc/config.xml

<config>
<modules>
<NAMESPACE_MODULENAME>
<version>0.1.0</version>
</NAMESPACE_MODULENAME>
</modules>
</config>

 

But before the system can actually see your new module you need another config file. This is because the Magento system won't traverse every folder in app/code/local looking for a config.xml file. Instead, it looks in app/etc/modules/ and processes every XML file there. This XML file is similar to the last but without a version number. It specifies that the module is <active>. And that it lives in the local ‘codePool', which means it's in app/code/local. To create this file in app/etc/modules. Its name is the module name as above.

FILE: app/etc/modules/NAMESPACE_MODULENAME.xml

 

<config>
<modules>
<NAMESPACE_MODULENAME>
<active>true</active>
<codePool>local</codePool>
</NAMESPACE_MODULENAME>
</modules>
</config>

 

Now if we flush out the Magento cache in the admin panel (via System->Cache Management->Flush Magento Cache button), and go to System->Configuration->Advanced you should see your module in the list. 

 

 

 

1.2 Declaring your controller 'routes'

But our module doesn't actually do anything currently. We need to add a 'route' going from a URL to a class we define. This will in turn actually do something. Alter your config.xml like so to add that route.

This modification we're adding to the <frontend> of the system (i.e. not the admin panel). And we're adding a router to the other <routers> in the system. We're giving that router a name, useful when dealing with layouts later on.

Then we say it <use>s the ‘standard’ frontend router system. Then it defines the important arguments (<args>): It’ll go to the <module> we’ve just defined. And it's all-important URL, called the <frontName>.

 

FILE: app/code/local/NAMESPACE/MODULENAME/etc/config.xml

 

<config>
<modules>
<NAMESPACE_MODULENAME>
<version>0.1.0</version>
</NAMESPACE_MODULENAME>
</modules>
   <frontend>
<routers>
<ITSROUTERNAME>
<use>standard</use>
<args>
<module>NAMESPACE_MODULENAME</module>
<frontName>URLNAME</frontName>
</args>
</ITSROUTERNAME>
</routers>
</frontend>
</config>

 

 

1.3 Defining the controller class

We’ll now define the PHP class that will be called via that route. Meaning, it will be called when the user goes to <magentourl>/URLNAME.

This will call a class in your controllers/ module directory. The default class that it will call is IndexController.php. And within that class the default method it will call will be indexAction(). All controller class methods called from the outside must have 'Action' suffixed to their name.

If you don’t use these defaults, you have to specify the controller name and action name after URLNAME i.e. [magentourl]/URLNAME/controllername/actionname, as opposed to just [magentourl]/URLNAME. [magentourl]/URLNAME/index/index is the same as just loading [magentourl]/URLNAME

Let’s create that controllers/IndexController.php class now. Its name must be prepended by the Namespace and Module name. All controllers must must have the word Controller at the end. (But you don’t need to use the word 'Controller' should you need to specify the controller in the url.)

The will extend Mage_Core_Controller_Front_Action to allow it to work as a controller and to give it access to various methods and properties of the system.

FILE: app/code/local/NAMESPACE/MODULENAME/controllers/IndexController.php

 

<?php
class NAMESPACE_MODULENAME_IndexController 

               extends Mage_Core_Controller_Front_Action 

   {
public function indexAction() 

       {
echo 'hihi!';
}

   }

?>

So if you go to <magentourl>/URLNAME you should see your new page. It will do nothing except displaying the words 'hihi'. Not impressive--but a start. 

 

You may also want to define a route to the admin panel. But that topic will be dealt with after part I. This is because you will be applying much of what you have learnt dealing with Magento's front end.

Do you want the multi store magento from Single installation of magento . If you want create multi store magento proceed my following way.

Process: 1

If your store have different type of Category and product then follow the steps. Catalog *then* Manage Categories *then* Add Root Category

Process: 2

Create the new Website System *then* Manage Stores *then* Create Website

fill up all asking.

Name: Name for the domain (“samdoit”)

Code : Identifier for the domain (“samdoit")

Create the new store System *then* Manage Stores *then* Create Store

Fill all fields

Website:) Select “samdoit.com” on dropdown .

Name: ) Use samdoit_com identify of store.

Root Category:) Select Categories from category list by default "Default Category"

Create store view:

System *then* Manage Stores *then* Create Store

View Store: Select “samdoit_com” show in dropdown menu.

Name and Code “samdoit_com”

Make sure all leters in smaller case Status: 'Enabled'

Process: 3

Create Magento another domains. You need to update this following files:

Find this two sample file installed

magento root directory

• index.php.sample
• .htaccess.sample .

Copy the two files and Rename both sample files by below names in your other domain.

• .htaccess
• index.php

Open “index.php”

and change line which start with“$mageFilename”

$mageFilename = ‘{Your magento root}/app/Mage.php’;

Also Change Line start with

$mageRunCode" $mageRunCode = isset ($_SERVER['MAGE_RUN_CODE']) ? $_SERVER['MAGE_RUN_CODE'] : ”;

change ' ' into Your store code

$mageRunCode = isset($_SERVER['MAGE_RUN_CODE']) ? $_SERVER['MAGE_RUN_CODE'] : ‘samdoit_com’;

Theme Changes: You must to change skin, media and javascript link . Now set Magento admin Panel by click follow way click " Configuration in System on admin panal " In Configuration tab select {YOUR website/store } from the dropdown Under Configuration tab Click "Web" under Web tab select and change the link for Secure also Unsecured : Skin Link (eg: Media Link (eg: JavaScript Link (eg: Now you done . Now your multiple stores magento is ready to use. We can create you a Magento Theme for your site by just copy the folder and paste the folder into {your magento}/skin/frontend/default/{your theme} " and paste it as your store name and then just go the "system *then* configuration *then* Web *then* Design" and change the select your store name and paste the theme name whatever you have created in magento skin folder.  

With the support of seamless customization and integrations, Magento 2 e-commerce stores can serve excellent experiences to customers. In many cases, the store owners are willing to allow the shoppers to add the product to the cart with a custom price.

Frequently, the store owner is prepared to set a fixed product pricing even if the consumer selects various options/add-ons from the front end for all or some specific products. Instead of manually changing all store products, we’ll need to manually code to override all store product prices with your preferred custom price.

In this article, I will instruct you to set a custom price of the product when adding the product to the cart by using Observe.

Let’s explore two straightforward steps below!

Step 1: Create Events/xml File

Firstly, you need to create events/xml in the folder Mageplaza/HelloWord/etc/frontend and use event checkout_cart_product_add_after

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">
    <event name="checkout_cart_product_add_after">
        <observer name="customprice" instance="Mageplaza\HelloWord\Observer\CustomPrice" />
    </event>
</config>
 

Step 2: Create CustomPrice.php File

Now, you have to create CustomPrice.php file that overrides your price in the Observer Folder.

<?php
    /**
     * Mageplaza Hello CustomPrice Observer
     *
     * @category    Mageplaza
     * @package    Mageplaza_HelloWord
     *
     */
    namespace Mageplaza\HelloWord\Observer;
 
    use Magento\Framework\Event\ObserverInterface;
    use Magento\Framework\App\RequestInterface;
 
    class CustomPrice implements ObserverInterface
    {
        public function execute(\Magento\Framework\Event\Observer $observer) {
            $item = $observer->getEvent()->getData('quote_item');         
            $item = ( $item->getParentItem() ? $item->getParentItem() : $item );
            $price = 100; //set your price here
            $item->setCustomPrice($price);
            $item->setOriginalCustomPrice($price);
            $item->getProduct()->setIsSuperMode(true);
        }
 
    }

Note: According to your need for setting a custom price for one or more products, you can manipulate this by adding conditions.

Conclusion

That is the detailed instruction on how to add the product to the cart with the custom price in Magento 2. Let us know if you have any questions by commenting below!

This article shows how we can search Magento Repositories using SearchCriteriaBuilder that implements SearchCriteriaInterface. An example is provided of how we can perform search on Product repository in Magento. Similarly, we can search for other entities like Category, Customer, Order, Invoice, CMS Page, CMS Block, etc.

We can add different conditions to build custom search criteria.

Filters

Filter class is used to add custom field, value, and condition type to the search criteria.

$filter
    ->setField("name")
    ->setValue("%laptop%")
    ->setConditionType("like");

• condition_type is optional.
• If condition_type is not provided then the default condition_type is set as eq.

Different condition types:

CONDITION   NOTES
eq          Equals
gt          Greater than
gteq        Greater than or equal
lt          Less than
lteq        Less than or equal
moreq       More or equal
neq         Not equal
in          The value can contain a comma-separated list of values.
nin         Not in. The value can contain a comma-separated list of values.
like        The value can contain the SQL wildcard characters when like is specified.
nlike       Not like
notnull     Not null
null        Null
finset      A value within a set of values
nfinset     A value that is not within a set of values.
from        The beginning of a range. Must be used with to.
to          The end of a range. Must be used with from.

Filter Groups

FilterGroup class is used to apply multiple search criteria filters.

For OR condition: Pass filters array inside the FilterGroup class object.
For AND condition: Pass filterGroups array inside the searchCriteria class object.

$filter1
    ->setField("name")
    ->setValue("%laptop%")
    ->setConditionType("like");

$filter2
    ->setField("store_id")
    ->setValue("1")
    ->setConditionType("eq");

$filterGroup1->setFilters([$filter1, $filter2]);

$filter3
    ->setField("url_type")
    ->setValue(1)
    ->setConditionType("eq");

$filterGroup2->setFilters([$filter3]);

$searchCriteria->setFilterGroups([$filterGroup1, $filterGroup2]);

The above code will generate the following conditions:

(name like %laptop% OR store_id eq 1) AND (url_type eq 1)

Sorting

SortOrder is used to apply sorting to the search criteria.

Field and Direction can be passed to the sortOrder object.

Field is the name of the field to sort.
Direction is how we would like to sort the result. The two sorting values are ASC and DESC.

$sortOrder
    ->setField("email")
    ->setDirection("ASC");

$searchCriteria->setSortOrders([$sortOrder]);

Pagination

Limit the number in the result.

$searchCriteria->setPageSize(20); //retrieve 20 or less entities

Set the current page

$searchCriteria
    ->setPageSize(20)
    ->setCurrentPage(2); //show the 21st to 40th entity

The search engine determines the maximum number of results that a query can return.
For Elasticsearch, the default value of 10000 is defined in the module’s etc/di.xml file.

Search Items Using Filters

Below is an example of how we can search Product Repository using Search Criteria Builder.

The ProductRepositoryInterface class has the getList(SearchCriteria $searchCriteria) function which returns the search result object. The object is an instance of the class that implements the interface SearchResultInterface.

FilterBuilder and SearchCriteriaBuilder are used to avoid shared instances, i.e. we will be using create() method in the builder object so that Magento will instantiate a new object (unshared object).

use Magento\Framework\Api\SearchCriteriaBuilder;
use Magento\Framework\Api\FilterBuilder;
use Magento\Catalog\Api\ProductRepositoryInterface;
use Magento\Catalog\Api\Data\ProductInterface;
...
...
$filter = $this->filterBuilder
    ->setField(ProductInterface::NAME)
    ->setValue('%headphone%')
    ->setConditionType('like')
    ->create();

$this->searchCriteriaBuilder->addFilters([$filter]);
$this->searchCriteriaBuilder->setPageSize(20);

$searchCriteria = $this->searchCriteriaBuilder->create();
$productsItems  = $this->productRepository
    ->getList($searchCriteria)
    ->getItems();

Search Items using FilterGroups

Using FilterGroups to add multiple AND and OR conditions to search products.

use Magento\Framework\Api\SearchCriteriaBuilder;
use Magento\Framework\Api\FilterBuilder;
use Magento\Framework\Api\Search\FilterGroupBuilder;
use Magento\Catalog\Api\ProductRepositoryInterface;
use Magento\Catalog\Api\Data\ProductInterface;
...
...
$filter1 = $this->filterBuilder
    ->setField(ProductInterface::NAME)
    ->setValue("%laptop%")
    ->setConditionType("like")
    ->create();

$filter2 = $this->filterBuilder
    ->setField("store_id")
    ->setValue("1")
    ->setConditionType("eq")
    ->create();

$filterGroup1 = $this->filterGroupBuilder
    ->setFilters([$filter1, $filter2]);

$filter3 = $this->filterBuilder
    ->setField("url_type")
    ->setValue(1)
    ->setConditionType("eq")
    ->create();

$filterGroup2 = $this->filterGroupBuilder
    ->setFilters([$filter3]);

$this->searchCriteriaBuilder
    ->setFilterGroups([$filterGroup1, $filterGroup2]);

$this->searchCriteriaBuilder->setPageSize(20);

$searchCriteria = $this->searchCriteriaBuilder->create();
$productsItems  = $this->productRepository
    ->getList($searchCriteria)
    ->getItems();

Product Repository

use Magento\Catalog\Api\ProductRepositoryInterface;
use Magento\Catalog\Api\Data\ProductInterface;

Category Repository

use Magento\Catalog\Api\CategoryRepositoryInterface;
use Magento\Catalog\Api\Data\CategoryInterface;

CMS Page Repository

use Magento\Cms\Api\PageRepositoryInterface;
use Magento\Cms\Api\Data\PageInterface;

CMS Block Repository

use Magento\Cms\Api\BlockRepositoryInterface;
use Magento\Cms\Api\Data\BlockInterface;

Customer Repository

use Magento\Customer\Api\CustomerRepositoryInterface;
use Magento\Customer\Api\Data\CustomerInterface;

Order Repository

use Magento\Sales\Api\OrderRepositoryInterface;
use Magento\Sales\Api\Data\OrderInterface;

Login/Logout Code in Header

<?php if (! Mage::getSingleton('customer/session')->isLoggedIn()): ?>

<a href="<?php echo Mage::helper('customer')->getLoginUrl(); ?>"><?php echo $this->__('Login') ?></a>

<?php else: ?>

<a href="<?php echo Mage::helper('customer')->getLogoutUrl(); ?>"><?php echo $this->__('Logout') ?></a>

<?php endif; ?>

How can I select a random row using Eloquent or Fluent in the Laravel framework?

I know that by using SQL, you can do order by RAND(). However, I would like to get the random row without doing a count on the number of records prior to the initial query.

Solutions:

Laravel >= 5.2:

User::inRandomOrder()->get();

or to get the specific number of records

// 5 indicates the number of records User::inRandomOrder()->limit(5)->get(); // get one random record
User::inRandomOrder()->first();

or using the random method for collections:

User::all()->random();
User::all()->random(10); // The amount of items you wish to receive

Laravel 4.2.7 - 5.1:

User::orderByRaw("RAND()")->get();

Laravel 4.0 - 4.2.6:

User::orderBy(DB::raw('RAND()'))->get();

Laravel 3:

User::order_by(DB::raw('RAND()'))->get();

Check this article on MySQL random rows. Laravel 5.2 supports this, for older version, there is no better solution then using RAW Queries.

edit 1: As mentioned by Double Gras, orderBy() doesn't allow anything else then ASC or DESC since this change. I updated my answer accordingly.

edit 2: Laravel 5.2 finally implements a wrapper function for this. It's called inRandomOrder().

As you know, configuring robot.txt is important to any website that is working on a site’s SEO. Particularly, when you configure the sitemapto allow search engines to index your store, it is necessary to give web crawlers the instructions in the robot.txt file to avoid indexing the disallowed sites. The robot.txt file, that resides in the root of your Magento installation, is directive that search engines such as Google, Yahoo, Bing can recognize and track easily. In this post, I will introduce the guides to configure the robot.txt file so that it works well with your site.

Following steps to Configure robots.txt in Magento 2

• On the Admin panel, click Stores. In the Settings section, select Configuration.
• Select Design under General in the panel on the left
• Open the Search Engine Robots section, and continue with following:
  • In Default Robots, select one of the following:
    • INDEX, FOLLOW
    • NOINDEX, FOLLOW
    • INDEX, NOFOLLOW
    • NOINDEX, NOFOLLOW
  • In the Edit Custom instruction of robots.txt File field, enter custom instructions if needed.
  • In the Reset to Defaults field, click on Reset to Default button if you need to restore the default instructions.
• When complete, click Save Config.

Examples of Custom Robots.txt file

• Allows Full Access

User-agent:* 
Disallow: 

• Disallows Access to All Folders

User-agent:* 
Disallow: / 

Default Robots.txt for Magento 2

Disallow: /lib/ 
Disallow: /*.php$ 
Disallow: /pkginfo/ 
Disallow: /report/ 
Disallow: /var/ 
Disallow: /catalog/ 
Disallow: /customer/ 
Disallow: /sendfriend/ 
Disallow: /review/ 
Disallow: /*SID= 
Disallow: /*? # Disable checkout & customer account 
Disallow: /checkout/ 
Disallow: /onestepcheckout/ 
Disallow: /customer/ 
Disallow: /customer/account/ 
Disallow: /customer/account/login/ # Disable Search pages 
Disallow: /catalogsearch/ 
Disallow: /catalog/product_compare/ 
Disallow: /catalog/category/view/ 
Disallow: /catalog/product/view/ # Disable common folders 
Disallow: /app/ 
Disallow: /bin/ 
Disallow: /dev/ 
Disallow: /lib/ 
Disallow: /phpserver/ 
Disallow: /pub/ # Disable Tag & Review (Avoid duplicate content) 
Disallow: /tag/ 
Disallow: /review/ # Common files 
Disallow: /composer.json 
Disallow: /composer.lock 
Disallow: /CONTRIBUTING.md 
Disallow: /CONTRIBUTOR_LICENSE_AGREEMENT.html 
Disallow: /COPYING.txt 
Disallow: /Gruntfile.js 
Disallow: /LICENSE.txt 
Disallow: /LICENSE_AFL.txt 
Disallow: /nginx.conf.sample 
Disallow: /package.json 
Disallow: /php.ini.sample 
Disallow: /RELEASE_NOTES.txt # Disable sorting (Avoid duplicate content) 
Disallow: /*?*product_list_mode= 
Disallow: /*?*product_list_order= 
Disallow: /*?*product_list_limit= 
Disallow: /*?*product_list_dir= # Disable version control folders and others 
Disallow: /*.git 
Disallow: /*.CVS 
Disallow: /*.Zip$ 
Disallow: /*.Svn$ 
Disallow: /*.Idea$ 
Disallow: /*.Sql$ 
Disallow: /*.Tgz$ 

More Robots.txt examples

Block Google bot from a folder

User-agent: Googlebot 
Disallow: /subfolder/ 

Block Google bot from a page

User-agent: Googlebot 
Disallow: /subfolder/page-url.html 

Common Web crawlers (Bots)

Here are some common bots in the internet.

User-agent: Googlebot 
User-agent: Googlebot-Image/1.0 
User-agent: Googlebot-Video/1.0 
User-agent: Bingbot 
User-agent: Slurp # Yahoo 
User-agent: DuckDuckBot 
User-agent: Baiduspider 
User-agent: YandexBot 
User-agent: facebot # Facebook 
User-agent: ia_archiver # Alexa

Slack is one of the most popular collaboration platforms in the world that brings all your communication together. Conversations in Slack are organized in channels. You can create channels for your teams, projects, topics, or any other purpose to keep information and conversations organized. You can search through everything that’s been posted in channels or your messages. Slack also allows you to talk with your teammates over audio or video calls and share documents, images, videos, and other files.

Slack is not an open-source application and it is not included in the Ubuntu repositories.

This tutorial explains how to install Slack on Ubuntu 18.04. The same instructions apply for Ubuntu 16.04 and any other Debian based distribution, including Debian, Kubuntu, Linux Mint and Elementary OS.

Prerequisites

The user you are logged in as must have sudo privileges to be able to install packages.

Installing Slack on Ubuntu

1. Download Slack

Open your terminal either by using the Ctrl+Alt+T keyboard shortcut or by clicking on the terminal icon.

Visit the Slack for Linux download page and download the latest Slack .deb package. You can also use the following wget command to download the package:

wget https://downloads.slack-edge.com/linux_releases/slack-desktop-4.0.2-amd64.deb

2. Install Slack

Once the download is complete, install Slack by running the following command as a user with sudo privileges:

sudo apt install ./slack-desktop-*.deb

You may be prompted to enter your user password. Once you have correctly entered your password, the installation will continue.

3. Start Slack

Now that you have Slack installed on your Ubuntu desktop, you can start it either from the command line by typing slack or by clicking on the Slack icon (Activities → Slack).

When you start Slack for the first time, a window like the following will appear:

From here you can sign in to a workspace you are already a member of or create a new workspace and start collaborating with your friends and colleagues.

Updating Slack

During the installation process, the official Slack repository will be added to your system. Use the cat command to verify the file contents:

cat /etc/apt/sources.list.d/slack.list

### THIS FILE IS AUTOMATICALLY CONFIGURED ### # You may comment out this entry, but any other modifications may be lost. deb https://packagecloud.io/slacktechnologies/slack/debian/ jessie main 

This ensures that your Slack installation will be updated automatically when a new version is released through your desktop standard Software Update tool.

By now you may know that PHP 7 has been available for quite some time now coming with a number of improvements over version 5. It may be wise to upgrade to PHP7 when running for instance a WordPress using Amazon AWS where you are responsible for any upgrades.

Also as of July 2016, Amazon officially added PHP7 to its repository so you can install it using yum. So first thing I did was create a backup image of my EC2 instance before I went on with the upgrade. Once I had my backups done and proceeded with the PHP 7 upgrade.

Here are the steps I took in order to upgrade from PHP 5.x to 7.

Login to your Linux instance and perform the regular system updates first

$ sudo yum update

Stop the running webserver

$ sudo service httpd stop

Remove any existing PHP packages

$ sudo yum remove php*

Remove old web server installs

$ sudo yum remove httpd*

Update yum package repository

$ sudo yum clean all
$ sudo yum upgrade -y

Install Apache 2.4

$ sudo yum install httpd24

Install PHP 7 packages

$ sudo yum install php70 php70-mysqlnd php70-imap php70-pecl-memcache php70-pecl-apcu php70-gd

Install a new version of mod_ssl

$ sudo yum install mod24_ssl

I also needed to reconfigure /etc/httpd/conf/httpd.conf and /etc/httpd/conf.d/ssl.conf.

Finally, all I needed to do is start my webserver

$ service httpd start

Magento Mage Core, Admin Static Blocks, or Phtml edits are usually includes getting url path such as images, javascript, base url, media and store url. There are different ways to retrieve mentioned URL paths depending on which section you’re editing.

To Retrieve URL path in STATIC BLOCK
To get SKIN URL

{{skin url='images/sampleimage.jpg '}}
To get Media URL

{{media url='/sampleimage.jpg'}}
To get Store URL

{{store url='mypage.html'}}
To get Base URL

{{base url='yourstore/mypage.html'}}
TO Retrieve URL path in PHTML
Note: In editing PHTML don’t forget to enclode the following code with PHP tag

Not secure Skin URL:

getSkinUrl('images/sampleimage.jpg') ?>
Secure Skin URL

getSkinUrl('images/ sampleimage.gif', array('_secure'=>true)) ?>
Get Current URL

$current_url = Mage::helper('core/url')->getCurrentUrl();
Get Home URL

$home_url = Mage::helper('core/url')->getHomeUrl();
Get Magento Media Url

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_LINK);
Get Magento Media Url

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA);
Get Magento Skin Url

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_SKIN);
Get Magento Store Url

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB);
Get Magento Js Url

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_JS);

how to add wordpress header and footer in magento.after complete my previus tutorial How to integrate magento and wordpress follow my simple steps.

Step 1:(include wordpress header in Your magento store )

Go to this link in your file manager

"
YOUR-MAGENTO-FOLDER/app/design/frontend/default/YOUR-THEME/template/page/html/header.phtml
"

in top of this file u add this simple wordpress function .

"
<?php get_header();?>
"
now You check in your magento store wordpress header show nice .

Step 2:(include wordpress footer in Your magento store)

Go to this link in your file manager

"YOUR-MAGENTO-FOLDER/app/design/frontend/default/YOUR-THEME/template/page/html/footer.phtml"

open that file delete all coding in that file u add this simple wordpress function only.

"
<?php get_footer();?>
"

Note:after adding all this you see some errors in prototype.js file. how to clear this error in next tutorial.

Problem:

I have an error when I add a module..

Please re-run the Magento compile command

so i run the below command, but also display error below when run the command from root,

php magento setup:di:compile

Compilation was started.
%message% 
0/7 [>---------------------------]   0% 1 sec 37.0 MiB%message% 
0/7 [>---------------------------]   0% 1 sec 37.0 MiBProxies code generation... 
0/7 [>---------------------------]   0% 1 sec 37.0 MiB Proxies code generation... 
1/7 [====>-----------------------]  14% 47 secs 43.5MiB Repositories code generation... 
1/7 [====>-----------------------]  14% 47 secs 43.5 MiB
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate
 24 bytes) in D:\xampp\htdocs\linsenwelt\vendor\zendframework\zend-code\src\Scan
ner\FileScanner.php on line 36

Solution 1:

A quick solution for the memory limit in Magento 2 command is to directly add the memory limit inside the command.

For the Compilation command,

php -dmemory_limit=5G bin/magento setup:di:compile

For Deployment

php -dmemory_limit=5G bin/magento setup:static-content:deploy

You can change as per 5G to max if the issue is not resolved.

Solution 2:

If you are using PHP >= 5.3.0 and you used the Magento 2.1.x and above, then after you run composer install, two files will be created in your root directory and your pub directory named .user.ini

Edit those files to override your PHP.ini settings, in this case is the memory_limit

; Set PHP memory limit to 768M which already enough for compilation tasks 
memory_limit = 768M 
max_execution_time = 18000

If you are using Apache, you will need to care the files inside the root directory only, not the /pub one and vice versa if you are using engineX (nginx)

Hope it helps.

Add wysiwyg editor in magento custom module. is very easy to make it in your magento custom modue use this following method to add wysiwyg editor .

go to the file

{your magento root folder}/Block/Adminhtml/{module name}/Edit/Tab/Form.php

add following code in top of the file

$fieldset->addField('followupemail_text', 'editor', array( 

'name'=>'followupemail_text',

'label' => Mage::helper('followupemail')->__('Content'),

'title' => Mage::helper('followupemail')->__('Content'),

'required' => true,

'style' => 'height:24em;',

'config' => $wysiwygConfig, ));

 

go to the file

{your magento root folder}/Block/Adminhtml/{module name}/Edit.php

add the following line in this file

protected function _prepareLayout()

{

// Load Wysiwyg on demand and Prepare layout

if (Mage::getSingleton('cms/wysiwyg_config')->isEnabled() && ($block = $this->getLayout()->getBlock('head')))

{

$block->setCanLoadTinyMce(true);

}

parent::_prepareLayout();

}

In Laravel 5 this has changed a bit. Now you can simply add the routes you want to exclude from CSRFToken verification, in $except an array of the class 'VerifyCsrfToken' (\app\Http\Middleware\VerifyCsrfToken.php):

class VerifyCsrfToken extends BaseVerifier 
{ 
protected $except = [ // Place your URIs here ]; 
}

Examples:

1. If you are using a route group:

Route::group(array('prefix' => 'api/v2'), function() { 
    Route::post('users/valid','UsersController@valid'); 
});

Your $except the array looks like:

protected $except = ['api/v2/users/valid'];

2. If you are using a simple route

Route::post('users/valid','UsersController@valid');

Your $except the array looks like:

protected $except = ['users/valid'];

3. If you want to exclude all routes under the main route (users in this case)

Your $except the array looks like:

protected $except = ['users/*'];

see: http://laravel.com/docs/master/routing#csrf-excluding-uris

From time to time everyone finds them selves in a position where they are faced with a development they have never confronted before. Today I was achieve to get all orders for a customer based on the customer email address.. While there are almost certainly several ways to do this, I found a nice query that is quick, and capable.

$orderCollection = Mage::getModel(‘sales/order’)->getCollection(); $orderCollection->addFieldToFilter(‘customer_email’,'email@domain.com’);

Happy coding, hope this helps next time you’re working on Magento

Magento CMS & nBlog Integrated Search extension includes your nBlog blog posts and Magento CMS pages. This extension is useful to make your store more interactive and reduces user bounce rate. 

After install extension go to System -> Index Management .
In Index Management check “Rebuild nBlog fulltext search index” click “Reindex Data”

if you are not install the supported magento extension nBlog,Samdoit_Portfolio the Search Setting
are look like the following image.

After install the supported extension (nblog,samdoit_portfolio) the setting will be look like the following image.

RESTful API's are hard! There are a lot of aspects to designing and writing a successful one. For instance, some of the topics that you may find yourself handling include authentication, hypermedia/HATEOS, versioning, rate limits, and content negotiation. Rather than tackling all of these concepts, however, let's instead focus on the basics of REST. We'll make some JSON endpoints behind a basic authentication system, and learn a few Laravel 4 tricks in the process.

The App

Let's build an API for a simple Read-It-Later app. Users will be able to create, read, update and delete URLs that they wish to read later.

Ready to dive in and get started?

/** * Setup the layout used by the controller.

* *@return void

*/

protected function singleadmin() {

$Feeds_return = array();

$data = array();

$response = [ 'admins' => [] ];

try {

if($_REQUEST['security_token'] == $this->token_security) {

$cache_key = 'admin_id_'.$_REQUEST['admin_id'];

if( !Cache::has( $cache_key) ) {

$statusCode = 200;

$Admin = EbooAdmin::find($_REQUEST['admin_id']);

if($Admin->count()>0) {

$response['admins'][] = [ "id" => $Admin->id, "title" => $Admin->admin_user, ];

}

else{

return Response::json($response, $statusCode);

}

Cache::put( $cache_key, $response, 1 );

return Response::json($response, $statusCode);

} else {

$response = Cache::get( $cache_key );

$statusCode = 200;

return Response::json($response, $statusCode);

}

}

}

catch(Exception $e){

$statusCode = 404;

return Response::json($response, $statusCode);

}

}

Recently, I updated the PHP on my machine to version 7.4 using homebrew for Mac OS only to then realise that one of my older projects that I still needed to maintain, made on version 7.2 would no longer work due to using depreciated PHP functions such as array_key_exists.

The long term solution to this would be to update the project so it’s compatible with PHP version 7.4, but for the sake of time, and potential fixes that needed to go out immediately, I needed to be able to develop this project in the environment it’s running in. Fortunately, I use valet to develop all my PHP applications a tool I can only recommend for PHP developers. Valet allows you to develop PHP applications on your local machine with a much higher level of ease than I’ve found using other services such as dockers or XAMP/MAMP.

Valet, with the use of homebrew, supports switching your system PHP version at will to any version installable via homebrew. So switching versions can be as simple as the following:

brew search php

This will show you all the versions of PHP available via brew, the “php” package represents the latest stable PHP version (which at the time of writing is 7.4) you can also see that versions 7.2 and 7.3 are available and I have them installed.
If you do not yet have the PHP version installed, you can install it by entering:

brew install php@7.2

Once installed, you can then use this with valet. By default, valet will use the system PHP version however you can override this by running:

valet use php@7.2

You should then see various outputs that look like the following:
Now you can check that your PHP version has changed:

php -v

You should see your PHP version has changed:

‍
It’s as simple as that!

That’s how you can quickly and easily switch your PHP version using valet and homebrew. Your computer may need a reboot if the change does not seem to take affect, I have only encountered this once in my experience though.

So the only question that remains now is, how do I get back to where I was?

Reverting back to the latest PHP

Once you have finished developing, you’re likely going to want to return to the latest version of PHP for your modern/new applications. Doing this is as simple as downgrading, just tell valet to use “php”, which as we discovered earlier, is the latest version of PHP. So lets run that:

valet use php

As before, you should see an output like the following:

php -v

You should see your PHP version has reverted.

If you want to change your shopping cart display like number of item and price ,

i give sample image show ,

<div class="mybag">

<a href="<?php echo $this->getUrl('checkout/cart')?>">

<span class="mybag-text">Shopping Cart:</span>

<?php $cartcnt= Mage::helper('checkout/cart')->getItemsCount();?>

<?php if($cartcnt==0):?>

<span class="empty-bag"><?php echo '0 items,';?>

<?php echo $this->helper('checkout')->formatPrice(Mage::getSingleton('checkout/cart')->getQuote()->getGrandTotal()); ?>

</span>

<?php else:?>

<span class="bag-item">

<?php echo $cartcnt.' '.'items,';?><?php echo $this->helper('checkout')->formatPrice(Mage::getSingleton('checkout/cart')->getQuote()->getGrandTotal()); ?></span>

<?php endif; ?>

</a>

</span>

</div>

I ran into this error when doing a

pecl install imagick

 on a Mac.

$ pecl install imagick
[...]
checking for pkg-config... no
pkg-config not found
configure: error: Please reinstall the pkg-config distribution
ERROR: `/private/tmp/pear/temp/imagick/configure --with-php-config=/usr/local/opt/php/bin/php-config --with-imagick' failed

By default, the needed pkg-config binary isn’t installed. You can install it via Homebrew.

$ brew instal pkg-config
==> Downloading https://homebrew.bintray.com/bottles/pkg-config-0.29.2.catalina.bottle.1.tar.gz
==> Downloading from https://akamai.bintray.com/c0/c0a6927c8e404f6db8b14d6644a218b22ddb0d27be1fa0a69d15bf0d9a6875ae?__gda__=exp=1571254410~hmac=2e306f9876b2de0ae458dcbf1e05bc609777305eb8ad5e25125e9467e8bfcfeb&response-content-disposition=
######################################################################## 100.0%
==> Pouring pkg-config-0.29.2.catalina.bottle.1.tar.gz
 /usr/local/Cellar/pkg-config/0.29.2: 11 files, 623KB

As a magento developer display related product on product view page.It’s easy to show related product by following few easy steps. First we will have to add products to a particular product as related product. Screen shows product added as related product

After selecting products it will show on your product view page if you can`t view related product on it .Do following steps it`s very easy to follow all the best friends.

1)Open catalog.xml

catalog.xml file available in .

{magento root}/app/design/frontend/default/{your theme}/layout/catalog.xml .

If you not have the file just copy file from

{magento toot}/app/design/frontend/base/default/layout/catalog.xml

to your theme i already mention the path.

2) Remove & Add some xml in catalog.xml

Search catalog_product_view in

{magento root}/app/design/frontend/default/{your theme}/layout/catalog.xml

. Command or remove the following line from there .Search in catalog.xml "catalog.product.related" in appropriately line 258 under <reference name="right"> .

<block type=“catalog/product_list_related” name=“catalog.product.related”before=“-” template=“catalog/product/list/related.phtml”/>

add following line in catalog.xml . Search in catalog.xml "<reference name="content">" in appropriately line 189 . Below "<block type="catalog/product_view"..........>" this linl add following line.

<block type=“catalog/product_list_related” name=“catalog.product.related”before=“-” as="catalog_product_relate" template=“catalog/product/list/related.phtml”/>

3) Adding related product in product view page.

Adding some code in view.phtml available in

{magento root}/app/design/frontend/default/{your theme}/template/catalog/product/view.phtml

If you not have the file just copy file from

{magento toot}/app/design/frontend/base/default/template/catalog/product/view.phtml .

Add following line in where you want to view.

<?php echo $this->getChildHtml('catalog_product_relate');?>

4) Related Product view

Here we discuse about how to add vTiger Sales Order item detail in any where in your vTiger , for example if you want to add Sales Order Item detail in your email .you just need that is just add simple function . if you want to add salesorder item view using single function.

 getDetailAssociatedProducts('SalesOrder',$focus);

 to youse the above function you got all the detail in your html format . 

Hi friends,

Some people ask about the difference between

Mage::getModel() and Mage::getSingleton()

in Magento. Here is the difference between these two:

Mage::getModel('module/model')

will create a new instance of the model object (if such object exists in configuration)
So if we write:

Mage::getModel('catalog/product'),

it will create new instance of the object product each time. So,

$p1 = Mage::getModel('catalog/product');
$p2 = Mage::getModel('catalog/product');

Then $p1 is a one instance of product and $p2 is another instance of product.

While Mage::getSingleton('catalog/product') will create reference on existing object (if object does not exist then this method will create an instance using ::getModel() and returns reference to it).
So, if

$p1 = Mage::getSingleton('catalog/product');
$p2 = Mage::getSingleton('catalog/product');

Then $p1 and $p2 both refer to the same instance of product as reference $p2.

That's all.. Cheers.. :)

Magento e-commerce has a standard newsletter function that is useful if you get it to work. This post will highlight the major reasons why your newsletter is not sent to your customers.

1. Magento schedules and sends the newsletters using a cronjob script called “cron.php” in your Magento installation root folder. To schedule this cronjob you need to access your web server using SSH (You can use for example Putty). For more information see the Magento wiki.
2. If you don’t want to schedule the cronjob you need to go twice to the cron.php file in your browser e.g. www.yoursite.com/cron.php every time you want to send your newsletter. The first time it will schedule the newsletter and the second time it will send it.
3. After login with ssh type: crontab -e This will open an editor. The contents may be empty if you have never set up crontabs for the current user.
4. To schedule the cronjob every 5 minutes you should enter: */5 * * * * php /absolute/path/to/magento/cron.php
5. Save and close
6. Now you can create a newsletter template at Newsletter / Newsletter Templates.

   Create Newsletter

7. After creating and saving the template you can schedule it by selecting “Queue Newsletter” in the Action pull-down.

   Queue newsletter

8. Select a date and time at “Queue Date Start” when you want to start sending your newsletter.
9. If you have multiple store views make sure you select at least one store view at “Subscribers From” otherwise you will have no recipients.
10. Click on “Save Newsletter” and you will see the scheduled newsletter at the Newsletter Queue.

    Queue Newsletter

11. If everything goes right you will see that after a while all the recipients will receive the newsletter and the status should be “Sent”

Create the Dropbox app use this following url http://www.samdoit.com/news/how-to-create-dropbox-app

Go to your admin panal menu click the menu by

System-->Tools->Multibackup

 then click the button called 

Check Available Backup

all the already taken bakup files are uploaded to Dropbox what are already linked to this site.

Remove selected table insert content from dump file

grep -v "INSERT INTO \`big_table\`"  dump.sql > dump_stripped.sql

Remove all insert content from dump file

grep -v "INSERT INTO" dump.sql > dump_stripped_insert.sql

Replace dump.sql with your dump file name

i have this error when i am trying to build

[Error: Failed to find 'ANDROID_HOME' environment variable. Try setting setting it manually.
Failed to find 'android' command in your 'PATH'. Try update your 'PATH' to include path to valid SDK directory.]

Solution

You have permission errors. My guess is that you tried to run the script as root rather than sudo. When running the script you have to run it as your user account using sudo.

change owner permission all files & folder to your current login user .

• Your android sdk
• Your ionic or cordova project files

dont run as admin or run using sudo

The default MySQL 8 auth plugin is auth_socket, which causes the error "SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client" when an application is attempting to log in to the database with a password. Let's go through the steps to fix this.

Step 1

Login to the mysql server in sudo mode as the root user and supply any required passwords.

sudo mysql -u root -p

Step 2

Now run the following ALTER USER command, replacing root with your database user and password if your password.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Now run:

FLUSH PRIVILEGES;

Now exit the MySQL server:

exit;

Step 3

You may need to restart the mysql services for the changes to take effect:

sudo service mysql restart

Problem

if (!(bool)$debugMode && extension_loaded('xdebug')) { 
  xdebug_disable(); 
}

if (!(bool)$debugMode && extension_loaded('xdebug')) {
 if (function_exists('xdebug_disable')) {
 xdebug_disable();
 }
}

As Magento 2 store owner, you may want to treat logged in and non-logged in customers differently. For example, you may want to offer exclusive features or discounts to logged in customers only. To implement this, you first need to confirm whether a Magento 2 customer is logged in or not?

Methods To Check If A Customer Is Logged-In In Magento 2

There are 2 ways you can check this. By injecting class and by using object manager. Although the 2nd method (object manager) is not recommended, it’s still used as an alternative.

Method 1: By Injecting Class (Dependency Injection)

In this method, first, you need to inject the following class in the constructor method:

/Magento/Customer/Model/Session

protected $_session;

    public function __construct(
        ...
        \Magento\Customer\Model\Session $session,
        ...
    ) {
        ...
        $this->_session = $session;
        ...
    }

Then in your class, use the following code in any function to check if the customer is logged in or not:

if ($this->_session->isLoggedIn()) {
        // Customer is logged in 
} else {
        // Customer is not logged in
}

Sample Code:

<?php
namespace [Vendor]\[Module]\Controller\Index;

use Magento\Framework\App\Action\Context;
use Magento\Framework\App\Action\Action;
use Magento\Customer\Model\Session;

class ClassName extends Action {
    protected $_session;

    public function __construct(Context $context, Session $session) {
        parent::__construct($context);
        $this->_session = $session;
    }

    public function execute()
    {
        // by using Session model
        if($this->_session->isLoggedIn()) {
            //customer has logged in
            // your code in here
        }else{
            //Customer is not logged in
            // your code in here
        }
    }
}

Method 2: Using Object Manager

You can use this method as an alternative to the above.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$customerSession = $objectManager->get('Magento\Customer\Model\Session');
if ($customerSession->isLoggedIn()) {
  // customer login action
}

Depending on your configuration it may also be unecessary. If you are in default or dev mode you do not need it.

You just need it on production mode

From command line and from your Magento root path:

php bin/magento setup:di:compile

P.S: After installing your module make sure you ran:

php bin/magento setup:upgrade

In this post I will show how you can add banner ads to your Ionic apps. I will be doing this on a new app but you can do it to your existing app as well. I have also written a post on adding banner ads to Ionic 2 apps, so if you are looking for Ionic 2 apps You can check that post out as well.

Step 1)

We will first start by creating a new Ionic project by issuing the following command in the command prompt

Step 2)

Now we will need to add the platform to out app. So will do the following command

Step 3)

As we will be using the AdMob Pro plugin we will need to download it in our project. We will do that by the following command

you can read more about the plugin in the Admob pro plugin documentation

Step 4)

Now we will need to add the following code to the $ionicPlatform.ready() in the app.js file

So the finished app.js file looks like this:

NOTE: The app.js file will be different for each template namely tabs,bank,sideMenu, make sure you add the code to the $ionicPlatform.ready() function and no to any function inside it.

With Advanced Content Manager for Magento 2, it’s possible to index and make your content searchable.

The default catalog search layout is overridden by our extension, in order to add our results to the search.
The extension is adding a Result Search Block into the Catalog Search Result page layout:

Samdoit/ContentManager/view/frontend/layout/catalogsearch_result_index.xml

<page xmlns:xsi="..." layout="2columns-left" xsi:noNamespaceSchemaLocation="..."> 
<body> 
<referenceContainer name="content"> 
<block class="Samdoit\ContentManager\Block\Search\Result" name="search.content.result" after="search.result" template="Samdoit_ContentManager::content/search/result.phtml" cacheable="false"> 
<referenceContainer> 
<body> 
<page>

The Result Block retrieves the current query and create the search filter. The block will load a ContentList Collection from the ids retrieved in the results.

This block has the following child:

<block class="Samdoit\ContentManager\Block\Content\Widget\ContentList" name="search_content_result_list" template="Samdoit_ContentManager::content/widget/list.phtml" cacheable="false"> <block>

This child block is nothing else that a ContentList widget. See the following documentation to customize the content list widget: XML layout

Then if you want to customize the result search for the content, you should override the following layout in frontend:

catalogsearch_result_index.xml

Be sure that the Blackbird_ContentManager module is loaded before yours. You can add the instruction in your module.xml file:

<module name=”Samdoit_ContentManager” setup_version=”1.0.0”> 
<sequence> 
<module name=”Samdoit_ContentManager”/>
<sequence> 
<module>

Now, in your catalogsearch_result_index.xml file, paste the following code in the tags and add instructions from the following resource: XML layout update

<referenceBlock name=”search_content_result_list” template=”my_custom_template.phtml”> <referenceBlock>

However if you just want to modify the template of the result search, see the following resource: Overriding templates

Integrity constraint violation: 1062 Duplicate entry ‘4-Images’ for key ‘EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME’, query was: UPDATE `eav_attribute_group` SET `attribute_group_name` = ? WHERE (`attribute_group_id`=10)

This particular error presented itself while upgrading from Magento 2.0.2 to Magento 2.1.x and stops the upgrade process. We’ve discovered the issue is related to old data from the previous Magento 1.9.x installation. In order to over come this error, you’ll need to delete a row from the database.

Run the following MySQL query to find and delete the offending attribute.

delete from eav_attribute_group WHERE attribute_group_name = 'Images';

After that then you can attempt to run the upgrade command again and the issue should be resolved.

We understand not everyone can be a MySQL / Magento 2 expert so if you’re faced with a similar issue and stuck between an upgrade feel free to contact us to assist with your problem.

We had a requirement to check if one of our modules is enabled or not as two of our modules were sharing the same attribute code. We wanted to make sure that we don’t try to create an attribute again if the other module already installed or enabled.

We have done this many times in Magento 1 by using the following code snippet -:

Mage::helper('core')->isModuleEnabled('vendor_modulename');

So we were wondering there must be a simple way of doing this in Magento 2 as well and yes we were not wrong. It is not a single line of code as we had in Magento 1 but there is nothing in Magento 2 which can be implemented in Magneto 2 ???? You have to add dependency to get access to the functions.

Anyways let’s crack on with the code to find out if the module exists or enabled in Magento 2

<?php

class Custom
{
    /**
     * @var \Magento\Framework\Module\Manager
     */
    protected $_moduleManager;

    /**
     * @param \Magento\Framework\Module\Manager $moduleManager
     */
    public function __construct(
        \Magento\Framework\Module\Manager $moduleManager
    ) {
        $this->_moduleManager = $moduleManager;
    }


    /**
     * Returns if module exists or not
     *
     * @return bool
     * @throws \Magento\Framework\Exception\LocalizedException
     */
    public function isModuleEnabled()
    {
      return $this->_moduleManager->isEnabled('Scommerce_CatalogUrl');
    }
}

That’s it, Hope this article helped you in some way. Please leave us your comment and let us know what do you think? Thanks.

• Delete the Module folder from {folder path}\app\code
• Remove module entry from below tables core_config_data & setup_module

• Run command

  {magento project root path}>{php path}\php bin/magento setup:upgrade => Setup Upgrade

  {magento project root path}>{php path}\php bin/magento cache:flush => Clear Cache

For one of my recent projects, I wanted to make use of the free allowance that AWS gives for SES.

One of the conditions of the SES allowance was that your calling app needs to be hosted on EC2.

I’ve not used EC2 before so I figured this would be a good way to dive into it.

Whilst I would never usually install software like a composer on a production server, this was pure to test things out.

So after signing up for AWS and creating a local ubuntu server on an EC2 t2micro instance then cloning down the project I ran composer install to come across the following message:

composer install
Loading composer repositories with package information
Updating dependencies (including require-dev)

mmap() failed: [12] Cannot allocate memory

mmap() failed: [12] Cannot allocate memory
PHP Fatal error: Out of memory (allocated 822091776) (tried to allocate 4096 bytes) in phar:///usr/local/bin/composer/src/Composer/DependencyResolver/Solver.php on line 223

Fatal error: Out of memory (allocated 822091776) (tried to allocate 4096 bytes) in phar:///usr/local/bin/composer/src/Composer/DependencyResolver/Solver.php on line 223

822091776bytes is over 800mb of memory being consumed by the composer.

Whilst php-fpm has a 128mb max memory limit per script by default,
php-cli has a value of -1 which means use unlimited memory.

In this instance attempting to allocate over 800mb of memory on a server with 1gb was not going to end well.

The solution was to create a swap file on the disk.

A swap file or partition is space on disk allocated that can be used when the physical memory allocation is exhausted. Once the allocation is exhausted, older items in memory get offloaded to the swap partition.

The actual solution for this I found over on this GitHub issue.

The following code will create a 1gb swap file in /var/swap.1 for our instance to use

sudo /bin/dd if=/dev/zero of=/var/swap.1 bs=1M count=1024
sudo /sbin/mkswap /var/swap.1
sudo /sbin/swapon /var/swap.1

The error you have received is from NPM (since the Cordova CLI is installed via NPM). This is a tricky issue where using NPM with sudo, and then not using sudo will result in weird permission issues.

Solution:

sudo chown -R $USER /usr/local/

csrf_token() is empty in l5-swagger and couldn't do any request.

I have tried to request it from the postman and it works. but in swagger, it didn't. I have taken a look from this link (Laravel 5 csrf_token value is Empty) but I still have no idea how to solve my problem.

How can I get the csrf_token inside my l5-swagger view?

Answer

 You should try to add this in /routes/web.php

Route::group(['middleware' => 'web'], function () { 
   Route::get('api/documentation', '\L5Swagger\Http\Controllers\SwaggerController@api')->name('l5swagger.api'); 
});

You can create a Plugin for the method SavePaymentInformation() in Magento 2 to add your logic before or after Payment information is saved.

The method will be called after a click on the Place order button from the second step of the Checkout page.

Original Class to create plugin:
Magento\Checkout\Model\PaymentInformationManagement

You can create a before or after plugin as per your requirement.

Create a global scope di.xml file,

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <type name="Magento\Checkout\Model\PaymentInformationManagement">
        <plugin name="set_payment_data_before_save"
                type="Samdoit\SavePayment\Plugin\Model\SavePaymentPlugin" sortOrder="10"/>
    </type>
</config>

Create a Plugin Class for the Before saves payment information, We have used Before Plugin type,

<?php
namespace Samdoit\SavePayment\Plugin\Model;

use Magento\Quote\Api\Data\AddressInterface;
use Magento\Quote\Api\Data\PaymentInterface;
use Magento\Checkout\Model\PaymentInformationManagement;
use Magento\Framework\Exception\AbstractAggregateException;

class SavePaymentPlugin
{
    /**
     * @param PaymentInformationManagement $subject
     * @param int $cartId
     * @param PaymentInterface $paymentMethod
     * @param AddressInterface|null $billingAddress
     *
     * @return array
     *
     * @throws AbstractAggregateException
     *
     * @SuppressWarnings(PHPMD.UnusedFormalParameter)
     */
    public function beforeSavePaymentInformation(
        PaymentInformationManagement $subject,
        int $cartId,
        PaymentInterface $paymentMethod,
        AddressInterface $billingAddress = null
    ): array {
            // Add your logic before Save Payment information
        return [$cartId, $paymentMethod, $billingAddress];
    }
}

Before Plugin:
$cartId: You get the current quote Cart id, You can get the details of the active quote by cart id from the method.

$paymentMethod contains the Payment related information, Payment method, Payment additional data

The $billingAddress field contains the billing data of the checkout billing section.

You can create an after plugin also for the above method if you need to do some logic after the Payment method successfully saved.

Above Code snippet, Save Payment Information Plugin for adding extra logic after or before Payment data save in Magento 2.

When you add jquery in your magento .

if you are got following error comes.

1)  You can`t add product in magento shopping cart,

2)   Product image not shown correctly in product view.

Solution :

open the file in

{magento root folder}/app/design/frontend/default/{your magento theme}/template/page/html/head.phtml

and

Paste the following lines


<script type="text/javascript">// <![CDATA[

jQuery.noConflict();
// ]]>

after


<!--[if lt IE 7]>
........
.........
<![endif]-->

You have created a new entity type and want to display it as a paginated list ?

First, integrate the MagePageBlockHtmlPager through your block :

class Your_Module_Block_Entityname_ListextendsMage_Core_Block_Template {

 protectedfunction _construct() {

  parent::_construct(); 

// We get our collection through our model  

$this->_entities = Mage::getModel('your_module/entityname')
->getCollection() 
->setOrder('created_at'); 

// Instantiate a new Pager block  

$pager =newMage_Page_Block_Html_Pager(); 

// We set our limit (here an integer store in configuration).  

// /!\ The limit must be set before the collection  

$pager->setLimit((int)Mage::getStoreConfig('your_module/entityname/pagination')) 
->setCollection($this->_entities); 

// Add our Pager block to our current list block  

$this->setChild('pager', $pager); 

} 

} 

ou just need now to include the call in your template (phtml) file :

 <divclass="your_module_entities"> 

 <?php foreach($this->_entities as $entity):?>

  <divclass="entity">

  <h2><?php echo $entity->getAttribute1();?></h2>

  <p><?php echo $entity->getAttribute2();?></p>

  </div> 

 <?php endforeach;?>

  </div> 
<?php echo $this->getChildHtml('pager');?>

And you should be good to go !

I'm using PHP's built-in DOMDocument() class to do some simple web-scrapping. However, it works on my 4.2 site, but not my 5.1 (both are on same installation of PHP).

Here's the error:

Class 'App\Http\Controllers\admin\DOMDocument' not found

 $list1 =new DOMDocument();

In Laravel 5.1 you must prefix the class name with the global namespace prefix '\'.

$list1 =new \DOMDocument();

I'm using PHP's built-in DOMXPath() class to do some simple web-scrapping. However, it works on my 4.2 site, but not my 5.1 (both are on same installation of PHP).

Here's the error:

Class 'App\Http\Controllers\admin\DOMXPath' not found

 $list1 =newDOMXPath();

In Laravel 5.1 you must prefix the class name with the global namespace prefix '\'.

$list1 =new \DOMXPath();

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':CordovaLib:processDebugResources'.
> com.android.ide.common.process.ProcessException: org.gradle.process.internal.ExecException: Process 'command '/home/arulmanickam/adt-bundle-linux-x86-20131030/sdk/build-tools/23.0.2/aapt'' finished with non-zero exit value 127

Solution :

If you are installing new Ubuntu 16.04 LTS or upgrading/Downgrade from your older Ubuntu installation then you will get an error like “phpMyAdmin – Error – The mbstring extension is missing. Please check your PHP configuration”. This error can happen on browser for your phpmyadmin access after installation or upgrade to Ubuntu 16.04.

just run these command

sudo apt-get install phpmyadmin php-mbstring php-gettext

sudo service apache2 restart

The topic today is one of the popular errors you will meet. As if the error message shows “An error has happened during application run. See exception log for details” in Magento 2 when you have uploaded Magento CE latest version and want to install it on your server, so what should you do? Here is the right solution for you.

How to resolve: “An error has happened during application run. See exception log for details”

Please open the .htaccess from the root and comment out the first line:

SetEnv MAGE_MODE developer

I tried to install an extension from the Magento market place but I got an incompatibility error...

Installing dependencies from lock file (including require-dev)

Verifying lock file contents can be installed on the current platform.

Your lock file does not contain a compatible set of packages. Please run composer update.

  Problem 1

    - laminas/laminas-dependency-plugin is locked to version 1.0.3 and an update of this package was not requested.

    - laminas/laminas-dependency-plugin 1.0.3 requires composer-plugin-api ^1.1 -> found composer-plugin-api[2.0.0] but it does not match the constraint.

  Problem 2

    - magento/magento-composer-installer is locked to version 0.1.13 and an update of this package was not requested.

    - magento/magento-composer-installer 0.1.13 requires composer-plugin-api ^1.0 -> found composer-plugin-api[2.0.0] but it does not match the constraint.

  Problem 3

    - dealerdirect/phpcodesniffer-composer-installer is locked to version v0.5.0 and an update of this package was not requested.

    - dealerdirect/phpcodesniffer-composer-installer v0.5.0 requires composer-plugin-api ^1.0 -> found composer-plugin-api[2.0.0] but it does not match the constraint.

  Problem 4

    - magento/magento-composer-installer 0.1.13 requires composer-plugin-api ^1.0 -> found composer-plugin-api[2.0.0] but it does not match the constraint.

    - colinmollenhour/cache-backend-redis 1.10.6 requires magento-hackathon/magento-composer-installer * -> satisfiable by magento/magento-composer-installer[0.1.13].

    - colinmollenhour/cache-backend-redis is locked to version 1.10.6 and an update of this package was not requested.

You are using Composer 2, which some of your plugins seem to be incompatible with. Make sure you update your plugins or report a plugin-issue to ask them to support Composer 2.

Solution

Downgrade Composer to Version 1 

If for any reason you need to downgrade Composer to the latest version 1 release, you can do so by running the following command as root:

sudo composer self-update --1

Once the hold has been removed, then ServerPilot will eventually automatically update the composer package again. However, you can manually upgrade it to the latest version 2 release by running the following command as root:

sudo composer self-update --2

You want to integrate your store to blog.simply follow my simple steps.

Step 1:
   Goto magneto store files edit index.php add these lines

if ( strpos($_SERVER['REQUEST_URI'], 'index.php/admin') === FALSE )
{
define('WP_USE_THEMES', false);
require_once('../wp-load.php');   // configure your WordPress location.
}

Step 2:

copy "Your-magento-folder/app/code/core/Mage/Core/functions.php"

to   "Your-magento-folder/app/code/local/Mage/Core/functions.php"

If u not have the folder structure create that folder and paste .

Step 3:

find "function __() " this line around 90 to 100  in "Your-magento-folder/app/code/local/Mage/Core/functions.php"

thats look like 

"

Here is the detail for Get current store id in magento

Magento Get store data.

Mage::app()->getStore();

Magento Store Id

Mage::app()->getStore()->getStoreId();

Magento Store code

Mage::app()->getStore()->getCode();

Magento Website Id

Mage::app()->getStore()->getWebsiteId();

Magento Store Name

Mage::app()->getStore()->getName();

Magento Is Active

Mage::app()->getStore()->getIsActive();

Magento Store Home Url.

Mage::app()->getStore()->getHomeUrl();

Here is a quick code to get the admin user’s data (id, name, username, email, password, etc).
By admin user, I mean the users that login through the admin panel and those who have access to the admin panel of Magento. The users can be administrator, or with some specific roles.

$user = Mage::getSingleton('admin/session')->getData();

$userId = $user->getUser()->getUserId();
$userEmail = $user->getUser()->getEmail();
$userFirstname = $user->getUser()->getFirstname();
$userLastname = $user->getUser()->getLastname();
$userUsername = $user->getUser()->getUsername();
$userPassword = $user->getUser()->getPassword();



Hope this helps.

Thanks.

The most likely cause for the vTiger error “Sorry! Attempt to access restricted file.” is the $root_directory value in the ‘config.inc.php’ is incorrect or misspelled.

In order to correct it follow the steps below:

• Go to your vTigerCRM directory
• Open “config.inc.php” with your favorite text editor
• Go to line 86 and adjust $root_directory value to correct vTiger directory. Note, that the directory must end with /. It should look something like this – $root_directory = ‘/var/www/vtigercrm/’;
• If you can't find the root directorey 
  • Open "Index.php" with your favorite text editor add the following code after <?php

  • echo "__dir__";die;

  • It's display the root directory

Hope that helps!

Third Party Platform interact with Magento 2 by API. When you are working for API related stuff and using SearchCriteriaBuilder Object for your query and if you want to apply OR conditions for custom query, You need to define setFilterGroups([Object]) for OR query.

Whenever you are dealing with SearchCriteriaBuilder in Magento 2, You might be need to query with OR conditions for custom requirement, You can give OR conditions to Magento\Framework\Api\SearchCriteriaBuilder by simple code snippets.

Let’s imagine, We built a query using OR conditions for Products.

Fetch collection of only those products whose sku is like `MSH01%` OR `type_id` is equal to simple.

<?php
namespace Rbj\Training\Block;

class Training extends \Magento\Framework\View\Element\Template
{
    public function __construct(
        \Magento\Framework\View\Element\Template\Context $context,
        \Magento\Catalog\Api\ProductRepositoryInterface $productRepository,
        \Magento\Framework\Api\SearchCriteriaBuilder $searchCriteriaBuilder,
        \Magento\Framework\Api\FilterBuilder $filterBuilder,
        \Magento\Framework\Api\Search\FilterGroupBuilder $filterGroupBuilder,
        array $data = []
    ) {
        $this->customerRepository = $customerRepository;
        $this->searchCriteriaBuilder = $searchCriteriaBuilder;
        $this->filterBuilder = $filterBuilder;
        $this->filterGroupBuilder = $filterGroupBuilder;
        parent::__construct($context, $data);
    }

    /**
     * OR condition for searchCriteriaBuilder
     */
    public function applyOrCondition() {
        $filter_1 = $this->filterBuilder
            ->setField('sku')
            ->setConditionType('like')
            ->setValue('MSH01%')
            ->create();

        $filter_2 = $this->filterBuilder
            ->setField('type_id')
            ->setConditionType('eq')
            ->setValue('simple')
            ->create();

        $filter_group = $this->filterGroupBuilder
            ->addFilter($filter_1)
            ->addFilter($filter_2)
            ->create();

        // add filter group to setFilterGroups()
        $searchCriteria = $this->searchCriteriaBuilder
            ->setFilterGroups([$filter_group])
            ->create();

        $products = $this->productRepository->getList($searchCriteria)->getItems();
        return $products;
    }

Using Magento\Framework\Api\FilterBuilder class, You need to create filterBuilder for your separate field.

using Magento\Framework\Api\Search\FilterGroupBuilder class, apply AND conditions to addFilter( ) with filterGroupBuilderobject.

Now Our searchCriteriaBuilder instance is ready for fetch collection of products,
$products = $this->productRepository->getList($searchCriteria)->getItems();
gives the result of our OR query for a products.

Use of session in Magento:
Let’s start this blog with the session definition, ‘It is a way to preserve certain data across subsequent accesses’. This enables you to build more customized applications and increase the appeal of your web site. Now, Let’s see how to set ,unset and retrieve a session in Magento.

Generally, Magento session is handled by core Module ‘core/session’. We use “set<session name>” to set a session variable. For more understanding, look on to the following syntax and example.

Mage::getSingleton(‘core/session’)->set<YOUR SESSION NAME>(<VARIABLE NAME>);
Example :
$myValue =’test’;
Mage::getSingleton(‘core/session’)->setMyValue($myValue);

In this example, I have declared the variable $myValue as “test”. I am going to set this variable in session. To do so, I have used the default syntax of the Magento in line 2. Now the session variable is set in the magento.Wow, its easy to set the session variable.

Let’s now look, how to get value from the session variable “MyValue”.  To retrieve the  session variable, we use 

get<YOUR SESSION NAME>();

Mage::getSingleton(‘core/session’)->get<YOUR SESSION NAME>();

In our example, we need to get the session value of “MyValue”. For this, let’s use “getMyValue();”. So our code will be as follows,

$getSession =Mage::getSingleton(‘core/session’)->getMyValue();

Next, we will see how to unset the session variable. To unset the session variable, we have the following syntax,

Mage::getSingleton(‘core/session’)->uns<YOUR SESSION NAME>();

Let’s have a simple example to unset the session variable.

Mage::getSingleton(‘core/session’)->unsMyValue();

This code will automatically delete the session of the MyValue.How to Use customer or core session in frontend. Use adminhtml session in the backend.

Core Session :- Mage::getSingleton(‘core/session’)
Customer Session :- Mage::getSingleton(‘customer/session’)
Admin Session :- Mage::getSingleton(‘adminhtml/session’)
Shopping Cart Session :-Mage::getSingleton(‘checkout/session’)->getQuote()

//Setup route example Route::get('/myapp/install/{key?}', array('as' => 'install', function($key = null) { if($key == "appSetup_key"){ try { echo '<br>init migrate:install...'; Artisan::call('migrate:install'); echo 'done migrate:install'; echo '<br>init with Sentry tables migrations...'; Artisan::call('migrate', [ '--package'=>'cartalyst/sentry' ]); echo 'done with Sentry'; echo '<br>init with app tables migrations...'; Artisan::call('migrate', [ '--path' => "app/database/migrations" ]); echo '<br>done with app tables migrations'; echo '<br>init with Sentry tables seader...'; Artisan::call('db:seed'); echo '<br>done with Sentry tables seader'; } catch (Exception $e) { Response::make($e->getMessage(), 500); } }else{ App::abort(404); } } }));

Install PHPUnit

Installing PHPUnit package on Ubuntu 16.04 (Xenial Xerus) is as easy as running the following command on the terminal:

sudo apt-get update
sudo apt-get install phpunit

Here we learn how to write custom mysql query in Magento2.

Suppose we have table ’employee’ with fields emp_id, emp_name, emp_code and emp_salary.

Custom Mysql Query

            $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); // Instance of object manager
            $resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
            $connection = $resource->getConnection();
            $tableName = $resource->getTableName('employee'); //gives table name with prefix

            //Select Data from table
            $sql = "Select * FROM " . $tableName;
            $result = $connection->fetchAll($sql); // gives associated array, table fields as key in array.

            //Delete Data from table
            $sql = "Delete FROM " . $tableName." Where emp_id = 10";
            $connection->query($sql);

            //Insert Data into table
            $sql = "Insert Into " . $tableName . " (emp_id, emp_name, emp_code, emp_salary) Values ('','XYZ','ABD20','50000')";
            $connection->query($sql);

            //Update Data into table
            $sql = "Update " . $tableName . " Set emp_salary = 20000 where emp_id = 12";
            $connection->query($sql);

So, you must follow the instructions for sites that use custom page templates. The process I've followed

• log into BigCommerce and create a new page. In this case, the page is "/newsletter/"
• Edit config.stencil.json and add it to the customLayouts -> page list (see below)
• Create and edit [sitehome]/templates/pages/custom/page/newsletter.html
• View the page locally and verify that it appears as expected.
• Perform a stencil push.

{
  "customLayouts": {
    "brand": {},
    "category": {},
    "page": {
      "locations.html":"/our-stores/",
      "employment.html":"/employment/",
      "newsletter.html":"/newsletter/",
      "ask-beth.html":"/ask-beth/"
    },
    "product": {}
  },
  "apiHost": "https://api.bigcommerce.com",
  "normalStoreUrl": "https://www.samdoit.com",
  "port": 3000
}

So, you must follow the instructions for sites that use custom page templates. The process I've followed

• log into BigCommerce and create a new page. In this case, the page is "/newsletter/"
• Create .stencil and add it to the customLayouts -> page list (see below)
• Create and edit [sitehome]/templates/pages/custom/page/newsletter.html
• View the page locally and verify that it appears as expected.
• Perform a stencil push.

{
  "customLayouts": {
    "brand": {},
    "category": {},
    "page": {
      "locations.html":"/our-stores/",
      "employment.html":"/employment/",
      "newsletter.html":"/newsletter/",
      "ask-beth.html":"/ask-beth/"
    },
    "product": {}
  },
  "apiHost": "https://api.bigcommerce.com",
  "normalStoreUrl": "https://www.samdoit.com",
  "port": 3000,
  "clientId": "xxxxxxxxxxxxxxxxx",
  "accessToken": "xxxxxxxxxxxxxxxxxx"
}

I am running a magento 2.4 project but current not in position to update mysql version. any way to skip that error ?

Magento 2 error Current version of RDBMS is not supported. Used Version: 10.1.37-MariaDB. Supported versions: MySQL-8, MySQL-5.7, MariaDB-(10.2-10.4)

Solution 

An alternative solution if you are in a bind.

Edit file app/etc/di.xml

You can specify acceptable MariaDB versions here - currently 10.2-10.4

Example to allow MariaDB 10.11

<item name="MariaDB-(10.2-10.11)" xsi:type="string">^10\.([2-9]|10|11)\.</item>

This script quickly adds a Magento Admin user directly into the database. It is possible to run this script from the command line or by copying and pasting into phpMyAdmin. Just make sure to edit the following fields with your personalized data and import. Most of these fields are trivial, I’m just listing them so you don’t miss anything.

1. Set the salt portion of your password. You’ll rarely need to change this. If you do, just use two lower case letters of your choice.
2. Set your password. At least 8 characters in length and at least one digit.
3. Firstname: Enter admin’s first name.
4. Lastname: Enter admin’s last name.
5. Enter email of admin user.
6. Enter username where ‘myuser’ is set. Notice ‘myuser’ shows up in two places.
7. Enter Firstname again. This is more symbolic to label the rule.