Technology News And Updates: August 2013

Saturday, 31 August 2013

How to send sms in php?

Send SMS code below:

<html>
<head>
<meta name="khoshalidev's@" content="index">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>send sms</title>
<style type="text/css">
body{
    font-family:"Lucida Grande", "Lucida Sans Unicode", Verdana, Arial, Helvetica, sans-serif;
    font-size:12px;
}
p, h1, form, button{border:0; margin:0; padding:0;}
.spacer{clear:both; height:1px;}
/* ----------- My Form ----------- /
.myform{
    margin:0 auto;
    width:340px;
    padding:14px;
}
/ ----------- stylized ----------- */
    #stylized{
        border:solid 2px #b7ddf2;
        background:#ebf4fb;
    }
    #stylized h1 {
        font-size:14px;
        font-weight:bold;
        margin-bottom:8px;
    }
    #stylized p{
        font-size:11px;
        color:#666666;
        margin-bottom:20px;
        border-bottom:solid 1px #b7ddf2;
        padding-bottom:10px;

}
    </style>

    <script type="text/javascript">

//Edit the counter/limiter value as your wish
var count = "160";   //Example: var count = "175";
function limiter(){
var tex = document.myform.text.value;
var len = tex.length;
if(len > count){
        tex = tex.substring(0,count);
        document.myform.text.value =tex;
        return false;
}
document.myform.limit.value = count-len;
}

// +,- delete
var r={'special':/[\W]/g}
function valid(o,w)
{
o.value = o.value.replace(r[w],'');
}

// phone number checker
function isNumeric()
{
var elem=document.myform.to.value;
var nalt=document.getElementById('phno1');
if(elem!="")
{
    var numericExpression = /^[0-9]+$/;
    if(elem.match(numericExpression))
    {
         nalt.innerHTML="";
         return true;
       }

    else{

    nalt.innerHTML="<font size=1 > Numbers Only</font>";
        document.myform.to.focus();
         document.myform.to.value="";
       return false;
    }
}
else if(elem.length==0) {
    nalt.innerHTML="<font size=1 > Enter Numbers</font>";
     document.myform.to.focus();;
   return false;
    }
}
</script>

</head>
<body>
<?

$from = ""; // Change , and put your SMS Number in www.2-waysms.com account
$token = ""; // Change , and put your token code in www.2-waysms.com account

$option = $_REQUEST["option"];
$text = $_REQUEST["text"];
$to = $_REQUEST["to"];
$senderid = $_REQUEST["senderid"];

    switch ($option) {


    case sendsms:
        if ($text == "") { echo
    "<center><br>Error!<br><b>Text not entered<b><br><a href=\"javascript:history.back(-1)\"><b>Go Back<b></a><br></center>";
die; } else { }

        if ($to == "") { echo "<center><br>Error!<br><b>Number not entered<b><br><a href=\"javascript:history.back(-1)\"><b>Go Back<b></a><br></center>";
die; } else { }

        if ($senderid == "") { echo "<center><br>Error!<br><b>From not entered<b><br><a href=\"javascript:history.back(-1)\"><b>Go Back<b></a><br></center>";
die; } else { }

        $url = "http://www.2-waysms.com/my/api/sms.php";

        $postfields = array ("from" => "$from",
        "token" => "$token",
        "text" => "$text",
        "to" => "$to",
        "senderid" => "$senderid");

        if (!$curld = curl_init()) {
        echo "Could not initialize cURL session.";
        exit;
        }
        curl_setopt($curld, CURLOPT_POST, true);
        curl_setopt($curld, CURLOPT_POSTFIELDS, $postfields);
        curl_setopt($curld, CURLOPT_URL, $url);
        curl_setopt($curld, CURLOPT_RETURNTRANSFER, true);
        $output = curl_exec($curld);
        curl_close ($curld);

        $out = explode('|',$output);

echo "<center>Message Status: Your message was sent successfully to $to $out[1]<br><a href=\"smser.php\"><b>Send New SMS Message</b></a></center>";

    break;

    default:

    echo

    "<div id=\"stylized\" class=\"myform\">"
       ."<form name=\"myform\" method=post action=\"$PHP_SELF?option=sendsms\">"
       ."<table border=\"0\">"
       ."<tr>"
       ."<center><h1>Send SMS with own Sender ID</h1></center>"
        ."<td>Sender ID</td>"
        ."<td><input type=\"text\" name=\"senderid\" onkeyup=\"valid(this,'special')\" onblur=\"valid(this,'special')\"></td>"
       ."</tr>"
       ."<tr>"
        ."<td>Number</td>"
        ."<td><input type=\"text\" name=\"to\" id=\"to\" onKeyup=\"isNumeric()\"><span id=phno1></span></td>"
       ."</tr>"
       ."<tr>"
        ."<td>Message</td>"
        ."<td><textarea name=text wrap=physical rows=4 cols=25 onkeyup=limiter()></textarea></td><br>"
     ."</tr>"
       ."<tr>"
       ."<td></td>"
      ."<td>Character left: <script type=\"text/javascript\">"
       ."document.write(\"<input type=text name=limit size=4 readonly value=\"+count+\">\");"
       ."</script><br></td>"
       ."</tr>"
       ."<tr>"
        ."<td> </td>"
        ."<td><input type=submit name=submit value=Send>"
        ."<div class=\"spacer\"></div></td>"
       ."</tr>"
       ."</table>"
       ."</form>"
    ."</div><br>";
    }

?>
</center>
</body>
</html>

Wednesday, 28 August 2013

Jquery Average Rating plugin Example

Disply average rating with decimal values from database in asp.net

Description:

In this example i will explain how to show average rating with decimal values in asp.net using jquery.

DataTable:Rate_table

Columnname Datatype AllowNulls

id int(set identity property=true) No

Rating float Yes

UserName varchar(50) Yes

After completion table design create new website using visual studio and Right click on your website >> select Add New Item >> Select Generic Handler and give name as RateHandle.ashx

C# Code:

<%@ WebHandler Language="C#" Class="RatingHandler" %>

using System;

using System.Data;

using System.Data.SqlClient;

using System.Web;

public class RatingHandler : IHttpHandler

{

public void ProcessRequest(HttpContext context)

{

SqlConnection con = new SqlConnection("Data Source=dhaval;Integrated Security=true;Initial Catalog=MySampleDB");

con.Open();

SqlCommand cmd = new SqlCommand("insert into Rate_Table(Rating,UserName) values(@rating,@name)", con);

cmd.Parameters.AddWithValue("@rating", context.Request.Form["rating"]);

cmd.Parameters.AddWithValue("@name", context.Request.LogonUserIdentity.Name);

cmd.ExecuteNonQuery();

cmd = new SqlCommand("select count(Id) as NumberOfUsers,sum(Rating) as Total from Rating_Table", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

da.Fill(dt);

float COUNT = float.Parse(dt.Rows[0]["NumberOfUsers"].ToString());

float RATING = float.Parse(dt.Rows[0]["Total"].ToString());

context.Response.ContentType = "text/plain";

try

{

float result = RATING / COUNT;

context.Response.Write(result.ToString("0.0"));

}

catch (Exception ex)

{

context.Response.StatusCode = 202;

context.Response.Write(ex.Message);

context.Response.Flush();

context.Response.End();

}

public bool IsReusable

{

get

{

return false;

}

After completion of write code in HttpHandler add following code in your aspx page

<title>Rating Demo</title>

$(function() {

$('#testRater').rater({ postHref: 'RatingHandler.ashx' });

});

</script>

</head>

<body>

<label for="rating">Rating</label>

<span class="rater-rating" id="rating" runat="server"></span> (<span class="rater-rateCount" id="count" runat="server"></span>)

</span>

</div>

</form>

</body>

</html>

After completion of aspx page design add the following namespaces in code behind

C# Code

using System;

using System.Data;

using System.Data.SqlClient;

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=Dhaval;Integrated Security=true;Initial Catalog=MySampleDB");

con.Open();

SqlCommand cmd = new SqlCommand("select count(Id) as NumberOfUsers,sum(Rating) as Total from Rate_Table", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

da.Fill(dt);

float count=0,rating=0,result=0;

if( Convert.ToInt32(dt.Rows[0]["NumberOfUsers"].ToString())!=0 )

{

count = float.Parse(dt.Rows[0]["NumberOfUsers"].ToString());

rating = float.Parse(dt.Rows[0]["Total"].ToString());

result = Convert.ToInt32(Math.Ceiling((rating / count) * 18));

avgrating.InnerText = Math.Round((rating / count), 1).ToString();

}

else

{

avgrating.InnerText = "0";

}

testSpan.Style.Add("width", result+"px");

userscount.InnerText = count.ToString();

}

Monday, 26 August 2013

Set recycle option in your admin panel.

Set recycle bin in your admin panel

php script for recycle option:
<?php
session_start();

$connect = mysql_connect("servername","username","password");
mysql_select("databasename");

$value=$_GET['value'];
if($value=="restore")
{
    $id=$_GET['id'];
    if($id!="")
    {
       $uid=$_SESSION['uid'];
       mysql_query("UPDATE portfolio SET Is_Deleted=0,Is_Active=1,Modified_By='$uid',Modified_Date=now() WHERE P_Id='$id';");
       //mysql_query("DELETE FROM loginmaster WHERE Login_Id='$id';");
       $msg="Blog Restored Successfully..!!";
    }
}
if($value=="delete")
{
    $id=$_GET['id'];
    if($id!="")
    {

       mysql_query("DELETE FROM portfolio WHERE P_Id='$id';");
       $msg="Package Permanantly Deleted..!!";
    }
}
    $select=mysql_query("SELECT * FROM portfolio WHERE Is_Deleted=1 ORDER BY P_Id desc;") or die(mysql_error());
    $count=mysql_num_rows($select);
    if($count==0)
       $msg1="No Data Found";
    $srno=0;

?>

this script for in your table:
<?php
    while($row=mysql_fetch_assoc($select))
    {

            $id= $row['P_Id'];
            $P_Name= $row['P_Name'];
            $Photo= $row['Photo'];
            $Website= $row['Website'];
            $srno=$srno+1;

            ?>
            <tr>
                <td align='center'><?php echo "$srno"; ?></td>
                <td align='center'><?php echo "$P_Name"; ?></td>
                <td align='center'><?php
                    if($Photo=="")
                    { echo "Empty";}
                    else
                        echo "<a href='Uploaded/$Photo' target='_blank'>Download</a>";
                ?>
                </td>
                <td align='center'><?php echo "$Website"; ?></td>
                <td align='center'><?php echo "<a href='ViewPo.php?value=View&id=$id'><img src='../Images/View.png' alt='View' title='View Record'></a>"; ?></td>
                <td align='center'><?php echo "<a href='RecyclePo.php?value=restore&id=$id'><img src='../Images/Restore.png' title='Restore Record' width='32px' height='32px'></a>"; ?></td>
                <td align='center' class="tdforfees1"><?php echo "<a href='RecyclePo.php?value=delete&id=$id' onclick='return confirmdelete();'><img src='../Images/Delete.png' title='Delete Record'></a>"; }?>

script for delete button:
<script type="text/javascript">
    function confirmdelete()
    {
        var Click=confirm("Are You Sure To Permenent Delete?");
        if(Click==true)
            return true;
        else
            return false;
    }
    </script>

Sunday, 25 August 2013

How to add images in your website using databse?

How to add images in your website using database?

<?php

//connect mysql//

$connect = mysql_connect("servername","username","password");

//select database//

mysql_select_db("databasename");

if($_POST['BtnSubmit'])
{
    $Name=$_POST['TxtName'];
    $Web=$_POST['Txtweb'];
    $Is_Active="1";
    $Is_Deleted="0";


    $filename = $_FILES["Photo"]["name"];
    $type = $_FILES["Photo"]["type"];
    $size = $_FILES["Photo"]["size"];
    $temp = $_FILES["Photo"]["tmp_name"];
    $error = $_FILES["Photo"]["error"];
    if($error >0)
       {
       }
    else
    {
       $fileext=explode('.',$filename);
       $fileext=$fileext[count($fileext)-1];
       $filename=$Name.'.'.$fileext;
       move_uploaded_file($temp,"Uploaded/".$filename);

       $query="INSERT INTO portfolio(P_Name,Photo,Website,Is_Active,Is_Deleted,Created_Date) VALUES('$Name','$filename','$Web',$Is_Active,$Is_Deleted,now());";
       $write=mysql_query($query);
       if($write)
           header('location:ListPo.php');
       else
           echo mysql_error();
    }




}

?>

Html code:

<form action="AddPo.php" method="post" onsubmit="return validation();" enctype="multipart/form-data">

    <table><tr><td><font color="#FFFFFF" size="+3" face="Lucida Handwriting"><strong>Add Portfolio</strong></font></td></tr></table><br />
    <table class='ImageBox1' align="center" >


        <tr>
            <td><input type="text" name="TxtName" id="TxtName" size="35" placeholder="Portfolio Name..!!" class="inputtext"/></td>
            <td style="padding-top:5px;"><font size="+3" color="#990000"> </font></td>
        </tr>

        <tr><td height="10px"></td></tr>

        <tr>
            <td>( Photo )<br /><input type="file" name="Photo" id="Photo" class="inputtext" size="27" placeholder="Photo"/></td>
            <td style="padding-top:5px;" valign="bottom"><font size="+3" color="#990000"> </font></td>
        </tr>

        <tr><td height="10px"></td></tr>

        <tr>
            <td><input type="text" name="Txtweb" id="Txtweb" size="35" placeholder="Website Name..!!" class="inputtext"/></td>
            <td style="padding-top:5px;"><font size="+3" color="#990000"> *</font></td>
        </tr>

        <tr>
            <td height="15px"></td>
        </tr>

        <tr>
            <td align="center">
                <input type="submit" value="Submit" name="BtnSubmit" class="botton" />
                <input type="reset" value="Reset" name="BtnReset" class="botton"/>
            </td>
        </tr>
    </table>

    </form>

Saturday, 24 August 2013

How to make login control in php?

Create a table in mysql

Table Name:member

id              int             primarykey, autoincrement
Firstname           varchar(20)
Lastname           varchar(20)
Email                 varchar(50)
Country             varchar(20)
Mobile             varchar(10)
Passwd              varchar(15)

Create Login box

<body>
    <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" >
    <h2 class="form-signin-heading"> Login</h2>
    <input type="text" name="Uname" size="20" placeholder="Username">
   <input type="password" name="Passwd" size="20" placeholder="Password"></br>
<input type="submit" value="Log In" >
</body>

PHP Script

<?php
    if(isset($_POST)&&!empty($_POST))
    {
        session_start();

        @$uname = $_SESSION['login'];
        $connect = mysql_connect("localhost","root","");
         mysql_select_db("login");

        $username = mysql_real_escape_string(stripslashes($_POST['Uname']));
        $passwd = mysql_real_escape_string(stripslashes($_POST['Passwd']));

        $select = mysql_query("SELECT * FROM member WHERE Uname = '$username' AND Passwd = '$passwd';");

        $numrow = mysql_num_rows($select);


        if($numrow!=0)
        {
            $_SESSION['login'] =$username;
            header("location:adminhome.php");
        }
        else
        {
            $_SESSION['login'] = "false";
            echo "<p>Login Failed, Username or Password Incorrect.</p>";
        }
    }


?>