export database table by php

export database table php Sometime there is need to export database table by php code. There is a very simple approach to do this.    

 

Joomla Last Database Query

Joomla Last Database Query     Joomla last database query.As we all know it is a bit difficult to find last executed query in CMS. because there are lots of internal trigger and threads are running. But there is a simple way to find last database query in joomla.     The Query Joomla’s database

Read More

mysql queries

mysql queries 1. Add column age and desg in emp_prof table. Mysql> use profile; Mysql>alter table emp_prof add column age int; Mysql> alter table emp_prof add column desg char(10); 2. Update all records of emp_prof.(desg= actn,officer) Mysql> use profile; Mysql>update emp_prof set age=24,desg=’officer’ where emp_id=101; Mysql>update emp_prof set age=21,desg=’actn’ where emp_id=102; (follow above queries for

Read More