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…
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…
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]…
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`…
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…
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…
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…
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,…
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…
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…
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…
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…
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….
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…
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/ …
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…
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>…
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…
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…
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…
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…
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…
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…
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…
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)…
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…
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…
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…
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…
