PHP – Change value y,n in database [closed]

by

Hope you need something like this.

<?php
$row->is_sponsored_by = 'y';//already stored value
$dropDnArr = array('y' => 'Yes', 'n' => 'No');//Say y & n storing DB And Yes & No is to display
echo "selected value ={$row->is_sponsored_by}<br/>";  ?> 
<label>Get Sponsored <span style="color:red">*</span></label>
<select style="width:100px;" class="form-control" name="sponsor"> <?php
    foreach ($dropDnArr AS $key => $value) {?>
        <option value="<?php echo $key;?>" 
                <?php echo (isset($row)) ? (($row->is_sponsored_by == $key) ? "selected" : "") : "";?> >
            <?php echo $value;?>
        </option> <?php
    } ?>
</select>

More Related Contents:

  1. strange character encoding of stored data , old script is showing them fine new one doesn’t
  2. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  3. How to create codeigniter dynamic menu from single table
  4. Laravel one to many relation with a one to one relation
  5. which is better every user have a table or just a row [closed]
  6. save user images in MYSQL database by which method? [closed]
  7. PDOException SQLSTATE[HY000] [2002] No such file or directory
  8. Many-to-many relationships examples
  9. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  10. How to upload images into MySQL database using PHP code
  11. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  12. MySQL check if a table exists without throwing an exception
  13. Maximum execution time in phpMyadmin
  14. Mysql No connection could be made because the target machine actively refused it
  15. How can I Use Prepared Statements in CodeIgniter
  16. Replacing mysql_* functions with PDO and prepared statements
  17. Is there any way to check the performance of mysql Indexing
  18. Codeigniter – Using Multiple Databases
  19. Selecting a float in MySQL
  20. How to create Codeigniter language files from database?
  21. phpmyadmin automatic logout time
  22. MySQL skipping first row
  23. Fatal error: Call to undefined function mysqli_result()
  24. Laravel nested relationships
  25. Codeigniter Transactions
  26. Inserting NOW() into Database with CodeIgniter’s Active Record
  27. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  28. mysql injection damages?
  29. How do I save PHP session data to a database instead of in the file system?
  30. Escaping SQL queries in Codeigniter

Leave a Comment