Naomba msaada nakosea wapi kwenye kuconnect hii form na database

Naomba msaada nakosea wapi kwenye kuconnect hii form na database

Aisee mimi nashida sama kwenye mysql yani niliinstall mysql ila hairun kabisaa inasema No server detected wakuu msaada...tofaut na Mysql naweza tumia nini kama mbadala
 
Post picha ya browser nzima pamoja na url address bar kuanzia site ya kwanza ya registration, nadhani unakosea kutumia server yako, nikiangalia picha ya mwisho yenye screen nyeusi ya PHP naona url inasoma file la PHP kutoka kwenye file system yaani C:/..... unapotumia webserver browser yako inabidi iende kwenye address ya hiyo server na sio kufungua file directly kupitia file system so kwa local server url itakua mfumo wa localhost:8080/My-Projects au similar.

Kama unatumia server kiusahihi kamwe hauwezi kuona php code maana ni security risk kubwa kama hapo credentials zako zote zinasomeka.
 
leoleo-tu said:
Wakuu, naendelea kujifunza vitu. Sasa sasa hivi najifunza ku interact na database.
Nimeweza kuunda fomu hii kwa msaada wa HTML and CSS
View attachment 2781188
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>
Na hii ni php code
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();
    }
?>
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
View attachment 2781190

Na nikiweka details nikasubmit ni kama vile hazitumwi kwenye php file maana napata hiki tu:
View attachment 2781199
Nimejaribu ku troubleshoot kwa kuiuliza Bardi na Chatgpt na kuipa code zote, na zote zinasema code inaonekana iko sawa.
hapa ninakosea wapi dronedrake
Click to expand...
Ingia hapa:

www.tutorialspoint.com

How do I connect an HTML web page to a database?

How do I connect an HTML web page to a database - HTML, Hypertext markup language and databases are often used for different domains, but for the purpose of this article, we'll try to connect them. Before we get started with the methods and how we can connect them, it's necessary to understand...
www.tutorialspoint.com www.tutorialspoint.com
 
Kang said:
Post picha ya browser nzima pamoja na url address bar kuanzia site ya kwanza ya registration, nadhani unakosea kutumia server yako, nikiangalia picha ya mwisho yenye screen nyeusi ya PHP naona url inasoma file la PHP kutoka kwenye file system yaani C:/..... unapotumia webserver browser yako inabidi iende kwenye address ya hiyo server na sio kufungua file directly kupitia file system so kwa local server url itakua mfumo wa localhost:8080/My-Projects au similar.

Kama unatumia server kiusahihi kamwe hauwezi kuona php code maana ni security risk kubwa kama hapo credentials zako zote zinasomeka.
Click to expand...
Mkuu naomba unieleweshe zaidi maana hapa sijaelewa.
Folder la project liko kwenye htdocs.
Hapa kuna screnshots
hii ni code ya kupost:
<form action="sign-in.php" method="post">
Hapa url screenshot ya page form
1697272770578.png

hapa screenshot nayopata nikisubmit hii form
1697272835071.png
 
leoleo-tu said:
Mkuu naomba unieleweshe zaidi maana hapa sijaelewa.
Folder la project liko kwenye htdocs.
Hapa kuna screnshots
hii ni code ya kupost:
<form action="sign-in.php" method="post">
Hapa url screenshot ya page form
View attachment 2781647
hapa screenshot nayopata nikisubmit hii form
View attachment 2781650
Click to expand...
Jinsi unavyofungua file zako sio sahihi, unafungua kupitia file system badala ya kupitia server, nadhani utakuwa una double click au unabdrag drop, hii sio sahihi, kwa vile php ni backend/server side inabidi iwe processed na server kisha server itume majibu kwenye browser kupitia http wewe unafungua mafile directly kupitia file system so haujaihusisha server kabisa ni kama hauna xampp, kumbuka browser haielewi php browser inaelewa html,css, na js tu so ndo maana php code yako inaonekana tu kwenyen screen kwa sababu browser inafungua kama text file. Njia hii ya kufungua mafile ya html kwenye file system inafanya kazi kwa kiasi fulani kwa site simple za frontend tu (html/css/js).

So fanya ifuatavyo, run XAMPP hakikisha Apache na MySql zinarun, bonyeza btn ya Admin pembeni ya Apache itafungua browser katika site kama localhost/dashboard (localhost ni computer yako kwa vile server ya apache ipo kwenye computer yako) hii dashboard ipo ndani ya htdocs folder so apache inaenda ndani ya htdocs inasoma yaliyomo ndani ya dashboard folder kama kuna php inapitia php processing kisha inarudisha html kwenye browser.

So kwa vile site yako iko ndani ya htdocs/My-Projects andika localhost/My-Projects katika browser address bar yako, apache itaenda ndani ya hiyo folder na kutafuta file kama index.html au index.php na itaiprocess na kurudisha page kama inavyotakiwa.

Pia ningekushauri usitumie -, space, na kuchanganya herufi kubwa na ndogo kwenye folder na file zako so folder myprojects ni bora zaidi.
 
Kang said:
Jinsi unavyofungua file zako sio sahihi, unafungua kupitia file system badala ya kupitia server, nadhani utakuwa una double click au unabdrag drop, hii sio sahihi, kwa vile php ni backend/server side inabidi iwe processed na server kisha server itume majibu kwenye browser kupitia http wewe unafungua mafile directly kupitia file system so haujaihusisha server kabisa ni kama hauna xampp, kumbuka browser haielewi php browser inaelewa html,css, na js tu so ndo maana php code yako inaonekana tu kwenyen screen kwa sababu browser inafungua kama text file. Njia hii ya kufungua mafile ya html kwenye file system inafanya kazi kwa kiasi fulani kwa site simple za frontend tu (html/css/js).

So fanya ifuatavyo, run XAMPP hakikisha Apache na MySql zinarun, bonyeza btn ya Admin pembeni ya Apache itafungua browser katika site kama localhost/dashboard (localhost ni computer yako kwa vile server ya apache ipo kwenye computer yako) hii dashboard ipo ndani ya htdocs folder so apache inaenda ndani ya htdocs inasoma yaliyomo ndani ya dashboard folder kama kuna php inapitia php processing kisha inarudisha html kwenye browser.

So kwa vile site yako iko ndani ya htdocs/My-Projects andika localhost/My-Projects katika browser address bar yako, apache itaenda ndani ya hiyo folder na kutafuta file kama index.html au index.php na itaiprocess na kurudisha page kama inavyotakiwa.

Pia ningekushauri usitumie -, space, na kuchanganya herufi kubwa na ndogo kwenye folder na file zako so folder myprojects ni bora zaidi.
Click to expand...
Mkuu yani nashukuru sana sana. Kosa langu lilikuwa hivyo nilikuwa na access file directly kw kulibofya. Nashukuru sasa hivi ina signup kabisa na kuandika kwenye database kabisa.
Asante sana mkuu sana.
 
You must log in or register to reply here.

Our Community

Regional Communities

Back
Top Bottom
Menu
Forums
New posts
Log in
Register