• 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

    Requirements:

    • 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 (

      id RAW(16) DEFAULT SYS_GUID() PRIMARY KEY,

      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);
    

    Or

    json_encode($text, JSON_INVALID_UTF8_SUBSTITUTE);

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

  • Test Post