Untitled



***************************************************************************************************************

<html>
<head>
<style>
body {
    background-color: white;
}
h1 {
text-align: center;}

#name1,#email1{

border: 2px solid green;
margin-left:2px;
text-align: center;
padding-left:200px;
}
#email1{
    letter-spacing:0.05em;
}
input,select{
float:right;
width:200px;
}
textarea{
width:500px;

}

</style>


<link rel="icon" type="image/jpg" href="DSC_0762 (2).jpg">

</head>

<body>
<div style="border: 5px solid green; background-color: lightblue; margin-left:400px; margin-right:400px; border-radius:30px; padding-right:10px; padding-left:10px">
<h1> Course Information </h1>
<form>


<span id="name1"> Name: </span>
  <input type="text" name="name">

  <br><br>
 <span id="email1"> Email:</span>
  <input type="email" name="email">
  <br><br>

    Gender:
  <select name="Gender">
  <option value="male">Male</option>
  <option value="Female">Female</option>
  <option value="others">Others</option>
</select><br><br>

  Date of birth :
  <input type="date" name="Date"><br><br>ss
   Course Name:
  <input type="text" name="cname"><br><br>
    Course Code:
  <input type="text" name="code"><br><br>
    Slot:
  <select name="Slot">
  <option value="L23+L24">L23+L24</option>
  <option value="L21+L22">L21+L22</option>
  <option value="L47+L48">L47+L48</option>
</select><br><br>
Mobile number:
  <input type="text" name="mobile"><br><br>


  <textarea name="message" rows="10" cols="30">
Remarks.


********************************************************************************************************************8

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";

if (mysqli_query($conn, $sql)) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>

********************************************************************************************************************************88


<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com');";
$sql .= "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('Mary', 'Moe', 'mary@example.com');";
$sql .= "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('Julie', 'Dooley', 'julie@example.com')";

if (mysqli_multi_query($conn, $sql)) {
    echo "New records created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>


***************************************************************************************************************8


<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
    }
} else {
    echo "0 results";
}

mysqli_close($conn);
?>

******************************************************************************************************

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "UPDATE MyGuests SET lastname='Doe' WHERE id=2";

if (mysqli_query($conn, $sql)) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . mysqli_error($conn);
}

mysqli_close($conn);
?>


*****************************************************************************************************8

<!DOCTYPE html>
<html>
<body>

<?php
$myfile = fopen("webdictionary.txt", "r") or die("Unable to open file!");
echo fgets($myfile);
fclose($myfile);
?>

</body>
</html>