90 results for: sql
Infinite scrolling with native JavaScript using the Fetch API
I have long wanted to talk about how infinite scroll functionality can be implemented in a list of items that might be on any Web page. Infinite scroll is a technique that allows the user to interact with the mouse by scrolling down to load new dynamic content. In this way, the…
Category : Javascript 15-05-2023 by Janeth Kent
How to fix excessive MySQL CPU usage
What happens if we realise that a series of databases that we thought were optimised through the use of indexes, have begun to consume CPU usage time of a server to unsuspected limits? Even users have stopped being able to access the server when it had a certain number of visits…
Category : Development 21-12-2022 by Janeth Kent
How to connect to MySQL with Node.js
Let's see how you can connect to a MySQL database using Node.js, the popular JavaScript runtime environment. Before we start, it is important to note that you must have Node.js installed on your system. Likewise, you must create a MySQL database. Create a MySQL database If you haven't already done so, you can…
Category : Javascript 04-11-2021 by Silvia Mazzetta
How to set up your own free web server with XAMPP
Nowadays anyone can create their own website easily and free of charge. Whether through a CMS (such as WordPress) or by hand with HTML, CSS and JavaScript, in a few minutes we can have a more or less functional website up and running. However, in order to test that everything…
Category : Servers 25-10-2021 by Silvia Mazzetta
What is a Full Stack Developer?
The demand for the Full Stack Developer is growing exponentially in recent years. Disruptive technology companies and startups are increasingly requesting this type of multipurpose profile that knows multiple programming languages and can assume all kinds of functions within the company. Throughout this article we will tell you what a full stack…
Category : News and events 06-08-2021 by Janeth Kent
htaccess Rules to Help Protect from SQL Injections and XSS
This list of rules by no means is a sure bet to secure your web services, but it will help in preventing script-kiddings from doing some basic browsing around. MySQL injection attempts are one of the most common hacking attacks against PHP websites. If your website is hosted on a dedicated…
Category : Security 01-03-2021 by Janeth Kent
Cumulative Layout Shift, what is and How to optimize CLS
Cumulative Layout Shift, one of the new Core Web Vitals metrics, is the first metric that focuses on user experience beyond performance. Unexpected movement of web page content is a major source of irritation for users on the web. The new cumulative design change metric helps developers understand the impact of…
Category : Seo & sem 14-01-2021 by Luigi Nori
What is Django and what is it used for
When we talk about Django, we refer to that framework that is used for any totally free and open source web application which is written in Python. Basically, it's a group of elements that will help you create web pages much more easily and quickly. At the moment you are going…
Category : Programming 26-12-2020 by Janeth Kent
A beginner’s guide to software vulnerabilities
What are software vulnerabilities The number of devices connected to the Internet is growing every day. And among those devices we find not only computers and smartphones, but also an ever-rising number of cameras, smoke detectors, motion sensors, smart door locks, and let’s not forget that even plant pots. Many households…
Category : Security 17-11-2020 by Iveta Karailievova
HTTP Cookies: how they work and how to use them
Today we are going to write about the way to store data in a browser, why websites use cookies and how they work in detail. Continue reading to find out how to implement and manage them - if you're looking for code! Understanding HTTP COOKIES - What are they? Cookies and other types…
Category : Programming 27-11-2020 by
Google Dorks: How to find interesting data and search like hacker
Go the words Google and Hacking together? Well if you thought that we will learn how to use hack Google, you might be wrong. But we can Use Google search engine to find interesting data accidentally exposed to the Internet. Such a simple search bar has the potential to help you also…
Category : Security 03-12-2021 by
A collection of interesting networks and technology aiming at re-decentralizing the Internet
The decentralised web, or DWeb, could be a chance to take control of our data back from the big tech firms. So how does it work? Take a look at this collection of projects aimed to build a decentralized internet. Cloud BitDust - is decentralized, secure and anonymous on-line storage, where only…
Category : Networking 27-08-2020 by Janeth Kent
MySQL 8.0 is now fully supported in PHP 7.4
MySQL and PHP is a love story that started long time ago. However the love story with MySQL 8.0 was a bit slower to start… but don’t worry it rules now ! The support of MySQL 8.0’s new default authentication method in PHP took some time and was added in PHP…
Category : Databases 27-10-2020 by Janeth Kent
Web shells as a security thread for web applications
Over the past two decades, web applications as an alternative to traditional desktop application have been on to rise. As their name suggests, they are installed on web servers and accessed via a web browser. This gives web apps a rather long list of advantages: multi-platform cross-compatibility, no installation required for…
Category : Security 04-05-2020 by Iveta Karailievova
The best websites of the Tor Deep Web and Dark Web Network
We already talked about Deep Web more than a year ago, explaining that to open Deep Web (or rather Dark Web) sites you need total and undetectable user anonymity and access to the "onion" network. The Dark Web is much smaller than the Deep Web and is composed mainly of sites…
Category : Security 03-11-2022 by Janeth Kent
Amazing Javascript Game Source Codes for Free
In this article we will share the code to make simple games with Javascript programming language. The games code can later be your reference material for making other simple games. Before you continue do you already know what is javascript programming ?, if you don't know yet, please read the brief…
Category : Javascript 19-07-2022 by Luigi Nori
10 Open source tools for security operations (SOC)
As we know, there are many moving parts to building a Security Operations Centre (SOC). From a technological point of view, it is very important to count on open source to identify threats and reduce costs. From a DiD (Defense in Depth) point of view, there are many devices and…
Category : Security 29-11-2019 by Janeth Kent
CRUD Operations Using Vue.js: a basic example
In this tutorial, we show you how to create CRUD application using vue js. here is very basic and simple example of vue.js crud app. using this vuejs crud (create read update delete) you can easily implement with php mysql or also in laravel or codeigniter framework. So it is a…
Category : Javascript 23-05-2020 by Luigi Nori
The history of software development in two minutes: a century of logic, languages and code
The video shows the hyper-compressed history of software development and programming beginning in 1912 with Bertrand Russell and Alfred North Whitehead and their work on formal logic and type theory. Then came the first electromechanical calculators from IBM and others. Turing laid the foundations for programming in 1930 and by 1940…
Category : Programming 20-08-2019 by Janeth Kent
A roadmap to becoming a web developer in 2019
There are plenty of tutorials online, which won't cost you a cent. If you are sufficiently self-driven and interested, you have no difficulty training yourself. The point to learn coding I think is to read a lot of code of other developers, then typing code and testing to see what…
Category : Programming 30-05-2019 by Janeth Kent
Best Node Js Resources, Courses and Tutorials.
NodeJS is a platform that enables developers to write high-performance and networked applications server side. And using good old Javascript as well. Why should you study NodeJS? To begin with, it never hurts to learn something new. But most importantly, it's great to learn NodeJS. With a focus on modern JavaScript and real-world application,…
Category : Javascript 10-05-2020 by Janeth Kent
How to Become an Automation Engineer
In today’s climate, IT professionals have just about as diverse a range of career options as anybody else. One such pathway that such a professional can take is automation engineering. If you have a passion for machinery, enjoy being detail oriented, and fancy making a boatload of cash, then this…
Category : Technology 08-02-2019 by Janeth Kent
80 Linux Network Monitor Software & Tools for Managing & Monitoring Unix/Linux Systems
It’s hard work monitoring and debugging Linux performance problems, but it’s easier with the right tools at the right time. Finding a Linux Network Monitor tool or Software package for your Critical servers and services that are running on those systems in one of the most (if not the most)…
Category : Security 23-10-2018 by Janeth Kent
How to Set up a Fully Functional Mail Server on Ubuntu 16.04 with iRedMail
Setting up your own mail server from scratch on Linux is complex and tedious, until you meet iRedMail. This tutorial is going to show you how you can easily and quickly set up a full-fledged mail server on Ubuntu 16.04 with iRedMail under 30 minutes. What is iRedMail? iRedMail is a shell…
Category : Networking 30-03-2023 by Janeth Kent
Best Websites to Learn Coding Online
You know and we know that it’s totally possible to learn to code for free... If you can teach yourself how to write code, you gain a competitive edge over your peers, you can think more algorithmically and thus can tackle problems more efficiently. But what are the best resources to achieve…
Category : Programming 19-06-2018 by Janeth Kent
MYSQL: How to create a new user and give it full access only to 1 database
To create a new user in MySQL and give it full access only to 1 database, say dbTest, these are the MySQL commands to do that To create the user: CREATE USER 'user'@'hostname'; To give it access to the database dbTest: GRANT ALL PRIVILEGES ON dbTest.* To 'user'@'hostname' IDENTIFIED BY 'password'; If you are running…
Category : Databases 07-02-2018 by Janeth Kent
ArangoDB, install and configure the popular Database in ubuntu 16.04
Introduction to ArangoDb, open source, NoSQL, multi-model database BigData seems to be getting stronger every day and more and more NoSQL databases are coming out to the market, all trying to position themselves in the lead to be the reference. This week I tried ArangoDB! Another NoSQL database? Today I'm going to…
Category : Databases 14-11-2017 by Janeth Kent
How JSON data types work in mysql
First introduced in MySQL 5.7.8, the JSON data type is a specialized binary column type, similar to a blob , but with added machinery to optimize the storage and retrieval of values from a column typed as json . Javascript Object Notation or more commonly known as JSON, is a modern…
Category : Databases 30-09-2019 by
How to Configure the Mod_Security Core Ruleset in Ubuntu
ModSecurity is a Web Application Firewall, a program that can be used to inspect information as it passes through your web server, intercepting malicious requests before they are processed by your web application. This tutorial will show you how to install ModSecurity on Apache, and configure it with some sensible rules provided…
Category : Servers 04-03-2017 by Janeth Kent
How to Disable Strict SQL Mode in MySQL 5.7 and Ubuntu 16.04
If your app was written for older versions of MySQL and is not compatible with strict SQL mode in MySQL 5.7, you can disable strict SQL mode. For example, apps such as WHMCS 6 and Craft 2 do not support strict SQL mode. If you're using WHMCS 7, see our article…
Category : Databases 18-02-2019 by Janeth Kent
Install Apache, MariaDB and PHP7 on Ubuntu 16.04
Ubuntu 16.04 LTS Xenial Xerus comes with PHP7 by default so you don’t have to rely on third-party PPA to get PHP7 installed. In this tutorial, we are going to look at how to install Apache, MariaDB and PHP7 (LAMP stack) on Ubuntu 16.04 LTS Xenial Xerus. Update: This tutorial is…
Category : Servers 18-11-2016 by Janeth Kent
Ubuntu servers security: 25 security tools to armor your system
The Ubuntu repositories contain several useful tools for maintaining a secure network and network administration.This security tools include network scanning,attack detection,Virus Detection etc. 1) Wireshark -- network traffic analyzer Wireshark is a network traffic analyzer, or "sniffer", for Unix and Unix-like operating systems. It is used for network troubleshooting, analysis, software and…
Category : Servers 14-09-2016 by Janeth Kent
MySql: How to build a performant search engine
In content-heavy websites, it becomes increasingly important to provide capable search possibilities to help your users find exactly what they’re looking for. The most obvious solution is searching your MySQL database directly, but implementing a generic MySQL search is not at all trivial. Here’s how to avoid those pitfalls and…
Category : Databases 10-09-2016 by Janeth Kent
SQLMAP installation and usage in Ubuntu and Kali linux
Let's talk about the penetration testing using one of the KALI linux tool called SQLMAP. What is SQLMAP? sqlmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It is a open source tool to use sql injection…
Category : Security 13-08-2016 by Janeth Kent
PHP7: Install PHP7 with NGINX and MEMCACHE in Ubuntu 14.04
Let's install PHP7 and Nginx on a new Ubuntu 14.04 server, and manually build the (not yet packaged) memcached module for PHP7. Command Rundown Update: It looks like the php-memcached package was built into ppa:ondrej/php-php7.0 for php7, so the manual build steps is probably not necessary any longer! Install it via the…
Category : Servers 05-12-2018 by
PHP:How To Upgrade to PHP 7 on Ubuntu 14.04
Introduction PHP 7, which was released on December 3, 2015, promises substantial speed improvements over previous versions of the language, along with new features like scalar type hinting.This guide explains how to quickly upgrade an Apache or Nginx web server running PHP 5.x (any release) to PHP 7. Warning: As with…
Category : Operating systems 13-03-2016 by Janeth Kent
Install HHVM + Nginx on Ubuntu 14.04
The LEMHH software stack is a group of software that can be used to serve dynamic web pages and web applications. This is an acronym that describes a Linux operating system, with an Nginx web server. The backend data is stored in MySQL and the dynamic processing is handled by…
Category : Networking 12-05-2017 by Janeth Kent
PHP7: Guide and References to all the changes between version 5.x and 7 of PHP
PHP 7 was released on December 3rd, 2015. It comes with a number of new features, changes, and backwards compatibility breakages that are outlined below. Performance Features Combined Comparison Operator Null Coalesce Operator Scalar Type Declarations Return Type Declarations Anonymous Classes Unicode Codepoint Escape Syntax Closure call() Method Filtered unserialize() IntlChar Class Expectations Group use Declarations Generator Return Expressions Generator Delegation Integer Division with intdiv() session_start() Options preg_replace_callback_array() Function CSPRNG Functions Support…
Category : Php 27-12-2015 by Janeth Kent
Optimize MySql On Low Memory Servers
Cloud computing makes it very affordable to get your own private virtual server on the Internet. Digital Ocean offers an entry level droplet for USD$5 per month, and Amazon.com has a micro instance tier on the EC2 platform that is free for the first year. These instances are rather useful…
Category : Databases 25-08-2020 by Luigi Nori
How to Configure Cloudflare Flexible SSL with WordPress website
This article is part of a serie of articles about Wordpress optimization with Cloudflare and some kinds of servers, if you want to understand well read these articles before: Speed up your site and protect it against DDOS attacks with CloudFlare Million of visitors per day with a super cheap php mysql…
Category : Servers 03-12-2015 by Janeth Kent
Easy debug of Php with ChromePhp and ChromeLogger
ChromePhp is a Module to log useful details directly in your Chrome JS console. You can inspect most as objects and see infos or values. It is a great way to debug PHP code on the fly, in Google Chrome. It's very easy to integrate to any project and log any…
Category : Php 30-03-2023 by Luigi Nori
The Best Free SSH Tabbed Terminal Clients for Windows
PuTTy is an emulator for the terminal. It allows you to log into another computer that can be on the same network or accessed via the internet. The basic program has no security, but you can add authentication and encryption to SSH to protect internet connections. The tool also includes…
Category : Networking 05-05-2021 by Janeth Kent
PHP: list of best awesome PHP libraries
It is an exciting time to be a PHP developer. There are lots of useful libraries released every day, and with the help of Composer and Github, they are easy to discover and use. Here is a complete list of the coolest that We’ve come across. Package Management Libraries for package and…
Category : Php 27-04-2014 by Janeth Kent
10 Server and network monitoring tools
When you have a website or a network, it’s helpful to be aware of any issues as soon as they occur. There are open source and freeware server/network monitoring tools that will supervise your infrastructure for any issues that may arise. These tools are meant to aid you in avoiding…
Category : Networking 04-02-2014 by Janeth Kent
Free PHP, HTML, CSS, JavaScript editor (IDE) - Codelobster PHP Edition
For valuable work on creation of sites you need a good comfortable editor necessarily. There are many requiring paid products for this purpose, but we would like to select free of charge very functional and at the same time of simple in the use editor - Codelobster PHP Edition .…
Category : Software 16-01-2014 by Janeth Kent
PHP: Storing arrays in database
When working with databases, sometimes it is necessary to store an array in a MySQL field. Unfortunately, there is no way to directly pass in an array as a parameter. Storing these data structures is a bit more complex, but by no means hard or impossible. To convert any array (or…
Category : Databases 18-11-2013 by Janeth Kent
Php: 12 Debugging Tools For Developers
PHP is faster and most used scripting language in practice; contains many features such as detailed documentation, a huge community, myriad of ready-to-use scripts and well-supported frameworks. Its quite easy to get started with PHP than with other scripting languages such as Python, or Ruby because of the features PHP…
Category : Software 05-11-2013 by Janeth Kent
Tutorial: Introduction to PHP:PDO
Many PHP programmers learned how to access databases by using either the MySQL or MySQLi extensions. As of PHP 5.1, there’s a better way. PHP Data Objects (PDO) provide methods for prepared statements and working with objects that will make you far more productive! PDO Introduction “PDO – PHP Data Objects…
Category : Databases 15-10-2013 by Janeth Kent
How to import and export a large database using SSH
The following code snippets will allow you to import and export a database Command Line. To get SSH access to your hosts server you will need to contact your web hosting company, our suggestion is that you find a reliable, high-performing, secure hosting company that can help you. In case you are on a…
Category : Databases 25-06-2019 by Janeth Kent
10 Javascript Tutorials You Must See
Fortunately, we live in an era of global connectivity and access to many resources. Thanks to the Internet and people who enjoy sharing content, you can find almost everything you need to learn, and for free. Free tutorials, books and courses are easily found without spending too much. So if you…
Category : Javascript 10-09-2020 by Silvia Mazzetta
10 Best PHP Scripts for Polling System
In this post we will show you a collection of 10 best PHP Poll Scripts. These PHP scripts for polling system can be added in any self-hosted website. Check out these awesome and easy to install scripts. 1. JAXpoll JAXpoll is a polling widget that you can add into any of your websites.…
Category : Php 23-08-2013 by Janeth Kent
PHP files are downloaded by browser instead of processed by the server, how to solve it?
After upgraded some packages in my ubuntu server, sometimes php configuration goes crazy and PHP files are downloaded by browser instead of processed by the server, how to solve it? Here are the steps to solve fastly the problem. Follow thiese commands: Code: sudo a2enmod php5 and it said "Module php5 already enabled". re-starting apache2…
Category : Networking 16-08-2013 by Janeth Kent
Top 12 free JavaScript resources for advanced users
If you have a strong knowledge in programming and want to improve your JavaScript skills or you want a good reference book then this list is for you. We've put together a list of 12 of our favorite JavaScript free book to help save you time and energy along the way.…
Category : Web design 16-01-2018 by Janeth Kent
PHP: Getting started with Object Oriented Programming in PHP5
This is a tutorial covers some main concepts of OOP in PHP5 with usable examples (however useless the something may be). The tutorial only covering a few fundamental subjects, all subjects are complete in and of themselves. What is OOP? Object Oriented Programming, referred to as OOP is a way to efficiently…
Category : Php 12-08-2013 by Janeth Kent
13 jQuery Plugins and Tutorials for e-commerce website
E-Commerce websites are making shopping easy for customers. The number of ecommerce websites are growing with every day. Shopping Cart is the most important aspect of an E-Commerce website. We all know that jQuery plugins helps us to add difficult things to our websites very easily. Below you’ll find 13 jQuery shopping cart plugin and…
Category : Javascript 02-08-2013 by Janeth Kent
How to detect r57 and c99 Shells in your server
When malicious intruders compromise a web server, there's an excellent chance a famous Russian PHP script, r57shell, will follow. The r57 and C99 shell PHP script gives the intruder a number of capabilities, including, but not limited to: downloading files, uploading files, creating backdoors, setting up a spam relay, forging…
Category : Security 26-07-2013 by Janeth Kent
The best code editor for web developers
Every web developer requires the right tools to do their job, therefore the choice of a source code editor shouldn’t come lightly. This is where we spend most of our development time and where productivity is gained or lost on a grand scale. But which is the best Code Editor? To determine the best source code editor, we…
Category : Software 25-07-2013 by Janeth Kent
21 PHP Libraries You Should Know About
The aim of the Standard PHP Library-or SPL is to provide a standard library of interfaces which allows developers to take full advantage of object-oriented programming in PHP. Therefore in this article we have collected 21 of the best PHP Libraries which will assist and help developers to simplify their work and serve…
Category : Programming 24-07-2013 by Janeth Kent
10 Best Free Ecommerce Solutions On The Market
There are many ecommerce platforms in the market. Some are free platforms and some are paid platforms. The main factors which you have to consider while choosing ecommerce platform is the price, useful functions, user friendly and with strong merchandising tools. Each platform has its own set of pros and cons…
Category : Software 19-07-2013 by Janeth Kent
Setup and Manage Mysql/MysqlAdmin root password
Managing mysql main root password is one of the most common questions/problems that new linux users have, and one of the essential tasks. By defaultroot user is MySQL admin account. The Linux / UNIXlogin root account for your operating system and MySQL root aredifferent. They are separate and nothing to…
Category : Databases 18-07-2013 by Janeth Kent
Top 15 Free Hacking Tools for Ethical Hackers
Intrusion tests, known as "Penetration Analysis" or "Ethical Hacking", are now a common practice to know the level of security a website has. These tests assess the type and extent of system and network vulnerabilities in terms of confidentiality and integrity. They check the security of the network and empirically verify…
Category : Security 19-06-2020 by Silvia Mazzetta
WordPress tips and tricks: how to custumize your theme
When you're in the process of writing a WordPress theme, there are a few behaviors you can change. Some of them are pretty basic, but they can really enhance the theme my making it go that extra mile. How to Customize The Login Page It’s quiet easy to customize the existing Login…
Category : Web design 10-07-2013 by Janeth Kent
20 useful cheat sheets for web developers
Being a web developer is an awesome job because you have the possibility to create awesome things. It is fun, you can play with some cool tools and you can earn a lot of money but like in any other type of specialization, you need to be up to date with all…
Category : Web design 03-07-2013 by Janeth Kent
Predis: PHP Library for REDIS
Redis is an open source data structure server with an in-memory dataset that does much more than simple key/value storage thanks to its built-in data types. It was started in 2009 by Salvatore Sanfilippo and because of its popularity quickly grew, being chosen by big companies like VMware (who later hired…
Category : Programming 01-07-2013 by Janeth Kent
NoSQL Concept and MongoDB
NoSQL has emerged as a different and alternative approach compared to relational database management systems (RDBMS). Actually, there are fundamental differences between the scalable NoSQL systems and relational database management systems. Relational database management systems are transaction-based and have ACID rules. NoSQL systems do not fully support the ACID rules and there is no…
Category : Databases 28-06-2013 by Janeth Kent
PHP Recursive Backup of MySql Database
This script can be used to make backup of your MySql database, you can use the script in conjunction with cronjobs $user = 'myuser'; $passwd = 'mypass'; $host = 'myhost'; $db = 'mydb'; // Delete the tables if they exists? $drop = true; // Tables that will be created $tables = false; // Compression algorythm that we will use $compression…
Category : Databases 24-06-2013 by Janeth Kent
20 Open Source Scripts Applications for Web Developers
Open source applications and tools can be handy for web designers and developers on a budget. Nowadays most of the tools and applications are increasingly either employing open source or are built entirely on it. And all of this adds up to an increasing premium on web development skills and…
Category : Programming 11-08-2016 by Janeth Kent
A List of Best Free SQL Injection Scanners and Tools
We’ve compiled a list of free SQL Injection Scanners we believe will be of a value to both web application developers and professional security auditors. Checking for SQL Injection vulnerabilities involves auditing your web applications and the best way to do it is by using automated SQL Injection Scanners. SQLbftools –…
Category : Databases 03-06-2013 by Janeth Kent
25 Useful HTML5 Tools For Web Designers & Developers
The latest version of HTML – HTML5, adds many new elements to the applications that are being developed. It's very important important for the web developers and web designers to learn and use the elements of HTML5 to develop web apps and sites. Here we have some fresh and news HTML5 resources which are…
Category : Web design 29-05-2013 by Janeth Kent
Million of visitors per day with a super cheap php mysql server using nginx and varnish
These instructions are the rather verbose, but hopefully easy enough to follow, steps to build a new Linux server using Varnish and Nginx to build a php application on a cheap server , all costing under $15 a month, capable of sustaining million hits per day, (we use blitz.io to…
Category : Networking 28-05-2013 by Janeth Kent
10 most used PHP features
We have compiled a selection of top 10 PHP native functions, classes and features. We know first-hand how invaluable these features are, so we hope you find them to be useful too. 1. PDO Class We use the PDO (PHP Data Object) exclusively for connecting to our MySQL databases. PDO provides a nice abstraction layer…
Category : Programming 22-05-2013 by Janeth Kent
Google Hacking Secrets: The Hidden Codes Of Google
No need for an introduction, Google is quite possibly the more powerful search engine used today, even used sometimes to check our connectivity; except that the power of the single search bar on the top of Google has become a source of concern for many, and if not they should…
Category : Security 08-04-2021 by Janeth Kent
Memcache: Installation and Usage on Ubuntu 12.10
About Memcache Memcache is a system that works to speed up virtual private servers by caching server information. The program allows you to allocate a specific amount of the server ram toward caching recently queried data for a certain amount of time. Once the data is requested again, memcache speeds up…
Category : Databases 03-05-2013 by Janeth Kent
Mysql:Guide To The MySql Query Cache
MySQL “Query Cache” is quite helpful for MySQL Performance optimization tasks but there are number of things you need to know. First let me clarify what MySQL Query Cache is - I’ve seen number of people being confused, thinking MySQL Query Cache is the same as Oracle Query Cache - meaning…
Category : Databases 25-03-2020 by Janeth Kent
MySql: Setup Master Slave Replication in Ubuntu
About MySQL replication MySQL replication is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database. This can helpful for many reasons including facilating a backup for the data,a way to analyze it without using…
Category : Databases 02-05-2013 by Janeth Kent
Redis: installation and usage on Ubuntu/Debian
About Redis Redis, developed in 2009, is a flexible, open-source, key value data store. Following in the footsteps of other NoSQL databases, such as Cassandra, CouchDB, and MongoDB, Redis allows the user to store vast amounts of data without the limits of a relational database. Additionally, it has also been compared…
Category : Databases 01-07-2013 by Janeth Kent
40 Free Visualization Libraries: Charts, Diagrams And Flowcharts
With the technology advancements, internet users have developed some standard methods to present data to users. They include the use of statistical charts and graphs. Presenting data in the form of charts and graphs makes it easy for the users to understand it. For today’s round up, we are presenting you…
Category : Web design 15-04-2013 by Janeth Kent
Install Webmin on Ubuntu
Webmin is a web-based control panel for any Linux machine that allows you to manage your server through a modern web-based interface. With Webmin, you can change settings for common packages on the fly, including web servers and databases, as well as manage users, groups and software packages. Through this tutorial,…
Category : Networking 18-06-2020 by Janeth Kent
Learning Loops in Php: FOREACH
Loops come in several different flavors in PHP: for, while, do-while, and foreach. We will introduce you to each of them in 3 lessons and we will show you how they can making repetitive tasks straightforward and easy to maintain. Lesson #3: The foreach Loop To understand FOREACH loops you have to know the arrays. When using a loop with…
Category : Php 11-04-2013 by Janeth Kent
Six Useful PHP code snippets
Here’s a mini list of useful PHP code snippets that we find using on a weekly basis. You could use these as is or expand them as part of other applications or add them to a php class. Adjust server time Useful if you have a server in a different timezone, like…
Category : Programming 11-04-2013 by Janeth Kent
Tips to Create Secure PHP Applications
PHP is one of the most popular programming languages for the web. Such languages are very helpful for the programmer but the security holes in it can create a problem. They can create problems in the development path.Below are few tips to help you avoid some common PHP security pitfalls…
Category : Php 29-06-2019 by Janeth Kent
PHP:EZSql class, manage your database connection easily
EZSql is a php class to make it very easy to deal with database connections, there’s already an ezsql documentation: Extensive ezsql documentation Requirements Wampserver ezsql library Installation First you need to download wampserver and ezsql library. I’ve already included the links in the requirements section. Next, setup your test folder. Then create your database configuration file…
Category : Php 11-04-2013 by Janeth Kent
PHP-MongoDB Beginners Guide
Over the last year or so, there's been a small revolution taking place in the database world, with the advent of "schema-less" database systems like Apache CouchDB. These databases follow a different approach to data storage as compared to the traditional relational model, and they're quickly becoming popular with Web…
Category : Databases 11-04-2013 by Janeth Kent
Import data from Mysql to MongoDb with EzSql class
This simple php class to demonstrate how to import data from a MySql database to a Mongodb with out complications. // It uses the ezsql database class from Justin Vincent: // http://justinvincent.com/ezsql include_once "ezsql/shared/ez_sql_core.php"; include_once "ezsql/mysql/ez_sql_mysql.php"; class mongodb_importer { public $user; public $pass; public $databse; public $server; public function import($table_name,$mongo_db) { $db = new ezSQL_mysql($this->user,$this->pass,$this->database,$this->server); $m = new Mongo(); $mongo_db = $m->selectDB($mongo_db); $collection = new MongoCollection($mongo_db, $table_name); $res = $db->get_results("select * from ". $table_name); $i = 0; foreach($res as $r) { $i++; $collection->insert($r); } return $i; } } ?> And here it is an example about how to use this! // create a new object $importer = new mongodb_importer(); // set your Mysql information $importer->database = "my_databse"; $importer->pass = "my_secret_password"; $importer->user = "my_user_name"; $importer->server = "localhost"; // import the data $count = $importer->import("user","new_db"); // print the result echo "Imported " . $count . " records."; ?>
Category : Databases 11-04-2013 by Janeth Kent
Genghis - Mongo DB Manager in a single file
For NoSQL fans, MongoDB is definitely the most popular solution with the simplicity and cross-platform support offered. In order to manage MongoDB databases easily, Genghis, a single-file, self-hosted and web-based solution is pretty handy. It can be installed either as a Ruby gem or as a standalone PHP script. Genghis is capable of managing any number of databases…
Category : Databases 11-04-2013 by Janeth Kent
How to install LAMP (Linux,Apache,Mysql,Php) in Ubuntu 12.10
About LAMP LAMP stack is a group of open source software used to get web servers up and running. The acronym stands for Linux, Apache, MySQL, and PHP. Since the virtual private server is already running Ubuntu, the linux part is taken care of. Here is how to install the rest. Set…
Category : Networking 11-04-2013 by Janeth Kent
A list of Great PHP libraries and classes you should know
It is an exciting time to be a PHP developer. There are lots of useful libraries released every day, and with the help of Composer and Github, they are easy to discover and use. Here are 24 of the coolest that I’ve come across. Your favorite is not on the list? Share it in…
Category : Programming 26-03-2021 by Janeth Kent
Php: Introduction to Mysqli Extension
Experienced developers eschew the original MySQL extension because of its abandoned status in PHP. Nascent web developers, however, may be completely oblivious to its dormant past and dying future. Introductory tutorials for connecting to MySQL from PHP are certainly abundant, as is evident from a simple “php and mysql tutorial” Google…
Category : Networking 11-04-2013 by Janeth Kent
How To Reset ISPCONFIG 3 Admin Password
On some occasions we may be installing a server, or simply it has been a long time since we last touched a panel that has not given us problems or we have not needed, and we find that we have forgotten the administrator password. In the case of ISPConfig3, we are…
Category : Networking 21-03-2021 by Janeth Kent
Install ISPCONFIG 3 in UBUNTU 12.04
Note: This is work in progress! You should probably test this in a virtual machine first and play around with various settings. There are a lot of tutorials over the Internet about how to configure an Ubuntu server for ISPConfig. I usually follow them, after all there aren’t so many variations on…
Category : Networking 11-04-2013 by Janeth Kent