dongyin2643 2016-03-27 12:51
浏览 32

将来自sql数据填充的列表的数据插入sql

I want to insert into different sql table the data coming from list populated by data coming from sql table. Please help

   if(isset($_POST['submit'])){
     mysql_connect("localhost","root","") or die(mysql_error());
        mysql_select_db("edge");
        $sql = "INSERT INTO my_table (this_is_one)
                    VALUES ('".$_POST['this_is_one']."')";

    }

//Connect and select array to dropdown
$conn = mysql_connect("localhost","root","") or die(mysql_error());
        mysql_select_db("save");


$options = '';
$sql = "SELECT * FROM reg1"; 
$result = mysql_query($sql,$conn);

while($row = mysql_fetch_array($result)) {
    $options .="<option>" . $row['Last_Name'] . "</option>";
}

$menu="<form id='this_is_one' name='this_is_one' method='post' action='listpopulate.php'>
  <p><label>filter</label></p>
    <select name='this_is_one' id='this_is_one'>
      " . $options . "
    </select>
    <input type='submit' value='submit'>    
</form>";
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
    • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
    • ¥15 MATLAB中streamslice问题
    • ¥15 如何在炒股软件中,爬到我想看的日k线
    • ¥15 51单片机中C语言怎么做到下面类似的功能的函数(相关搜索:c语言)
    • ¥15 seatunnel 怎么配置Elasticsearch
    • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
    • ¥15 (标签-MATLAB|关键词-多址)
    • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
    • ¥500 52810做蓝牙接受端