हेल्लो दोस्तों आज के पोस्ट में हम आपको php crud के बारे में बतायेंगे की कैसे किया जाता है साथ ही इसका प्रोग्राम के साथ आप इसका आउटपुट को भी देख सकते है
<?php include "toastrlink.php"; #------Now Connection ---------# $conn = mysqli_connect("localhost","root","","ajax_crud"); if($conn){ ?> <script type='text/javascript'> toastr.success('Connection Successfully'); </script> <?php }else{ die("Connection Failed".mysqli_connect_error()); } ?>
<script> function myFunction() { var x = document.getElementById("password"); var x1 = document.getElementById("confirm-password"); // alert(x); if (x.type === "password" && x.type === "password") { x.type = "text"; x1.type = "text"; } else { x.type = "password"; x1.type = "password"; } } </script>
<?php include "dbConnect.php"; ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0/dist/css/bootstrap.min.css"> <link href="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/2.0.1/css/toastr.css" rel="stylesheet"/> <link rel="stylesheet" href="style.css"> </head> <body> <section> <div class="container"> <form id="signup" class="form"> <h1>Sign Up</h1> <div class="form-field"> <label for="username">Username:</label> <input type="text" name="username" id="username" autocomplete="off"> <small></small> </div> <div class="form-field"> <label for="email">Email:</label> <input type="text" name="email" id="email" autocomplete="off"> <small></small> </div> <div class="form-field"> <label for="password">Password:</label> <input type="password" name="password" id="password" class="password" autocomplete="off"> <small></small> <!-- <i class="bi bi-eye-slash" id="togglePassword1"></i> --> </div> <div class="form-field"> <label for="confirm-password">Confirm Password:</label> <input type="password" name="confirm-password" id="confirm-password" autocomplete="off"> <small></small> <!-- <i class="bi bi-eye-slash" id="togglePassword"></i> --> </div> <div > <!-- An element to toggle between password visibility --> <input type="checkbox" onclick="myFunction()">Show Password </div> <div class="form-field mt-2"> <input type="submit" value="Sign Up"> </div> </form> </div> </section> <script src="app.js"> </script> <script> function myFunction() { var x = document.getElementById("password"); var x1 = document.getElementById("confirm-password"); // alert(x); if (x.type === "password" && x.type === "password") { x.type = "text"; x1.type = "text"; } else { x.type = "password"; x1.type = "password"; } } </script> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0/dist/js/bootstrap.min.js" ></script> <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.11.5/dist/umd/popper.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0/dist/js/bootstrap.bundle.min.js"></script> <script src="http://code.jquery.com/jquery-1.9.1.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/2.0.1/js/toastr.js"></script> </body> </html>
@import url('https://fonts.googleapis.com/css?family=Open+Sans&display=swap'); :root { --error-color: #dc3545; --success-color: #28a745; --warning-color: #ffc107; } * { margin: 0; padding: 0; box-sizing: border-box; } body { font-family: 'Open Sans', sans-serif; font-size: 16px; background-color: #f4f4f4; display: flex; flex-direction: column; justify-content: center; align-items: center; min-height: 100vh; margin: 0; } .container { background-color: #fff; padding: 1em; border-radius: 5px; box-shadow: 0 2px 5px rgba(0, 0, 0, 0.3); width: 400px; } .form { padding: 10px 20px; } .form h1 { font-size: 1.5em; text-align: center; margin-bottom: 20px; } .form-field { margin-bottom: 5px; } .form-field label { display: block; color: #777; margin-bottom: 5px; } .form-field input { border: solid 2px #f0f0f0; border-radius: 3px; padding: 10px; margin-bottom: 5px; font-size: 14px; display: block; width: 100%; } .form-field input:focus { outline: none; } .form-field.error input { border-color: var(--error-color); } .form-field.success input { border-color: var(--success-color); } .form-field small { color: var(--error-color); } /* button */ .btn { width: 100%; padding: 3%; background: #007bff; border-bottom: 2px solid #007bff; border-top-style: none; border-right-style: none; border-left-style: none; color: #fff; text-transform: uppercase; } .btn:hover { background: #0069d9; cursor: pointer; } .btn:focus { outline: none; }
<!DOCTYPE html> <html lang="en"> <head> <link href="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/2.0.1/css/toastr.css" rel="stylesheet"/> </head> <body> <script src="http://code.jquery.com/jquery-1.9.1.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/2.0.1/js/toastr.js"></script> </body> </html>
const usernameEl = document.querySelector('#username'); const emailEl = document.querySelector('#email'); const passwordEl = document.querySelector('#password'); const confirmPasswordEl = document.querySelector('#confirm-password'); const form = document.querySelector('#signup'); const checkUsername = () => { let valid = false; const min = 3, max = 25; const username = usernameEl.value.trim(); if (!isRequired(username)) { showError(usernameEl, 'Username cannot be blank.'); } else if (!isBetween(username.length, min, max)) { showError(usernameEl, `Username must be between ${min} and ${max} characters.`) } else { showSuccess(usernameEl); valid = true; } return valid; }; const checkEmail = () => { let valid = false; const email = emailEl.value.trim(); if (!isRequired(email)) { showError(emailEl, 'Email cannot be blank.'); } else if (!isEmailValid(email)) { showError(emailEl, 'Email is not valid.') } else { showSuccess(emailEl); valid = true; } return valid; }; const checkPassword = () => { let valid = false; const password = passwordEl.value.trim(); if (!isRequired(password)) { showError(passwordEl, 'Password cannot be blank.'); } else if (!isPasswordSecure(password)) { showError(passwordEl, 'Password must has at least 8 characters that include at least 1 lowercase character, 1 uppercase characters, 1 number, and 1 special character in (!@#$%^&*)'); } else { showSuccess(passwordEl); valid = true; } return valid; }; const checkConfirmPassword = () => { let valid = false; // check confirm password const confirmPassword = confirmPasswordEl.value.trim(); const password = passwordEl.value.trim(); if (!isRequired(confirmPassword)) { showError(confirmPasswordEl, 'Please enter the password again'); } else if (password !== confirmPassword) { showError(confirmPasswordEl, 'The password does not match'); } else { showSuccess(confirmPasswordEl); valid = true; } return valid; }; const isEmailValid = (email) => { const re = /^(([^<>()\[\]\\.,;:\s@"]+(\.[^<>()\[\]\\.,;:\s@"]+)*)|(".+"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/; return re.test(email); }; const isPasswordSecure = (password) => { const re = new RegExp("^(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[!@#\$%\^&\*])(?=.{8,})"); return re.test(password); }; const isRequired = value => value === '' ? false : true; const isBetween = (length, min, max) => length < min || length > max ? false : true; const showError = (input, message) => { // get the form-field element const formField = input.parentElement; // add the error class formField.classList.remove('success'); formField.classList.add('error'); // show the error message const error = formField.querySelector('small'); error.textContent = message; }; const showSuccess = (input) => { // get the form-field element const formField = input.parentElement; // remove the error class formField.classList.remove('error'); formField.classList.add('success'); // hide the error message const error = formField.querySelector('small'); error.textContent = ''; } form.addEventListener('submit', function (e) { // prevent the form from submitting e.preventDefault(); // validate fields let isUsernameValid = checkUsername(), isEmailValid = checkEmail(), isPasswordValid = checkPassword(), isConfirmPasswordValid = checkConfirmPassword(); let isFormValid = isUsernameValid && isEmailValid && isPasswordValid && isConfirmPasswordValid; // submit to the server if the form is valid if (isFormValid) { } }); const debounce = (fn, delay = 500) => { let timeoutId; return (...args) => { // cancel the previous timer if (timeoutId) { clearTimeout(timeoutId); } // setup a new timer timeoutId = setTimeout(() => { fn.apply(null, args) }, delay); }; }; form.addEventListener('input', debounce(function (e) { switch (e.target.id) { case 'username': checkUsername(); break; case 'email': checkEmail(); break; case 'password': checkPassword(); break; case 'confirm-password': checkConfirmPassword(); break; } }));