D dee-u Forum Veteran Elite Dec 21, 2019 #21 Dito name="fullname" yung fullname dapat ang gamitin mo sa post. $fullname = $_POST['fullname'];
F FinestWork Honorary Poster Established Dec 21, 2019 #22 PHP: $fullname = $_POST['fullname']; $email = $_POST['email']; $code = $_POST['password']; $phone_number = $_POST['gender']; $job = $_POST['job']; $password = $_POST['password']; $password = md5($password); //Password Encrypted if (!empty ($fullname) || !empty($email) || !empty($code) || !empty($phone_number) || !empty($job) || !empty($password)) { $host = "localhost"; $username = "root"; $dbpassword = ""; $dbname = "final_project"; //create connection here $conn= new mysqli($host,$username,$dbpassword,$dbname); if (mysqli_connect_error()) { die('Connect Error('.mysqli_connect_errno().')'.mysqli_connect_errno()); }else{ $SELECT = "SELECT email from register where email = ? Limit 1"; $INSERT = "INSERT into register (fullname,email,code,phone_number,job,password) value(?,?,?,?,?,?)"; //Prepaired Statement $stmt = $conn->prepare($SELECT); $stmt->bind_param("s",$email); $stmt->execute(); $stmt->bind_result($email); $stmt->store_result(); $rnum = $stmt->num_rows; if ($rnum==0) { $stmt-> close(); $stmt = $conn->prepare($INSERT); $stmt->bind_param("ssssii", $fullname,$email,$code,$phone_number,$job,$password); $stmt->execute(); echo "Sign up Successfully!"; }else{ echo "Someone registered with this email"; } $stmt->close(); $conn->close(); } }else{ echo "All field are required!"; die(); } ?> Copy mo na lang 'yan, kailangan mo gumawa ng form field para sa gender mo
PHP: $fullname = $_POST['fullname']; $email = $_POST['email']; $code = $_POST['password']; $phone_number = $_POST['gender']; $job = $_POST['job']; $password = $_POST['password']; $password = md5($password); //Password Encrypted if (!empty ($fullname) || !empty($email) || !empty($code) || !empty($phone_number) || !empty($job) || !empty($password)) { $host = "localhost"; $username = "root"; $dbpassword = ""; $dbname = "final_project"; //create connection here $conn= new mysqli($host,$username,$dbpassword,$dbname); if (mysqli_connect_error()) { die('Connect Error('.mysqli_connect_errno().')'.mysqli_connect_errno()); }else{ $SELECT = "SELECT email from register where email = ? Limit 1"; $INSERT = "INSERT into register (fullname,email,code,phone_number,job,password) value(?,?,?,?,?,?)"; //Prepaired Statement $stmt = $conn->prepare($SELECT); $stmt->bind_param("s",$email); $stmt->execute(); $stmt->bind_result($email); $stmt->store_result(); $rnum = $stmt->num_rows; if ($rnum==0) { $stmt-> close(); $stmt = $conn->prepare($INSERT); $stmt->bind_param("ssssii", $fullname,$email,$code,$phone_number,$job,$password); $stmt->execute(); echo "Sign up Successfully!"; }else{ echo "Someone registered with this email"; } $stmt->close(); $conn->close(); } }else{ echo "All field are required!"; die(); } ?> Copy mo na lang 'yan, kailangan mo gumawa ng form field para sa gender mo
C Captcha-Google Eternal Poster Established Dec 21, 2019 TS TS #23 dee-u said: Dito name="fullname" yung fullname dapat ang gamitin mo sa post. $fullname = $_POST['fullname']; Click to expand... ok na paps walang error pero walang data sa database pag pindot ko sa button
dee-u said: Dito name="fullname" yung fullname dapat ang gamitin mo sa post. $fullname = $_POST['fullname']; Click to expand... ok na paps walang error pero walang data sa database pag pindot ko sa button
F Flavored Eternal Poster Dec 21, 2019 #26 PHP: $stmt->bind_param("ssssii", $fullname,$email,$code,$phone_number,$job,$password); nasa line na yan yung mali kaya ayaw mag save hanapin mo nlng
PHP: $stmt->bind_param("ssssii", $fullname,$email,$code,$phone_number,$job,$password); nasa line na yan yung mali kaya ayaw mag save hanapin mo nlng
K Kentify Moderator Moderator Dec 21, 2019 #27 mali kasi yung: $fullname = $_POST['name'] dapat kasi $fullname= $_POST['fullname'] at yung: $phone_number = $_POST['gender'] <---- bakit naging phone number yung gender mo? change gender to $_POST['phone_number'] tapos create ka ulit ng form tas lagyan mo ng gender. lastly, $password = $_POST['pass'] to $password = $_POST['password'] yan lang naman error mo eh Last edited: Dec 21, 2019
mali kasi yung: $fullname = $_POST['name'] dapat kasi $fullname= $_POST['fullname'] at yung: $phone_number = $_POST['gender'] <---- bakit naging phone number yung gender mo? change gender to $_POST['phone_number'] tapos create ka ulit ng form tas lagyan mo ng gender. lastly, $password = $_POST['pass'] to $password = $_POST['password'] yan lang naman error mo eh
P Pi Sces Forum Veteran Jan 2, 2020 #28 dapat kasi same value yung ipapasok sa database table mo sa column nya para ma save yung output mo