Populate data into drop down list

PHP
1

hey guys, so im trying to populate data from database into a drop down list. when i was working with mysql it worked fine and now i mgrated to pdo, so im still learning, and the coding changed and the drop down doesn’t get populated. is there something wrong with my code?


<div class="dropdown">
		<label>Choose an Event : <label/>
		<select name="event" id="event">
			<option value="" disabled selected>Choose</option>
			<?php
			require "connection.php";
			$user_id = $_SESSION['sess_user_id'];
			$eventnames = $dbh->prepare("SELECT event_id,event_name FROM event WHERE euser_id = $user_id");
			$eventnames->execute(array('euser_id'));
			if($eventnames->rowCount() > 0)
			{
				$eventnames->setFetchMode(PDO::FETCH_ASSOC);
				while( $retrieve = $eventnames->fetch());
				{
					$id = $retrieve['event_id'];
					$name = $retrieve['event_name'];
					echo '<option value="'.$id.'">'.$name.'</option>';
				}
			}
			?>
		</select>
	</div>

previously the fetch query was done above <!doctype html> thought it was because of placement or something.


<?php
			require "connection.php";
			$user_id = $_SESSION['sess_user_id'];
			$eventnames = $dbh->prepare("SELECT event_id,event_name FROM event WHERE euser_id = $user_id");
                        $events ="";
			$eventnames->execute();
			if($eventnames->rowCount() > 0)
			{
				$eventnames->setFetchMode(PDO::FETCH_ASSOC);
				while( $retrieve = $eventnames->fetch());
				{
					$id = $retrieve['event_id'];
					$name = $retrieve['event_name'];
					$events .= '<option value="'.$id.'">'.$name.'</option>';
				}
			}
			?>

<div class="dropdown">
		<label>Choose an Event : <label/>
		<select name="event" id="event">
			<option value="" disabled selected>Choose</option>
			<?php
			       echo $events;
                   	?>
		</select>
	</div>

TIA! :slight_smile:

2

I’d do this:


<div class="dropdown">
		<label>Choose an Event : <label/>
		<select name="event" id="event">
			<option value="" disabled selected>Choose</option>
			<?php
			require "connection.php";
			$user_id = $_SESSION['sess_user_id'];
			$eventnames = $dbh->prepare("SELECT event_id,event_name FROM event WHERE euser_id = :user");
        $eventnames->bindParam(':user', $user_id);
			$eventnames->execute();
			if($eventnames)
			{
				while( $retrieve = $eventnames->fetch());
				{
					$id = $retrieve['event_id'];
					$name = $retrieve['event_name'];
					echo '<option value="'.$id.'">'.$name.'</option>';
				}
			}
        $eventnames->CloseCursor();
			?>
		</select>
	</div>

If it didn’t work, I’d add lots of echo() statements, and enable error reporting, so I can see how far it gets and what’s going wrong. (Don’t know why my indents don’t work the same).

3

i got :

Array ( [0] => 00000 [1] => [2] => )

when i added:

print_r($eventnames->errorInfo());

what does that mean?

4

Hard to say. Where did you add that code, and did the drop-down list work?

5

i added it where

$eventnames = CloseCursoe()

is suppose to be. no the drop down did not work.

6

solution:


require "connection.php"; 
    $user_id = $_SESSION['sess_user_id']; 
    $eventnames = $dbh->prepare("SELECT event_id,event_name FROM event WHERE euser_id = :user"); 
    $eventnames->bindParam(':user', $user_id);
    $eventnames->execute();
    $retrieve = $eventnames->fetchAll();

   <div class="dd-wrap">
		<label>Choose an Event : <label/>
		<select name="eventss" onchange="getnames(this.value)">
			<option value="" disabled selected>Choose</option>
			<?php foreach($retrieve as $r): ?>
			<option value="<?=$r['event_id']?>"><?=$r['event_name']?></option>
			<?php endforeach ?>
		</select>
	</div>

question solved.