php怎么读取MYSQL数据到radio选项 】、如上图,我想把“生源”右边需要填写的那一栏由input的text类型变成radio类型,让用户从某个存有生源数据的mysql数据库里选取生源城市。请问怎么在源代码中读取数据库中的生源城市并生产radio类型。本人新手,请给位多多指教。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我觉得是先把数据库的内容读取出来,生源那个用Select做,选项可以用for循环弄 先从数据库读数据,例如性别那块的数据,3个radio是同一个值,那么把读出来的性别值分别对三种情况进行判断,if(性别字段值 == 男){radio男checked}elseif(性别字段值 == 女){radio女checked}else{radio保密checked}....户口类型类似这样 <select> <?php for($i=0;$i<10;$i++) echo "<option value='city'>".$i."</option>"; ?></select> 数据库部分不太会,但我想的是先select出所有地点,然后用mysql_fetch_array()这个函数,取出每一行应该就行了 <?php $sex = 0;?><html><head><title></title></head><body> <label > <input type="radio" name='sex' value='1' <?php if($sex==1){ echo 'checked'; } ?> >是 </label> <label > <input type="radio" name='sex' value='0' <?php if($sex==0){ echo 'checked'; } ?> >否 </label> </body></html> 您好,再给我看看。我选择并登陆数据库后应该怎么选择TABLE呢,我的那个存放生源的数据库为cb,表单为nation,表单中city那一列为生源城市。 <td> <select name="source"> <?php $url = "localhost"; $user = "root"; $password = "cb40922020"; $con = mysql_connect($url,$user,$password); mysql_query("set names 'utf8'"); mysql_select_db("cb"); mysql_fetch_array(); for ($i=0; $i <10 ; $i++) { echo "<option value='city'>".$i."</option>"; } ?> </select> </td> $res=mysql_query("select city from nation“);while($row=mysql_fetch_array($res)) echo "<option value='city'>".$row['city']."</option>"; <?php$query = mysql_query("select city from nation");$citys = array(1,2,3,4);while($thread=mysql_fetch_assoc($query)){ $citys[] = $thread['city'];}foreach($citys as $k=>$v){ echo '<input type="radio" value="'.$v.'">'.$v;}?> 版主您好,按照您的方法,还是不行呢。<select name="source"> <option>---请选择---</option> <?php] mysql_connect("localhost","root","cb40922020") or die("Error:",mysql_error()); mysql_select_db("cb"); $query=mysql_query("select city from nation"); $citys= array(1,2,3,4); while ($row = mysql_fetch_assoc($query)){ $citys[]=$row['city']; } foreach ($citys as $k => $v) { echo '<option value="'.$v.'">.$v</option>'; } ?> </select>最终结果为: 你要radio还是select? 要select,问题中我写的有误,不是radio,抱歉 <select> $servername="localhost"; $username="root"; $password="cb40922020"; $dbname="cb"; $conn = new mysqli($servername,$username,$password,$dbname); if($conn->connect_error) die( 'Connect Error'.$conn->connect_error); $sql="select city from nation"; echo "<select>"; if($res->num_rows > 0){ while($row=$res->fetch_assoc()) echo "<option>".$row['city']."</option>"; } $res->close(); $conn->close();</select> <?php$query = mysql_query("select city from nation");$citys = array();while($thread=mysql_fetch_assoc($query)){ $citys[] = $thread['city'];}echo '<select name="city">'; foreach($citys as $k=>$v){ echo '<option value="'.$v.'">'.$v.'</option>';}echo '</select>'?> 各位牛人,有人听说过网络营销系统吗 关于ob_start(); PHP程序如何调用html文件?小白问题,求指导!! [求助]如何用PHP实现这个功能? 我的PHP不能连接到Mysql,求救! FTP上传问题,源代码见正文 哪里有vbuletin的安装说明呀 fopen()函數怎么不能用??在哪可以設置嗎? 写函数高手请帮忙。。。。 呵呵,请问我要学php需要装那些东西(我用win2000),在哪儿下载? 求大神给看看 用php写的代码 收到的短信是乱码 如何取出二维数组中的不重复元素并进行拼接?php
if(性别字段值 == 男){radio男checked}elseif(性别字段值 == 女){radio女checked}else{radio保密checked}....户口类型类似这样
<?php
for($i=0;$i<10;$i++)
echo "<option value='city'>".$i."</option>";
?>
</select>
<?php
$sex = 0;
?>
<html>
<head>
<title></title>
</head>
<body>
<label >
<input type="radio" name='sex' value='1' <?php if($sex==1){ echo 'checked'; } ?> >是
</label>
<label >
<input type="radio" name='sex' value='0' <?php if($sex==0){ echo 'checked'; } ?> >否
</label>
</body>
</html>
<td>
<select name="source">
<?php
$url = "localhost";
$user = "root";
$password = "cb40922020";
$con = mysql_connect($url,$user,$password);
mysql_query("set names 'utf8'");
mysql_select_db("cb");
mysql_fetch_array(); for ($i=0; $i <10 ; $i++) {
echo "<option value='city'>".$i."</option>";
}
?>
</select>
</td>
$res=mysql_query("select city from nation“);
while($row=mysql_fetch_array($res))
echo "<option value='city'>".$row['city']."</option>";
<?php
$query = mysql_query("select city from nation");
$citys = array(1,2,3,4);
while($thread=mysql_fetch_assoc($query)){
$citys[] = $thread['city'];
}foreach($citys as $k=>$v){
echo '<input type="radio" value="'.$v.'">'.$v;
}
?>
版主您好,按照您的方法,还是不行呢。
<select name="source">
<option>---请选择---</option>
<?php]
mysql_connect("localhost","root","cb40922020") or die("Error:",mysql_error());
mysql_select_db("cb");
$query=mysql_query("select city from nation");
$citys= array(1,2,3,4);
while ($row = mysql_fetch_assoc($query)){
$citys[]=$row['city'];
}
foreach ($citys as $k => $v) {
echo '<option value="'.$v.'">.$v</option>';
}
?>
</select>最终结果为:
要select,问题中我写的有误,不是radio,抱歉
$username="root";
$password="cb40922020";
$dbname="cb";
$conn = new mysqli($servername,$username,$password,$dbname);
if($conn->connect_error)
die( 'Connect Error'.$conn->connect_error);
$sql="select city from nation"; echo "<select>";
if($res->num_rows > 0){
while($row=$res->fetch_assoc())
echo "<option>".$row['city']."</option>";
}
$res->close();
$conn->close();</select>
<?php
$query = mysql_query("select city from nation");
$citys = array();
while($thread=mysql_fetch_assoc($query)){
$citys[] = $thread['city'];
}
echo '<select name="city">';
foreach($citys as $k=>$v){
echo '<option value="'.$v.'">'.$v.'</option>';
}
echo '</select>'
?>