results for: mysql
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
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 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
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
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
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
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
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
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
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