Get Complete Free Training in PHP,ANDROID,DIGITAL MARKETING : February 2015

Saturday 28 February 2015

PHP script for email verification or confirmation in php?

(1) first create table user:

create table user
(id int primary key auto_increment,

name varchar(200),
email varchar(200),
phone varchar(200),
password varchar(200),
com_code varchar(200));

(2)write code for connect.php file:

<?php

$con=mysql_connect("localhost","root","");
mysql_select_db("itexamtime",$con) or die(mysql_error());

?>

(3)write code for registerform.php file:
<?php

echo '<form action="insert1.php" method="post">
Name<input type=text name="name">
Email<input type=email name="email">
phone <input type=text name="phone">
password<input type=password name="password">
<input type=submit name=submit value=submit>';

?>

(4)write code for insert1.php file:

<?php
$name=$_POST['name'];
$email=$_POST['email'];
$phone=$_POST['phone'];
$password=$_POST['password'];
$com_code=md5(uniqid(rand()));
include_once("connect.php");

$sql="insert into user(name,email,phone,password,com_code)values('$name','$email','$phone','$password','$com_code')";

$result=mysql_query($sql) or die(mysql_error());

if($result)
{
$to = $email;
$subject = "Confirmation from TutsforWeb to $username";
$header = "ItexamTime: Confirmation LInk";

$message .= "http://funmoviemasti.com/confirm.php?passkey=$com_code";

$sentmail = mail($to,$subject,$message,$header);

if($sentmail)
{
echo "Your Confirmation link Has Been Sent To Your Email Address.";
}
else
{
echo "Cannot send Confirmation link to your e-mail address";
}

}

?>

(5)write code for confirm.php file:

<?php

include_once("connect.php");

$passkey = $_GET['passkey'];

$sql="update user set com_code='1' where com_code='$passkey'";

$result=mysql_query($sql) or die(mysql_error());

if($result)

{

echo "your account is active ";

}

?>

Friday 27 February 2015

PHP Script for Dynamic Drop down List

(1)create table account:

create table account
(
id int(5) primary key auto_increment,
name varchar(20),
contact varchar(20),
address varchar(200),
emailid varchar(20),
account varchar(20),
password varchar(20),
image varchar(200),
idproof varchar(200),
addressproof varchar(200));

(2)insert some values into table
(3) then use following code :

<html>
<head>
<title>
Deposit money
</title>
</head>

<body>
<form >
<select name=account>
<?php

include("connect.php");

$sql="select * from account";

$result=mysql_query($sql);

while($row=mysql_fetch_array($result))
{

echo '<option value="'.$row['id'].'">';

echo $row['id'];

echo '</option>';

}

?>
</select>
<form>
</body>
</html>

Undefined Index problem in PHP

this problem comes when you do not declare name
so overcome this use following code:

$mobile=isset($_POST['mobile']) ? $_POST['mobile'] : 'Null';

Thursday 26 February 2015

PHP script for file Upload

PHP script for file Upload

(1)step 1: write code for "slider.html"

<form action="sliderupload.php" method="post" enctype="multipart/form-data">
UPload<input type="file" name="image">
<input type="submit" name="submit" value="Upload">

</form>

(2)step 2: write code for "sliderupload.html"

<?php

$image=$_FILES['image']['name'];

include("connect.php");

$sql="insert into slider(image)values('$image')";

mysql_query($sql) or die(mysql_errror());

move_uploaded_file($_FILES['image']['tmp_name'],"slider/".$_FILES['image']['name']) or die(mysql_error());

?>

(3)write code for class.php file :

<?php

class db

{

var $host="servername";

var $username="username";

var $password="password";

function connect()
{

$connect=mysql_connect($this->host,$this->username,$this->password);

mysql_select_db("a1390987_om",$connect) or die(mysql_error());

if(!$connect)
{

echo "connection error ";
}

}

function display($table)
{

$sql="select * from $table ";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

return $row;

}

}

$obj=new db();
$obj->connect();

?>

(4)use img tag to display image & write following code for displayslider.php:

<?php

include("class.php");

$table="slider";

$slider=$obj->display($table);

$image=$slider['image'];

echo $image;

echo "<img src='slider/".$image."' height=200 width=200 border=10 >";

?>

PHP Script for Admin login with session management & Logout

(1)first write following code for Login form "loginform.html" file

<form action="login.php" method="post">
<table border=0>
<tr><td>User name:</td>
<td>
<input name="username" type="TEXT"></td> </tr>
<tr><td>Password</td><td>
<input name="Password" type="PASSWORD"></td>
</tr>

<tr>
<td></td><td><input value="submit" name="SubmitUser" type="submit"></td>
</form>
</tr>
</table>

(2) Then write code for "login.php" file

<?php

$username=$_POST['username'];
$password=$_POST['password'];
$con=mysql_connect("hostname","username","password") or die(mysql_error());

mysql_select_db("databasename",$con);

$sql="select username,password from login where username='$username' AND password='$password'";

$result=mysql_query($sql) or die(mysql_error());

$num=mysql_num_rows($result) or die(mysql_error());

if($num>0)
{

session_start();

$_SESSION['username']=$username;

header("Location:dashboard.php");

}

else if($num==0)
{
header("Location:error.php");
}

?>

(3)Session management code:

<?php

session_start();
if(!isset($_SESSION['username']))
{

header("Location:index.php");

}

?>
NOte:
write this code on every your page starting or simply save it as

session.php & on every page use it as

<?php include("session.php"); ?>

(4)Logout code : save file name as "logout.php"

see below code:

<?php

session_start();

session_destroy();

header("Location:loginform.html");

?>

Tuesday 24 February 2015

how to use ckeditor in php ?
(1)download   (ckeditor_3.6.6)
(2)user following code to link:
<?php
    include("ckeditor/ckeditor.php");
    $CKeditor = new CKeditor();
    $CKeditor->BasePath = 'ckeditor/';
    $CKeditor->editor('editor1');
?>

& use can also use another following code :

<?php require("ckeditor/ckeditor.php"); ?>

<script type="text/javascript" src="ckeditor/ckeditor.js"></script>
<script type="text/javascript" src="somedirectory/ckeditor/ckeditor.js"></script>

<textarea class="ckeditor" name="editor1">Write any thing</textarea>

Wednesday 18 February 2015

Login page code in PHP

(1)first create file index.html

<form action="login.php" method="post">
                    <span class="loginText">User name:</span><br>
                                         <input name="username" type="TEXT"><br>
                                         <span class="loginText">Password:</span><br>
                                         <input name="Password" type="PASSWORD">
                                         <br>
                                         <span class="loginText">login as user: <i>demo</i><br>with password: <i>anahaw</i></span>
                                        </td>
                                    </tr>

                                    <tr>
                                        <td align="right"><input value="submit" name="SubmitUser" type="submit"></td>
                                        </form>

(2)create login.php file

<?php

$username=$_POST['username'];
$password=$_POST['Password'];
$con=mysql_connect("localhost","root","") or die(mysql_error());

mysql_select_db("payroll",$con);

$sql="select username,password from login where username='$username' AND password='$password'";

$result=mysql_query($sql) or die(mysql_error());

$num=mysql_num_rows($result) or die(mysql_error());

if($num>0)
{
session_start();
$_SESSION['username']=$username;
header("Location:welcome.php");

}

else
{
echo "invalid login";
}

?>

Pagination in PHP

<?php

    mysql_connect("localhost","root","")or die("Problems...");
    mysql_select_db("payroll");

    $per_page = 2;
    $pages_query = mysql_query("SELECT COUNT('id') FROM employee");
   echo $pages_query."<br>";
    $pages = ceil(mysql_result($pages_query, 0) / $per_page);
   echo $pages;

    $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
    $start = ($page - 1) * $per_page;

    $query = mysql_query("SELECT * FROM employee LIMIT $start, $per_page");

    while($row = mysql_fetch_assoc($query))


   {



echo '<form action=update.php method=post      enctype="multipart/form-data">
<table border=1 cellspacing=3 cellpadding=2 bgcolor=orange bordercolor=black>
<tr><td>DATE OF SIGN UP</td><td><INPUT TYPE=TEXT NAME="name" value="'.$row['name'].'"></td></tr>
<tr><td>NAME</TD><td><INPUT TYPE=TEXT NAME="phone"      value="'.$row['phone'].'"></td></tr>
<tr><td>ADDRESS</TD><TD><input type=text name="salary"        value="'.$row['salary'].'"></td></tr>

<tr><td> </td><td>
<input type=hidden name=hidden value="'.$row['emp_id'].'">
<input type=submit name=update value=update></td></tr>

</TABLE>

</FORM>';




    }

    $prev = $page - 1;
    $next = $page + 1;

    if(!($page<=1)){
        echo "<a href='pagination1.php?page=$prev'>Prev</a> ";
    }

    if($pages>=1 && $page<=$pages){

        for($x=1;$x<=$pages;$x++){
            echo ($x == $page) ? '<strong><a href="?page='.$x.'">'.$x.'</a></strong> ' : '<a href="?page='.$x.'">'.$x.'</a> ';

        }

    }

    if(!($page>=$pages)){
        echo "<a href='pagination1.php?page=$next'>Next</a>";
    }


?>

Ajax with PHP & Mysql database

(1) create file index.html

<html>
<head>
<script>
function showUser() {
    if (str == "") {
        document.getElementById("txtHint").innerHTML = "";
        return;
    } else {
        if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                document.getElementById("txtHint").innerHTML = xmlhttp.responseText;
            }
        }
        xmlhttp.open("GET","getuser.php?",true);
        xmlhttp.send();
    }
}
</script>
</head>
<body>

<form name="users" onclick="showUser()">

<input type=submit value=submit   >

</form>
<form>
<select name="users" onchange="showUser()">
<option value="">Select a person:</option>
<option value="1">Peter Griffin</option>
<option value="2">Lois Griffin</option>
<option value="3">Joseph Swanson</option>
<option value="4">Glenn Quagmire</option>
</select>
</form>
<br>
<div id="txtHint"><b>Person info will be listed here...</b></div>

</body>
</html>

(2) then create file

getuser.php

<!DOCTYPE html>
<html>
<head>
<style>
table {
    width: 100%;
    border-collapse: collapse;
}

table, td, th {
    border: 1px solid black;
    padding: 5px;
}

th {text-align: left;}
</style>
</head>
<body>

<?php
//$q = intval($_GET['q']);

$con = mysqli_connect('localhost','root','','my_db');
if (!$con) {
    die('Could not connect: ' . mysqli_error($con));
}

mysqli_select_db($con,"ajax_demo");
//$sql="SELECT * FROM user WHERE id = '".$q."'";

$sql="SELECT * FROM user";

$result = mysqli_query($con,$sql);

echo "<table>
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Age</th>
<th>Hometown</th>
<th>Job</th>
</tr>";
while($row = mysqli_fetch_array($result)) {
    echo "<tr>";
    echo "<td>" . $row['FirstName'] . "</td>";
    echo "<td>" . $row['LastName'] . "</td>";
    echo "<td>" . $row['Age'] . "</td>";
    echo "<td>" . $row['Hometown'] . "</td>";
    echo "<td>" . $row['Job'] . "</td>";
    echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>
</body>
</html>