Reply to thread

Message

<blockquote data-quote="geeko" data-source="post: 23327462" data-attributes="member: 465247">Error එක-----------Warning: mysqli_stmt_close() expects parameter 1 to be mysqli_stmt, boolean given in C:\wamp\www\register.php on line 342Code එක-----------[PHP]&lt;?php// Include config filerequire_once 'config.php';&nbsp;// Define variables and initialize with empty values$username = $password = $confirm_password = $first_name = $last_name = $email = $date_of_birth = $nic = $passport = $marital_state = $children = $residency = $height = $weight = $body_type = $appearance = $skin_colour = $ethnicity = $caste = $religion = $education = $career_sector = $mother_language = $occupation = $social_class = $drinking = $alcohol = $smoking = $diet = $family_values = $personality = $hobbies = $profile_posted_by = $about_me = &quot;&quot;;$username_err = $password_err = $confirm_password_err = $first_name_err = $last_name_err = $email_err = $date_of_birth_err = $nic_err = $passport_err = $marital_state_err = $children_err = $residency_err = $height_err = $weight_err = $body_type_err = $appearance_err = $skin_colour_err = $ethnicity_err = $caste_err = $religion_err = $education_err = $career_sector_err = $mother_language_err = $occupation_err = $social_class_err = $drinking_err = $alcohol_err = $smoking_err = $diet_err = $family_values_err = $personality_err = $hobbies_err = $profile_posted_by_err = $about_me_err = &quot;&quot;;&nbsp;// Processing form data when form is submittedif($_SERVER[&quot;REQUEST_METHOD&quot;] == &quot;POST&quot;){&nbsp; &nbsp; &nbsp; &nbsp; //validate firstname&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['first_name']))){&nbsp; &nbsp; &nbsp; &nbsp; $first_name_err = &quot;Please enter first name.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $first_name = trim($_POST['first_name']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //validate lastname&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['last_name']))){&nbsp; &nbsp; &nbsp; &nbsp; $last_name_err = &quot;Please enter last name.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $last_name = trim($_POST['last_name']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //validate email&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['email']))){&nbsp; &nbsp; &nbsp; &nbsp; $email_err = &quot;Please enter email.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $email = trim($_POST['email']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate date of birth&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['date_of_birth']))){&nbsp; &nbsp; &nbsp; &nbsp; $date_of_birth_err = &quot;Please enter date of birth.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $date_of_birth = trim($_POST['date_of_birth']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate nic&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['nic']))){&nbsp; &nbsp; &nbsp; &nbsp; $nic_err = &quot;Please enter NIC.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $nic = trim($_POST['nic']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate passport&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['passport']))){&nbsp; &nbsp; &nbsp; &nbsp; $passport_err = &quot;Please enter passport.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $passport = trim($_POST['passport']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate marital state&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['marital_state']))){&nbsp; &nbsp; &nbsp; &nbsp; $marital_state_err = &quot;Please enter marital state.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $marital_state = trim($_POST['marital_state']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate children&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['children']))){&nbsp; &nbsp; &nbsp; &nbsp; $children_err = &quot;Please enter children.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $children = trim($_POST['children']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate residency&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['residency']))){&nbsp; &nbsp; &nbsp; &nbsp; $residency_err = &quot;Please enter residency.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $residency = trim($_POST['residency']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate height&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['height']))){&nbsp; &nbsp; &nbsp; &nbsp; $height_err = &quot;Please enter height.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $height = trim($_POST['height']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate weight&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['weight']))){&nbsp; &nbsp; &nbsp; &nbsp; $weight_err = &quot;Please enter weight.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $weight = trim($_POST['weight']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate body type&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['body_type']))){&nbsp; &nbsp; &nbsp; &nbsp; $body_type_err = &quot;Please enter body type.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $body_type = trim($_POST['body_type']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate appearance&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['appearance']))){&nbsp; &nbsp; &nbsp; &nbsp; $appearance_err = &quot;Please enter appearance.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $appearance = trim($_POST['appearance']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //validate skin colour&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['skin_colour']))){&nbsp; &nbsp; &nbsp; &nbsp; $skin_colour_err = &quot;Please enter skin colour.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $skin_colour = trim($_POST['skin_colour']);&nbsp; &nbsp; }&nbsp; &nbsp; //validate ethnicity&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['ethnicity']))){&nbsp; &nbsp; &nbsp; &nbsp; $ethnicity_err = &quot;Please enter ethnicity.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $ethnicity = trim($_POST['ethnicity']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate caste&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['caste']))){&nbsp; &nbsp; &nbsp; &nbsp; $caste_err = &quot;Please enter email.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $caste = trim($_POST['caste']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate religion&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['religion']))){&nbsp; &nbsp; &nbsp; &nbsp; $religion_err = &quot;Please enter religion.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $religion = trim($_POST['religion']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate education&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['education']))){&nbsp; &nbsp; &nbsp; &nbsp; $eeducation_err = &quot;Please enter education.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $education = trim($_POST['education']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate career sector&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['career_sector']))){&nbsp; &nbsp; &nbsp; &nbsp; $career_sector_err = &quot;Please enter career sector.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $career_sector = trim($_POST['career_sector']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate mother language&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['mother_language']))){&nbsp; &nbsp; &nbsp; &nbsp; $mother_language_err = &quot;Please enter mother language.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $mother_language = trim($_POST['mother_language']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate occupation&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['occupation']))){&nbsp; &nbsp; &nbsp; &nbsp; $occupation_err = &quot;Please enter occupation.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $occupation = trim($_POST['occupation']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate social class&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['social_class']))){&nbsp; &nbsp; &nbsp; &nbsp; $social_class_err = &quot;Please enter social class.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $social_class = trim($_POST['social_class']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate drinking&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['drinking']))){&nbsp; &nbsp; &nbsp; &nbsp; $drinking_err = &quot;Please enter drinking.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $drinking = trim($_POST['drinking']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate alcohol&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['alcohol']))){&nbsp; &nbsp; &nbsp; &nbsp; $alcohol_err = &quot;Please enter alcohol.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $alcohol = trim($_POST['alcohol']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate smoking&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['smoking']))){&nbsp; &nbsp; &nbsp; &nbsp; $smoking_err = &quot;Please enter smoking.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $smoking = trim($_POST['smoking']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate diet&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['diet']))){&nbsp; &nbsp; &nbsp; &nbsp; $diet_err = &quot;Please enter diet.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $diet = trim($_POST['diet']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate family values&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['family_values']))){&nbsp; &nbsp; &nbsp; &nbsp; $family_values_err = &quot;Please enter famili values.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $family_values = trim($_POST['family_values']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate personality&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['personality']))){&nbsp; &nbsp; &nbsp; &nbsp; $personality_err = &quot;Please enter personality.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $personality = trim($_POST['personality']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate hobbies&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['hobbies']))){&nbsp; &nbsp; &nbsp; &nbsp; $hobbies_err = &quot;Please enter hobbies.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $hobbies = trim($_POST['hobbies']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate profile posted by&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['profile_posted_by']))){&nbsp; &nbsp; &nbsp; &nbsp; $profile_posted_by_err = &quot;Please enter profile posted by.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $profile_posted_by = trim($_POST['profile_posted_by']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //validate about me&nbsp; &nbsp; &nbsp; &nbsp; if(empty(trim($_POST['about_me']))){&nbsp; &nbsp; &nbsp; &nbsp; $about_me_err = &quot;Please enter about me.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $about_me = trim($_POST['about_me']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Validate username&nbsp; &nbsp; if(empty(trim($_POST[&quot;username&quot;]))){&nbsp; &nbsp; &nbsp; &nbsp; $username_err = &quot;Please enter a username.&quot;;&nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; // Prepare a select statement&nbsp; &nbsp; &nbsp; &nbsp; $sql = &quot;SELECT user_id FROM users WHERE username = ?&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($stmt = mysqli_prepare($link, $sql)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Bind variables to the prepared statement as parameters&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysqli_stmt_bind_param($stmt, &quot;s&quot;, $param_username);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Set parameters&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_username = trim($_POST[&quot;username&quot;]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Attempt to execute the prepared statement&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(mysqli_stmt_execute($stmt)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /* store result */&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysqli_stmt_store_result($stmt);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(mysqli_stmt_num_rows($stmt) == 1){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $username_err = &quot;This username is already taken.&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $username = trim($_POST[&quot;username&quot;]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;Oops! Something went wrong. Please try again later.&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Close statement&nbsp; &nbsp; &nbsp; &nbsp; mysqli_stmt_close($stmt);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; // Validate password&nbsp; &nbsp; if(empty(trim($_POST['password']))){&nbsp; &nbsp; &nbsp; &nbsp; $password_err = &quot;Please enter a password.&quot;;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } elseif(strlen(trim($_POST['password'])) &lt; 6){&nbsp; &nbsp; &nbsp; &nbsp; $password_err = &quot;Password must have atleast 6 characters.&quot;;&nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $password = trim($_POST['password']);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; // Validate confirm password&nbsp; &nbsp; if(empty(trim($_POST[&quot;confirm_password&quot;]))){&nbsp; &nbsp; &nbsp; &nbsp; $confirm_password_err = 'Please confirm password.';&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; $confirm_password = trim($_POST['confirm_password']);&nbsp; &nbsp; &nbsp; &nbsp; if($password != $confirm_password){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $confirm_password_err = 'Password did not match.';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; // Check input errors before inserting in database&nbsp; &nbsp; if(empty($username_err) &amp;&amp; empty($password_err) &amp;&amp; empty($confirm_password_err) &amp;&amp; empty($first_name_err) &amp;&amp; empty($last_name_err) &amp;&amp; empty($email_err) &amp;&amp; empty($date_of_birth_err) &amp;&amp; empty($nic_err) &amp;&amp; empty($marital_state_err) &amp;&amp; empty($children_err) &amp;&amp; empty($residency_err) &amp;&amp; empty($height_err) &amp;&amp; empty($weight_err) &amp;&amp; empty($body_type_err) &amp;&amp; empty($appearance_err) &amp;&amp; empty($skin_colour_err) &amp;&amp; empty($ethnicity_err) &amp;&amp; empty($caste_err) &amp;&amp; empty($religion_err) &amp;&amp; empty($education_err) &amp;&amp; empty($career_sector_err) &amp;&amp; empty($mother_language_err) &amp;&amp; empty($occupation_err) &amp;&amp; empty($social_class_err) &amp;&amp; empty($drinking_err) &amp;&amp; empty($alcohol_err) &amp;&amp; empty($smoking_err) &amp;&amp; empty($diet_err) &amp;&amp; empty($family_Values_err) &amp;&amp; empty($personality_err) &amp;&amp; empty($hobbies_err) &amp;&amp; empty($about_me_err) &amp;&amp; empty($profile_posted_by_err)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Prepare an insert statement&nbsp; &nbsp; &nbsp; &nbsp; // $sql = &quot;INSERT INTO users (username, password, first_name, last_name, email, date_of_birth, nic, children, passport, marital_state, residency, height, weight, body_type, appearance, skin_colour, ethnicity, caste, religion, education, career_sector, mother_language, occupation, social_class, drinking, alcohol, smoking, diet, family_values, personality, hobbies, profile_posted_by, about_me) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($stmt = mysqli_prepare($link, &quot;INSERT INTO users (username, password, first_name, last_name, email, date_of_birth, nic, children, passport, marital_state, residency, height, weight, body_type, appearance, skin_colour, ethnicity, caste, religion, education, career_sector, mother_language, occupation, social_class, drinking, alcohol, smoking, diet, family_values, personality, hobbies, profile_posted_by, about_me) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)&quot;)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Bind variables to the prepared statement as parameters&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysqli_stmt_bind_param($stmt, &quot;sssssssssssssssssssssssssssssssss&quot;,$param_username, $param_password, $param_first_name, $param_last_name, $param_email, $param_nic, $param_date_of_birth, $param_passport, $param_marital_state, $param_children, $param_residency, $param_height, $param_weight, $param_body_type, $param_appearance, $param_skin_colour, $param_ethnicity, $param_caste, $param_religion, $param_education, $param_career_sector, $param_mother_language, $param_occupation, $param_social_class, $param_drinking, $param_alcohol, $param_smoking, $param_diet, $param_family_values, $param_personality, $param_hobbies, $param_about_me, $param_profile_posted_by);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Set parameters&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_username = $username;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_first_name = $first_name;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_last_name = $last_name;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_email = $email;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_password = password_hash($password, PASSWORD_DEFAULT); // Creates a password hash&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_date_of_birth = $date_of_birth;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_nic = $nic;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_passport = $passport;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_marital_state = $marital_state;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_residency = $residency;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_height = $height;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_weight = $weight;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_body_type = $body_type;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_appearance = $appearance;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_skin_colour = $skin_colour;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_ethnicity = $ethnicity;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_caste = $caste;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_religion = $religion;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_education = $education;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_career_sector = $career_sector;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_mother_language = $mother_language;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_occupation = $occupation;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_social_class = $social_class;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_drinking = $drinking;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_alcohol = $alcohol;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_smoking = $smoking;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_diet = $diet;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_family_values = $family_values;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_personality = $personality;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_hobbies = $hobbies;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_about_me = $about_me;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_children = $children;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $param_profile_posted_by = $profile_posted_by;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Attempt to execute the prepared statement&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(mysqli_stmt_execute($stmt)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Redirect to login page&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; header(&quot;location: login.php&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;Something went wrong. Please try again later.&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Close statement&nbsp; &nbsp; &nbsp; &nbsp; mysqli_stmt_close($stmt);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; // Close connection&nbsp; &nbsp; mysqli_close($link);}?&gt;[/PHP]</blockquote>

[QUOTE="geeko, post: 23327462, member: 465247"] Error එක ----------- Warning: mysqli_stmt_close() expects parameter 1 to be mysqli_stmt, boolean given in C:\wamp\www\register.php on line 342 Code එක ----------- [PHP] <?php // Include config file require_once 'config.php'; // Define variables and initialize with empty values $username = $password = $confirm_password = $first_name = $last_name = $email = $date_of_birth = $nic = $passport = $marital_state = $children = $residency = $height = $weight = $body_type = $appearance = $skin_colour = $ethnicity = $caste = $religion = $education = $career_sector = $mother_language = $occupation = $social_class = $drinking = $alcohol = $smoking = $diet = $family_values = $personality = $hobbies = $profile_posted_by = $about_me = ""; $username_err = $password_err = $confirm_password_err = $first_name_err = $last_name_err = $email_err = $date_of_birth_err = $nic_err = $passport_err = $marital_state_err = $children_err = $residency_err = $height_err = $weight_err = $body_type_err = $appearance_err = $skin_colour_err = $ethnicity_err = $caste_err = $religion_err = $education_err = $career_sector_err = $mother_language_err = $occupation_err = $social_class_err = $drinking_err = $alcohol_err = $smoking_err = $diet_err = $family_values_err = $personality_err = $hobbies_err = $profile_posted_by_err = $about_me_err = ""; // Processing form data when form is submitted if($_SERVER["REQUEST_METHOD"] == "POST"){ //validate firstname if(empty(trim($_POST['first_name']))){ $first_name_err = "Please enter first name."; } else{ $first_name = trim($_POST['first_name']); } //validate lastname if(empty(trim($_POST['last_name']))){ $last_name_err = "Please enter last name."; } else{ $last_name = trim($_POST['last_name']); } //validate email if(empty(trim($_POST['email']))){ $email_err = "Please enter email."; } else{ $email = trim($_POST['email']); } //validate date of birth if(empty(trim($_POST['date_of_birth']))){ $date_of_birth_err = "Please enter date of birth."; } else{ $date_of_birth = trim($_POST['date_of_birth']); } //validate nic if(empty(trim($_POST['nic']))){ $nic_err = "Please enter NIC."; } else{ $nic = trim($_POST['nic']); } //validate passport if(empty(trim($_POST['passport']))){ $passport_err = "Please enter passport."; } else{ $passport = trim($_POST['passport']); } //validate marital state if(empty(trim($_POST['marital_state']))){ $marital_state_err = "Please enter marital state."; } else{ $marital_state = trim($_POST['marital_state']); } //validate children if(empty(trim($_POST['children']))){ $children_err = "Please enter children."; } else{ $children = trim($_POST['children']); } //validate residency if(empty(trim($_POST['residency']))){ $residency_err = "Please enter residency."; } else{ $residency = trim($_POST['residency']); } //validate height if(empty(trim($_POST['height']))){ $height_err = "Please enter height."; } else{ $height = trim($_POST['height']); } //validate weight if(empty(trim($_POST['weight']))){ $weight_err = "Please enter weight."; } else{ $weight = trim($_POST['weight']); } //validate body type if(empty(trim($_POST['body_type']))){ $body_type_err = "Please enter body type."; } else{ $body_type = trim($_POST['body_type']); } //validate appearance if(empty(trim($_POST['appearance']))){ $appearance_err = "Please enter appearance."; } else{ $appearance = trim($_POST['appearance']); } //validate skin colour if(empty(trim($_POST['skin_colour']))){ $skin_colour_err = "Please enter skin colour."; } else{ $skin_colour = trim($_POST['skin_colour']); } //validate ethnicity if(empty(trim($_POST['ethnicity']))){ $ethnicity_err = "Please enter ethnicity."; } else{ $ethnicity = trim($_POST['ethnicity']); } //validate caste if(empty(trim($_POST['caste']))){ $caste_err = "Please enter email."; } else{ $caste = trim($_POST['caste']); } //validate religion if(empty(trim($_POST['religion']))){ $religion_err = "Please enter religion."; } else{ $religion = trim($_POST['religion']); } //validate education if(empty(trim($_POST['education']))){ $eeducation_err = "Please enter education."; } else{ $education = trim($_POST['education']); } //validate career sector if(empty(trim($_POST['career_sector']))){ $career_sector_err = "Please enter career sector."; } else{ $career_sector = trim($_POST['career_sector']); } //validate mother language if(empty(trim($_POST['mother_language']))){ $mother_language_err = "Please enter mother language."; } else{ $mother_language = trim($_POST['mother_language']); } //validate occupation if(empty(trim($_POST['occupation']))){ $occupation_err = "Please enter occupation."; } else{ $occupation = trim($_POST['occupation']); } //validate social class if(empty(trim($_POST['social_class']))){ $social_class_err = "Please enter social class."; } else{ $social_class = trim($_POST['social_class']); } //validate drinking if(empty(trim($_POST['drinking']))){ $drinking_err = "Please enter drinking."; } else{ $drinking = trim($_POST['drinking']); } //validate alcohol if(empty(trim($_POST['alcohol']))){ $alcohol_err = "Please enter alcohol."; } else{ $alcohol = trim($_POST['alcohol']); } //validate smoking if(empty(trim($_POST['smoking']))){ $smoking_err = "Please enter smoking."; } else{ $smoking = trim($_POST['smoking']); } //validate diet if(empty(trim($_POST['diet']))){ $diet_err = "Please enter diet."; } else{ $diet = trim($_POST['diet']); } //validate family values if(empty(trim($_POST['family_values']))){ $family_values_err = "Please enter famili values."; } else{ $family_values = trim($_POST['family_values']); } //validate personality if(empty(trim($_POST['personality']))){ $personality_err = "Please enter personality."; } else{ $personality = trim($_POST['personality']); } //validate hobbies if(empty(trim($_POST['hobbies']))){ $hobbies_err = "Please enter hobbies."; } else{ $hobbies = trim($_POST['hobbies']); } //validate profile posted by if(empty(trim($_POST['profile_posted_by']))){ $profile_posted_by_err = "Please enter profile posted by."; } else{ $profile_posted_by = trim($_POST['profile_posted_by']); } //validate about me if(empty(trim($_POST['about_me']))){ $about_me_err = "Please enter about me."; } else{ $about_me = trim($_POST['about_me']); } // Validate username if(empty(trim($_POST["username"]))){ $username_err = "Please enter a username."; } else{ // Prepare a select statement $sql = "SELECT user_id FROM users WHERE username = ?"; if($stmt = mysqli_prepare($link, $sql)){ // Bind variables to the prepared statement as parameters mysqli_stmt_bind_param($stmt, "s", $param_username); // Set parameters $param_username = trim($_POST["username"]); // Attempt to execute the prepared statement if(mysqli_stmt_execute($stmt)){ /* store result */ mysqli_stmt_store_result($stmt); if(mysqli_stmt_num_rows($stmt) == 1){ $username_err = "This username is already taken."; } else{ $username = trim($_POST["username"]); } } else{ echo "Oops! Something went wrong. Please try again later."; } } // Close statement mysqli_stmt_close($stmt); } // Validate password if(empty(trim($_POST['password']))){ $password_err = "Please enter a password."; } elseif(strlen(trim($_POST['password'])) < 6){ $password_err = "Password must have atleast 6 characters."; } else{ $password = trim($_POST['password']); } // Validate confirm password if(empty(trim($_POST["confirm_password"]))){ $confirm_password_err = 'Please confirm password.'; } else{ $confirm_password = trim($_POST['confirm_password']); if($password != $confirm_password){ $confirm_password_err = 'Password did not match.'; } } // Check input errors before inserting in database if(empty($username_err) && empty($password_err) && empty($confirm_password_err) && empty($first_name_err) && empty($last_name_err) && empty($email_err) && empty($date_of_birth_err) && empty($nic_err) && empty($marital_state_err) && empty($children_err) && empty($residency_err) && empty($height_err) && empty($weight_err) && empty($body_type_err) && empty($appearance_err) && empty($skin_colour_err) && empty($ethnicity_err) && empty($caste_err) && empty($religion_err) && empty($education_err) && empty($career_sector_err) && empty($mother_language_err) && empty($occupation_err) && empty($social_class_err) && empty($drinking_err) && empty($alcohol_err) && empty($smoking_err) && empty($diet_err) && empty($family_Values_err) && empty($personality_err) && empty($hobbies_err) && empty($about_me_err) && empty($profile_posted_by_err)){ // Prepare an insert statement // $sql = "INSERT INTO users (username, password, first_name, last_name, email, date_of_birth, nic, children, passport, marital_state, residency, height, weight, body_type, appearance, skin_colour, ethnicity, caste, religion, education, career_sector, mother_language, occupation, social_class, drinking, alcohol, smoking, diet, family_values, personality, hobbies, profile_posted_by, about_me) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; if($stmt = mysqli_prepare($link, "INSERT INTO users (username, password, first_name, last_name, email, date_of_birth, nic, children, passport, marital_state, residency, height, weight, body_type, appearance, skin_colour, ethnicity, caste, religion, education, career_sector, mother_language, occupation, social_class, drinking, alcohol, smoking, diet, family_values, personality, hobbies, profile_posted_by, about_me) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")){ // Bind variables to the prepared statement as parameters mysqli_stmt_bind_param($stmt, "sssssssssssssssssssssssssssssssss",$param_username, $param_password, $param_first_name, $param_last_name, $param_email, $param_nic, $param_date_of_birth, $param_passport, $param_marital_state, $param_children, $param_residency, $param_height, $param_weight, $param_body_type, $param_appearance, $param_skin_colour, $param_ethnicity, $param_caste, $param_religion, $param_education, $param_career_sector, $param_mother_language, $param_occupation, $param_social_class, $param_drinking, $param_alcohol, $param_smoking, $param_diet, $param_family_values, $param_personality, $param_hobbies, $param_about_me, $param_profile_posted_by); // Set parameters $param_username = $username; $param_first_name = $first_name; $param_last_name = $last_name; $param_email = $email; $param_password = password_hash($password, PASSWORD_DEFAULT); // Creates a password hash $param_date_of_birth = $date_of_birth; $param_nic = $nic; $param_passport = $passport; $param_marital_state = $marital_state; $param_residency = $residency; $param_height = $height; $param_weight = $weight; $param_body_type = $body_type; $param_appearance = $appearance; $param_skin_colour = $skin_colour; $param_ethnicity = $ethnicity; $param_caste = $caste; $param_religion = $religion; $param_education = $education; $param_career_sector = $career_sector; $param_mother_language = $mother_language; $param_occupation = $occupation; $param_social_class = $social_class; $param_drinking = $drinking; $param_alcohol = $alcohol; $param_smoking = $smoking; $param_diet = $diet; $param_family_values = $family_values; $param_personality = $personality; $param_hobbies = $hobbies; $param_about_me = $about_me; $param_children = $children; $param_profile_posted_by = $profile_posted_by; // Attempt to execute the prepared statement if(mysqli_stmt_execute($stmt)){ // Redirect to login page header("location: login.php"); } else{ echo "Something went wrong. Please try again later."; } } // Close statement mysqli_stmt_close($stmt); } // Close connection mysqli_close($link); } ?> [/PHP] [/QUOTE]

Verification

Nawa warak dahaya keeyada? (Namaya wadi kireema dahaya)

Search

Latest ads

Reply to thread