SQL - JOIN in SQL Server

A SQL join clause combines records from two or more tables in a relational database. It creates a set that can be saved as a table or used as it is. A JOIN is a means for combining fields from two tables (or more) by using values common to each. Different SQL JOINs INNER JOIN: Returns all rows when there is at least...

Read More

Step to Send email from localhost/WAMP Server

This solution requires sendmail.exe (a Command Line Interface (CLI) executable which accepts email from PHP, connects to an SMTP server and sends email). You will not require to use it by command, don’t bother about it  Download the sendmail.zip and follow these steps: Create a folder named “sendmail” in “C:\wamp\”. Extract these 4...

Read More

Create Mysqldata to xml using php

Normal 0 false false false EN-US X-NONE X-NONE ...

Read More

How To Create excel file with Mysql Data using php Code.

Hi friends, I have code for how to create a excel file with mysql data using php code. Follow the below steps to retrieve the data from database Config.php <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); ?> a.php <?php           include("config.php");          ...

Read More

PHP Login Page with MD5 possword

This post for PHP beginners Login Page Example. I want to explain creating database, posting form values, storing the session value and destroy the session. It's is very useful and simple.  DATABASE CREATE TABLE admin ( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(40) UNIQUE, password VARCHAR(40) );  CODE config.php <?php $host="localhost";...

Read More