javascript - Dropdown list set put selected value from database -

-

i trying create drop down menu select value stored in database. right code creates dropdown first option selected. have read through several tutorials, , tried apply them, cannot working. hope can help.

<div class="form-group">     <label>up-to-date</label>     <select class="form-control" name="uptodate"/>         <option value="ja">ja</option>         <option value="nee">nee</option>     </select> </div>

whole code :

<?php  error_reporting(e_all);  ini_set('display_errors', 1);  session_start();  include("../includes/connect.php");    if (isset($_session['logged_in'])) {  	if(isset($_post['btnslaop'])) {  		$id=$_post['id'];  		$uitgeleend=$_post['uitgeleend'];  		$nr=$_post['nr'];  		$model=$_post['model'];  		$serienummer=$_post['serienummer'];  		$capaciteit=$_post['capaciteit'];  		$uptodate=$_post['uptodate'];  		$persoon=$_post['persoon'];  		$datumuitgeleend=$_post['datumuitgeleend'];  		$datumretour=$_post['datumretour'];  		$opmerking=$_post['opmerking'];  		$sql="update ipads set uitgeleend='$uitgeleend', nr='$nr', model='$model', serienummer='$serienummer', capaciteit='$capaciteit', uptodate='$uptodate', persoon='$persoon', datumuitgeleend='$datumuitgeleend', datumretour='$datumretour', opmerking='$opmerking' id='$id'";  		$result=$db->query($sql);  		header("location:overzicht-ipads.php");  	} else if (isset($_post['btnslaopings'])) {  		$id=$_post['id'];  		$uitgeleend=$_post['uitgeleend'];  		$nr=$_post['nr'];  		$model=$_post['model'];  		$serienummer=$_post['serienummer'];  		$capaciteit=$_post['capaciteit'];  		$uptodate=$_post['uptodate'];  		$persoon=$_post['persoon'];  		$datumuitgeleend=$_post['datumuitgeleend'];  		$datumretour=$_post['datumretour'];  		$opmerking=$_post['opmerking'];  		$sql  ="update ipads set nr='$nr', model='$model', serienummer='$serienummer', capaciteit='$capaciteit', uptodate='$uptodate', persoon='$persoon', datumuitgeleend='$datumuitgeleend', datumretour='$datumretour', opmerking='$opmerking' id='$id'";  		$sql .="insert geschiedenis (select * ipads id='$id')";  		$sql .="update ipads set uitgeleend='nee', persoon='', datumuitgeleend='', datumretour='', opmerking='' id='$id'";  		$result=mysqli_multi_query($db, $sql);  		header("location:overzicht-ipads.php");  	}  	if(isset($_get['id'])) {  		$id=$_get['id'];  		$sql="select id, uitgeleend, nr, model, serienummer, capaciteit, uptodate, persoon, datumuitgeleend, datumretour, opmerking ipads id='$id'";  		$result=$db->query($sql);  		$rij=$result->fetch_assoc();  		$uitgeleend=$rij['uitgeleend'];  		$nr=$rij['nr'];  		$model=$rij['model'];  		$serienummer=$rij['serienummer'];  		$capaciteit=$rij['capaciteit'];  		$uptodate=$rij['uptodate'];  		$persoon=$rij['persoon'];  		$datumuitgeleend=$rij['datumuitgeleend'];  		$datumretour=$rij['datumretour'];  		$opmerking=$rij['opmerking'];  		  		include("../includes/get_header_wn.php");  ?>              <h1 class="page-title">wijzigen</h1>                      <ul class="breadcrumb">              <li><a href="index.php">home</a> </li>              <li class="active">leen ipad <?php echo $nr ?></li>          </ul>            </div>    <form id="gegevensform" class="col-xs-4" form method="post" action="overzicht-ipads-edit.php">  	<input type="hidden" name="id" value="<?php echo $id?>">      <div class="form-group">          <label>uitgeleend</label>          <input type="text" class="form-control" name="uitgeleend" value="<?php echo $uitgeleend ?>" />      </div>        <div class="form-group">          <label>nr</label>          <input type="text" class="form-control" name="nr" value="<?php echo $nr ?>" />      </div>        <div class="form-group">          <label>model</label>          <input type="text" class="form-control" name="model" value="<?php echo $model ?>" />      </div>        <div class="form-group">          <label>serienummer</label>          <input type="text" class="form-control" name="serienummer" value="<?php echo $serienummer ?>" />      </div>        	<div class="form-group">          <label>capaciteit</label>  		 <input type="text" class="form-control" name="capaciteit" value="<?php echo $capaciteit ?>" />      </div>           <div class="form-group">          <label>up-to-date</label>          <select class="form-control" name="uptodate"/>  		<option value="ja">ja</option>  		<option value="nee">nee</option>  		</select>      </div>    	<div class="form-group">          <label>persoon</label>          <input type="text" class="form-control" name="persoon" value="<?php echo $persoon ?>" />      </div>  	  	<div class="form-group">          <label>datum uitgeleend</label>          <input type="text" id="datepicker" class="form-control" name="datumuitgeleend" value="<?php echo $datumuitgeleend ?>" />      </div>  	  	<div class="form-group">          <label>datum retour</label>          <input type="text" id="datepicker1" class="form-control" name="datumretour" value="<?php echo $datumretour ?>" />      </div>  	  	<div class="form-group">  		<label for="comment">opmerking</label>  		<textarea class="form-control" rows="5" id="comment" name="opmerking" /><?php echo $opmerking ?></textarea>  	</div>        <button class="btn btn-primary pull-right" name="btnslaop" input type="submit"><i class="fa fa-save"></i> opslaan</button>  	      <a href="overzicht-ipads.php"><input type="button" name="btncancel" value="annuleer" class="btn btn-primary pull-left"></a>  	  	<button class="btn btn-primary pull-middle" name="btnslaopings" type="submit"><i class="fa fa-save"></i> opslaan & archiveren</button>  	      <?php  		include('../includes/get_footer.php');  	?>  </form>    <?php  			}  			} else {  			header("location:overzicht-ipads.php");  			}  		?>

php: if($selectedval == "yourval") echo "selected";

e.g.:

<div class="form-group">     <label>up-to-date</label>     <select class="form-control" name="uptodate"/>         <option value="ja" <?php if($selectedval == "ja") echo "selected";?>>ja</option>         <option value="nee" <?php if($selectedval == "nee") echo "selected";?>>nee</option>     </select> </div>

edit: in case, replace $selectedval $uptodate


Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

reactjs - React router and this.props.children - how to pass state to this.props.children -

-
i'm using react-router first time , don't know how think in yet. here's how i'm loading components in nested routes. entry point .js reactdom.render( <router history={hashhistory} > <route path="/" component={app}> <route path="models" component={content}> </route> </router>, document.getelementbyid('app') ); app.js render: function() { return ( <div> <header /> {this.props.children} </div> ); } so child of app content component sent in. i'm using flux , app.js has state , listens changes, don't know how pass state down this.props.children. before using react-router app.js defines children explicitly, passing state natural don't see how now. using couple of react helper methods can add state, props , whatever else this.props.children render: function() { var children = react.ch...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more