Tag - php-mysql.

How to display indian currency properly in pdf in Magento 2.x

Download the font that support Indian Rupee symbol. please download dejavu-sans font. copy  DejaVuSans.ttf place the above font folder in lib/LinLibertineFont/ directory../vendor/magento/module-sales/Model/Order/Pdf/AbstractPdf.php./vendor/magento/module-sales/Model/Order/Pdf/Items/AbstractItems.php $font = \Zend_Pdf_Font::fontWithPath( // $this->_rootDirectory->getAbsolutePath(‘lib/internal/LinLibertineFont/LinLibertine_Re-4.4.1.ttf’) $this->_rootDirectory->getAbsolutePath(‘lib/internal/LinLibertineFont/DejaVuSans.ttf’) ); (in _setFontRegular(), _setFontBold(), _setFontItalic() functions in both files.)

Read more...

Simple Pagination with php-mysql

Simple pagination code for PHP developers. Step 1 :Create database name “pagination” in mysql using phpMyadmin. -- -- Table structure for table `exclusive_news` --CREATE TABLE `exclusive_news` ( `id` int(2) NOT NULL, `post_id` int(6) DEFAULT NULL, `date` varchar(25) CHARACTER SET latin1 NOT NULL, `title` longtext CHARACTER SET utf8 COLLATE utf8_general_mysql500_ci NOT NULL, `content` longtext NOT NULL, `media` varchar(500) CHARACTER SET latin1 NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf16; orStep 2 :import the sql file from db folder of project to database [...]

Read more...