Category: Database

How to calculate statistics in daily, weekly , monthly and yearly using php 7

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

XML crud operations using php 5

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

How to change order of display posts using php 4

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

How to create rss feeds using php and mysql 7

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

How to prevent php website from sql injection 10

How to prevent php website from sql injection

Hi friends, In this post, i would like to explain what is sql injection and how to prevent from this attacks to our website. SQL Injection: SQL injection is another vulnerability of PHP.  SQL...

How to import and export big database files 1

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

How to get list of table names from database in mysql? 2

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 Date functions in php code 0

Mysql Date functions in php code

Hello friends, The following query will add some times to mysql date column. Get the today date : $date = date(‘Y-m-d H:i:s’); Convert it into strtotime and add which one we have to add,...

How to create excel file with mysql data using php code 28

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

How to display the mysql table schema using php code? 2

How to display the mysql table schema using php code?

Hello friends, The following script is for displaying the mysql connecting using php code and  table schema using php code. It will be useful when we want to know the total fields of table....