PHP Assignment Help-154273

TASK – PHP

image1

Image2

image3

image4

image5

Solution :

ADD PHP:

<style>

 

html { height: 100% }

::-moz-selection { background: #fe57a1; color: #fff; text-shadow: none; }

::selection { background: #fe57a1; color: #fff; text-shadow: none; }

body { background-image: radial-gradient( cover, rgba(92,100,111,1) 0%,rgba(31,35,40,1) 100%), url(‘http://i.minus.com/io97fW9I0NqJq.png’) }

.login {

background: #eceeee;

border: 1px solid #42464b;

border-radius: 6px;

height: 257px;

margin: 20px auto 0;

width: 298px;

}

.submit h1 {

background-image: linear-gradient(top, #f1f3f3, #d4dae0);

border-bottom: 1px solid #a6abaf;

border-radius: 6px 6px 0 0;

box-sizing: border-box;

color: #727678;

display: block;

height: 43px;

font: 600 14px/1 ‘Open Sans’, sans-serif;

padding-top: 14px;

margin: 0;

text-align: center;

text-shadow: 0 -1px 0 rgba(0,0,0,0.2), 0 1px 0 #fff;

}

input[type=”date”], input[type=”text”] {

background: url(‘http://i.minus.com/ibhqW9Buanohx2.png’) center left no-repeat, linear-gradient(top, #d6d7d7, #dee0e0);

border: 1px solid #a1a3a3;

border-radius: 4px;

box-shadow: 0 1px #fff;

box-sizing: border-box;

color: #696969;

height: 39px;

margin: 31px 0 0 29px;

padding-left: 37px;

transition: box-shadow 0.3s;

width: 240px;

}

input[type=”date”]:focus, input[type=”text”]:focus {

box-shadow: 0 0 4px 1px rgba(55, 166, 155, 0.3);

outline: 0;

}

.show-password {

display: block;

height: 16px;

margin: 26px 0 0 28px;

width: 87px;

}

 

 

.toggle {

background: url(http://i.minus.com/ibitS19pe8PVX6.png) no-repeat;

display: block;

height: 16px;

margin-top: -20px;

width: 87px;

z-index: -1;

}

 

.forgot:hover { color: #3b3b3b }

input[type=”submit”] {

width:240px;

height:35px;

display:block;

font-family:Arial, “Helvetica”, sans-serif;

font-size:16px;

font-weight:bold;

color:#fff;

text-decoration:none;

text-transform:uppercase;

text-align:center;

text-shadow:1px 1px 0px #37a69b;

padding-top:6px;

margin: 29px 0 0 29px;

position:relative;

cursor:pointer;

border: none;

background-color: #37a69b;

background-image: linear-gradient(top,#3db0a6,#3111);

border-top-left-radius: 5px;

border-top-right-radius: 5px;

border-bottom-right-radius: 5px;

border-bottom-left-radius:5px;

box-shadow: inset 0px 1px 0px #2ab7ec, 0px 5px 0px 0px #497a78, 0px 10px 5px #999;

}

 

.shadow {

background: #000;

border-radius: 12px 12px 4px 4px;

box-shadow: 0 0 20px 10px #000;

height: 12px;

margin: 30px auto;

opacity: 0.2;

width: 270px;

}

 

 

input[type=”submit”]:active {

top:3px;

box-shadow: inset 0px 1px 0px #2ab7ec, 0px 2px 0px 0px #31524d, 0px 5px 3px #999;

}

 

</style>

<html>

<body>

<form action=”add2.php” method=”post”>

<div>

Name            :<input type=”text” name=”name” placeholder = “Name” required><br>

Date of Birth   :<input type=”date” name=”date” required><br>

<input type=”submit” value=”submit”>

</div>

<div></div>

</form>

</body>

</html>

<?php

if (isset($_GET[‘mess’]))

{

$m = $_GET[‘mess’];

echo ‘<script language=”javascript”>alert(“‘.$m.'”);</script>’;

}

 

 

ADD1 PHP

 

 

<?php

 

include (“dbcon.php”);

 

$name=$_POST[‘name’];

$date=$_POST[‘date’];

 

if (strlen($name)<100)

{

$insert=”INSERT INTO person(id,name,birth_date) VALUES (”, ‘$name’, ‘$date’)”;

$a=mysqli_query($cn,$insert);

 

/*if($a)

{

echo “<script type=\”text/javascript\”>.”alert(‘Succes’);”.”</script>”;

}*/

if($a)

{

$redirectUrl = ‘add.php’;

echo ‘<script type=”application/javascript”>       alert(“Succesfully Added”); window.location.href = “‘.                   $redirectUrl.'”;</script>’;

}

else

{

echo “Error!”. mysql_error();

}

}

else

{

echo “input is very high please select less then 100 words”;

echo “<html></br><a href=\”add.php\”>back</a></html>”;

}

?>

 

 

ADD2 PHP

 

<?php

 

include (“dbcon.php”);

 

$name=$_POST[‘name’];

$date=$_POST[‘date’];

 

if (strlen($name)<100)

{

$insert=”INSERT INTO person(id,name,birth_date) VALUES (”, ‘$name’, ‘$date’)”;

$a=mysqli_query($cn,$insert);

 

/*if($a)

{

echo “<script type=\”text/javascript\”>.”alert(‘Succes’);”.”</script>”;

}*/

if($a)

{

header(‘location:add.php?mess=success’);

}

else

{

echo “Error!”. mysql_error();

}

}

else

{

echo “input is very high please select less then 100 words”;

echo “<html></br><a href=\”add.php\”>back</a></html>”;

}

?>

 

ADDp PHP

 

<html>

<body>

<form action=”log.php” method=”post”>

UserName: <input type=”text” name=”username” required><br>

Password: <input type=”password” name=”password” required><br>

<input type=”submit” value=”Login”>

</form>

</body>

</html>

 

ADDR PHP

 

<?php

include(“dbcon.php”);

$sql=”select *from person”;

$rs=mysql_query($sql);?>

<form action=”instrel.php” method=”post” >

<select name=”s1″ required >

<option value=””>Select Parent</option>

<?php while($rw=mysql_fetch_array($rs)){ ?>

 

 

 

 

 

<option value=”<?php echo $rw[‘id’]?>”><?php echo $rw[‘name’]?></option>

<?php  }

 

?></select> <?php

$sql2=”select *from person”;

$rs2=mysql_query($sql2);?>

<select name=”s2″ required >

<option value=””>Select Child</option>

<?php while($rw2=mysql_fetch_array($rs2)){ ?>

 

<option value=”<?php echo $rw2[‘id’]?>”><?php echo $rw2[‘name’]?></option>

<?php  }

?></select>

<input type=”submit” name=”ADD” value=”ADD RELATION” />

</form>

 

 

CONNECTION PHP

 

<?php

$servername = “localhost”;

$username = “root”;

$password = “”;

 

// Create connection

$conn = new mysqli($servername, $username, $password);

 

// Check connection

if ($conn->connect_error) {

die(“Connection failed: ” . $conn->connect_error);

}

echo “Connected successfully”;

?>

 

DBCON PHP

 

<?php

$cn=@mysqli_connect(‘127.0.0.1′,’root’,”) or die(“cannot connect to the host”);

mysqli_select_db($cn,’family’) or die(“cannot select database”);

?>

 

FAMILY SQL

 

— phpMyAdmin SQL Dump

— version 4.5.1

— http://www.phpmyadmin.net

— Host: 127.0.0.1

— Generation Time: May 08, 2016 at 06:46 PM

— Server version: 10.1.9-MariaDB

— PHP Version: 7.0.0

 

SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;

SET time_zone = “+00:00”;

 

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

 

— Database: `family`

 

— ——————————————————–

 

— Table structure for table `parent`

 

CREATE TABLE `parent` (

`parent_id` int(5) NOT NULL,

`child_id` int(5) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

— Dumping data for table `parent`

 

INSERT INTO `parent` (`parent_id`, `child_id`) VALUES

(1, 3),

(8, 3),

(5, 1),

(9, 1);

 

— ——————————————————–

 

— Table structure for table `person`

 

CREATE TABLE `person` (

`id` int(5) NOT NULL,

`name` char(100) NOT NULL,

`birth_date` varchar(10) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

— Dumping data for table `person`

 

INSERT INTO `person` (`id`, `name`, `birth_date`) VALUES

(1, ‘Andrea Pirlo’, ‘1975-06-15’),

(2, ‘David Silva’, ‘1976-05-03’),

(3, ‘Mario Götze’, ‘1995-02-12’),

(4, ‘Joao Moutinho’, ‘1960-12-09’),

(5, ‘Diego Forlan’, ‘1950-11-24’),

(6, ‘Marek Hamsik’, ‘1999-06-20’),

(7, ‘Jonelle Filigno’, ‘1975-04-08’),

(8, ‘ANOUK HOOGENDIJK’, ‘1976-02-15’),

(9, ‘Julia Simic’, ‘1950-12-12’);

 

— Indexes for dumped tables

 

— Indexes for table `person`

ALTER TABLE `person`

ADD PRIMARY KEY (`id`);

 

— AUTO_INCREMENT for dumped tables

 

— AUTO_INCREMENT for table `person`

ALTER TABLE `person`

MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

 

 

INDEX PHP

 

 

<html>

<head>

<style>

html { height: 100% }

::-moz-selection { background: #fe57a1; color: #fff; text-shadow: none; }

::selection { background: #fe57a1; color: #fff; text-shadow: none; }

body { background-image: radial-gradient( cover, rgba(92,100,111,1) 0%,rgba(31,35,40,1) 100%), url(‘http://i.minus.com/io97fW9I0NqJq.png’) }

.login {

background: #eceeee;

border: 1px solid #42464b;

border-radius: 6px;

height: 257px;

margin: 20px auto 0;

width: 298px;

}

.login h1 {

background-image: linear-gradient(top, #f1f3f3, #d4dae0);

border-bottom: 1px solid #a6abaf;

border-radius: 6px 6px 0 0;

box-sizing: border-box;

color: #727678;

display: block;

height: 43px;

font: 600 14px/1 ‘Open Sans’, sans-serif;

padding-top: 14px;

margin: 0;

text-align: center;

text-shadow: 0 -1px 0 rgba(0,0,0,0.2), 0 1px 0 #fff;

}

input[type=”password”], input[type=”text”] {

background: url(‘http://i.minus.com/ibhqW9Buanohx2.png’) center left no-repeat, linear-gradient(top, #d6d7d7, #dee0e0);

border: 1px solid #a1a3a3;

border-radius: 4px;

box-shadow: 0 1px #fff;

box-sizing: border-box;

color: #696969;

height: 39px;

margin: 31px 0 0 29px;

padding-left: 37px;

transition: box-shadow 0.3s;

width: 240px;

}

input[type=”password”]:focus, input[type=”text”]:focus {

box-shadow: 0 0 4px 1px rgba(55, 166, 155, 0.3);

outline: 0;

}

.show-password {

display: block;

height: 16px;

margin: 26px 0 0 28px;

width: 87px;

}

input[type=”checkbox”] {

cursor: pointer;

height: 16px;

opacity: 0;

position: relative;

width: 64px;

}

input[type=”checkbox”]:checked {

left: 29px;

width: 58px;

}

.toggle {

background: url(http://i.minus.com/ibitS19pe8PVX6.png) no-repeat;

display: block;

height: 16px;

margin-top: -20px;

width: 87px;

z-index: -1;

}

input[type=”checkbox”]:checked + .toggle { background-position: 0 -16px }

.forgot {

color: #7f7f7f;

display: inline-block;

float: right;

font: 12px/1 sans-serif;

left: -19px;

position: relative;

text-decoration: none;

top: 5px;

transition: color .4s;

}

.forgot:hover { color: #3b3b3b }

input[type=”submit”] {

width:240px;

height:35px;

display:block;

font-family:Arial, “Helvetica”, sans-serif;

font-size:16px;

font-weight:bold;

color:#fff;

text-decoration:none;

text-transform:uppercase;

text-align:center;

text-shadow:1px 1px 0px #37a69b;

padding-top:6px;

margin: 29px 0 0 29px;

position:relative;

cursor:pointer;

border: none;

background-color: #37a69b;

background-image: linear-gradient(top,#3db0a6,#3111);

border-top-left-radius: 5px;

border-top-right-radius: 5px;

border-bottom-right-radius: 5px;

border-bottom-left-radius:5px;

box-shadow: inset 0px 1px 0px #2ab7ec, 0px 5px 0px 0px #497a78, 0px 10px 5px #999;

}

 

.shadow {

background: #000;

border-radius: 12px 12px 4px 4px;

box-shadow: 0 0 20px 10px #000;

height: 12px;

margin: 30px auto;

opacity: 0.2;

width: 270px;

}

 

 

input[type=”submit”]:active {

top:3px;

box-shadow: inset 0px 1px 0px #2ab7ec, 0px 2px 0px 0px #31524d, 0px 5px 3px #999;

}

 

</style>

<body>

 

<form action=”log.php” method=”post”>

<div class=”login”>

UserName: <input type=”text” name=”username” placeholder=”Username” required><br>

Password: <input type=”password” name=”password” placeholder=”password” required><br>

<input type=”submit” value=”Login”>

</div>

<div class=”shadow”></div>

</form>

</body>

</html>

 

INSTREL PHP

 

<?php

 

include (“dbcon.php”);

 

$parent_id=$_POST[‘s1’];

$child_id=$_POST[‘s2’];

 

$insert=”INSERT INTO parent(parent_id,child_id) VALUES (‘$parent_id’, ‘$child_id’)”;

if(mysql_query($insert));

//$query =new mysqli($insert)or die (mysql_error());

 

?>

 

LOG PHP

 

<?php

//session_start();

$username=$_POST[‘username’];

$password=$_POST[‘password’];

$hashed_password = crypt(‘password123’);

 

$admin=”admin”;

$password1= hash_equals($hashed_password, crypt($password, $hashed_password));

if ($username==$admin && $password==$password1)

{

//$_SESSION[‘user’]=$username;

//echo “$username”;

header (“location:add.php”);

}

else

{

header (“location:index.php”);

//echo “please enter correct username and password”;

}

?>

 

LOGIN PHP

 

<?php

session_start();

$username=$_POST[‘username’];

$password=$_POST[‘password’];

 

if ($username==’admin’ && $password=’pasword123′)

{

header (“location:add.php”);

}

else

{

header (“location:index.php”);

}

?>

 

 

PERSON PHP

 

<?php

include(“dbcon.php”);

$sql=”select *from person”;

$rs=mysql_query($sql);?>

<table border=”1″>

<tr>

<th>ID</th>

<th>Name</th>

<th>Date Of birth</th></tr>

<?php while($rw=mysql_fetch_array($rs)){ ?>

<tr>

<tr>

 

<td><?php echo $rw[‘id’]?>  </td>

<td><?php echo $rw[‘name’]?>  </td>

<td><?php echo $rw[‘birth_date’]?>  </td>

</tr>

<?php  }

 

?></table>