Hi friends, in this post i would like to explain about Multi-language support for web application with MySql and PHP. I got many requests from users to multi-language using google translator is fine but the grammar is not properly established. So we can avoid and easily implement using mysql and php.
Tag: mysql
Simple Steps to Build a Custom CMS application Using PHP
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.
How to calculate statistics in daily, weekly , monthly and yearly using php
In this post i am going to explain about how to calculate statistics in daily, weekly , monthly and yearly using php. Recently i have worked in this concept. In the administration section we need to display these type statistics. I will explain graphs in the next post. Get these information from the database and …
XML crud operations using php
Hi friends,In this post i would like to explain about curd operations ( add, edit and delete ) data using xml file. It is simple to maintain and rapid in the operations, it will be useful when simple operations required. Below code explain the how to insert , edit , view and delete operations using …
How to change order of display posts using php
Hi friends, In this post i would like to explain about how to change the order of placements using php code. It is simple code to implement. We can use this code in admin section to change the order and display those content depends on order. Today i want to share with you all. Database …
How to create rss feeds using php and mysql
In this post i want to explain how to create rss feeds using php code and get the data from mysql table. It is very simple to develop and use. Step 1 : Connect to database We already discussed about how to connect database using php code.See the following code to connect database: …
How to import and export big database files
Hello friends, today i want to share some basic concepts but we need to know about import and export databases. If it is small database file, we can directly export or import from the phpmyadmin. Process to export: 1) Go to phpmyadmin -> click on database -> there we have button called “export”. 2) When …
How to get list of table names from database in mysql?
Hi friends, I got the requirement to display the list of table names from the database using php code. I got the solution for it, once check the below code. 1) Connect to database: mysql_connect(“dbserver”,”dbuser”,”dbpassword”); 2)Get the list of tables from table $result = mysql_list_tables(“dbname”); 3) Count the total number of tables $num_tables = mysql_num_rows($result); …
How to create excel file with mysql data using php code
Hello friends, I have code for how to create a excel file with mysql data using php code. By following 5 steps to create excel file.We can implement it in admin section of websites for user list excel file. PHP Solutions: Dynamic Web Design Made Easy Follow the below steps to retrieve the data from …
How to take backup of Database using PHP code?
I want to share my views with you all on how to take backup of Database(MySql) using simple PHP code. , I recently worked on some project, due to some reasons I lost my database, then i think for is any code for taking backup of database, finally i got this code and now I …