Go4Expert - Help

Warning: require_once(DbConnector.php) [function.require-once]: failed to open stream: No such file or directory in /home/zendurl/public_html/p/program5/signup.php on line 21

Fatal error: require_once() [function.require]: Failed opening required 'DbConnector.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/zendurl/public_html/p/program5/signup.php on line 21

The file (signup.php):

PHP Code:


		
			
<form action="signup.php?submit" class='form colours' method='POST'>

    <fieldset>

        <legend>Join Programmer's Space</legend>

            <p align='right'>Username: <input name='username' size='25' maxlength='25' /></p>            

            <p align='right'>Password: <input name='password' size='25' maxlength='25' /></p>    

                        <p align='right'><input type='submit' value='Submit' /></p>

    </fieldset>

</form>

<?php

// Check if the form has been submitted

if(isset($_GET["submit"]))

{

    if(isset($_POST["username"]) && isset($_POST["password"]))

    {    

        //Username or password is not blank

        if($_POST["username"]!="" && $_POST["password"]!="")

        { // Everything is ok add the user to the database

 

            // Connect to the database

            require_once("DbConnector.php");   // Include the database class

            $db = new DbConnector();               // Create an instance of the database class

            $db->connect();                               // Connect to the database

            $query = "SELECT * FROM members WHERE username='".$_POST["username"]."'";

            $result = $db->query($query);

            $result = mysql_num_rows($result);

 

            if($result!="0")

                echo "Username already exists!";

            else 

            { 

                // Create a query that inserts the data from the form to the database

                $query = "INSERT INTO members(username,password) VALUES('".$_POST["username"]."','".$_POST["password"]."')";

 

                $result = $db->query($query);

                echo "Signed up succesfully you can now <a href=\"login.php\">log in</a>";

            }

        }

        else 

        {

            echo "Error: No username or password supplied, try again.";

        }

 

    }

    else 

        echo "Error: please fill in the <a href=\"signup.php\">signup form</a>";

}

?>

DBConnector.php

PHP Code:


		
			
<?php

////////////////////////////////////////////////////////////////////////////////////////

// Class: DbConnector

///////////////////////////////////////////////////////////////////////////////////////

require_once 'DbVars.php';

 

class DbConnector extends Dbvars {

 

        var $theQuery;

        var $link;

  var $dbname;

  var $host;

  var $user;

  var $pass;

    

   function DbConnector(){

        // Load settings from parent class

        $settings = Dbvars::getSettings();

        // Get the main settings from the array we just loaded

        $this->host = $settings['dbhost'];

        $this->dbname = $settings['dbname'];

        $this->user = $settings['dbusername'];

        $this->pass = $settings['dbpassword'];

    }

  

   function setDatabase($ndbname)

  {

    $this->dbname = $ndbname;

  }

  

  function connect()

  {

                 // Connect to the database

                 $this->link = mysql_connect($this->host, $this->user, $this->pass)or die(mysql_error());

                 mysql_select_db($this->dbname);

  }

 

    function query($query) {

 

        $this->theQuery = $query;

        $res = mysql_query($query, $this->link)or die(mysql_error());

  return $res;

 

    }

 

    function fetchArray($result) {

 

       return mysql_fetch_array($result);

 

    }

 

}

?>