Rounded Circle progress in android
Here is some GREAT resorces....Go and have fun....
http://stackoverflow.com/questions/27213381/how-to-create-circular-progressbar-in-android
https://github.com/lzyzsd/CircleProgress
http://stackoverflow.com/questions/21333866/how-to-create-a-circular-progressbar-in-android-which-rotates-on-it
http://www.cardinalsolutions.com/blog/2014/11/android_circle_progr
https://codeszealot.wordpress.com/2014/07/15/android-circular-progressbar-ring-shaped-progressbar-with-text/
Saturday, December 19, 2015
Saturday, December 5, 2015
The following classes could not be found. android.support.v7.internal.widget.*********
with<style name="AppTheme" parent="Theme.AppCompat.Light.DarkActionBar"> <!-- Customize your theme here. --> </style>
<style name="AppTheme" parent="Base.Theme.AppCompat.Light.DarkActionBar"> <!-- Customize your theme here. --> </style>
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);
?>
$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);
?>
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">
© 2012–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);
?>
----------------------
<?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">
© 2012–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);
?>
----------------------
Wednesday, July 8, 2015
Android Mail sample
package com.example.studentregistration;
import java.util.ArrayList;
import java.util.List;
import org.apache.http.NameValuePair;
import org.apache.http.message.BasicNameValuePair;
import org.json.JSONException;
import org.json.JSONObject;
import com.example.helpers.JSONParser;
import com.example.studentregistration.Register.CreateUser;
import android.app.Activity;
import android.app.ProgressDialog;
import android.content.Intent;
import android.os.AsyncTask;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
public class ContactUs extends Activity implements OnClickListener{
private Button btnSend, btnCancel;
private ProgressDialog pDialog;
JSONParser jsonParser = new JSONParser();
private static final String LOGIN_URL = "http://pratheepan.info/ws4/mymail.php";
// ws4/show.php
private static final String TAG_SUCCESS = "success";
private static final String TAG_MESSAGE = "message";
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.contactus);
btnSend = (Button)findViewById(R.id.btnSend);
btnCancel = (Button)findViewById(R.id.btnCancel);
//register listeners
btnSend.setOnClickListener(this);
btnCancel.setOnClickListener(this);
}
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
switch (v.getId()) {
case R.id.btnSend:
//do somthing here.................
new CreateUser().execute();
break;
case R.id.btnCancel:
Intent i2 = new Intent(this, HomePage.class);
startActivity(i2);
break;
default:
break;
}
}
class CreateUser extends AsyncTask<String, String, String> {
EditText strName = (EditText)findViewById(R.id.txtName);
String name = strName.getText().toString();
EditText strPhone = (EditText)findViewById(R.id.txtPhone);
String phone = strPhone.getText().toString();
EditText strSubject = (EditText)findViewById(R.id.txtSubject);
String subject = strSubject.getText().toString();
EditText strDepartment = (EditText)findViewById(R.id.txtMessage);
String message = strDepartment.getText().toString();
/**
* Before starting background thread Show Progress Dialog
* */
boolean failure = false;
@Override
protected void onPreExecute() {
super.onPreExecute();
pDialog = new ProgressDialog(ContactUs.this);
pDialog.setMessage("Creating User...");
pDialog.setIndeterminate(false);
pDialog.setCancelable(true);
pDialog.show();
}
@Override
protected String doInBackground(String... args) {
// TODO Auto-generated method stub
// Check for success tag
int success;
// String username = user.getText().toString();
// String password = pass.getText().toString();
// String email = em.getText().toString();
try {
// Building Parameters
List<NameValuePair> params = new ArrayList<NameValuePair>();
params.add(new BasicNameValuePair("Name", name));
params.add(new BasicNameValuePair("Phone", phone));
params.add(new BasicNameValuePair("Subject", subject));
params.add(new BasicNameValuePair("Message", message));
// Log.d("request!", "starting");
//====================================================== ws4/mymail.php
//Posting user data to script
JSONObject json = jsonParser.makeHttpRequest(
LOGIN_URL, "POST", params);
success = json.getInt(TAG_SUCCESS);
if (success == 1) {
// Intent in = new Intent(ContactUs.this, Homepage.class);
// finish();
// TextView tvres = (TextView)findViewById(R.id.tvResult);
// tvres.setText("Message Successfully Sent !");
return json.getString(TAG_MESSAGE);
}
else
{
Log.d("Login Failure!", json.getString(TAG_MESSAGE));
return json.getString(TAG_MESSAGE);
}
} catch (JSONException e) {
e.printStackTrace();
}
return null;
}
/**
* After completing background task Dismiss the progress dialog
* **/
protected void onPostExecute(String file_url) {
// dismiss the dialog once product deleted
// UserServ serv = UserServImpl.getInstance();
// DataList.setUsers(serv.getUsers());
pDialog.dismiss();
if (file_url != null){
Toast.makeText(ContactUs.this, file_url, Toast.LENGTH_LONG).show();
}
}
}
}
import java.util.ArrayList;
import java.util.List;
import org.apache.http.NameValuePair;
import org.apache.http.message.BasicNameValuePair;
import org.json.JSONException;
import org.json.JSONObject;
import com.example.helpers.JSONParser;
import com.example.studentregistration.Register.CreateUser;
import android.app.Activity;
import android.app.ProgressDialog;
import android.content.Intent;
import android.os.AsyncTask;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
public class ContactUs extends Activity implements OnClickListener{
private Button btnSend, btnCancel;
private ProgressDialog pDialog;
JSONParser jsonParser = new JSONParser();
private static final String LOGIN_URL = "http://pratheepan.info/ws4/mymail.php";
// ws4/show.php
private static final String TAG_SUCCESS = "success";
private static final String TAG_MESSAGE = "message";
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.contactus);
btnSend = (Button)findViewById(R.id.btnSend);
btnCancel = (Button)findViewById(R.id.btnCancel);
//register listeners
btnSend.setOnClickListener(this);
btnCancel.setOnClickListener(this);
}
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
switch (v.getId()) {
case R.id.btnSend:
//do somthing here.................
new CreateUser().execute();
break;
case R.id.btnCancel:
Intent i2 = new Intent(this, HomePage.class);
startActivity(i2);
break;
default:
break;
}
}
class CreateUser extends AsyncTask<String, String, String> {
EditText strName = (EditText)findViewById(R.id.txtName);
String name = strName.getText().toString();
EditText strPhone = (EditText)findViewById(R.id.txtPhone);
String phone = strPhone.getText().toString();
EditText strSubject = (EditText)findViewById(R.id.txtSubject);
String subject = strSubject.getText().toString();
EditText strDepartment = (EditText)findViewById(R.id.txtMessage);
String message = strDepartment.getText().toString();
/**
* Before starting background thread Show Progress Dialog
* */
boolean failure = false;
@Override
protected void onPreExecute() {
super.onPreExecute();
pDialog = new ProgressDialog(ContactUs.this);
pDialog.setMessage("Creating User...");
pDialog.setIndeterminate(false);
pDialog.setCancelable(true);
pDialog.show();
}
@Override
protected String doInBackground(String... args) {
// TODO Auto-generated method stub
// Check for success tag
int success;
// String username = user.getText().toString();
// String password = pass.getText().toString();
// String email = em.getText().toString();
try {
// Building Parameters
List<NameValuePair> params = new ArrayList<NameValuePair>();
params.add(new BasicNameValuePair("Name", name));
params.add(new BasicNameValuePair("Phone", phone));
params.add(new BasicNameValuePair("Subject", subject));
params.add(new BasicNameValuePair("Message", message));
// Log.d("request!", "starting");
//====================================================== ws4/mymail.php
//Posting user data to script
JSONObject json = jsonParser.makeHttpRequest(
LOGIN_URL, "POST", params);
success = json.getInt(TAG_SUCCESS);
if (success == 1) {
// Intent in = new Intent(ContactUs.this, Homepage.class);
// finish();
// TextView tvres = (TextView)findViewById(R.id.tvResult);
// tvres.setText("Message Successfully Sent !");
return json.getString(TAG_MESSAGE);
}
else
{
Log.d("Login Failure!", json.getString(TAG_MESSAGE));
return json.getString(TAG_MESSAGE);
}
} catch (JSONException e) {
e.printStackTrace();
}
return null;
}
/**
* After completing background task Dismiss the progress dialog
* **/
protected void onPostExecute(String file_url) {
// dismiss the dialog once product deleted
// UserServ serv = UserServImpl.getInstance();
// DataList.setUsers(serv.getUsers());
pDialog.dismiss();
if (file_url != null){
Toast.makeText(ContactUs.this, file_url, Toast.LENGTH_LONG).show();
}
}
}
}
email sample
<?php
$to = "indika.senavirathne@gmail.com";
$subject = "Testing Email From Dot University ";
// ' "
$message = '
<html>
<head>
<title>HTML email</title>
</head>
<body>
<p>Testing Email From IT Department Dot University!</p>
<div style="color:#0000FF float:"left" ">
<img src="http://www.lankaholidaytours.com/images/vip.jpg" width="150" height="150">
</div>
<div style="color:#0000FF float:"left" ">
<table width="350" height="100" float:"left" border="0" border-color: #666 align="left" cellpadding="0" cellspacing="0" style="font-family: Arial, Helvetica, sans-serif;font-size: 12px;">
<tr>
<td height="59" colspan="2" style="font-family: Arial, Helvetica, sans-serif; font-size: 24px;font-weight: bold;color: #2D9348;padding-left: 5px;">Dear Student ! </td>
</tr>
<tr>
<td >Name</th>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Name'].'</td>
</tr>
<tr>
<td>Phone</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Phone'].'</td>
</tr>
<tr>
<td>Subject</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Subject'].'</td>
</tr>
<tr>
<td>Message</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;"><strong>'.$_REQUEST['Message'].'</strong> </td>
</tr>
<tr>
<td>i</td>
</tr>
</table>
</div>
<br clear="all"></Br>
<div height="59" colspan="2" style="font-family: Arial, Helvetica, sans-serif; font-size: 11px;color: #330000;padding-left: 5px;">
IMPORTANT</Br>
This email and all its attachments are intended solely for the named addressee. It is private and confidential and may contain legally privileged material.
</div>
</body>
</html>
';
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// More headers
$headers .= 'From: <indika.senavirathne@gmail.com>' . "\r\n";
$headers .= 'Cc: indika.senavirathne@gmail.com' . "\r\n";
mail($to,$subject,$message,$headers);
$response["success"] = 1;
$response["message"] = "Message successfuly sent!";
die(json_encode($response));
?>
$to = "indika.senavirathne@gmail.com";
$subject = "Testing Email From Dot University ";
// ' "
$message = '
<html>
<head>
<title>HTML email</title>
</head>
<body>
<p>Testing Email From IT Department Dot University!</p>
<div style="color:#0000FF float:"left" ">
<img src="http://www.lankaholidaytours.com/images/vip.jpg" width="150" height="150">
</div>
<div style="color:#0000FF float:"left" ">
<table width="350" height="100" float:"left" border="0" border-color: #666 align="left" cellpadding="0" cellspacing="0" style="font-family: Arial, Helvetica, sans-serif;font-size: 12px;">
<tr>
<td height="59" colspan="2" style="font-family: Arial, Helvetica, sans-serif; font-size: 24px;font-weight: bold;color: #2D9348;padding-left: 5px;">Dear Student ! </td>
</tr>
<tr>
<td >Name</th>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Name'].'</td>
</tr>
<tr>
<td>Phone</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Phone'].'</td>
</tr>
<tr>
<td>Subject</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Subject'].'</td>
</tr>
<tr>
<td>Message</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;"><strong>'.$_REQUEST['Message'].'</strong> </td>
</tr>
<tr>
<td>i</td>
</tr>
</table>
</div>
<br clear="all"></Br>
<div height="59" colspan="2" style="font-family: Arial, Helvetica, sans-serif; font-size: 11px;color: #330000;padding-left: 5px;">
IMPORTANT</Br>
This email and all its attachments are intended solely for the named addressee. It is private and confidential and may contain legally privileged material.
</div>
</body>
</html>
';
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// More headers
$headers .= 'From: <indika.senavirathne@gmail.com>' . "\r\n";
$headers .= 'Cc: indika.senavirathne@gmail.com' . "\r\n";
mail($to,$subject,$message,$headers);
$response["success"] = 1;
$response["message"] = "Message successfuly sent!";
die(json_encode($response));
?>
Wednesday, March 18, 2015
PHP web service to insert data to mysql database and retreive
<?php
mysql_connect("localhost","pfdsr","sdffsd") or die("database error");
mysql_select_db("sfdfsds");
if (!empty($_POST)) {
$Name = mysql_real_escape_string($_REQUEST['username']);
$Email = mysql_real_escape_string($_REQUEST['email']);
$Address= mysql_real_escape_string($_REQUEST['password']);
$result = mysql_query("SELECT email from student WHERE email = '$Email'");
$no_of_rows = mysql_num_rows($result);
if ($no_of_rows > 0) {
// user existed
$response["success"] = 2;
$response["message"] = "Email already registered!";
die(json_encode($response));
} else {
try {
$query2 = mysql_query("INSERT INTO student VALUES(null, '$Name', '$Email', '$Address')")or die(mysql_error());
//$result2 = mysql_query($query2);
$last_insert_id = mysql_insert_id();
$result = mysql_query("SELECT name, email, address FROM student WHERE id = '$last_insert_id' ")or die(mysql_error());
$json = array();
$row = mysql_fetch_assoc($result);
$json['student'][] = $row;
//echo json_encode($json);
$response["success"] = 1;
$response["message"] = "Login successful!";
die(json_encode($response));
}
catch (PDOException $ex) {
$response["success"] = 0;
$response["message"] = "Database Error1. Please Try Again!";
die(json_encode($response));
}
}
} else {
?>
<h1>Register</h1>
<form action="enterdata.php" method="post">
Username:<br />
<input type="text" name="username" value="" />
<br /><br />
Password:<br />
<input type="password" name="password" value="" />
<br /><br />
Email:<br />
<input type="text" name="email" value="" />
<br /><br />
<input type="submit" value="Register New User" />
</form>
<?php
}
?>
Friday, March 13, 2015
HTML Email in PHP Desing 2
<?php
$to = "sender@gmail.com";
$subject = "Testing Email From KD University ";
// ' "
$message = '
<html>
<head>
<title>HTML email</title>
</head>
<body>
<p>Testing Email From IT Department KD University!</p>
<div style="color:#0000FF float:"left" ">
<img src="http://www. .com.au/app/img/nslogo.png" width="150" height="150">
</div>
<div style="color:#0000FF float:"left" ">
<table width="350" height="100" float:"left" border="0" border-color: #666 align="left" cellpadding="0" cellspacing="0" style="font-family: Arial, Helvetica, sans-serif;font-size: 12px;">
<tr>
<td height="59" colspan="2" style="font-family: Arial, Helvetica, sans-serif; font-size: 24px;font-weight: bold;color: #2D9348;padding-left: 5px;">Dear Student ! </td>
</tr>
<tr>
<td >Name</th>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Name'].'</td>
</tr>
<tr>
<td>Phone</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Phone'].'</td>
</tr>
<tr>
<td>Subject</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Subject'].'</td>
</tr>
<tr>
<td>Message</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;"><strong>'.$_REQUEST['Message'].'</strong> </td>
</tr>
<tr>
<td>i</td>
</tr>
</table>
</div>
<br clear="all"></Br>
<div height="59" colspan="2" style="font-family: Arial, Helvetica, sans-serif; font-size: 11px;color: #330000;padding-left: 5px;">
IMPORTANT</Br>
This email and all its attachments are intended solely for the named addressee. It is private and confidential and may contain legally privileged material.
</div>
</body>
</html>
';
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// More headers
$headers .= 'From: <sender@gmail.com>' . "\r\n";
$headers .= 'Cc: sender@gmail.com' . "\r\n";
mail($to,$subject,$message,$headers);
?>
$to = "sender@gmail.com";
$subject = "Testing Email From KD University ";
// ' "
$message = '
<html>
<head>
<title>HTML email</title>
</head>
<body>
<p>Testing Email From IT Department KD University!</p>
<div style="color:#0000FF float:"left" ">
<img src="http://www. .com.au/app/img/nslogo.png" width="150" height="150">
</div>
<div style="color:#0000FF float:"left" ">
<table width="350" height="100" float:"left" border="0" border-color: #666 align="left" cellpadding="0" cellspacing="0" style="font-family: Arial, Helvetica, sans-serif;font-size: 12px;">
<tr>
<td height="59" colspan="2" style="font-family: Arial, Helvetica, sans-serif; font-size: 24px;font-weight: bold;color: #2D9348;padding-left: 5px;">Dear Student ! </td>
</tr>
<tr>
<td >Name</th>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Name'].'</td>
</tr>
<tr>
<td>Phone</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Phone'].'</td>
</tr>
<tr>
<td>Subject</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;">'.$_REQUEST['Subject'].'</td>
</tr>
<tr>
<td>Message</td>
<td height="29" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;font-weight: bold;color: #2D9348;padding-left: 5px;"><strong>'.$_REQUEST['Message'].'</strong> </td>
</tr>
<tr>
<td>i</td>
</tr>
</table>
</div>
<br clear="all"></Br>
<div height="59" colspan="2" style="font-family: Arial, Helvetica, sans-serif; font-size: 11px;color: #330000;padding-left: 5px;">
IMPORTANT</Br>
This email and all its attachments are intended solely for the named addressee. It is private and confidential and may contain legally privileged material.
</div>
</body>
</html>
';
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// More headers
$headers .= 'From: <sender@gmail.com>' . "\r\n";
$headers .= 'Cc: sender@gmail.com' . "\r\n";
mail($to,$subject,$message,$headers);
?>
HTML Email with PHP
<?php
$to = "sender@gmail.com";
$subject = "Testing Email From ";
// ' "
$message = '
<html>
<head>
<title>HTML email</title>
</head>
<body>
<p>Testing Email From</p>
<div style="color:#0000FF float:"left" ">
<img src="http://www. v .com.au/app/img/nslogo.png" width="150" height="150">
</div>
<table width="350" height="100" float:"left" border="0" border-color: #666 align="left" cellpadding="0" cellspacing="0" style="font-family: Arial, Helvetica, sans-serif;font-size: 12px;">
<tr>
<td height="59" colspan="2" style="font-family: Arial, Helvetica, sans-serif; font-size: 24px;font-weight: bold;color: #2D9348;padding-left: 5px;">Dear Student ! </td>
</tr>
<tr>
<th align="left">Firstname</th>
<th align="left">Lastname</th>
</tr>
<tr>
<td>Indika</td>
<td align="left">Senavirathne</td>
</tr>
<tr>
<td>Address</td>
<td><strong>Kuruvikulama</strong> </td>
</tr>
</table>
</body>
</html>
';
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// More headers
$headers .= 'From: <sender@gmail.com@gmail.com>' . "\r\n";
$headers .= 'Cc: sender@gmail.com@gmail.com' . "\r\n";
mail($to,$subject,$message,$headers);
?>
$to = "sender@gmail.com";
$subject = "Testing Email From ";
// ' "
$message = '
<html>
<head>
<title>HTML email</title>
</head>
<body>
<p>Testing Email From</p>
<div style="color:#0000FF float:"left" ">
<img src="http://www. v .com.au/app/img/nslogo.png" width="150" height="150">
</div>
<table width="350" height="100" float:"left" border="0" border-color: #666 align="left" cellpadding="0" cellspacing="0" style="font-family: Arial, Helvetica, sans-serif;font-size: 12px;">
<tr>
<td height="59" colspan="2" style="font-family: Arial, Helvetica, sans-serif; font-size: 24px;font-weight: bold;color: #2D9348;padding-left: 5px;">Dear Student ! </td>
</tr>
<tr>
<th align="left">Firstname</th>
<th align="left">Lastname</th>
</tr>
<tr>
<td>Indika</td>
<td align="left">Senavirathne</td>
</tr>
<tr>
<td>Address</td>
<td><strong>Kuruvikulama</strong> </td>
</tr>
</table>
</body>
</html>
';
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// More headers
$headers .= 'From: <sender@gmail.com@gmail.com>' . "\r\n";
$headers .= 'Cc: sender@gmail.com@gmail.com' . "\r\n";
mail($to,$subject,$message,$headers);
?>
Wednesday, March 4, 2015
iPhone Screen SIzes
iPhone 4S
Screen Size: 3.5 Inches
Resolution: 640 x 960 (Half: 320 x 480)
iPhone 5
Screen Size: 4.0 Inches
Resolution: 640 × 1136 (Half: 320 x 568)
iPhone 5S/5C
Screen Size: 4.0 Inches
Resolution: 640 x 1136 (Half: 320 x 568)
iPhone 6
Screen Size: 4.7 Inches
Resolution: 828 x 1472 (Half: 414 x 736)
Resolution: 750 x 1334 (Half: 375 x 667)
iPhone 6 Plus
Screen Size: 5.5 Inches
Resolution: 906 x 1704 (Half: 453 x 852)
Resolution: 1242 x 2208 (1/3: 414 x 736)
The size of iPhone 6 Plus is @3x scaling. So, it is divided by 3.
So, other than 320 x 480 and 320 x 568, we have to use 375 x 667 and 414 x 736 at the Resizable iPhone Simulator.
After you build and run your project with the Resizable iPhone Simulator, you may set Width as 414, Compact and Height as 736, Regular and remember to click “Apply” like screen shot below:-
Screen Size: 3.5 Inches
Resolution: 640 x 960 (Half: 320 x 480)
iPhone 5
Screen Size: 4.0 Inches
Resolution: 640 × 1136 (Half: 320 x 568)
iPhone 5S/5C
Screen Size: 4.0 Inches
Resolution: 640 x 1136 (Half: 320 x 568)
iPhone 6
Screen Size: 4.7 Inches
Resolution: 750 x 1334 (Half: 375 x 667)
iPhone 6 Plus
Screen Size: 5.5 Inches
Resolution: 1242 x 2208 (1/3: 414 x 736)
The size of iPhone 6 Plus is @3x scaling. So, it is divided by 3.
So, other than 320 x 480 and 320 x 568, we have to use 375 x 667 and 414 x 736 at the Resizable iPhone Simulator.
After you build and run your project with the Resizable iPhone Simulator, you may set Width as 414, Compact and Height as 736, Regular and remember to click “Apply” like screen shot below:-
Adding Pods to an Xcode project
vi podfile
platform :ios, ‘8.1’ -these quartz are wrong…
pod ‘AFNetworking’
:wq
pod install
================================
platform :ios, '6.0'
pod 'AFNetworking'
pod 'MWPhotoBrowser'
================================================
mac:test789 indikasenavirathne$ pod install
/System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/universal-darwin14/rbconfig.rb:213: warning: Insecure world writable dir /usr/local in PATH, mode 040777
Analyzing dependencies
CocoaPods 0.36.0.rc.1 is available.
To update use: `gem install cocoapods --pre`
[!] This is a test version we'd love you to try.
For more information see http://blog.cocoapods.org
and the CHANGELOG for this version http://git.io/BaH8pQ.
Downloading dependencies
Installing AFNetworking (2.5.1)
Generating Pods project
Integrating client project
[!] From now on use `test789.xcworkspace`.
mac:test789 indikasenavirathne$ pod install
/System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/universal-darwin14/rbconfig.rb:213: warning: Insecure world writable dir /usr/local in PATH, mode 040777
Analyzing dependencies
CocoaPods 0.36.0.rc.1 is available.
To update use: `gem install cocoapods --pre`
[!] This is a test version we'd love you to try.
For more information see http://blog.cocoapods.org
and the CHANGELOG for this version http://git.io/BaH8pQ.
Downloading dependencies
Using AFNetworking (2.5.1)
Installing DACircularProgress (2.2.0)
Installing MBProgressHUD (0.9)
Installing MWPhotoBrowser (1.4.1)
Installing PSTCollectionView (1.2.3)
Installing SDWebImage (3.7.1)
Generating Pods project
Integrating client project
mac:test789 indikasenavirathne$
platform :ios, ‘8.1’ -these quartz are wrong…
pod ‘AFNetworking’
:wq
pod install
================================
platform :ios, '6.0'
pod 'AFNetworking'
pod 'MWPhotoBrowser'
================================================
mac:test789 indikasenavirathne$ pod install
/System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/universal-darwin14/rbconfig.rb:213: warning: Insecure world writable dir /usr/local in PATH, mode 040777
Analyzing dependencies
CocoaPods 0.36.0.rc.1 is available.
To update use: `gem install cocoapods --pre`
[!] This is a test version we'd love you to try.
For more information see http://blog.cocoapods.org
and the CHANGELOG for this version http://git.io/BaH8pQ.
Downloading dependencies
Installing AFNetworking (2.5.1)
Generating Pods project
Integrating client project
[!] From now on use `test789.xcworkspace`.
mac:test789 indikasenavirathne$ pod install
/System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/lib/ruby/2.0.0/universal-darwin14/rbconfig.rb:213: warning: Insecure world writable dir /usr/local in PATH, mode 040777
Analyzing dependencies
CocoaPods 0.36.0.rc.1 is available.
To update use: `gem install cocoapods --pre`
[!] This is a test version we'd love you to try.
For more information see http://blog.cocoapods.org
and the CHANGELOG for this version http://git.io/BaH8pQ.
Downloading dependencies
Using AFNetworking (2.5.1)
Installing DACircularProgress (2.2.0)
Installing MBProgressHUD (0.9)
Installing MWPhotoBrowser (1.4.1)
Installing PSTCollectionView (1.2.3)
Installing SDWebImage (3.7.1)
Generating Pods project
Integrating client project
mac:test789 indikasenavirathne$
Adding Pods to an Xcode project
vi podfile
platform :ios, ‘8.1’ -these quatz are wrong...
pod ‘AFNetworking’
:wq
pod install
Subscribe to:
Comments (Atom)