PHP Is Simple

Tuesday, 15 October 2024

logout.php

Hi all

use this code

<?php

session_start();

unset($_SESSION['username']);

header('location:index.php');

user home page

Hi all

Use this code

//userhome.php

<!DOCTYPE html>

<?php

session_start();

echo 'Welcome '.$_SESSION['username'];

if(!isset($_SESSION['username']))

{

header('location:index.php');

}

<head>

<style>

body {

font-family: Arial, sans-serif;

background-color: #f4f4f4;

margin: 0;

padding: 0;

display: flex;

justify-content: center;

align-items: center;

height: 100vh;

}

.container {

text-align: center;

background-color: #fff;

padding: 30px;

border-radius: 8px;

box-shadow: 0 2px 10px rgba(0, 0, 0, 0.1);

}

h1 {

color: #333;

}

a {

display: inline-block;

margin: 10px;

padding: 10px 20px;

background-color: #007BFF;

color: #fff;

text-decoration: none;

border-radius: 4px;

transition: background-color 0.3s ease;

}

a:hover {

background-color: #0056b3;

}

</style>

</head>

<body>

<h1>Welcome to User Home</h1>

<p>Please select an option:</p>

<a href="profile.php">Go to Profile</a>

<a href="settings.php">Go to Settings</a>

<a href="viewpatient.php">View Patients</a>

<a href="logout.php">Logout</a>

</div>

</body>

</html>

Mysqli Login

Hi all,

Use this code

<?php

$username = $_POST['username'];

$password = $_POST['password'];

$count1 = substr_count($username, "'");

$count2 = substr_count($password, "'");

$err = 0;

if ($count1 > 0 || $count2 > 0) {

$err = 1;

}

// Create connection using MySQLi

include('dbconnect.php');

if (!$con) {

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

}

// Use prepared statements to avoid SQL injection

$sql = "SELECT * FROM tbl_login WHERE lg_username = '$username' AND lg_password = '$password' AND lg_status = '1'";

echo $sql;

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

$flag = 0;

$type = '';

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

$flag = 1;

$type = $row['lg_type'];

session_start();

$_SESSION['user'] = $type; // store session data

$_SESSION['username'] = $username;

}

echo $flag;

echo $type;

if ($err > 0) {

echo "<script>location.href='index.php?msg=Invalid Username or Password'</script>";

} else if ($flag == 1 && $type == "admin") {

echo "<script>location.href='adminhome.php'</script>";

} else if ($flag == 1 && $type == "user") {

echo "<script>location.href='userhome.php'</script>";

} else if ($flag == 1 && $type == "faculty") {

echo "<script>location.href='facultyhome.php'</script>";

} else {

echo "<script>location.href='index.php?msg=Invalid Username or Password'</script>";

}

// Close the connection

mysqli_close($con);

Delete row using Mysqli

Hi all,

Use this code

...............................

<?php

include('dbconnect.php');

// Use prepared statements to avoid SQL injection

$query = "delete FROM tbl_patient where id='$_GET[id]'";

mysqli_query($con, $query);

header('location:viewdoctor.php');

View table using Mysqli

Hi all

Use this code

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

<?php

include('dbconnect.php');

// Use prepared statements to avoid SQL injection

$query = 'SELECT * FROM tbl_patient';

$result = mysqli_query($con, $query); // mysqli_query replaces mysql_query

if (!$result) {

$message = 'ERROR: ' . mysqli_error($con); // mysqli_error replaces mysql_error

echo $message;

return;

} else {

echo '

<html>

<head>

<style>

table {

width: 80%;

border-collapse: collapse;

margin: 50px auto;

font-family: Arial, sans-serif;

background-color: #f2f2f2;

}

th, td {

border: 1px solid #ddd;

padding: 12px;

text-align: center;

}

th {

background-color: #4CAF50;

color: white;

}

tr:nth-child(even) {

background-color: #f9f9f9;

}

tr:hover {

background-color: #d1e0e0;

}

a {

color: red;

text-decoration: none;

}

a:hover {

text-decoration: underline;

}

</style>

</head>

<body>

<table>

<tr>';

// Fetch field names dynamically and create table headers

$fields = mysqli_fetch_fields($result); // mysqli_fetch_fields replaces mysql_fetch_field

foreach ($fields as $field) {

echo '<th>' . ucfirst($field->name) . '</th>';

}

echo '<th>Delete</th></tr>';

// Fetch table rows

while ($row = mysqli_fetch_row($result)) { // mysqli_fetch_row replaces mysql_fetch_row

echo '<tr>';

$idval = $row[0]; // Assume the first column is the id

foreach ($row as $cell) {

echo '<td>' . htmlspecialchars($cell) . '</td>'; // Use htmlspecialchars to prevent XSS

}

echo '<td><a href="delpatient.php?id=' . $idval . '">Delete</a></td>';

echo '</tr>';

}

echo '</table>

</body>

</html>';

mysqli_free_result($result); // mysqli_free_result replaces mysql_free_result

}

mysqli_close($con); // mysqli_close replaces mysql_close

Wednesday, 12 April 2023

Apriori Algorithm

import numpy as nm

import matplotlib.pyplot as mtp  
import pandas as pd 
from apyori import apriori  
import urllib.request

url="http://localhost/web/hupaddpairs.php?item1="

dataset = pd.read_csv('item_set1.csv')  
transactions=[]  
for i in range(0, 32):
    transactions.append([str(dataset.values[i,j])  for j in range(0,5)]) 

vals=""
rules= apriori(transactions= transactions, min_support=0.003, min_confidence = 0.2, min_lift=3, min_length=2, max_length=2) 
results= list(rules)  
for item in results:
    pair = item[0]   
    items = [x for x in pair]  
    print("Rule: " + items[0] + " -> " + items[1])  
    print("Support: " + str(item[1]))  
    print("Confidence: " + str(item[2][0][2]))  
    print("Lift: " + str(item[2][0][3]))  
    print("=====================================")  
    vals=url+items[0]+"&item2="+items[1]
    print(vals)
    webUrl = urllib.request.urlopen(vals)
    vals=""

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

Data

item_set1.csv

electronics.smartphone,	electronics.video.tv			
electronics.smartphone,	electronics.video.tv,appliances.kitchen.washer		
electronics.smartphone,	electronics.audio.headphone			
electronics.audio.headphone,electronics.smartphone	appliances.environment.vacuum,kids.skates

Tuesday, 13 December 2022

PHP and MySQL

MySql

Mysql is a powerful RDBMS.

Top companies in the world such as Youtube, Paypal, Linkedin, Facebook, Twitter, Cisco, Uber, Verizon, Github, Walmart, Flipcart, Alibaba, Paypal etc have adopted Mysql for this reason.

PHP programming language has built-in APIs for interacting with MySQL.

MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses.

MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often, MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python.