Re: reuse my data source

There are ways to reset/rewind the results, however if you loop and fetch into an array you don't have to reset the array and If you use fetchAll() $data = $stmt->fetchAll(PDO::FETCH_ASSOC); You just foreach over $data whenever you want. On Mon, Jun 2, 2014 at 11:59 AM, Jim Lucas <lists@cmsws.com> wrote: > On 05/31/2014 10:16 AM, ICCSI wrote: > >> I have following code to get data to show data and fill my select list. >> The following code works either to fill list or show data in the table, >> but >> not both. >> >> It looks like the data show on the table then it reaches the end of data, >> so the select list does not have anything to fill. I might be wrong. >> >> If I am right, how can I move the data to BOF, or if I am wrong then is it >> possible to have it reuse the data source second time on the form. >> >> Your help and information is great appreciated, >> >> Regards, >> >> >> Iccsi, >> >> <?php >> >> >> $hostname = 'localhost'; >> $username = 'root'; >> $password = 'password'; >> >> try { >> $dbh = new PDO("mysql:host=$hostname;dbname="MyDB", $username, >> $password); >> echo 'Connected to database'; >> } >> catch(PDOException $e) >> { >> echo $e->getMessage(); >> } >> >> $stmt = $dbh->query('SELECT MyField from Mytable'); >> while($data = $stmt->fetch(PDO::FETCH_ASSOC)){ >> >> echo >> "<tr><td>".$data{'MyField'}."</td></tr>"; >> >> } >> ?> >> >> <select name='mylist' id='mylist' size='1'> >> >> <?php >> >> while($row = $stmt->fetch(PDO::FETCH_ASSOC)) >> >> { >> >> echo "<option>".$row['MyField']."</option>"; >> >> } >> >> ?> >> >> </select> >> >> > Try this: > > > <?php > > $hostname = 'localhost'; > $username = 'root'; > $password = 'password'; > > $dataSet = array(); > > > try { > > $dbh = new PDO("mysql:host=$hostname;dbname="MyDB", $username, > $password); > > echo 'Connected to database'; > > } catch(PDOException $e) { > > echo $e->getMessage(); > > exit; > > > } > > $stmt = $dbh->query('SELECT MyField from Mytable'); > > while ( $data = $stmt->fetch(PDO::FETCH_ASSOC) ) { > > $dataSet[] = $data; > > } > > if ( $dataSet ) { > > reset($dataSet); > > echo "<table>"; > > foreach ( $dataSet AS $row ) { > > echo "<tr><td>[$row['MyField']}</td></tr>"; > > } > > echo "</table>"; > > } > > if ( $dataSet ) { > > reset($dataSet); > > echo "<select><option>Make your choice</option>"; > > foreach ( $dataSet AS $row ) { > > echo "<option>{$row['MyField']}</option>"; > > } > > echo "</select>"; > > } > > > -- > Jim Lucas > > http://www.cmsws.com/ > http://www.cmsws.com/examples/ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >