• Laravel routes & .htaccess file not working on 1and1 hosting

    Just add RewriteBase / in my .htaccess
    Following are my .htaccess code for /public/.htaccess
    RewriteBase /
    Options -MultiViews -Indexes

  • How to restore user & server data to the new server in VestaCP


    • Backup file from old server
    • root login credentials of new server
    • VestaCP must be installed on new server

  • How to send or upload files from one server to another server

    SCP (secure copy) is a command-line utility that allows you to securely copy files and directories between two locations. 
    The scp command uses SSH to transfer data, so it requires a password or passphrase for authentication.....

  • Create Table SQL Query in Oracle Database

    Connnect SQL:

    sqlplus <user>/<password>@//<Host>:<port>/XE

    CREATE TABLE products (


      category varchar2(50) DEFAULT NULL,

      productId varchar2(50) NOT NULL unique,

      title varchar2(500) NOT NULL,

      productDescription clob NULL,

      imageUrls clob NOT NULL,

      categoryPath varchar2(255) NOT NULL,

      attributes clob NOT NULL,

      shippingCharges binary_double DEFAULT NULL,

      estimatedDeliveryTime varchar2(100) NULL,

      sellerName varchar2(255) NOT NULL,

      keySpecs clob NOT NULL,

      detailedSpecs clob NOT NULL,

      specificationList clob NOT NULL,

      date_added timestamp(0) DEFAULT SYSTIMESTAMP NOT NULL,

      date_modified timestamp(0) DEFAULT SYSTIMESTAMP NOT NULL

    ) ;

  • PHP json_encode() Malformed UTF-8 characters, possibly incorrectly encoded

    // Change character set to utf8
    $mysqli -> set_charset("utf8");

    json_encode($text, JSON_INVALID_UTF8_IGNORE);


    json_encode($text, JSON_INVALID_UTF8_SUBSTITUTE);

    $encoded = json_encode( utf8ize( $responseForJS ) );
    $json = html_entity_decode($source);
    $data = json_decode($json,true);

  • Test Post