In phpMyAdmin, you can import a MySQL database and choose specific columns from a table using the following steps: Access phpMyAdmin: Open your web browser and navigate to the phpMyAdmin interface by entering the appropriate URL (usually something like http://localhost/phpmyadmin). Select Database: Choose the database where you want to import Read more…
There are many ways to maintain the revisions using PHP and MySQL. I am going to explain with a small example for how to make revisions of your content using PHP. Take database tables as contents table: 123456789101112131415161718192021222324252627282930– — Table structure for table `contents` — CREATE TABLE `contents` ( Read more…
In this post, we would learn how to display the data in HTML 5 table format from the database MySQL using PHP. Earlier we have learned how to install MySQL and how to use MySQL into our PHP application. Sample MySQL database Before connecting to database we need to create Read more…
In the earlier post, we learned about how to install PHP installation procedure in Windows, Mac and Linux systems with apache server. In this post, I am going to explain how to install Nginx (Engine X),MySql, PHP (LEMP) server on Ubuntu. Nginx server will suitable for high availability and capable Read more…
In this post I would like to share my views on how swapping column values in MySQL table. Recently I have a requirement that one record should be active mode in the given point of time remaining records should be in inactive mode. I have got the solution for it. Read more…
In this post I am going to explain about how to generate Data dictionary in MySql database. In the earlier posts we learned about installation of MySql, import and export databases , MySql table schema, MySql database backup and MySql views. We can have simple query which will in below Read more…
Hello, friends! In a previous post, I explained how to install the SVN client on your Ubuntu system. Now, in this post, I will guide you through the installation of MySQL Workbench on Ubuntu 12.04. MySQL Workbench is an invaluable tool for tasks such as database schema preparation, ER diagram Read more…
Hi, In this post i am goig to explain about How to build virtual keyboard for your web application using google api. I got an request from users how to type hindi words in the web page. By using this code we can easily build the application your own language. ( Google support few languages ).
How to build virtual keyboard for your web application | Anil labs
In this post i would like to build a Simple Steps to Build a Custom CMS application Using PHP and Mysql. We will pulling data ( content ) from mysql and displayed in the nice formated way to display in the front-end section. And Content is manageble by admin section by WYSIWYG editor.
Simple Steps to Build a Custom CMS application Using PHP by Anil Kumar Panigrahi
In this post i would like to explain about how to implementing graphs using fusion charts. And implemented using PHP. In my previous post explained about How to calculate statistics in daily, weekly , monthly and yearly using php. Get the information using that post and implement the graph using this code. Create a xml file with specific feilds and download the fusion charts from the site. By following example i will explain. We can get the values from database and create xml file as mentioned.
This picture denotes : A graph for number of registrations over the year ( by monthly ) divided men and women.
how to implement graphs using fusion charts and php | Anil Labs