Connecting mysql to PHP

[Misomurai]

Hey, can someone tell me what's wrong with this code?

My browser says that line 3 is wrong, but I'm not sure what's wrong about it.

Thanks 

 

--------------------------------------------------------------------------------------------

 

<?php

    if ($_POST['submit1'] != ''){

      $link = mysql_connect("$dbname", "$_library_lab", "$password");

      if (!$link == FALSE) {

        $database = mysql_select_db('bookmark');

        if ($database==TRUE){

          $name = $_POST['name'];

          $book = $_POST['book'];

          $bookmark = $_POST['bookmark'];

          $shiori = $_POST['shiori'];

 

          $sql="insert into bookmark (name, book, bookmark, shiori) values('{$name}','{$book}','{$bookmark}','{$shiori}')";

          $result = mysql_query($sql);

          if ($result == TRUE){

          }else{

            echo('DB insert Failure!');

          }

        }

        mysql_close($link);

      }

    }

    ?>

[trq]

The variables you are passing to mysql_connect(), wehere are they defined? And why the hell are they in quotes?

 

ps: The mysql extension has been deprecated. All new code should be using mysqli or PDO.

[Yohanne]

its okay for a beginner, to protice procedural coding like you show code above. and try to reconstruct your code or else use other way for insert.