php数组获获取数据库相应id值
来源:百度知道 编辑:UC知道 时间:2024/05/30 04:38:29
<FORM METHOD=POST ACTION="play.php">
<?php
mysql_connect("localhost","hedejiang","hedejiang");
mysql_select_db("hedejiang");
mysql_query("SET NAMES 'utf8'");
$sql="SELECT * FROM `imusic` LIMIT 0 , 5";
$query=mysql_query($sql);
while($row=mysql_fetch_array($query)){
$id=$row['imusic_id'];
$name=$row['imusic_name'];
echo "<hr/>";
echo $id."<INPUT TYPE=\"checkbox\" NAME=\"checkbox[]\" value=\"$id\">".$name;
}
?>
<hr/>
<INPUT TYPE="submit" ONCLICK="">
</FORM>
我B页面的代码
<?php
if($_POST!=""){
$p=$_POST['checkbox'];
print_r($p);
echo "<br/>";
foreach($p as $k=>$v){
echo $v.'<
<?php
mysql_connect("localhost","hedejiang","hedejiang");
mysql_select_db("hedejiang");
mysql_query("SET NAMES 'utf8'");
$sql="SELECT * FROM `imusic` LIMIT 0 , 5";
$query=mysql_query($sql);
while($row=mysql_fetch_array($query)){
$id=$row['imusic_id'];
$name=$row['imusic_name'];
echo "<hr/>";
echo $id."<INPUT TYPE=\"checkbox\" NAME=\"checkbox[]\" value=\"$id\">".$name;
}
?>
<hr/>
<INPUT TYPE="submit" ONCLICK="">
</FORM>
我B页面的代码
<?php
if($_POST!=""){
$p=$_POST['checkbox'];
print_r($p);
echo "<br/>";
foreach($p as $k=>$v){
echo $v.'<
mysql_select_Db("hedejiang");
先把大小写改了,
你也得告诉print_r($p);打印出什么来才好分析
<?php
$p=$_POST['checkbox'];
print_r($p);
mysql_connect("localhost","hedejiang","hedejiang");
mysql_select_db("hedejiang");
$sql="select * from `imusic` where `imusic_id` in (join(',',$p))";
$query=mysql_query($sql);
while($assoc=mysql_fetch_assoc($query)){
echo $assoc['imusic_name'];
}
?>
没事用 print_r 进行输出看看。