HTML表单使用下拉列表提交

I am a bit new to PHP development. I have a form that I need to submit and insert values into a specific table.

For example:

I have H&M value in a drop down list, and when I choose this option in a drop down list all the values are inserted in all other tables and in a table that I have chosen.

I have this part first:

$projectIndex = 0;
switch ('ddlProjekat') 
{
    case "0":
        $projectIndex = 0;
        break;
    case "H&M":
        $projectIndex = 1;
        break;
    case "Takko Fashion":
        $projectIndex = 2;
        break;
    case "Deichmann":
        $projectIndex = 3;
        break;
    case "CortefielSRB":
        $projectIndex = 4;
        break;
    case "CortefielBiH":
        $projectIndex = 5;
        break;
    case "CortefielMNE":
        $projectIndex = 6;
        break;
    case "CortefielCRO":
        $projectIndex = 7;
        break;          
    case "C&A Fashion":
        $projectIndex = 8;
        break;
    case "Sephora":
        $projectIndex = 9;
        break;
    case "Lurdy":
        $projectIndex = 10;
        break;
}

Then goes the HTML form with all the fields, and then this part:

if(isset($_POST['btnSubmit']))
{
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}

if(! get_magic_quotes_gpc() )
{
   $prodavnica = addslashes ($_POST['tbBrProd']);
   $grad = addslashes($_POST['tbGrad']);
   $adresa = addslashes($_POST['tbAddress']);
   $telefon = addslashes($_POST['taTelefon']);
   $rvreme = addslashes($_POST['taRVreme']);
   $aglk = addslashes($_POST['taAGLK']);
   $datumtp = addslashes($_POST['tbDatum']);
   $usb = addslashes($_POST['tbUSB']);
   $iprange = addslashes($_POST['tbIPRange']);
   $projekat = addslashes($_POST['ddlProjekat']);
   }
else
{
   $prodavnica = addslashes ($_POST['tbBrProd']);
   $grad = addslashes($_POST['tbGrad']);
   $adresa = addslashes($_POST['tbAddress']);
   $telefon = addslashes($_POST['taTelefon']);
   $rvreme = addslashes($_POST['taRVreme']);
   $aglk = addslashes($_POST['taAGLK']);
   $datumtp = addslashes($_POST['tbDatum']);
   $usb = addslashes($_POST['tbUSB']);
   $iprange = addslashes($_POST['tbIPRange']);
   $projekat = addslashes($_POST['ddlProjekat']);
   }
if($projectIndex = 1){


$sql = "INSERT INTO hm ".
       "(StoreID, Grad, Adresa, Telefon, RadnoVreme, AGLK, DatumTP, BeetleModel, IPRange)".
       "VALUES('$prodavnica','$grad','$adresa', '$telefon', '$rvreme', '$aglk', '$datumtp', '$usb', '$iprange')";


mysql_select_db('fiskali');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}
}
?>
<?php
if($projectIndex = 2){


$sql = "INSERT INTO takko ".
       "(StoreID, Grad, Adresa, Telefon, RadnoVreme, AGLK, DatumTP, BeetleModel, IPRange) ".
       "VALUES('$prodavnica','$grad','$adresa', '$telefon', '$rvreme', '$aglk', '$datumtp', '$usb', '$iprange')";


mysql_select_db('fiskali');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}
}
?>
<?php
if($projectIndex = 3){


$sql = "INSERT INTO deichmann ".
       "(StoreID, Grad, Adresa, Telefon, RadnoVreme, AGLK, DatumTP, BeetleModel, MS4Sync) ".
       "VALUES('$prodavnica','$grad','$adresa', '$telefon', '$rvreme', '$aglk', '$datumtp', '$usb', '$iprange')";


mysql_select_db('fiskali');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}
}
?>
<?php
if($projectIndex = 4){


$sql = "INSERT INTO cortefiel ".
       "(StoreID, Grad, Adresa, Telefon, RadnoVreme, AGLK, DatumTP, BeetleModel, IPRange) ".
       "VALUES('$prodavnica','$grad','$adresa', '$telefon', '$rvreme', '$aglk', '$datumtp', '$usb', '$iprange')";


mysql_select_db('fiskali');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}
}
?>
<?php
if($projectIndex = 5){


$sql = "INSERT INTO cortefiel_bih ".
       "(StoreID, Grad, Adresa, Telefon, RadnoVreme, AGLK, DatumTP, BeetleModel, IPRange) ".
       "VALUES('$prodavnica','$grad','$adresa', '$telefon', '$rvreme', '$aglk', '$datumtp', '$usb', '$iprange')";


mysql_select_db('fiskali');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}
}
?>
<?php
if($projectIndex = 6){


$sql = "INSERT INTO cortefiel_mne ".
       "(StoreID, Grad, Adresa, Telefon, RadnoVreme, AGLK, DatumTP, BeetleModel, IPRange) ".
       "VALUES('$prodavnica','$grad','$adresa', '$telefon', '$rvreme', '$aglk', '$datumtp', '$usb', '$iprange')";


mysql_select_db('fiskali');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}
}
?>
<?php
if($projectIndex = 7){


$sql = "INSERT INTO cortefiel_cro ".
       "(StoreID, Grad, Adresa, Telefon, RadnoVreme, AGLK, BeetleModel, IPRange) ".
       "VALUES('$prodavnica','$grad','$adresa', '$telefon', '$rvreme', '$aglk', '$usb', '$iprange')";


mysql_select_db('fiskali');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}
}
?>
<?php
if($projectIndex = 8){


$sql = "INSERT INTO ca ".
       "(StoreID, Grad, Adresa, Telefon, RadnoVreme, AGLK, DatumTP, BeetleModel, IPRange) ".
       "VALUES('$prodavnica','$grad','$adresa', '$telefon', '$rvreme', '$aglk', '$datumtp', '$usb', '$iprange')";


mysql_select_db('fiskali');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}
}
?>

I hope this was understandable.

I am open to all kind of questions and also critics.

Thanks in advance

写回答
好问题 0 提建议
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

2条回答默认最新

douzhigan1687 2014-05-27 16:41

关注

Two problems that I can see, 1) the switch statement value was incorrectly formatted (string given, ought to be a POST variable), and 2) the conditions contained assignments, not a equality checks. Those and there is excessive redundancy. Consider this:

<?php

if(isset($_POST['btnSubmit']))
{

    $conn = new mysqli('localhost ', 'root', '', 'fiskali');
    if ($conn->connect_error)
    {
      trigger_error('Database connection failed: '  . $conn->connect_error, E_USER_ERROR);
    }

    switch ( $_POST['ddlProjekat'] )
    {
        case 'H&M'          : $tablename = 'hm';    break;
        case 'Takko Fashion': $tablename = 'takko'; break;
        case 'Deichmann'    : $tablename = 'takko'; break;
        // remaining case statements here
    }

    $sql = "INSERT INTO $tablename (StoreID, Grad, Adresa, Telefon, RadnoVreme, AGLK, DatumTP, BeetleModel, IPRange) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";

    $stmt = $conn->prepare($sql);
    $stmt->bind_param('issssssss', $_POST['tbBrProd'], $_POST['tbGrad'], $_POST['tbAddress'], $_POST['taTelefon'], $_POST['taRVreme'], $_POST['taAGLK'], $_POST['tbDatum'], $_POST['tbUSB'], $_POST['tbIPRange']);
    $stmt->execute();

    if($stmt === false)
    {
        trigger_error('Error: ' . $sql . $conn->error, E_USER_ERROR);
    }
    $stmt->close();

}

?>

本回答被题主选为最佳回答 , 对您是否有帮助呢?

查看更多回答(1条)

报告相同问题？

关注问题

html如何处理表单提交错误的问题 css html 有问必答
2022-05-23 13:05

回答 3 已采纳必填的字段input应该加 required="required" <form method="post" action="testing.php"> <p class="
#html提交表单# html5 javascript 前端
2022-04-24 21:53

回答 3 已采纳表单？为什么不用ajax获取axios呢，表单的话能用列表吗
html表单下拉选项如何动态从mysql中获取 html mysql php
2022-07-07 13:02

回答 6 已采纳 1、修改 <!doctype html> <html> <head> <meta charset="utf-8" /> <titl
web前端开发与应用——创建下拉列表
2021-12-01 22:40

leo Messi 7的博客 下拉列表选择区是由<select>标签和<option>标签构成，其中<select>标签用来创建下拉列表，<option>标签定义了列表中的可用选项。基本结构如下： <select name=""> <option ...
如何使用codeigniter表单进行输入/下拉列表 html javascript jquery php
2018-01-06 06:18

回答 1 已采纳 The below code is worked for me. You can use select2.js for your requirement. See this website. T
HTML表单数据提交 html javascript
2022-02-08 16:46

回答 2 已采纳 <form method="post"onsubmit="return checkip()"> <label class='lab' for="exampl
带有下拉列表的PHP联系表单 html php
2018-02-09 05:52

回答 1 已采纳 You simply miss to use drop down in your code. Update like below :- <?php if ($_POST["email"
html 下拉图片列表,图片、表单、下拉选项
2021-06-10 17:32

女木水的博客 novalidate 规定在提交表单时不应该验证 form 或 input 域下拉选项文盲小学中学大学研究生定义选择列表（下拉列表）name 必须有multiple 多选,默认会显示所有,名字要使用数组like[]disabled禁用size 显示几个...
使用ajax提交html表单 ajax css html php
2018-09-28 06:50

回答 2 已采纳 You can use ajax post request on button click, so page will not refresh. var http = new XMLHttpRe
HTML提交表单到php html5 php
2022-09-12 23:11

回答 2 已采纳如果后台已经设置编码，可以尝试在表单中加入编码 <input type="hidden" name="encode" id="encode" value="utf-8"/>
表单提交Bootstrap下拉数据 html php
2019-05-17 01:28

回答 1 已采纳 Set name to your select control <select name="inputState" class="form-control" Then you can
头歌教学实践平台 Web前端开发基础 HTML-表单类的标签
2024-01-20 14:06

`<select>`定义下拉列表，`<option>`定义可选项。示例： ```html 颜色：红色蓝色绿色 ``` 5. `<label>`标签：与输入元素关联，提供更好的用户体验，点击标签会聚焦对应的输入元素。示例： ```...
web前端学习（五）—— HTML表单（2）- 多选下拉列表以及控件
2021-12-11 15:48

web前端大师的博客一、多选下拉列表 1、框架：<select> <option> ? </option> </select> 2、multiple="multiple"是用来：支持多选 size是用来：设置条目数量代码举例： <!DOCTYPE html> <...
前端html入门学习资源
2024-02-24 17:01

3. **表单.html**：`<form>`标签用于创建表单，`action`定义提交表单的URL，`method`指定提交方式（GET或POST）。`<label>`与`<input>`结合，为输入控件提供文字说明，`<fieldset>`和`<legend>`组合可以创建表单组，...
HTML-表单，下拉菜单,文本域
2024-04-27 17:27

7_35Durant的博客双标签：select嵌套option,select是下拉菜单整体，option是下拉菜单的每一项。作用：收集用户信息，类似登陆界面，调查问卷，搜索区域。占位文本-提示信息,在文本框和密码框没输入时显示。单标签：单选框是圆圈，多...
没有解决我的问题, 去提问

码龄粉丝数原力等级 --

HTML表单使用下拉列表提交

2条回答默认最新

码龄粉丝数原力等级 --

HTML表单使用下拉列表提交

2条回答 默认 最新

2条回答默认最新