How to fetch data in excel or generate excel file in PHP

File structure for this tutorial : config.php (database connection file) index.php (For fetching data ) genrate-excel.php (For genrating excel file ) Create a sql table tblemployee. Structure…

Read More

Password Hashing in PHP

Functions for hashing password password_hash() password_verify() password_hash() – Syntax: [code language=”php”] string password_hash(string $password , integer $algo [, array $options ] ) [/code] string $password – Password…

Read More

How to delete records?

1) Write the delete statement: [code language=”php”] $sql = "DELETE FROM `users` WHERE `id`=:id"; [/code] 2) Prepare the query: [code language=”php”] $query = $dbh -> prepare($sql); [/code]…

Read More

How to use PDO to update the database?

1) Write the regular update statement and again, instead of values, assign the named placeholders. For example: [code language=”php”] $sql = "UPDATE `users` SET `city`= :city, `phone`…

Read More

How to use PDO to read data from the database?

1) Write the regular select statement and again, instead of values, put named placeholders. For example: [code language=”php”] $sql = "SELECT * FROM users"; [/code] 2) Prepare…

Read More

How to use PDO to insert data into the database?

The SQL code for the users table: [code language=”sql”] CREATE TABLE IF NOT EXISTS users (id int(11) NOT NULL AUTO_INCREMENT, name varchar(60) DEFAULT NULL, phone varchar(12) DEFAULT…

Read More

PDO – PHP database extension

PDO – PHP database extension PDO (PHP Data Objects) is a PHP extension through which we can access and work with databases. Though PDO is similar in…

Read More

INCREASE WEBSITE LOADTIME

How to Increase Website loadtime and Page Speed ? Click Here… Click Here …. Some Website to Check Other Website Performance. Click Here…. Click Here…. Rajesh KumarI’m Rajesh Kumar, a DevOps,…

Read More

TURN OFF DISPLAY ERROR IN PHP

Method 1 & 2 & 3 https:///…-standards-error-fix Method 4 error_reporting(0); ini_set(‘display_errors’, ‘0’);     # don’t show any errors… error_reporting(E_ALL | ~E_STRICT);  # …but do log them…

Read More

Microservices Architectural Design Patterns Playbook

Rajesh KumarI’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked…

Read More

Lets Understand the Ruby programming world in 5 mins!!!

Lets Understand the Ruby programming world in 5 mins? Ruby Ruby is a dynamic, interpreted, reflective, object-oriented, general-purpose programming language. It was designed and developed in the…

Read More

Checklist for Validating A DevOps Architecture

Source – http://blog.flux7.com/blogs/devops/checklist-for-validating-a-devops-architecture-part-1 Author – Ali Hussain Checklist: Validate DevOps Architecture Understand business needs An organization moving to the cloud truly understand cloud’s benefits only when setting up…

Read More

Apache Ant

Ant is a Java library and command-line tool. Ant’s mission is to drive processes described in build files as targets and extension points dependent upon each other….

Read More

21+ Most Useful Time Saving WordPress Shortcuts

WordPress Keyboard Shortcuts for Visual Post Editor Ctrl + b = Bold Ctrl + i = Italic Ctrl + c = Copy Ctrl + v = Paste…

Read More

Joomla Website Performance

SEO and PERFORMANCE http://www.joomlaaa.com/Joomla-Articles/optimization/How-can-I-make-my-Joomla-site-load-faster.html http://www.joomlaperformance.com http://www.websiteoptimization.com http://www.pathos-seo.com/joomla-technical-optimization/making-a-faster-joomla-website.html http://www.pathos-seo.com/joomla-technical-optimization/making-a-faster-joomla-website.html   http://www.wzcreativetechnology.com/joomla-tips-and-tricks/74-how-to-make-joomla-site-load-fast.html http://extensions.joomla.org/extensions/site-management/cache/7350 http://www.open-source-depot.com/archives/13-MySQL-Performance-Tip-on-CentOS4-on-GoDaddy.html http://www.open-source-depot.com/archives/13-MySQL-Performance-Tip-on-CentOS4-on-GoDaddy.html http://www.cyberciti.biz/tips/enable-the-query-cache-in-mysql-to-improve-performance.html   http://forum.joomla.org/viewtopic.php?f=433&t=344013l http://kb.siteground.com/article/How_to_optimize_a_MySQL_database_using_phpMyAdmin.html http://www.electrictoolbox.com/mysql-optimize-table-cli/ http://forum.joomla.org/viewtopic.php?p=1250059 http://kb.siteground.com/article/How_to_optimize_a_MySQL_database.html http://developer.yahoo.com/performance/rules.html http://www.mightyjoomla.com/Joomla-Tips-Tricks/enable-and-use-gzip-compression-in-joomla-cms-to-enhance-website-performance.html http://forum.joomla.org/viewtopic.php?t=50278     www.websiteoptimization.com/services/analyze/  …

Read More

Kunena Migration

Before starting the migration: upgrade both the source and target websites to the latest available versions of the component backup the source and target websites Migrate core…

Read More

npm – Node Packaged Modules

Install a package SYNOPSIS npm install (with no args in a package dir) npm install <tarball file> npm install <tarball url> npm install <folder> npm install <name>…

Read More

JSHINT

JSHint is a community-driven tool to detect errors and potential problems in JavaScript code and to enforce your team’s coding conventions. It is very flexible so you can…

Read More

Know about nodejs?

What is nodejs? Node.js untangles concurrency by replacing the Java platform’s standard, multithreaded approach with single-threaded, event-driven I/O. Node.js (Node) is an I/O environment built on top…

Read More

Best date android apps

Tagged Tagged – Meet, Date, Chat, Flirt, Free, Fun! Over 300 million members make Tagged the largest and best FREE app to meet new people and make…

Read More

Top Must have android apps in India

Indian Rail Info App Indian Rail Info App is the most downloaded Android application for information about Indian Railways. It enables users to search information about train…

Read More

Java Command Line Options

-client       to select the “client” VM -server       to select the “server” VM -hotspot      is a synonym for the “client” VM  [deprecated] The default VM is client. -cp…

Read More

Introdcution of Perl

What is Perl Perl is a programming language, It’s Object Oriented, simple to learn and very powerful. Perl stand for: “Practical Extraction and Reporting Language”. Perl is…

Read More

Jetty – Java-based HTTP server

Jetty is a 100% pure Java-based HTTP server and servlet container (application server). Jetty is a free and open source project under the Apache 2.0 License. Jetty is used by…

Read More

XML Is the Here, the Now, and the Future

XML Is the Here, the Now, and the Future XML is short for Extensible Markup Language, which is a specification developed by the World Wide Web Consortium…

Read More

How to move magento shop to another server

The following procedure describes the basic needs for moving your magento-shop to another server. There might be additional things to consider (changing domains, DNS, PHP-Configuration, tools & programms on your server)…

Read More

Connection failed: 404 – Not Found

scmuser created the topic: standalone-pom: Connection failed: 404 – Not Found Error – [code language=”css”] [ERROR] Failed to execute goal org.sonatype.plugins:nexus-m2settings-maven-plugin:1.6.6:download (default-cli) on projec t standalone-pom: Connection…

Read More

Chef Error – Waiting for remote response before bootstrap in windows

rajeshkumar created the topic: Waiting for remote response before bootstrap in windows When i bootstrap windows node, i get following error.. [code language=”css”] knife bootstrap windows winrm…

Read More

AWT is not properly configured on this server

rajeshkumar created the topic: AWT is not properly configured on this server Problem AWT is not properly configured on this server. Perhaps you need to run your…

Read More

How to automatically recover Tomcat from crashes

rajeshkumar created the topic: How to automatically recover Tomcat from crashes How to automatically recover Tomcat from crashes Tomcat occasionally crashes if you do frequent hot-deploys or…

Read More