Advertisement
Falcon-G21

menapilkan data di combo box dengan mysqli

Oct 23rd, 2016
297
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.72 KB | None | 0 0
  1.            <select>
  2.               <option>Choose ID</option>
  3.               <?php    
  4.                 $con = new mysqli('localhost', 'root', '', 'mysqli_crud');
  5.                 if ($con->connect_errno > 0){
  6.                 die('Could not connect: ' .connect_error());
  7.                 }
  8.                 $sqli_id = mysqli_query($con, "SELECT * FROM tbl_artikel");
  9.                 if(mysqli_num_rows($sqli_id) == 0){
  10.                    echo "<option>No Data Here</option>";
  11.                 }else{
  12.                  while($row = mysqli_fetch_assoc($sqli_id)){
  13.                   echo "<option value=".$row['id'].">".$row['id']."</option>";
  14.                  }
  15.                  }
  16.               ?>          
  17.               </select>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement