PHP:更新查询问题 [英] PHP: Update query issue

问题描述

我有一个更新查询，它工作正常.当我单击编辑"按钮时，它将显示其中包含内容的字段，我们要对其进行编辑或更新.

<input type="text" />可以正常工作，但我也想要<select>标记.

代码是这样的

Hi,

I have an update query, which is working fine. When I click on the edit button, it shows the field with content inside it, which we want to edit or update.

It is working fine with <input type="text" /> but I also want it with <select> tag.

code is like this

<select name='location' value="<?php echo $row['location']; ?>">
                 <option value=''> - Select - </option>
                 <option value='Anywhere' >Anywhere</option>
                 <option value='Ahmedabad' >Ahmedabad</option>
                 <option value='Bangalore' >Bangalore</option>
                 <option value='Chennai' >Chennai</option>
                 <option value='Delhi' >Delhi</option>
                 <option value='Delhi Region' >Delhi Region</option>
                 <option value='Gurgaon' >Gurgaon</option>
                 <option value='Hyderabad' >Hyderabad</option>
                 <option value='Kolkata' >Kolkata</option>
                 <option value='Mumbai' >Mumbai</option></select>

所以我想要我已经选择的城市，它应该显示在编辑页面上，但就我而言，它不显示，我必须再次选择，如果我未选择任何城市，则它在数据库中显示为空白.

谁能在这方面，我的工作或必须更改的内容上帮助我

So i want whatever i city already chose, it should show on edit page, but in my case its not showing, i have to select again, if i am not selecting any city then it shows blank in the database.

Can anyone help me in this, what i do or what i have to change

推荐答案

row ['location']; ?>> < option value =''> -选择-</option> < option value ='Anywhere'> Anywhere</option> < option value ='Ahmedab​​ad'> Ahmedab​​ad</option> < option value ='班加罗尔'>班加罗尔</option> < option value ='Chennai'> Chennai</option> < option value ='德里'>德里</option> < option value =德里地区">德里地区</option> < option value ='Gurgaon'> Gurgaon</option> < option value ='海得拉巴'>海得拉巴</option> < option value ='加尔各答'>加尔各答</option> < option value ='孟买'>孟买</option></select>

row['location']; ?>"> <option value=''> - Select - </option> <option value='Anywhere' >Anywhere</option> <option value='Ahmedabad' >Ahmedabad</option> <option value='Bangalore' >Bangalore</option> <option value='Chennai' >Chennai</option> <option value='Delhi' >Delhi</option> <option value='Delhi Region' >Delhi Region</option> <option value='Gurgaon' >Gurgaon</option> <option value='Hyderabad' >Hyderabad</option> <option value='Kolkata' >Kolkata</option> <option value='Mumbai' >Mumbai</option></select>

所以我想要我已经选择的城市，它应该显示在编辑页面上，但就我而言，它不显示，我必须再次选择，如果我未选择任何城市，则它在数据库中显示为空白.

谁能在这方面，我的工作或必须更改的内容上为我提供帮助

So i want whatever i city already chose, it should show on edit page, but in my case its not showing, i have to select again, if i am not selecting any city then it shows blank in the database.

Can anyone help me in this, what i do or what i have to change

您需要设置应选择的选项的selected属性.因此，如果应选择任意位置"，结果将是:

You would need to set the selected property of the option that should be selected. So, if Anywhere should be selected, the result would be:

<option value="Anywhere" selected="selected">Anywhere</option>

最好是使用循环添加选项，并将所选属性添加到所选选项.

祝你好运！

Best would be to add the options using a loop and add the selected property to the selected option.

Good luck!

这篇关于PHP:更新查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！