如何从mysql中选择/查询多个名称

9rygscc1 于 2021-06-21 发布在 Mysql

关注(0)|答案(1)|浏览(379)

大家好，
拜托，我正在尝试实现一些简单的东西，但我没有找到合适的解决方案在php。我想征求一些意见。
我在array/vector中有一个名为$lines的服务器列表，现在我想在mysql数据库中选择每个服务器名称，以便收集其他信息。
你能告诉我如何从中的服务器名称进行循环，选择/查询每一个吗？
谢谢！！

<html>
<head>
</head>
<body>
<form name="form1" method="post">
<textarea rows="10" name="servers[]" cols="50" ></textarea>
<input type="submit" name="submit" value="Submit" />
</form>
<?php
$con=mysqli_connect("hostxxxx","userxxxx","xxxxxxxx","xxxxxxx");
//Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  } 
if(isset($_POST["submit"]))
{
        if(!empty($_POST["servers"]))
        {
             echo '<h4>You have selected the following Servers:</4><br>';
            $submitted_array = array_keys($_POST["servers"]);                                                                  
       $lines = explode(PHP_EOL, $_POST["servers"][$submitted_array[0]]);
            foreach($lines as $servers)
            {           
        echo ($servers."<br>");
                }
}
else
{
echo 'Please write something';
}
}
?>
</body>
</html>

mysql php

来源：https://stackoverflow.com/questions/50142313/how-to-select-query-multiple-names-from-mysql

1条答案

按热度按时间

sdnqo3pr1#

我得到了我需要的结果，我希望它能帮助我：

<body>
<form name="form1" method="post">
<textarea rows="1000" name="servers[]" cols="100" style="width:300px;height:300px;"></textarea>
<input type="submit" name="submit" value="Submit" />
</form>
<?php
$con=mysqli_connect("hostxxxxx:portxx","userx","passxx","msdb");
//Check connection
if (mysqli_connect_errno())
 {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }    
if(isset($_POST["submit"]))
{
   if(!empty($_POST["servers"]))
   {
           echo '<h4>You have selected the following Servers:</4><br>';
           $submitted_array = array_keys($_POST["servers"]);                                                                  
           //BREAKING IN AN ARRAY
    $lines = explode(PHP_EOL, $_POST["servers"][$submitted_array[0]]);
           //foreach($lines as $servers)
           //{            
        //echo ($servers."<br>");
           //}
//REMOVING BLANK SPACES:        
function trim_value(&$value) 
{
   $value = trim($value); 
}
//ADDING QUOTES BETWEEN THE VALUES
function add_quotes($str) {
   return sprintf("'%s'", $str);
}
//REMOVING BLANK LINES        
array_walk($lines, 'trim_value');        
$VCSAC2 = "VCSAC2";
$LPAR = "LPAR";
$HOSTF = "HOSTF";
$CLASSG = "CLASSG";
$IP = "IP";
$STATUS = "STATUS";
//USING IMPLODE        
//$sql=sprintf("SELECT * FROM main WHERE HOSTF IN (".implode(',', $lines).")");
$sql=sprintf("SELECT * FROM main WHERE HOSTF IN (".implode(',', array_map('add_quotes',$lines)).")");        
//USED TO CHECK SQL SINTAX        
//echo $sql;        
$result=mysqli_query($con,$sql);    
}
else
{
   echo 'Please write something';
}
}
?>
<table id="demo1" cellpadding="0" cellspacing="0" style="width:100%" style="font-size:13px">
        <thead>  
       <tr>
                   <th align=left>HostName</th>
                   <th align=left>VCS</th>
            <th align=left>LPAR</th>
            <th align=left>IP</th>
            <th align=left>Class</th>
        </tr>
        </thead>
           <?php while($dado = mysqli_fetch_array($result)) {?>
       <tbody>
       <tr>
        <td align=left style="font-size:14px"><?php echo $dado[$HOSTF]; ?></td>
        <td align=left style="font-size:14px"><?php echo $dado[$VCSAC2]; ?></td>
            <td align=left style="font-size:14px"><?php echo $dado[$LPAR]; ?></td>
            <td align=left style="font-size:14px"><?php echo $dado[$IP]; ?></td>
            <td align=left style="font-size:14px"><?php echo $dado[$CLASSG]; ?></td>
            </tr>
        </tbody>
           <?php } ?>
           </table> <br><br>
</body>

展开查看全部

赞(0）回复(0）举报 2021-06-21

我来回答

如何从mysql中选择/查询多个名称

1条答案

相关问题

热门标签

最新问答