Sunday, October 25, 2015

Function class

<?php
    $host="localhost";
$username="danduwaw_meetfri";


   
$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());    



//========================================
function  markAsUserLogged($email){


$result =mysql_query("UPDATE customer SET logstatus='1' WHERE email='com'")or die(mysql_error());
$json = array();

}

                                   


//==============================================================
       
        $attencence="0";
    
    
function markSubject1Absence($year,$month,$today,$grade,$subject_id1){
$sql = "SELECT `apn` FROM `student` WHERE `grade` = '".$grade."' ";
$result = mysql_query($sql);
$json = array();
if(mysql_num_rows($result))
{
while($row=mysql_fetch_assoc($result))
{
        // $json['student'][]=$row;
        $json[]=$row;
}
}
//======================================================================
if($subject_id1==1){
for($i = 0, $l = count($json); $i < $l; ++$i) {
  $apn=$json[$i];
  $cleanedAPN=$apn['apn'];
 
  $subject_id="1";      
                                           
$inserted_Attendence = mysql_query("INSERT INTO attendence VALUES(null, '$year', '$month', '$today' ,'$grade', '$cleanedAPN', '$subject_id', '$attencence' )")or die(mysql_error());

}
} else{
}
}
//======================================================================
function markSubject2Absence($year,$month,$today,$grade,$subject_id1){
$sql = "SELECT `apn` FROM `student` WHERE `grade` = '".$grade."' ";
$result = mysql_query($sql);
$json = array();
if(mysql_num_rows($result))
{
while($row=mysql_fetch_assoc($result))
{
        // $json['student'][]=$row;
        $json[]=$row;
}
}
//======================================================================
if($subject_id1==2){
for($i = 0, $l = count($json); $i < $l; ++$i) {
  $apn=$json[$i];
  $cleanedAPN=$apn['apn'];
 
  $subject_id="2";      
                                           
$inserted_Attendence = mysql_query("INSERT INTO attendence VALUES(null, '$year', '$month', '$today' ,'$grade', '$cleanedAPN', '$subject_id', '$attencence' )")or die(mysql_error());

}
} else{
}
}
    //========================================
   
function markSubject3Absence($year,$month,$today,$grade,$subject_id1){
$sql = "SELECT `apn` FROM `student` WHERE `grade` = '".$grade."' ";
$result = mysql_query($sql);
$json = array();
if(mysql_num_rows($result))
{
while($row=mysql_fetch_assoc($result))
{
        // $json['student'][]=$row;
        $json[]=$row;
}
}
//======================================================================
if($subject_id1==3){
for($i = 0, $l = count($json); $i < $l; ++$i) {
  $apn=$json[$i];
  $cleanedAPN=$apn['apn'];
 
  $subject_id="3";      
                                           
$inserted_Attendence = mysql_query("INSERT INTO attendence VALUES(null, '$year', '$month', '$today' ,'$grade', '$cleanedAPN', '$subject_id', '$attencence' )")or die(mysql_error());

}
} else{
}
}
?>
----------------------------------------
DB_Connect.php
<?php
class DB_Connect {
    private $conn;

    // Connecting to database
    public function connect() {
      /**
 * Database config variables
 */
define("DB_HOST", "localhost");
define("DB_USER", "danduwawetfri");
define("DB_PASSWORD", " ");
define("DB_DATABASE", "_meetfriends");

        
        // Connecting to mysql database
        $this->conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
        
        // return database handler
        return $this->conn;
    }
}

?>
-----------------------
<?php
       
$host="localhost";





$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());


//=================================

$sql = "SELECT * FROM `customer` ";
$result = mysql_query($sql);
$json = array();

if(mysql_num_rows($result)){
    while($row=mysql_fetch_assoc($result)){
        $json['customer'][]=$row;
    }
}
mysql_close($con);
echo json_encode($json );
?>

-----------------------------------------

<?php
   
$host="localhost";
$username="";
$password="";
$db_name=" ";


$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());
                      
                            
        $syear= mysql_real_escape_string($_REQUEST['syear']);
        $smonth= mysql_real_escape_string($_REQUEST['smonth']);
    $sdays= mysql_real_escape_string($_REQUEST['sdays']);
   
    $eyear= mysql_real_escape_string($_REQUEST['eyear']);
        $emonth= mysql_real_escape_string($_REQUEST['emonth']);
    $eday= mysql_real_escape_string($_REQUEST['eday']);
   
    $grade= mysql_real_escape_string($_REQUEST['grade']);
    $subject_id= mysql_real_escape_string($_REQUEST['subject_id']);
   
   
   
     $d1= mysql_real_escape_string($_REQUEST['StartDate_madeDate']);
         $d2= mysql_real_escape_string($_REQUEST['EndDate_madeDate']);
  
   // $sql = "SELECT * FROM `payments` WHERE `subject_id` = '".$subject_id."' AND `grade` = '".$grade."' AND
   //      `timestamp` BETWEEN '2013-1-28 00:00:00' and '2015-5-29 00:00:00' ";

  $sql = "SELECT * FROM `payments` WHERE `subject_id` = '".$subject_id."' AND `grade` = '".$grade."' AND
         `timestamp` BETWEEN '".$d1."' and '".$d2."' ";



$result = mysql_query($sql);

$json = array();
if(mysql_num_rows($result))
{
while($row=mysql_fetch_assoc($result))
{
        $json['paid'][]=$row;
}
}else{
 $json="0";  }

echo json_encode($json);
mysql_close($con);

?>
----------------------------

<?php
   

   
$host="localhost";
$username="prathee1_lexisu";
$password=" ";
$db_name="  ";


$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());

                            
        $month= mysql_real_escape_string($_REQUEST['month']);
        $date= mysql_real_escape_string($_REQUEST['today']);
    $year= mysql_real_escape_string($_REQUEST['year']);
    $grade= mysql_real_escape_string($_REQUEST['grade']);
    $subject_id= mysql_real_escape_string($_REQUEST['subject_id']);
   
     


$sql = "SELECT * FROM `payments` WHERE `year` = '".$year."' AND `month` = '".$month."' AND `date` = '".$date."' AND `grade` = '".$grade."' AND `subject_id` = '".$subject_id."'";

$result = mysql_query($sql);

$json = array();
if(mysql_num_rows($result))
{
while($row=mysql_fetch_assoc($result))
{
        $json['paid'][]=$row;
}
}

echo json_encode($json);
mysql_close($con);

?>
Posted by at No comments:
login-------------

<?php

$host="localhost";
$username="sssmeetfri";
$password="ssss";
$db_name="ssss";
include('function.php');

$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());

if (isset($_POST['email']) && isset($_POST['password'])) {

    // receiving the post params
    $email = $_POST['email'];
    $password = $_POST['password'];


    $sql = "SELECT * FROM `customer` WHERE `email`='".$email."' AND `password`='".$password."'";
    $result = mysql_query($sql);
   
    if(mysql_num_rows($result)){
    while($row=mysql_fetch_assoc($result)){
       // $json["error"] = TRUE;
       // $json["error_msg"] = "User already existed with " . $email;

        $json['user'][]=$row;
                   markAsUserLogged($email);
            }
        }
   else{
              $json=0;
  }
   
}
mysql_close($con);
echo json_encode($json);
?>

---------------------------------------------------------
<!DOCTYPE html>
<!--[if lt IE 7]> <html class="lt-ie9 lt-ie8 lt-ie7" lang="en"> <![endif]-->
<!--[if IE 7]> <html class="lt-ie9 lt-ie8" lang="en"> <![endif]-->
<!--[if IE 8]> <html class="lt-ie9" lang="en"> <![endif]-->
<!--[if gt IE 8]><!--> <html lang="en"> <!--<![endif]-->
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  <title>Login Form</title>
  <link rel="stylesheet" href="css/style.css">
  <!--[if lt IE 9]><script src="//html5shim.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
</head>
<body>
  <section class="container">
    <div class="login">
      <h1>Login to Web App</h1>
      <form method="post" action="wlogin.php">
        <p><input type="text" name="email" value="" placeholder="Username or Email"></p>
        <p><input type="password" name="password" value="" placeholder="Password"></p>
        <p class="remember_me">
          <label>
            <input type="checkbox" name="remember_me" id="remember_me">
            Remember me on this computer
          </label>
        </p>
        <p class="submit"><input type="submit" name="commit" value="Login"></p>
      </form>
    </div>

    <div class="login-help">
      <p>Forgot your password? <a href="index.html">Click here to reset it</a>.</p>
    </div>
  </section>

  <section class="about">
    <p class="about-links">
      <a href="http://www.cssflow.com/snippets/login-form" target="_parent">View Article</a>
      <a href="http://www.cssflow.com/snippets/login-form.zip" target="_parent">Download</a>
    </p>
    <p class="about-author">
      &copy; 2012&ndash;2013 <a href="http://thibaut.me" target="_blank">Thibaut Courouble</a> -
      <a href="http://www.cssflow.com/mit-license" target="_blank">MIT License</a><br>
      Original PSD by <a href="http://www.premiumpixels.com/freebies/clean-simple-login-form-psd/" target="_blank">Orman Clark</a>
  </section>
</body>
</html>

----------------------------------
register
<?php
       
ssss


$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());

//================================================================
                                                  
        $name= mysql_real_escape_string($_REQUEST['name']);
        $email= mysql_real_escape_string($_REQUEST['email']);
    $age= mysql_real_escape_string($_REQUEST['age']);
    $city= mysql_real_escape_string($_REQUEST['city']);
    $mobile= mysql_real_escape_string($_REQUEST['mobile']);
    $job= mysql_real_escape_string($_REQUEST['job']);
    $gender= mysql_real_escape_string($_REQUEST['gender']);
    $desc= mysql_real_escape_string($_REQUEST['desc']);
$img= mysql_real_escape_string($_REQUEST['img']);
    $edlevel= mysql_real_escape_string($_REQUEST['edlevel']);

$civilstatus= mysql_real_escape_string($_REQUEST['civilstatus']);
//======================================================

if (isUserExisted($email)) {
 $p3=3;
}
else{

    $inserted_payment = mysql_query("INSERT INTO customer VALUES(null, '$name', '$email','$city', '$gender', '$mobile', '$age','$job',   '$civilstatus', '$edlevel', '$desc', '$img' )")or die(mysql_error());
     $last_insert_id = mysql_insert_id();
    if ($last_insert_id != null) {
    $p3=1;
    }

}
//====================================================
 function isUserExisted($email) {
       $select = mysql_query("SELECT `email` FROM `customer` WHERE `email` = '".$_POST['email']."'") or exit(mysql_error());

            if(mysql_num_rows($select)){
            // user existed
              return true;
        } else {
           return false;
        }
    }
mysql_close($con);
echo json_encode($p3);
?>
--------------------------
<?php
       
ssss


$apn="1";

$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());

$sql = "SELECT * FROM `customer` WHERE `id` = '".$apn."'";
$result = mysql_query($sql);

$json = array();
if(mysql_num_rows($result))
{
while($row=mysql_fetch_assoc($result))
{
        $json['student'][]=$row;
}
}

echo json_encode($json);

mysql_close($con);

?>
-----------------------------------------------

<?php
       
$host="localhost";
$username="prathee1_lexisu";
$password="Asdf!@#4";
$db_name="prathee1_lexis";


$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());
//================================================================
                              
        $grade= mysql_real_escape_string($_REQUEST['grade']);
           
        $chkPayments1= mysql_real_escape_string($_REQUEST['chkPayments1']);
        $chkPayments2= mysql_real_escape_string($_REQUEST['chkPayments2']);
    $chkPayments3= mysql_real_escape_string($_REQUEST['chkPayments3']);
   
    $chkAttendence1= mysql_real_escape_string($_REQUEST['chkAttendence1']);
    $chkAttendence2= mysql_real_escape_string($_REQUEST['chkAttendence2']);
    $chkAttendence3= mysql_real_escape_string($_REQUEST['chkAttendence3']);
   
    $student_apn= mysql_real_escape_string($_REQUEST['student_apn']);
    $subject_id= mysql_real_escape_string($_REQUEST['subject_id']);
   
    $month= mysql_real_escape_string($_REQUEST['month']);
    $today= mysql_real_escape_string($_REQUEST['date']);
    $year= mysql_real_escape_string($_REQUEST['year']);
   
    $subject_id1="1";
    $subject_id2="2";
    $subject_id3="3";
   
//================================================================
 $attencence="1";

$A1;
 if ($chkAttendence1== 1) {
                               //    "UPDATE  reservations SET  status = 5,check_out_timestamp=:cDate WHERE id=:ResID");          
 $inserted_Attendence1 =mysql_query("UPDATE attendence SET attencence=1 WHERE year=$year && month=$month && date=$today && grade=$grade && student_apn=$student_apn && subject_id=$subject_id1
 ")or die(mysql_error());


 //$inserted_Attendence1 = mysql_query("INSERT INTO attendence VALUES(null, '$year', '$month', '$today' ,'$grade', '$student_apn', '$subject_id1' , '$attencence')")or die(mysql_error());


if ($inserted_Attendence1 == true) {
 $A1="a1";
}
else{
$A1="0";
}
}else{ }   


//================================================================

$A2;
 if ($chkAttendence2== 1) {
                               //    "UPDATE  reservations SET  status = 5,check_out_timestamp=:cDate WHERE id=:ResID");          
 $inserted_Attendence1 =mysql_query("UPDATE attendence SET attencence=1 WHERE year=$year && month=$month && date=$today && grade=$grade && student_apn=$student_apn && subject_id=$subject_id2
 ")or die(mysql_error());


 //$inserted_Attendence1 = mysql_query("INSERT INTO attendence VALUES(null, '$year', '$month', '$today' ,'$grade', '$student_apn', '$subject_id1' , '$attencence')")or die(mysql_error());


if ($inserted_Attendence1 == true) {
 $A2="a2";
}
else{
$A2="0";
}
}else{ }   


//================================================================
$A3;
 if ($chkAttendence3== 1) {
                               //    "UPDATE  reservations SET  status = 5,check_out_timestamp=:cDate WHERE id=:ResID");          
 $inserted_Attendence1 =mysql_query("UPDATE attendence SET attencence=1 WHERE year=$year && month=$month && date=$today && grade=$grade && student_apn=$student_apn && subject_id=$subject_id3
 ")or die(mysql_error());


 //$inserted_Attendence1 = mysql_query("INSERT INTO attendence VALUES(null, '$year', '$month', '$today' ,'$grade', '$student_apn', '$subject_id1' , '$attencence')")or die(mysql_error());


if ($inserted_Attendence1 == true) {
 $A3="a3";
}
else{
$A3="0";
}
}else{ }   


//================================================================

$query_5 = mysql_query("SELECT * FROM payments WHERE student_apn= '$student_apn' && month = '$month' && year= '$year' && grade= '$grade' && subject_id= '$subject_id1' ")or die(mysql_error());
    $is_already_saved5 = mysql_num_rows($query_5);
   
    if($is_already_saved5==1){   
        //echo "1";
         }
    else{
   
//================================================================
$p1;
 if ($chkPayments1 == 1) {
 $inserted_payment = mysql_query("INSERT INTO payments VALUES(null, '$year', '$month' ,'$grade', '$student_apn', '$subject_id1', '$chkPayments1', '$today',null )")or die(mysql_error());
 $last_insert_id = mysql_insert_id();
if ($last_insert_id != null) {
 $p1="1";
}
else{
$p1="0";
}
}else{ }
}
//=======================================================
$query_6 = mysql_query("SELECT * FROM payments WHERE student_apn= '$student_apn' && month = '$month' && year= '$year' && grade= '$grade' && subject_id= '$subject_id2' ")or die(mysql_error());
    $is_already_saved6 = mysql_num_rows($query_6);
   
    if($is_already_saved6==1){   
        //echo "1";
         }
    else{
   
 if ($chkPayments2 == 1) {
$inserted_payment = mysql_query("INSERT INTO payments VALUES(null, '$year', '$month','$grade', '$student_apn', '$subject_id2', '$chkPayments2', '$today',null )")or die(mysql_error());
$last_insert_id = mysql_insert_id();
if ($last_insert_id != null) {
 $p2="11";
}
else{
$p2="0";
}
}else{ }
}
//======================================================

$query_7 = mysql_query("SELECT * FROM payments WHERE student_apn= '$student_apn' && month = '$month' && year= '$year' && grade= '$grade' && subject_id= '$subject_id3' ")or die(mysql_error());
    $is_already_saved7 = mysql_num_rows($query_7);
   
    if($is_already_saved7==1){   
        //echo "1";
         }
    else{
   
 if ($chkPayments3 == 1) {
$inserted_payment = mysql_query("INSERT INTO payments VALUES(null, '$year', '$month','$grade', '$student_apn', '$subject_id3', '$chkPayments3', '$today',null )")or die(mysql_error());
$last_insert_id = mysql_insert_id();
if ($last_insert_id != null) {
 $p3="111";
}
else{
$p3="0";
}

}else{ }
}

//====================================================
//echo $p1;
 //return array("Name"=>"Ahmad Sayeed","Email"=>"ahmad@gmail.com");
    $a = array();
$a['english_sub'] = $p1;
$a['science_sub'] = $p2;
$a['maths_sub'] = $p3;   
$a['english_Attendence'] = $A1;   
$a['science_Attendence'] = $A2;   
$a['maths_Attendence'] = $A3;   



        $json = array();
    $json['user'][]=$a;   
       
       
//================================================================   
mysql_close($con);
echo json_encode($json);
?>
----------------------

Posted by at No comments:
Subscribe to: Comments (Atom)