Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.62 KB | None | 0 0
  1. <select name="element">
  2. <?php
  3.  
  4.     try
  5.     {
  6.         /*** query the database ***/
  7.         $result = DB::getInstance()->query("SELECT atomicnumber, english FROM elements");
  8.  
  9.         /*** loop over the results ***/
  10.         foreach($result as $row)
  11.         {
  12.             /*** create the options ***/
  13.             echo '<option value="'.$row['atomicnumber'].'"';
  14.             if($row['atomicnumber']==42)
  15.             {
  16.                 echo ' selected';
  17.             }
  18.             echo '>'. $row['english'] . '</option>'."\n";
  19.         }
  20.     }
  21.     catch(PDOException $e)
  22.     {
  23.         echo 'No Results';
  24.     }
  25. ?>
  26. </select>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement