Advertisement
tj1899

Insert NULL instead of blank if form fields left empty

Jul 14th, 2021 (edited)
380
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 1.90 KB | None | 0 0
  1. <?php
  2. if ($_SERVER['REQUEST_METHOD'] == "POST") {
  3. require('dbconnect.php');
  4. if (isset($_POST['submit'])) {
  5. if (empty($_POST['slist']) || empty($_POST['catelist'])) {
  6.    $showerror = "Location or Category can not be empty";
  7.  }
  8. else{
  9.  $location = $_POST['slist'];
  10.  $bio = (isset($_POST['setbio']) && !empty($_POST['setbio'])) ? $_POST['setbio'] : null;
  11.  $category = $_POST['catelist'];
  12.  $skill1 = (isset($_POST['skill1']) && !empty($_POST['skill1'])) ? $_POST['skill1'] : null;
  13.  $skill2 = (isset($_POST['skill2']) && !empty($_POST['skill2'])) ? $_POST['skill2'] : null;
  14.  $skill3 = (isset($_POST['skill3']) && !empty($_POST['skill3'])) ? $_POST['skill3'] : null;
  15. $sql = "INSERT INTO user_info(s_location, s_bio, s_category, s_skill1,s_skill2,s_skill3) VALUES (:location,:bio,:category,:s1,:s2,:s3)";
  16.  $stmt=$conn->prepare($sql);
  17.   $stmt->bindPARAM(':location',$location);
  18.   $stmt->bindPARAM(':bio',$bio);
  19.   $stmt->bindPARAM(':category',$category);
  20.   $stmt->bindPARAM(':s1',$skill1);
  21.   $stmt->bindPARAM(':s2',$skill2);
  22.   $stmt->bindPARAM(':s3',$skill3);
  23.  if ($stmt->execute()) {
  24.   echo"success";
  25.  }
  26.  else{
  27.   echo"some error occoured";
  28.  }
  29. }
  30. }
  31. }
  32. ?>
  33.  
  34. <form class="row g-3" method="POST" action="users.php">
  35. <select name="slist" id="slist" required>
  36.  <option value="">Select State</option>
  37.  <option value="1">state 1</option>
  38.  <option value="2">state 2</option>
  39.  <option value="3">state 3</option>
  40. </select>
  41. <textarea rows="5" name="setbio" id="setbio" maxlength="600"></textarea>
  42. <select name="catelist" id="catelist" required>
  43.   <option value="">Select Category</option>
  44.   <option value="1">Category 1</option>
  45.   <option value="2">Category 2</option>
  46.   <option value="3">Category 3</option>
  47. </select>
  48. <input  type="text" id="skill1" name="skill1" placeholder="1">
  49. <input type="text" id="skill2" name="skill2" placeholder="2">
  50. <input type="text" id="skill3" name="skill3" placeholder="3">
  51. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement