Hii sio table tupu hii ni structure/schema ya table. Kuona kama table ina data bonyeza Browse au fanya SQL select query kwenye hiyo table.Naona table ni tupu mkuu au nakosea sehemu?
View attachment 2781276
Ingia hapa: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
Na hii ni php codeCode:<!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>
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.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
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
Mkuu naomba unieleweshe zaidi maana hapa sijaelewa.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.
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).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
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.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.