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: Code 12345678910<?php DEFINE ('DB_USER', 'root'); DEFINE...

 

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 we click on that button, we...

 

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)...

 

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. Follow the below steps to retrieve the data from database:   1) Connect to database: 1234567891011121314151617$dbhost= "Mysql server name";...

 

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 am easily colloect the backup of database each day, when it is run in cron job. The...