PHP Is Simple

Tuesday, 13 December 2022

PHP General Points

PHP

Front End of the application is developed using PHP.

With the help of PHP static part of the project could be easily bind with Back End.

As this is free software the same can be downloaded and deployed easily.

It is integrated with a number of Common databases, including PostgreSQL , MySQL, , Sybase, Informix, and Microsoft SQL Server.

PHP supports a large number of important protocols such as IMAP ,POP3, and LDAP.

PHP can handle forms, i.e. gather data from files, save in hard drive etc.

We add, delete, modify elements within our database using PHP.

We can easily handle cookies variables and set cookies.

Using PHP, you can restrict users to access some pages of your website using session.

It can encrypt data using various algorithms. Hashing can also be done.

Wednesday, 27 April 2022

Auto ID in forms

Hi all,

This has got three parts

1. Code in the form - saveform.php

<html>

<body>

<?php

include('dbconnect.php');

$mid=getid('student','sid');

Id <input type=text name=id1 value='<?php echo $mid; ?>' disabled >

Name <input type=text name=name><br>

</form>

</body>

</html>

2. Code in the save part -savestudent.php

<?php

$id=$_POST['id'];

echo $id;

include('dbconnect.php')

//DB insert query part

3. Include file - dbconnect.php

<?php

$con = mysql_connect("localhost","root","");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

mysql_select_db("anganwadi", $con);

function getid($tablename,$fieldid)

{

$query="select max($fieldid)+1 as mid from $tablename";

echo $query;

$data=mysql_query($query);

$maxid=0;

while($row=mysql_fetch_array($data))

{

$maxid=$row['mid'];

}

return $maxid;

}

Thursday, 8 April 2021

Refresh a page continually and retrieve from db

Hi all

Use settimeout function with php

Use this code on top of your program.

function hup()

{

location.href='predictions.php';

}

</script>

Monday, 22 February 2021

Retrieve IP address from httprequest using PHP

Hi All,

Use this line for IP address retrieval.

This can be used to verify authenticity of feedbacks.

<?php

$ipAddress = $_SERVER['REMOTE_ADDR'];

echo $ipAddress;

Monday, 7 September 2020

Python DB Connectivity and Serial Port Connection

HI,

Use this code

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

import mysql.connector

import time;

import serial;

from mysql.connector import Error

from mysql.connector import errorcode

ser = serial.Serial('COM3', 9600, timeout=0,parity=serial.PARITY_EVEN, rtscts=1)

try:

connection = mysql.connector.connect(host='localhost',

database='hupiot',

user='root',

password='hup')

cur = connection.cursor()

while True:

s=ser.read();

print(s);

time.sleep(1);

sql=("INSERT INTO timerecord (userid, recordtime, userrole ) VALUES (%s,%s,%s)")

val=("1",s,"1")

if s=="9":

cur.execute(sql,val)

connection.close()

except mysql.connector.Error as error :

connection.rollback() #rollback if any exception occured

print("Failed inserting record into python_users table {}".format(error))

Saturday, 20 June 2020

Hi All,
See how graph can be drawn using Google tools.

----------------------------------------------
Table structures

CREATE TABLE IF NOT EXISTS `graphdata` (
`id` int(11) NOT NULL,
`percentage` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `graphdata`
--

INSERT INTO `graphdata` (`id`, `percentage`) VALUES
(1, 80),
(2, 60);

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

<!DOCTYPE html>

<html>
<head>
<meta charset="UTF-8">
<title> PROJECT MANAGEMENT</title>
<link rel="stylesheet" href="css/style.css" type="text/css">
</head>
<body>
<?php
include'dbconnect.php';
$sql="delete from graphdata";
mysql_query($sql);

$sql="select distinct(pgid) as pgids from members";
$data=mysql_query($sql);
while($row=mysql_fetch_array($data))
{
$id=$row['pgids'];
echo $id."<br>";
$qr="select percentage from members where pgid='$id'";
echo $qr;
$sum=0;
$count=0;
$data1=mysql_query($qr);
$percentage=0;
while($row1=mysql_fetch_array($data1))
{
$count=$count+1;
$percentage=$percentage+$row1['percentage'];

}
$sum=$sum+$percentage;
$avg=$sum/$count;
mysql_query("insert into graphdata values('$id','$avg')");

}

?>
</body>
</html>
<!DOCTYPE html>
<html lang="en-US">
<body>

<h1>My Web Page</h1>

<div id="piechart"></div>

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>

<script type="text/javascript">
// Load google charts
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);

// Draw the chart and set the chart values
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Id', 'Percentage']
<?php
$sql="select * from graphdata,proreg where graphdata.id=proreg.id";
$data=mysql_query($sql);
while($row=mysql_fetch_array($data))
{
$id=$row['name'];
$avg=$row['percentage'];
?>

<?php
echo ",['$id', $avg]";
}
?>

]);

// Optional; add a title and set the width and height of the chart
var options = {'title':'My Average Day', 'width':550, 'height':400};

// Display the chart inside the <div> element with id="piechart"
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
}
</script>

</body>
</html>

Tuesday, 21 April 2020

Auto Id and File Upload

Hi All,
Find the code for Auto Id and File Upload in PHP...

CREATE TABLE IF NOT EXISTS `studentreg` (
`sid` int(11) NOT NULL,
`name` text NOT NULL,
`address` text NOT NULL,
`email` text NOT NULL,
`phone` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

------------------------------------------------
studentform.php
-----------------------------------------------------
<html>
<body>
<?php

$con=mysql_connect("localhost","root","");
mysql_select_db("snit",$con);

//Code to insert into both registration and Login table
if(isset($_POST['btnsubmit']))
{
$sql="insert into studentreg values('$_POST[id1]','$_POST

[name]','$_POST[address]','$_POST[email]','$_POST

[phone]')";
echo $sql;
$sql1="insert into login values('$_POST[id1]','$_POST[password]','student','0')";
mysql_query($sql,$con);
mysql_query($sql1,$con);

$target_dir = "uploads/";
$target_file=$target_dir .$_POST['id1'].'.jpg';
move_uploaded_file($_FILES["fileToUpload"]["tmp_name"],

$target_file) or die('Error'.mysql_error());

}

?>

<?php

//Auto generate next id in the screen.

//Query to get the highest value in table

$sql="select max(sid) as mid from studentreg";
$data=mysql_query($sql);
$id=0;
while($row=mysql_fetch_array($data))
{
$id=$row['mid'];
}

$id=$id+1;
echo $id;
?>
<form action=# method=post enctype="multipart/form-data">
<pre>
Id <input name=id disabled=disabled value="<?php echo

$id ; ?>" pattern="[a-zA-Z]{2,10}" title="Enter only

characters">
<input type=hidden name=id1 value="<?php echo $id ; ?>" >
Name <input name=name required=required maxlength=18>
Address <input name=address>
Email <input type=email name=email>
Phone <input name=phone pattern="[0-9]{10,12}">
Password<input name=password >
Photo <input type="file" name="fileToUpload"

id="fileToUpload">
<input type=submit name=btnsubmit value='Save'>
</pre>
</form>