保存运行时创建的文本框到mysql数据库[关闭]

Question

Hi I am new to php. I am working on a form which creates a dynamic table when the page it opened the problem is that the table consist of the input text boxes which I don't have an idea to save it into my database I know the basic insert query but this one is a tricky part can anyone help me out here is my code

            <table border='0px'>
                <?php 
                $c = 1;
                $scomp = mysql_query("SELECT * FROM subject WHERE compulsory!='$c'")or die(mysql_error());
                $v =0;
                while($fsub = mysql_fetch_array($scomp)){

                $ycode = $fsub["code"];
                echo "<tr>";
                echo "<td width='200px'><font color='#FF6600'><strong>$fsub[name]</strong></td><td><input name='s_$ycode' type='text' size='1' maxlength='2'></td>";
                echo "</tr>";
                $v++;
                }
                 echo "<input id='hh' name='hh' type='text' value= '$v'/>";
                ?>
            </table> 

Answer 1

You are not using the concatenation operator for joining the strings with the variables. The concatenation operator in PHP is (.) the dot operator. Even when you run mysql query you will not get any records.

Below is the correct syntax for your query

$scomp = mysql_query("SELECT * FROM subject WHERE compulsory!= ".$c);

below is your fixed code. Try it now

            $c = 1;
            $scomp = mysql_query("SELECT * FROM subject WHERE compulsory!=".$c)or die(mysql_error());
            $v =0;
            while($fsub = mysql_fetch_array($scomp)){

            $ycode = $fsub["code"];
            echo "<tr>";
            echo "<td width='200px'><font color='#FF6600'><strong>".$fsub[name]."</strong></td><td><input name='s_".$ycode."' type='text' size='1' maxlength='2'></td>";
            echo "</tr>";
            $v++;
            }
             echo "<input id='hh' name='hh' type='text' value= '$v'/>";
            ?>
        </table>