How can I show company_name in update_page which saved in brand table?

PHP
1

How can I show company_name in update_page which saved in brand table?



<form class="form-horizontal" action="brand_update.php?id=<?php echo $id?>" method="post">
<div class="control-group <?php echo !empty($brand_nameError)?'error':'';?>">
<label class="control-label">Brand </label>
<div class="controls">
<input name="brand_name" type="text"  placeholder="Brand Name" value="<?php echo !empty($brand_name)?$brand_name:'';?>">
<?php if (!empty($brand_nameError)): ?>
<span class="help-inline"><?php echo $brand_nameError;?></span>
<?php endif; ?>
</div>
</div>



<div class="control-group <?php echo !empty($company_nameError)?'error':'';?>">
<label class="control-label">Company </label>
<div class="controls">
<?php
$conn = new mysqli('localhost', 'root', '', 'mydb') 
or die ('Cannot connect to db');
    $result = $conn->query("select  company_name from company ORDER BY company_name ASC");
    echo "<select name='company_name'>";
    while ($row = $result->fetch_assoc()) {
                  unset( $company_name);
                  $company_name = $row['company_name']; 
				  echo '<option>'.$company_name.'</option>';
				   echo '<option>'. $row['company_name'].'</option>';
                  echo '<option value="'.$company_name.'">'.$company_name.'</option>';
                 }
    echo "</select>";
 ?>
</div>
</div>




<div class="control-group <?php echo !empty($noteError)?'error':'';?>">
<label class="control-label">Note</label>
<div class="controls">
<input name="note" type="text"  placeholder="Note" value="<?php echo !empty($note)?$note:'';?>">
<?php if (!empty($noteError)): ?>
<span class="help-inline"><?php echo $noteError;?></span>
<?php endif;?>
</div>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-success">Save</button>
<a class="btn" href="brand.php">Back</a>
</div>
</form>

1074×597 25.9 KB

2

You can by just adding “selected” to option with value from database

echo "<select name='company_name'>";
    while ($row = $result->fetch_assoc()) {
		echo '<option value="'.$row['company_name'].'" selected>'. $row['company_name'].'</option>';
		// other option ..............-----------------
    }
echo "</select>";
3

Hi mlukac89 ,

It fetches only last values.

4

Change this line while ($row = $result->fetch_assoc()) { to while ($row = $result->fetch_array(MYSQLI_ASSOC)) { so you will get an array with all selected items.

5

Yes, but you have to actually make sure that it’s the correct company, not just stick ‘selected’ on all of them.

echo "<select name='company_name'>";
while ($row = $result->fetch_assoc()) {
  $sel = "";
  if ($row['company_name'] == $yourcompanyname) $sel = " selected";
  echo '<option value="'.$row['company_name'].'" " . $sel . ">'. $row['company_name'].'</option>';
  // other option ..............-----------------
    }
echo "</select>";
2 Likes
6

Thanks @droopsnoot i forgot about that. :frowning:

7 
				 <?php

$conn = new mysqli(‘localhost’, ‘root’, ‘’, ‘tv_channel’)
or die (‘Cannot connect to db’);
$result = $conn->query(“select company_name from company order by company_name asc”);
echo “

8

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.