如何使用php将下拉选择数据插入mysql [英] How to insert dropdown selection datainto mysql using php

问题描述

它为男性插入onle M，为女性插入F但不插入整个单词。

PLZ尽快帮助我

提前付款

我的HTML代码

It inserts onle M for male and F for female but not insert whole word.
PLZ HELP ME ASAP
Thanks in advance
My html code

<form method="post" action="form1.php"></br>
Gender:<select name="gender" id="gender">
            <option value="">Select One</option>
            <option value = "M">Male</option>
            <option value = "F">Female</option>
    </select><br><br>
<input type="submit" value="Submit Data">
</form>

< br $> b $ b



我的PHP代码

My php code

<?php


mysql_connect("localhost","root","")
    or
    die("DataBase cannot connected");

mysql_select_db("test")
    or
    die("DataBase not found");

    $gender = $_POST['gender'];
            $sql=mysql_query("INSERT INTO gender(Sex) VALUES ('$gender')");

$result=mysql_query($sql);
    if($result)
    {
    print"Data inserted successfully";
    print"</br>";
    print'<a href="index.html">Back to Page</a>';
    }
    else
    {
        print"Error in process";
        mysql_close();
    }

?>

推荐答案

gender =

_POST [' gender'];

sql = mysql_query（ INSERT INTO gender（Sex）VALUES（'

sql=mysql_query("INSERT INTO gender(Sex) VALUES ('

这篇关于如何使用php将下拉选择数据插入mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！