Codefessional! Coding Updates!: November 2016

Tuesday, November 29, 2016

E-Commerce Website Using PHP!

Customer can view the collection and browse through different category of pearl jewelry, can view new arrival, can short the jewelry by price and color, can search the product by name, can place an order and track it from a wide range of designs available online.

///////////////////////////////////////////////////////////////////////////////////////////////////
//// index.php
///////////////////////////////////////////////////////////////////////////////////////////////////

<style>
#header:hover{
background-color:#00CCFF;
font-weight:bold}

#pimg:hover{background-color:#FF66CC}
</style>

<?php
session_start();
include("db.php");
$obj=new DB;
//-----------header--------------------------------
$sql="select * from category";
$cats=$obj->GetSqlTable($sql);
$numcat=count($cats);
//------------old-------------------------------
unset($_SESSION['numofprotodisp']);
//--New----------------------------------------

if(isset($_REQUEST['id'])){
$id=$_REQUEST['id'];}
else
$id=1;
$sql="select * from product where cat_id=".$id." limit 0,6";
$prods=$obj->GetSqlTable($sql);
$numpro=count($prods);

$sql="select * from product where cat_id=".$id;
$fullpro=$obj->GetSqlTable($sql);
$num=count($fullpro);
$_SESSION['numpro']=$num;
$round=ceil($num/3);
//----------end new-------------------------
?>

<table>

<tr>
<table bgcolor="#FF3366" width="100%" border="1" cellpadding="1" cellspacing="1">
<h2 align="center"><font color="#660033">THE ECCOMERCE SITE</font></h2>
<tr>
<?php for($i=0;$i<$numcat;$i++){?>
<td align="center" id="header" height="40" align="center"><a href="index.php?id=<?php echo $cats[$i]['cat_id']?>"><?php echo ucfirst($cats[$i]['cat_name'])?></a></td>
<?php }?>
</tr>
</table>
<?php $total=0;
if(isset($_SESSION['cart'])){
foreach($_SESSION['cart'] as $key=>$val)
{ $total=$total+$val;}
}
// onClick="window.location='mycart.php'"
?>
<img src="icons/mycart.png" align="right" width="70" height="70" onClick="window.location='mycart.php'"/><br/><br/><br/><br/>
<div id="mycart" align="right" onClick="window.location='mycart.php'">My Cart(<?php echo $total;?>)</div>
</tr>

<h3 align="center"><strong>Muna Practice of Pagination</strong></h3>
<div align="center">

Category:<select onchange="byCat(this.value)">
<option value="" "selected='selected'">Categories</option>
<?php foreach($cats as $cat){?>
<option value=" <?php echo $cat['cat_id']?>"> <?php echo $cat['cat_name']?></option>
<?php }?>
</select>
Sort:<select onchange="sortby(this.value)">
<option value="" "selected='selected'">Sort By</option>
<option value="DESC">High to Low</option>
<option value="ASC">Low to High</option>
</select>
Classification:<select onchange="selClassif(this.value)">
<option value="" "selected='selected'">Select Classif</option>
<option value="PARTY">PARTY</option>
<option value="FESTIVE">FESTIVE</option>
<option value="YOUTH COLLECTION">YOUTH COLLECTION</option>
<option value="CASUAL">CASUAL</option>
<option value="WEDDING COLLECTION">WEDDING COLLECTION</option>
<option value="FOR MOMS">FOR MOMS</option>
<option value="CORPORATE COLLECTION">CORPORATE COLLECTION</option>
</select>
Price:<select onchange="selPrice(this.value)">
<option value="" "selected='selected'">Select Price</option>
<option value="0-1000">Below 1000</option>
<option value="1000-1200">1000-1200</option>
<option value="1201-1400">1201-1400</option>
<option value="1401-1600">1401-1600</option>
<option value="1601-1800">1601-1800</option>
<option value="1800-3000">Above 1800</option>
</select><br/>
Showing<select id="numofitem" onchange="loadPagi(this.value)">
<?php for($i=3;$i<=$num+3;$i+=3){?>
<option value="<?php echo $i;?>"><?php echo $i;?></option>
<?php }?>
</select>Entries Per Page:
</div>


<div id="dynpart">
<table border="1" cellpadding="1" cellspacing="1" align="center">
<?php
for($i=0;$i<$numpro;$i++){
$coltd="";
if($i%3==0){
$r=3;
echo'<tr>';
}
//$prods[$i]['prod_id']
$coltd.="<td id='pimg'><img src='snaps/".$prods[$i]['image']."' width='200' height='200' onclick=\"window.location='enlarge.php?id=".$prods[$i]['prod_id']."'\"><br/>";
$coltd.=$prods[$i]['name']."<br/>";
$coltd.="$".$prods[$i]['price'];
//dynamic portion
$flag=0;
if(isset($_SESSION['cart'])){
foreach($_SESSION['cart'] as $key=>$val){
if($key==$prods[$i]['prod_id']){ //many key but one i like 1001
$flag=1;
}
}
}
if($flag==1){
$coltd.="<img id='cartimg_".$prods[$i]['prod_id']."' src='icons/removecart.jpg' width='70' height='20' align='right' onclick='cartfun(".$prods[$i]['prod_id'].")'>";
}
else{
$coltd.="<img id='cartimg_".$prods[$i]['prod_id']."' src='icons/addtocart.jpg' width='70' height='20' align='right' onclick='cartfun(".$prods[$i]['prod_id'].")'>";
}

//dynamic portion end
$coltd.="</td>";
echo $coltd;
$r--;
if($r==0){
echo'</tr>';
}

}
?>
</table>



<div id="pagi" align="center">


<?php
for($i=1;$i<=3;$i++){
?>

<button style="background-color:#33FFCC" onclick="anyPage(<?php echo $i;?>)"><?php if($i==1){?><font color="#CC0000"; size="+2"><?php echo $i;?></font> <?php } else {echo $i;}?></button>
<?php }?>

<a href="javascript:void(0)" onclick="anyPage(<?php echo 1+1;?>)"><img src="icons/Next.png" height="30" width="30" /></a>
<a href="javascript:void(0)" onclick="anyPage(<?php echo $round;?>)"><img src="icons/Last.png" height="30" width="30" /></a><br/>
Showing 0 -10 of <?php echo $_SESSION['numpro'];?> Products
</div>

</div>

<script src="http://code.jquery.com/jquery-1.10.1.min.js"></script>
<script>
//global var decl
function loadPagi(numofprotodisp){
// alert(numofprotodisp);
var numofprotodisp=$("#numofitem").val();
$.ajax({
type:"POST",
url:"update.php",
data:{"page":1,"numofprotodisp":numofprotodisp},
success:function(data){
$("#dynpart").html(data)
}

});
}

function anyPage(p){
$.ajax({
type:"POST",
url:"update.php",
data:{"page":p},
success:function(data){
$("#dynpart").html(data)
}

});
}

function cartfun(id){

if($("#cartimg_"+id).attr("src")=="icons/addtocart.jpg"){
$("#cartimg_"+id).attr("src","icons/removecart.jpg");
var action="add";
}
else{
$("#cartimg_"+id).attr("src","icons/addtocart.jpg");
var action="remove";

}
$.ajax({
url:"updatecart.php",
type:"POST",
data:{"action":action,"id":id},
success:function(data){
$("#mycart").html("My cart("+data+")");
}
});
}

function selPrice(price){
alert(price);
$.ajax({
type:"POST",
url:"update.php",
data:{"price":price},
success:function(data){
$("#dynpart").html(data)
}

});
}

function selClassif(clasif){
alert(clasif);
$.ajax({
type:"POST",
url:"update.php",
data:{"clasif":clasif},
success:function(data){
$("#dynpart").html(data)
}

});
}
function sortby(sortval){
alert(sortval);
$.ajax({
type:"POST",
url:"update.php",
data:{"sortval":sortval},
success:function(data){
$("#dynpart").html(data)
}

});
}

function byCat(catid){
alert(catid);
$.ajax({
type:"POST",
url:"update.php",
data:{"catid":catid},
success:function(data){
$("#dynpart").html(data)
}

});
}

</script>

///////////////////////////////////////////////////////////////////////////////////////////////////
//// End index.php
///////////////////////////////////////////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////////////////////////////////////////
//// db.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<?php
///////////////////////////////////////////////////////////////////////////////////////////////////
//// Muna ECOMMERCE DATABASE FUNCTION Library
///////////////////////////////////////////////////////////////////////////////////////////////////
//// Database Functions
///////////////////////////////////////////////////////////////////////////////////////////////////
////
//// Usage:
//// $db = new DB(); //instantiate using default read-only connection
//// $db = new DB($user,$pass); //instantiate using a specific login/pass
////
///////////////////////////////////////////////////////////////////////////////////////////////////

$showsql = true;
//$db = new DB();

class DB {
private $dbhost = "localhost";
private $dbuser = "root";
private $dbpass = "";
private $dbname = "yourdbname";

public $error = "";

function __construct()
{
}

//print json_encode($rows, JSON_NUMERIC_CHECK);
//---------------
public function ReportError ($sql, $message) {
//echo "SQL ERROR:\nMessage: $message\nSQL: $sql\n";
$this->error = $message;
}

//highchart
public function GetChart ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
$rows = Array();
while ($res = mysql_fetch_object($result))
//will ignore anything that comes after
{
$row[0]=$res->year;
$row[1]=$res->amount;
//$row[1]=$channel->Date;
array_push($rows,$row);
//array_push(array,value1,value2...)

}
mysql_close($con);
//print_r($rows);
print_r(json_encode($rows, JSON_NUMERIC_CHECK));
}
//delete by muna

public function deleteRow($sql) {
$con = mysql_connect($this->dbhost,$this->dbuser,$this->dbpass);
if (!$con) {
die("Could not connect to database!");
}
mysql_select_db($this->dbname, $con);
//mysql_select_db("esigns_prod", $con);
$result = mysql_query($sql, $con);
mysql_close($con);
return $result;
}
//by muna
public function GetSqlTable ($sql)
{
$data = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
while ($row = mysql_fetch_assoc($result))
//will ignore anything that comes after
{
$data[] = $row;
}
mysql_close($con);
return $data;
}

public function InsertSql ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result) {$output= 1;}
else $output= 0;

mysql_close($con);
return $output;
}

//returns a 1d list of results (using the first column returned)
public function GetList2 ($sql) {
$con = mysql_connect($this->dbhost,$this->dbuser,$this->dbpass);
if (!$con) {
die("Could not connect to database!");
}
//mysql_select_db("esigns_prod", $con);
$result = mysql_query($sql, $con);
while ($row = mysql_fetch_array($result)) {
$results[] = $row[0];
}
mysql_close($con);
return $results;
}

public function GetRow2 ($sql) {
$con = mysql_connect($this->dbhost,$this->dbuser,$this->dbpass);
if (!$con) {
die("Could not connect to database!");
}
$con = $this->GetDB();
$result = mysql_query($sql, $con);
return mysql_fetch_assoc($result);
}

public function GetDB ()
{
$con = mysql_connect($this->dbhost,$this->dbuser,$this->dbpass);
if (!$con)
{
die("Could not connect to database!");
}
mysql_select_db($this->dbname, $con);
return $con;
}

public function Clean($sql)
{
return mysql_real_escape_string($sql, $this->GetDB());
}

public function Query ($sql)
{
$output=0;
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if (!isset($result))
{
return 0;
}
if (!$result) {return 0;}
if ($row = mysql_fetch_row($result))
{
$output = $row[0];
}
mysql_close($con);
return $output;
}

//returns the first two columns in an sql query as a keyed array
public function GetArray ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
while ($row = mysql_fetch_row($result))
{
//verify there are two rows of data, otherwise return an indexed list of the first
$output[$row[0]] = $row[1];
}
mysql_close($con);
return $output;
}
//returns the first column of each row returned
public function GetList ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
while ($row = mysql_fetch_row($result))
{
array_push($output, $row[0]);
}
mysql_close($con);
return $output;
}

public function GetResult ($sql)
{
$con = $this->GetDB();
if (!$con) {return 0;}
$result = mysql_query($sql, $con);
//mysql_close($con);
return $result;
}

public function GetJSON ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
while ($row = mysql_fetch_row($result))
//will ignore anything that comes after
{
$data = Array();
for ($i=0; $i<mysql_num_fields($result); $i++) {
$data[mysql_fetch_field($result, $i)->name] = $row[$i];
}
array_push($output, $data);
}
mysql_close($con);
return json_encode($output);
}

public function GetTable ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
while ($row = mysql_fetch_row($result))
//will ignore anything that comes after
{
$data = Array();
for ($i=0; $i<mysql_num_fields($result); $i++) {
$data[mysql_fetch_field($result, $i)->name] = $row[$i];
}
array_push($output, $data);
}
mysql_close($con);
return $output;
}

public function GetRow ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
if ($row = mysql_fetch_row($result))
//will ignore anything that comes after
{
$output = $row;
}
mysql_close($con);
return $output;
}

public function GetRowObject ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
if ($row = mysql_fetch_assoc($result))
//will ignore anything that comes after
{
$output = $row;
}
mysql_close($con);
return $output;
}

public function GetRows ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
while ($row = mysql_fetch_row($result))
//will ignore anything that comes after
{
array_push($output, $row);
}
mysql_close($con);
return $output;
}

public function Command ($sql)
{
global $showsql;
$this->error = "";
//if ($showsql) {echo "SQL: $sql\n";}
$con = $this->GetDB();
if (!$con) {return 0;}
$result = mysql_query($sql, $con);
$rows = mysql_affected_rows($con);
if ($rows < 1)
{
$this->error = mysql_error($con);
//$this->ReportError($sql, mysql_error($con));
//echo "DB ERROR: " . mysql_error($con) . "\n";
}
mysql_close($con);
return $rows;
}

}
?>

///////////////////////////////////////////////////////////////////////////////////////////////////
//// End db.php
///////////////////////////////////////////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////////////////////////////////////////
//// updatecart.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<?php
session_start();
if(isset($_REQUEST['qty'])){
$qty=$_REQUEST['qty'];
}
$id=$_REQUEST['id'];
$action=$_REQUEST['action'];

switch($action){
case "add":
$total=0;
$_SESSION['cart'][$id]=1;
foreach($_SESSION['cart']as $key=>$val){
$total=$total+$val;
}
echo"$total";
break;

case "update":
$total=0;
$_SESSION['cart'][$id]=$qty;
foreach($_SESSION['cart']as $key=>$val){
$total=$total+$val;
}
echo"$total";
break;

case "remove":
$total=0;
unset($_SESSION['cart'][$id]);
foreach($_SESSION['cart']as $key=>$val){
$total=$total+$val;
}
echo"$total";
break;

}
?>
///////////////////////////////////////////////////////////////////////////////////////////////////
//// End updatecart.php
///////////////////////////////////////////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////////////////////////////////////////
//// update.php
///////////////////////////////////////////////////////////////////////////////////////////////////

<?php

include("db.php");
$obj=new DB;
session_start();

if(isset($_REQUEST['numofprotodisp'])){
$numofprotodisp=$_REQUEST['numofprotodisp'];
$_SESSION['numofprotodisp']=$numofprotodisp;
}
else
{ if(isset($_SESSION['numofprotodisp']))
{$numofprotodisp=$_SESSION['numofprotodisp'];}
else
{$numofprotodisp=6;}
}

if(isset($_REQUEST['page'])){
$page=$_REQUEST['page'];
$pageLimit=($_REQUEST['page']-1)*$numofprotodisp;
}
else
{$page=1;
$pageLimit=1;
}
$numofprotodisp;

//--New----------------------------------------
//echo $numofprotodisp;//9echo $pageLimit;//0
//WHERE column_name BETWEEN value1 AND value2;
//WHERE price BETWEEN ".$p[0]." AND ".$p[1].";

if(isset($_REQUEST['id'])){

$id=$_REQUEST['id'];

}
else
{ if(isset($_REQUEST['catid'])){
$id=$_REQUEST['catid'];
}
else
{$id=1;}
}
$sql="select * from product where cat_id=".$id ;
/***************Price Sort********************************/
if(isset($_REQUEST['price'])){
$price=$_REQUEST['price'];
$p=explode("-",$price);
//echo $p[0];echo $p[1];
$sql.=" and price BETWEEN ".$p[0]." AND ".$p[1];

}

/***************Classif ********************************/
if(isset($_REQUEST['clasif'])){
$clasif=$_REQUEST['clasif'];

$sql.=" and classification ='".$clasif."'";

}
/***************Classif End********************************/
/**************ASC/DESC**************/
if(isset($_REQUEST['sortval'])){
$sortval=$_REQUEST['sortval'];
$sql.=" ORDER BY price ".$sortval;
}
echo $sql.=" limit ".$pageLimit.",".$numofprotodisp;
/***************Price Sort End********************************/

$prods=$obj->GetSqlTable($sql);
$numpro=count($prods);
//----------end new-------------------------

//********************************footer********************************
$sql="select * from product where cat_id=".$id;
$fullpro=$obj->GetSqlTable($sql);
$num=count($fullpro);
$round=ceil($num/$numofprotodisp);
//********************************footer End********************************
?>


<h3 align="center"><strong>Next Page</strong></h3>
<div id="dynpart">
<table border="1" cellpadding="1" cellspacing="1" align="center">
<?php
for($i=0;$i<$numpro;$i++){
$coltd="";
if($i%3==0){
$r=3;
echo'<tr>';
}
//$prods[$i]['prod_id']
$coltd.="<td id='pimg'><img src='snaps/".$prods[$i]['image']."' width='200' height='200' onclick=\"window.location='enlarge.php?id=".$prods[$i]['prod_id']."'\"><br/>";
$coltd.=$prods[$i]['name']."<br/>";
$coltd.="$".$prods[$i]['price'];
//dynamic portion
$flag=0;
if(isset($_SESSION['cart'])){
foreach($_SESSION['cart'] as $key=>$val){
if($key==$prods[$i]['prod_id']){ //many key but one i like 1001
$flag=1;
}
}
}
if($flag==1){
$coltd.="<img id='cartimg_".$prods[$i]['prod_id']."' src='icons/removecart.jpg' width='70' height='20' align='right' onclick='cartfun(".$prods[$i]['prod_id'].")'>";
}
else{
$coltd.="<img id='cartimg_".$prods[$i]['prod_id']."' src='icons/addtocart.jpg' width='70' height='20' align='right' onclick='cartfun(".$prods[$i]['prod_id'].")'>";
}

//dynamic portion end
$coltd.="</td>";
echo $coltd;
$r--;
if($r==0){
echo'</tr>';
}

}
?>
</table>


<div id="pagi" align="center">

<?php

if($page>1){?>
<a href="javascript:void(0)" onclick="anyPage(1)"><img src="icons/first.jpg" height="30" width="30" /></a>
<a href="javascript:void(0)" onclick="anyPage(<?php echo $page-1;?>)"><img src="icons/prev.png" height="30" width="30" /></a>
<?php }//if end
for($i=$page-2;$i<=$page+2;$i++){
if($i>=1&& $i<=$round){
?>

<button style="background-color:#33FFCC" onclick="anyPage(<?php echo $i;?>)"><?php if($i==$page){?><font color="#CC0000"; size="+2"><?php echo $i;?></font> <?php } else {echo $i;}?></button>
<?php }

}

$j=$i-2;
if($j<=$round){
//echo $round;
//echo $j;
//echo $round;//19

?>

<a href="javascript:void(0)" onclick="anyPage(<?php echo $page+1;?>)"><img src="icons/Next.png" height="30" width="30" /></a>
<a href="javascript:void(0)" onclick="anyPage(<?php echo $round;?>)"><img src="icons/Last.png" height="30" width="30" /></a>
<?php }?><br/>
Showing <?php echo $pageLimit;?> -<?php echo $pageLimit+$numofprotodisp;?> of <?php echo $_SESSION['numpro'];?> Products
</div>


///////////////////////////////////////////////////////////////////////////////////////////////////
//// End update.php
///////////////////////////////////////////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////////////////////////////////////////

//// mycart.php

///////////////////////////////////////////////////////////////////////////////////////////////////

<?php

session_start();

include("db.php");

$obj=new DB;

//echo'<pre>'; print_r($_SESSION['cart']);

//foreach($_SESSION['cart'] as $key=>val){}

<table>

<tr>

<h3 align="center"><strong>Displaying the details of item in your cart!</strong></h3>

<tr>

<td align="center" bgcolor="#339933" height="40"><strong>Product</strong></td>

<td align="center" bgcolor="#339933" height="40"><strong>Quantity</strong></td>

<td align="center" bgcolor="#339933" height="40"><strong>Price</strong></td>

<td align="center" bgcolor="#339933" height="40"><strong>Total</strong></td>

<td align="center" bgcolor="#339933" height="40"><strong>Remove</strong></td>

</tr>

<?php

$cntr=1;

$totalBuy=0;

$totalQty=0;

foreach($_SESSION['cart'] as $key=>$val){

$totalQty=$totalQty+$val;

$id=$key;

$sql="select * from product where prod_id=".$id;

$prod=$obj->GetSqlTable($sql);

//echo'<pre>'; print_r($prod);

<tr>

</td>

<td align="center" bgcolor="#99FFFF"><img src="snaps/<?php echo $prod[0]['image'];?>" align="center" width="30" height="30" >

</td>

<select onchange="update(<?php echo $prod[0]['prod_id'];?>,this.value)">

<?php

for($i=1;$i<$prod[0]['quantity']; $i++){

<option <?php if($i==$val) echo 'selected="selected"'?>value="<?php echo $i;?>"><?php echo $i;?></option>

<?php }?>

</select>

</td>

</td>

<?php $totalBuy=$totalBuy +$val * $prod[0]['price'];?>

</td>

</td>

</tr>

<?php

$cntr++;

}

<tr>

<td colspan="2" align="center" bgcolor="#336633"><strong>Total</strong>

</td>

</td>

</td>

</tr>

<tr>

</td>

</tr>

</table>

</tr>

</table>

function update(id,val){

$.ajax({

url:"midcart.php",

type:"POST",

data:{"action":"update","id":id,"qty":val},

success:function(){

window.location.reload();

}

});

}

</script>

///////////////////////////////////////////////////////////////////////////////////////////////////

//// End mycart.php

///////////////////////////////////////////////////////////////////////////////////////////////////

Friday, November 25, 2016

Internal Messaging System Using PHP & Javascript

///////////////////////////////////////////////////////////////////////////////////////////////////
//// index.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<h2 align="center" style="color:#CC33FF"> Login Verification IMS</h2>
<form id="myform" action="#" method="post" onSubmit="return checkvalidate()">
<table align="center" style="color:#FF99FF">
<tr>
<td><strong>Email</strong></td>
<td><input type="text" id="useremail" name="useremail" maxlength="17" /></td>
<td><span style="color:#FF0000" id="usernameerr"></span></td>
</tr>

<tr>
<td><strong>Password</strong></td>
<td><input type="password" id="userpassword" name="userpassword" maxlength="8" /></td>
<td><span style="color:#FF0000" id="userpassworderr"></span></td>
</tr>

<tr>

<td><input type="hidden" name="action" value="trans" /></td>
<td colspan="2"><img src="img/sub.png" height="25" width="80" id="sub" name="sub" onclick="javascript:doSubmit()"/></td>

</tr>
</table>
</form>

<?php
include("db.php");
$obj=new DB;
session_start();
if(isset($_REQUEST['logout'])){
unset($_SESSION['username']);
unset($_SESSION['userid']);
header("Location:index.php");

}

if(isset($_REQUEST['action'])){
$useremail=$_REQUEST['useremail'];
$userpassword=$_REQUEST['userpassword'];
$sql="select * from userlogin where useremail='$useremail' and password='$userpassword'";
$results=$obj->getTable($sql);
echo'<pre>';
$emailid=$results[0]['useremail'];
$name=strstr($emailid,"@",true);
ucfirst($name);
$_SESSION['username']=$name;
$_SESSION['userid']=$results[0]['id'];
header("Location:dashboard.php");

}
?>

<script>
function doSubmit(){
alert("hi");
var form=document.forms[0];
if(form.onsubmit){
var flag=form.onsubmit.call(form);
if(flag==true){
form.submit();
}
}
}

function checkvalidate(){
var userpass=document.getElementById("userpassword").value;
var useremail=document.getElementById("useremail").value;

var passerr=document.getElementById("userpassworderr");
var emailerr=document.getElementById("usernameerr");

var validation =true;
var emailvalida=false;

//email validation
for(var i=0; i<useremail.length; i++){
if(useremail.charAt(i)=="@"){
emailvalida=true;
}

}

if(emailvalida==false || useremail==""||useremail.length<8){ //if anyone is true
emailerr.innerHTML="<font color=red size=2>Enter Proper Email</font>";
validation =false
}

//name validation
if(userpass==""||userpass.length<4){ //if anyone is true
passerr.innerHTML="<font color=red size=2>Enter Proper Name</font>";
validation =false;
}

alert(validation);

return validation;
//return false;
}
</script>
///////////////////////////////////////////////////////////////////////////////////////////////////
//// End index.php
///////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////
//// inbox.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<?php
$leftTop="Muna Inbox";
include("afterloginheader.php");

include("db.php");
$obj=new DB;
//$sql="select * from userlogin where useremail='$useremail' and password='$userpassword'";
//$results=$obj->getTable($sql);
?>

<form action="#" method="post">
<table border="1" width="65%" align="center" style="background-color:#FFCCCC">
<tr>
<th><strong><input type="checkbox" id="selectAll" onclick="chkall()"/></strong></th>
<th><strong>Froom</strong></th>
<th><strong>Subject</strong></th>
<th><strong>Date</strong></th>
<th><strong>Action</strong></th>
</tr>

<?php $sql="select * from email_tbl where `To`=".$_SESSION['userid']."";
$results=$obj->GetTable($sql);
foreach($results as $result){

?>
<tr>
<td>
<input type="checkbox" id="checkbox[]" name="checkbox[]" value="<?php echo $result['id'];?>" />
</td>
<td>
<?php echo $result['From'];?>
</td>

<td>
<?php echo $result['Subject'];?>
</td>

<td>
<?php echo $result['Date'];?>
</td>
<td>
<img src="img/del1.jpg" height="25" width="80" align="left" onclick=del(<?php echo $result['id'];?>)/>
</td>
</tr>

<?php
}
?>

<tr>
<td><input type="submit" value="Delete Sel" id="sub" name="sub" /></td>
</tr>
</table>
</form>

<div align="center" style="display:block">
<form action="#" method="post">
<table>
<tr>
<td>
User List
</td>
<td>
<select id="userlist">
<?php $sql="select * from userlogin";
$results=$obj->GetTable($sql);
foreach($results as $result){?>

<option value="<?php echo $result['useremail'] ?>"><?php echo $result['useremail'] ?></option>
<?php }?>
</select>
</td>
</tr>
<tr>
<td>Subject</td><td><input type="text" id="subj" name="subj" placeholder="Enter Subject here"/></td>
</tr>
<tr>
<td>Message</td><td><textarea id="msg" name="msg" rows="4" cols="50" placeholder="Enter Content here"></textarea> </td>
</tr>

<tr>
<td><input type="hidden" value="trans" name="action" /></td>
<td><img src="img/send2.jpg" width="80" height="25" align="left" onclick="submitform()"/>
<img src="img/save.jpg" width="80" height="25" align="left" onclick="saveEmail()"/></td>
</tr>

</table>
</form>
</div>
<script src="//code.jquery.com/jquery-1.11.3.min.js"></script>
<script>
//setInterval("saveEmail()",30000);
function saveEmail(){
var id=document.getElementById("userlist").value;
var subject=document.getElementById("subj").value;
var msg=document.getElementById("msg").value;
$.ajax({
type:"POST",
url:"savemsg.php",
data:{"id":id,"subject":subject,"msg":msg},
success:function(data){
alert(data);
$("#display").html(data);
}

});
}

function submitform() {
var form = document.forms[0];

if (form.onsubmit) {
var result = form.onsubmit.call(form);
}

if (result !== false) {
form.submit();
}
}
</script>

<?php
if(isset($_REQUEST['action'])){
echo "comming here";
}
?>

</tr>
</table>
///////////////////////////////////////////////////////////////////////////////////////////////////
//// End inbox.php
///////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////
//// savemsg.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<?php
//{"id":id,"subject":subject,"msg":msg},
session_start();
/*$id=$_REQUEST['id'];
$msg=$_REQUEST['msg'];
$subject=$_REQUEST['subject'];*/
$id=$_REQUEST['id']=2;
$msg=$_REQUEST['msg']="doooo how are you today plz call any time you are free want to talk imo to you";
$subject="call me";
$_SESSION['userid']=1;

include("db.php");
$obj=new DB;
//$sql="select * from category";
//$cats=$obj->getTable($sql);
echo $inssql="insert into email_tbl set `To`='".$id."',`From`=".$_SESSION['userid'].", Subject='".$subject."' ,Content='".$msg."',Date=Now(),published='0'";
echo $results=$obj->insertdelSql($inssql);
///////////////////////////////////////////////////////////////////////////////////////////////////
//// End savemsg.php
///////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////
//// sent.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<?php
$leftTop="Muna Sent List";
include("afterloginheader.php");

include("db.php");
$obj=new DB;
//$sql="select * from userlogin where useremail='$useremail' and password='$userpassword'";
//$results=$obj->getTable($sql);
?>

<form action="#" method="post">
<table border="1" width="65%" align="center" style="background-color:#FFCCCC">
<tr>
<th><strong><input type="checkbox" id="selectAll" onclick="chkall()"/></strong></th>
<th><strong>To</strong></th>
<th><strong>Subject</strong></th>
<th><strong>Date</strong></th>
<th><strong>Action</strong></th>
</tr>

<?php $sql="select * from email_tbl where `From`=".$_SESSION['userid']."";
$results=$obj->GetTable($sql);
foreach($results as $result){

?>
<tr>
<td>
<input type="checkbox" id="checkbox[]" name="checkbox[]" value="<?php echo $result['id'];?>" />
</td>
<td>
<?php echo $result['To'];?>
</td>

<td>
<?php echo $result['Subject'];?>
</td>

<td>
<?php echo $result['Date'];?>
</td>
<td>
<img src="img/del1.jpg" height="25" width="80" align="left" onclick=del(<?php echo $result['id'];?>)/>
</td>
</tr>

<?php
}
?>

</tr>
</table>
///////////////////////////////////////////////////////////////////////////////////////////////////
//// End sent.php
///////////////////////////////////////////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////////////////////////////////////////
//// draft.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<?php
$leftTop="Muna Draft List";
include("afterloginheader.php");

include("db.php");
$obj=new DB;
//$sql="select * from userlogin where useremail='$useremail' and password='$userpassword'";
//$results=$obj->getTable($sql);
?>

<form action="#" method="post">
<table border="1" width="65%" align="center" style="background-color:#FFCCCC">
<tr>
<th><strong><input type="checkbox" id="selectAll" onclick="chkall()"/></strong></th>
<th><strong>To</strong></th>
<th><strong>Subject</strong></th>
<th><strong>Date</strong></th>
<th><strong>Action</strong></th>
</tr>

<?php $sql="select * from email_tbl where `From`=".$_SESSION['userid']." and published='0'";
$results=$obj->GetTable($sql);
foreach($results as $result){

?>
<tr>
<td>
<input type="checkbox" id="checkbox[]" name="checkbox[]" value="<?php echo $result['id'];?>" />
</td>
<td>
<?php echo $result['To'];?>
</td>

<td>
<?php echo $result['Subject'];?>
</td>

<td>
<?php echo $result['Date'];?>
</td>
<td>
<img src="img/del1.jpg" height="25" width="80" align="left" onclick=del(<?php echo $result['id'];?>)/>
</td>
</tr>

<?php
}
?>

</tr>
</table>
///////////////////////////////////////////////////////////////////////////////////////////////////
//// End draft.php
///////////////////////////////////////////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////////////////////////////////////////
//// trash.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<?php
$leftTop="Muna Sent List";
include("afterloginheader.php");

include("db.php");
$obj=new DB;
//$sql="select * from userlogin where useremail='$useremail' and password='$userpassword'";
//$results=$obj->getTable($sql);
?>

<form action="#" method="post">
<table border="1" width="65%" align="center" style="background-color:#FFCCCC">
<tr>
<th><strong><input type="checkbox" id="selectAll" onclick="chkall()"/></strong></th>
<th><strong>From</strong></th>
<th><strong>Subject</strong></th>
<th><strong>Date</strong></th>
<th><strong>Action</strong></th>
</tr>

<?php $sql="select * from email_tbl where `To`=".$_SESSION['userid']." and status='delete'";
$results=$obj->GetTable($sql);
foreach($results as $result){

?>
<tr>
<td>
<input type="checkbox" id="checkbox[]" name="checkbox[]" value="<?php echo $result['id'];?>" />
</td>
<td>
<?php echo $result['From'];?>
</td>

<td>
<?php echo $result['Subject'];?>
</td>

<td>
<?php echo $result['Date'];?>
</td>
<td>
<img src="img/del1.jpg" height="25" width="80" align="left" onclick=del(<?php echo $result['id'];?>)/>
</td>
</tr>

<?php
}
?>

</tr>
</table>
///////////////////////////////////////////////////////////////////////////////////////////////////
//// End trash.php
///////////////////////////////////////////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////////////////////////////////////////
//// db.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<?php
class DB{
private $dbhost="localhost";
private $dbuser="root";
private $dbpass="";
private $dbname="email";

//The mysql_query function in php returns TRUE on success and FALSE on failure.

public function insertdelSql($sql){
$result=mysql_query($sql,$this->getCon());
return $result;
}

public function hc($sql,$ch){
$result=mysql_query($sql,$this->getCon());
while($res=mysql_fetch_assoc($result)){
if($res['name']==$ch){
$resarr[]=array('name'=>$res['name'],'y'=>$res['amount'],'sliced'=>"true",'selected'=>"true");
}

else{
$resarr[]=array('name'=>$res['name'],'y'=>$res['amount']);
}
}
//$res=json_encode($resarr, JSON_NUMERIC_CHECK);
return $resarr;
}

public function getTable($sql){
$result=mysql_query($sql,$this->getCon());
while($row=mysql_fetch_array($result)){
$resarr[]=$row;
}
return $resarr;
}

public function getCon(){
$con=mysql_connect($this->dbhost,$this->dbuser,$this->dbpass);
mysql_select_db($this->dbname,$con)or
die(mysql_error("can't connect db"));
return $con;
}

}//class end