php - Database driven select box being empty on submit -

-

i trying submit form value in database php. in form select box value comes database.

<?php include_once 'header.php'; $sql="select uid,name emitra_basic block='$user'"; $result = $conn->query($sql); //form validion  if(isset($_post['submit']))    {   $eid =$_post["eid"];   if($eid=="blank")  {      $flag=1;   $iderr="please select e-mitra";  } $miatm =trim($_post["miatm"]);  if(empty($miatm) || !preg_match("/^[a-za-z0-9 ]*$/",$miatm)) { $flag=1;  $mierr="please enter valid id";  }  .............like if($flag==0) { $sqll="insert **********";   }

//my form is

<form id="basic" method="post" name="basic">  <select class="select-style gender" name="eid">         <option value="blank">please select e-mitra id</option>         <?php  while($row=mysqli_fetch_array($result))  { ?>   <option value="<?php echo $row['uid']; ?>"><?php echo $row['uid']." (" . $row['name'] .")"; ?></option> <?php  } ?> </select>      <p class="contact"><label for="bid">micro-atm serial no</label></p>  <input type="text" name="miatm" value ="<?php if (isset($miatm)) echo $miatm; ?>"    /> <?php echo $mierr; ?>   <p class="contact"><label for="bid">micro-atm tid no</label></p>  <input type="text" name="tid" value ="<?php if (isset($tid)) echo $tid; ?>" /> <?php echo $tierr; ?>     <input class="buttom" name="submit" id="submit"  value="add me" type="submit">

its seems ok.but when tried submit form if of 1 field remain empty show blank value in select box. how can remain same selected value in select box if textbox remain empty.

you need retain value of drop down after form submit.

user selected attribute of select option.

<?php if (isset($_post['submit'])) {   $eid =$_post["eid"];   if ($eid=="blank") {     $flag=1;     $iderr="please select e-mitra";   } } $sql="select uid,name emitra_basic block='$user'"; $result = $conn->query($sql); ?> <select class="select-style gender" name="eid"> <option value="blank">please select e-mitra id</option> <?php while($row=mysqli_fetch_array($result)) {   $selected = (isset($_post["eid"]) && $_post["eid"] == $row['uid']) ? 'selected="selected"' : ''; ?>   <option value="<?php echo $row['uid']; ?>" <?php echo $selected;?>><?php echo $row['uid']." (" . $row['name'] .")"; ?></option> <?php  } ?> </select>

Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more