How to convert SQL to Excel in Php?

Arpi    PHP    

Many a times while developing a project we want to send the query data to the user or we want to have the query data for any other reason like analysis or report etc.

So to convert the SQL query data into the excel sheet form is many a times useful for developers.

You can do it using following code,

<?      $sql = "select * from wp_db";
	$result = mysql_query($sql);
	$arr_data = array();

	while($data = mysql_fetch_assoc($result)){
                   $arr_data[] = $data;

		}

read more

How to configure mail from localhost ( wamp ) using PHP?

Arpi    PHP, sample programs, Tips, Tutorials     php, php mail

I have searched a lot when I was required to configure mail using my localhost for my project. At many sites I have read that it’s just not possible to send mail using localhost. You have to upload your project on the net.

But after searching a lot I get to know that it’s possible to send mail using localhost without uploading the project.  And today I post this blog so that the PHP programmer can get to know that it’s not that we just cannot send mail from localhost .We can do.

Steps to send mail from localhost:

read more