Question

I m taking lessons at lynda.com on PHP with MySQL Essential Training . Everything has gone great so far but I got to a point where I needed to do something a little different in order to achieve the same results as the instructor in the videos. Here s his code:

<?php
 $query = "INSERT INTO subjects (
             menu_name, position, visible
          ) VALUES (
              {$menu_name} , {$position}, {$visible}
          )";
?>

当他执行这些职务时,我需要总结一下,在单项引用中可以预见的变数,这样我就认为:

<?php
 $query = "INSERT INTO subjects (
             menu_name, position, visible
          ) VALUES (
              {$menu_name} ,  {$position} ,  {$visible} 
          )";
?>

It s the only way that I can get the code to work otherwise I get an error that says: "You have an error in your SQL syntax, check the manual that corresponds to your MySQL server version for the right syntax to use..." I understand wrapping $menu_name in single quotes since it represents a string, but the other two represent integer values. Why won t my code execute without the quotes? Is there something I need to change in a config file? Is it considered a better practice to use the the quotes on integers and let SQL do the conversion for me, or should I not need to use those quotes? Any help would be greatly appreciated. If you can t tell by now, I m kind of a noob. Thanks in advance for your help.

Answer 1

检查你的愤怒价值。如果您的变数没有价值,那么你最终会遇到这样的问题。

INSERT INTO subjects (
         menu_name, position, visible
      ) VALUES (
          menu name , , ,)

如果贵方的价值观是正确的,那么你们的心情就好了。

Answer 2

问题固定下来。

我说,我是个不言而喻的,一个不言而喻的错误正是我所做的。

I was missing an = in a piece of code and that was causing me to get those MySQL syntax errors. Here s the code I fixed:

<p>Visible:
   <input type="radio" name="visible" value="0" /> No
    &nbsp;
   <input type="radio" name="visible" value="1" /> Yes
</p>

最初,当我发现yn子错误时,我没有在价值和“1”之间打上平等标志。

这是一种令人sil笑皆是的错误,但当你发现造成你头痛的错误时,它始终感到好。在这一进程中,我仍然学到很多东西。感谢你们的帮助!

友情链接