MySQL Category: MySQL
MySQL 
Linux How to install Xampp on Linux
In this tutorial we are going to learn Installing latest version of Xampp on Linux , setting Linux htdocs folder permissions issue, How to add a Linux environment variable for PHP, Installing Composer “A Dependency Manager for PHP”. XAMPP is a completely free, easy to install Apache distribution containing MySQL / MariaDB, PHP, and Perl. […]
MySQL MySQL How to sum rows between a range of Timestamps
Sometime we have to face a problem liking summing a MySQL field value between given two timestamps, and we have to rely on google, stack overflow for answer but sometime it become difficult to get desire result. In this post I will go through a example to solve our problem How to sum rows over […]
PHP Admin Plus Free Login System with PHP, MySQL and Foundation
Admin Plus Free Login System is free Login system built using PHP, Mysql and Zurb’s Responsive Framework Foundation. This is very simple login panel where user can login, change his profile picture, update user details … Credits : Sanjay Prasad (Design and Developed). This tutorial is also available on my other website openplus.in . Why […]
Linux Installing Lampp on Rosa Linux using Shell Script
I have published so many tutorial on installing and configuring xampp but today going to show you how to install lampp (stands for Linux, apache,MariaDB/MySQL,php and perl) on Rosa Linux. System configuration : Laptop used – Acer eMachine 732Z with 4GB RAM Distro used – ROSA DESKTOP FRESH R9 2016.1 KDE 5.9 Installing Lampp on […]
PHP PHP Image upload , Saving link to Database complete tutorial
This blog is dedicated to all our visitors who asked me to publish a working tutorial on image upload using PHP and Saving its path to Mysql Table. How to do that : First we will create a file called install.php , it will create a database called myimages and a table named imgtables and […]
MySQL My way learn MySQLI and PHP by examples
MySQL is world most used database and when its works PHP then they have no match. Learning MySQL is very is one can found thousand of tutorial on net but these are now old as MySQLI(or MySQL Advanced) next version are now on demand as implementation is easy, secure and little bit faster. In this […]
PHP Upload user profile image and save to data base -PHP MYSQLI
If you are working on customized CMS or Social networking website then user profile image may be or may not be a head ache I have developed my own where we can upload and rename the image username.jpg/png/gif with size restriction to 200KB. First design a table where database name is Sanjay. Create a table […]