MCP gallery
Posts
College db php
<?php $server_name="sql12.freesqldatabase.com"; $username="sql12738410"; $password="nS8SynW1uW"; $database_name="sql12738410"; $conn=mysqli_connect($server_name,$username,$password,$database_name); //now check the connection if(!$conn) { die("Connection Failed:" . mysqli_connect_error()); } if(isset($_POST['save'])) { $Name = isset($_POST['Name']) ? $_POST['Name'] : ''; $Technology = isset($_POST['Technology']) ? $_POST['Technology'] : ''; $Year = isset($_POST['Year']) ? $_POST['Year'] : ''; $Roll_no = isset($_POST['Roll_no']) ? $_POST['Roll_no'] : ''; $Phone = isset($_POST['Phone']) ? $_POST['Phone'] : ''; $Message = isset($_POST['Message']) ? $_POST['Message'] : ''; if($Name && $Technology && $Year && $Roll_no && $Ph...
College DB css
* { margin: 0; padding: 0; box-sizing: border-box; } body { font-family: 'Arial', sans-serif; background: linear-gradient(135deg, #3498db, #2ecc71); /* Blue to Green Gradient */ display: flex; justify-content: center; align-items: center; height: 100vh; } .form-container { background-color: rgba(255, 255, 255, 0.1); padding: 20px; border-radius: 15px; box-shadow: 0 0 30px rgba(255, 255, 255, 0.2); width: 350px; backdrop-filter: blur(10px); } h2 { text-align: center; margin-bottom: 20px; color: #fff; font-weight: bold; text-transform: uppercase; } label { display: block; margin-bottom: 5px; color: #fff; font-weight: bold; letter-spacing: ...
College DB html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Student Form</title> <link rel="stylesheet" href="styles.css"> </head> <body> <div class="form-container"> <h2>Contact Form</h2> <form action="connect.php" method="post"> <label for="name">Name:</label> <input type="text" id="name" name="Name" required> <label for="technology">Technology:</label> <select id="technology" name="Technology" required> <option value="CIT">CIT</...
PhP
<?php $server_name="sql12.freesqldatabase.com"; $username="sql12738410"; $password="nS8SynW1uW"; $database_name="sql12738410"; $conn=mysqli_connect($server_name,$username,$password,$database_name); //now check the connection if(!$conn) { die("Connection Failed:" . mysqli_connect_error()); } if(isset($_POST['save'])) { $Name = $_POST['Name']; $Email = $_POST['Email']; $Phone = $_POST['Phone']; $Service = $_POST['Service']; $Message = $_POST['Message']; $sql_query = "INSERT INTO Contact(Name,Email,Phone,Service,Message) VALUES ('$Name','$Email','$Phone','$Service','$Message')"; if (mysqli_query($conn, $sql_query)) { echo "New Details Entry inserted successfully !"; } else { echo "Error: " . $sql . "" . mysqli_error($conn); } mysqli_close($conn); } ?>
HTmL
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>A Sample Tutorial for Database Connection</title> <style> body { background-color: #32e692; font-family: 'Verdana', sans-serif; margin: 0; padding: 0; display: flex; justify-content: center; align-items: center; height: 100vh; } .container { width: 100%; max-width: 500px; padding: 20px; background-color: white; border-radius: 10px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); } h1 { text-align: center; color: #333; margin-bottom: 20px; font-size: 24px; } form { width: 100%; } table {...
Detail
Host: sql12.freesqldatabase.com Database name: sql12738410 Database user: sql12738410 Database password: nS8SynW1uW Port number: 3306 http://www.phpmyadmin.co
Php
<?php $name = $_POST['name']; $email = $_POST['email']; $phone = $_POST['phone']; $service = $_POST['service']; $message = $_POST['message']; //connection $conn = new mysqli('localhost:3306', 'root', '', 'test'); if($conn->connect_error){ die('Connection failed: '.$conn->connect_error); } else{ $stmt = $conn->prepare("INSERT INTO contact (name, email, phone, service, message) VALUES (?, ?, ?, ?, ?)"); $stmt->bind_param("ssiss", $name, $email, $phone, $service, $message); $stmt->execute(); echo "Contact Form sent successfully."; $stmt->close(); $conn->close(); } ?>
Css
* { box-sizing: border-box; margin: 0; padding: 0; font-family: Arial, sans-serif; } body { background-color: #f4f4f4; display: flex; justify-content: center; align-items: center; height: 100vh; } .contact-form-container { background-color: #fff; padding: 20px; border-radius: 8px; box-shadow: 0 2px 10px rgba(0, 0, 0, 0.1); width: 100%; max-width: 400px; } h2 { text-align: center; margin-bottom: 20px; } form { display: flex; flex-direction: column; } label { margin-bottom: 5px; font-weight: bold; } input, textarea, select { padding: 10px; margin-bottom: 15px; border: 1px solid #ccc; border-radius: 4px; width: 100%; } button ...
Html
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Contact Form</title> <link rel="stylesheet" href="styles.css"> </head> <body> <div class="contact-form-container"> <h2>Contact Us</h2> <form action="connect.php" method="POST"> <label for="name">Name:</label> <input type="text" id="name" name="name" required> <label for="email">Email:</label> <input type="email" id="email" name="email" required> <label for="phone">Phone Number:</label...
