<?php
$db = new mysqli('localhost', 'root', '', 'db_lms');
//Data fatching
$status = 'active';
$sql = $db->prepare("SELECT id, name, email FROM users WHERE `status` = 'active' ORDER BY id DESC");
// $sql->bind_param('s', $status);
$sql->execute();
$sql->store_result();
$sql->bind_result($id, $name, $email);
$sql->fetch();
$sql->close();
echo $id.') '.$name.' - '.$email;
//Data Insert
$id = $id+1;
$pass = '';
$status = 'active';
$sql = $db->prepare("INSERT INTO users (id, name, email, password, status) VALUES (?, ?, ?, ?, ?)");
$sql->bind_param('issss', $id, $name, $email, $pass, $status);
$sql->execute();
// $id = 17;
// $name = 'Gouranga';
// $email = 'gouranga@gmail.com';
// $sql = $db->prepare("UPDATE users SET name = ?, email = ? WHERE id = 18");
// $sql->bind_param('ss', $name, $email);
// echo $sql->execute();
// if($sql->execute()){
// echo 'Updated successfully';
// }
$id='13';
$sql->prepare("DELETE FROM users WHERE id=$id");
if ($sql->execute()) {
echo 'Deleted successfully';
}else {
echo 'Incorrect ID';
}
// print_r($result);
// $result = $sql->get_result();
// while($row = $result->fetch_assoc()){
// print_r($row);
// echo '<br /><br />';
// }
// echo password_hash('123', PASSWORD_DEFAULT);
// $pass = $_POST['pass'];
// $email = $_POST['email'];
// if($db->query("SELECT * FROM users WHERE `email` = '$email'")->num_rows > 0){
// $sql = $db->prepare("SELECT * FROM users WHERE `email` = ? AND `password` = ?");
// $sql->bind_param('ss', $email, $pass);
// $sql->execute();
// $result = $sql->get_result();
// // $row = $result->fetch_assoc();
// // print_r($row['name']);
// // if($result->num_rows > 0){
// // echo 'Login successful';
// // }else{
// // echo 'Login unsuccessful';
// // }
// }else{
// echo 'Login failed';
// }
// if(isset($_POST['email']) && isset($_POST['pass'])){
// $email = $_POST['email'];
// $pass = $_POST['pass'];
// if($db->query("SELECT * FROM users WHERE `email` = '$email'")->num_rows > 0){
// $pss = $db->query("SELECT * FROM users WHERE `email` = '$email'")->fetch_assoc()['password'];
// if(password_verify($pass, $pss)){
// echo 'Login successful';
// }else{
// echo 'Login unsuccessful';
// }
// } else {
// echo 'User not found';
// }
// }
// date_default_timezone_set("Asia/Kolkata");
// echo date("d-m-Y h:i:s A");
function sum($val=0, $val2=0) {
return $val + $val2;
}
function multiply($val=1, $val2=1) {
return $val * $val2;
}
echo sum(5,15);
echo '<br>';
echo multiply(0,5);
?>
<!--
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<form method="POST">
<input type="email" name="email" placeholder="Enter email id"><br>
<input type="text" name="pass" placeholder="password"><br><br>
<input type="submit" value="Submit">
</form>
</body>
</html> -->
Post a Comment