Wakuu, naendelea kujifunza vitu. Sasa sasa hivi najifunza ku interact na database.
Nimeweza kuunda fomu hii kwa msaada wa HTML and CSS
Na huu ndiyo code yangu ya HTML
Na hii ni php code
Lakini imekaa kufanya kazi, server ina run na nimeunda data base inaitwa user_signup na table inaitwa user_credentials na nimeset kila kitu kuanzia first_name, last_name, email, password, na agree, nikaweza na value pia.
Ila nikitest php file kwenye browser kwa kuandika directory napata error hii
Na nikiweka details nikasubmit ni kama vile hazitumwi kwenye php file maana napata hiki tu:
Nimejaribu ku troubleshoot kwa kuiuliza Bardi na Chatgpt na kuipa code zote, na zote zinasema code inaonekana iko sawa.
hapa ninakosea wapi dronedrake
Nimeweza kuunda fomu hii kwa msaada wa HTML and CSS
Na huu ndiyo code yangu ya HTML
Code:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<link rel="stylesheet" type="text/css" href="styles.css">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Sign Up</title>
</head>
<body>
<div class="sign-box">
<h1>Signup</h1>
<form action="sign-in.php" method="post">
<input type="text" class="input-box" placeholder="First name" name="first_name" required>
<input type="text" class="input-box" placeholder="Second name" name="last_name" required>
<input type="email" class="input-box" placeholder="Email" name="email" required>
<input type="password" class="input-box" placeholder="Password" name="password" required>
<p><span><input type="checkbox" name="agree" value="yes" required>I agree to the terms of the services.</span></p>
<button type="submit" class="sign-btn">Sign up</button>
<hr>
<p class="or">OR</p>
<button type="button" class="sign-btn">Login with Facebook</button>
<p>Do you have an account? <a href="#">Login</a></p>
</form>
</div>
</body>
</html>
Code:
<?php
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$email = $_POST['email'];
$password = $_POST['password'];
$agree = $_POST['agree'];
$conn = new mysqli('localhost','root','','user_signup');
if($conn->connection_error){
die('Connection Failed : ' .$conn->connection_error);
}else{
$stmt = $conn->prepare("INSERT INTO user_credentials(first_name, last_name, email, password, agree) values(?, ?, ?, ?, ?)");
$stmt->bind_param("sssss", $first_name, $last_name, $email, $password, $agree);
$stmt->execute();
echo "Registration succesiful...";
$stmt->close();
$stmt->close();
}
?>Ila nikitest php file kwenye browser kwa kuandika directory napata error hii
Na nikiweka details nikasubmit ni kama vile hazitumwi kwenye php file maana napata hiki tu:
Nimejaribu ku troubleshoot kwa kuiuliza Bardi na Chatgpt na kuipa code zote, na zote zinasema code inaonekana iko sawa.
hapa ninakosea wapi dronedrake