Member Avatar for ElegantElephant

I have a dropdown list and the selected item depends on the record the form is for. How do I allow PHP to determine which item in the list is selected according to how that row is configured?

Edited by ElegantElephant because: n/a
  • 5 Contributors
  • 4 Replies
  • 98 Views
  • 19 Hours Discussion Span
  • Latest Post Latest Post by saiprem

Dani AI

Generated

For : the typical server-side approach is to fetch the record value and, when you render the <select>, compare each option value to that record and output the selected attribute for the matching option. asked for a snippet, so below is a safe, minimal example. 's tutorial can help with basics and 's point about using AJAX is valid when option lists depend on other selections.

<?php
// $row is the DB row for the form
$current = isset($_POST['status']) ? $_POST['status'] : $row['status'];

$options = [
  'open'    => 'Open',
  'pending' => 'Pending',
  'closed'  => 'Closed',
];

foreach ($options as $value => $label) {
  $sel = ((string)$value === (string)$current) ? ' selected' : '';
  echo '<option value="' . htmlspecialchars($value, ENT_QUOTES, 'UTF-8') . '"' . $sel . '>'
       . htmlspecialchars($label, ENT_QUOTES, 'UTF-8') . '</option>';
}
?>

Notes and quick troubleshooting:

  • Use htmlspecialchars to avoid XSS when echoing values or labels.
  • Prefer strict comparison or cast to string to avoid mismatches between ints and strings.
  • If you want the form to "remember" a user choice after validation fails, check $_POST first (as shown).
  • If options come from a separate DB query, loop over that result the same way: compare each option's id to the saved id.
  • If the selected option is not appearing, view the page source to confirm the selected attribute is present and verify the variable used for comparison actually holds the expected value (use var_dump during debugging).

If the second dropdown depends on the first, load options via AJAX on change to avoid full page reloads (as suggested). Use prepared statements when fetching DB values.

Recommended Answers

All 4 Replies

Member Avatar for rondroid

Can you give me a little code snippet?

Ron

Member Avatar for scmsimplybest

Hello ElegantElephant,

Please Provide Some Of Ur Code...or Post Ur Whole Problem Code here So we can figure it Out !! :)

Thanks !!

Member Avatar for saiprem

It seems the link which you gave is working fine and I didn't understand what we need to do.

I can give you one suggestion in your code, Instead of resubmitting the whole form data, make an Ajax call to update the second dropdown(Fill the second dropdown using Ajax call).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.