Vraag & Antwoord

Webprogrammeren & scripting

Ik snap er niks meer van !!!!

Anoniem
Annie
1 antwoord
  • Help!

    Ik krijg steeds de foutmelding "No Database selected"

    Kan iemand mij helpen? Hieronder staat de code. Wat doe ik fout?

    [code:1:241548b715]
    <?php

    //require the PEAR::DB classes.

    require_once 'DB.php';


    $db_engine = 'mysql';
    $db_user = 'devotion_eric';
    $db_pass = 'passwd';
    $db_host = 'localhost';
    $db_name = "devotion_test";

    $dbconnect = mysql_connect('localhost','devotion_eric','passwd');
    $datasource = mysql_select_db("devotion_test", $dbconnect);
    //$db_engine.'://'.
    //$db_user.':'.
    //$db_pass.'@'.
    //$db_host.'/'.
    //$db_name;


    $db_object = DB::connect($datasource, TRUE);

    /* assign database object in $db_object,

    if the connection fails $db_object will contain

    the error message. */

    // If $db_object contains an error:

    // error and exit.

    if(DB::isError($db_object)) {
    die($db_object->getMessage());
    }

    $db_object->setFetchMode(DB_FETCHMODE_ASSOC);

    // we write this later on, ignore for now.

    include('check_login.php');

    ?>
    [/code:1:241548b715]

    Check_login.php
    [code:1:241548b715]
    <?php

    /* check login script, included in db_connect.php. */

    session_start();

    if (!isset($_SESSION['username']) || !isset($_SESSION['password'])) {
    $logged_in = 0;
    return;
    } else {

    // remember, $_SESSION['password'] will be encrypted.

    if(!get_magic_quotes_gpc()) {
    $_SESSION['username'] = addslashes($_SESSION['username']);
    }


    // addslashes to session username before using in a query.
    $pass = $db_object->query("SELECT password FROM users WHERE username = '".$_SESSION['username']."'");

    if(DB::isError($pass) || $pass->numRows() != 1) {
    $logged_in = 0;
    unset($_SESSION['username']);
    unset($_SESSION['password']);
    // kill incorrect session variables.
    }

    $db_pass = $pass->fetchRow();

    // now we have encrypted pass from DB in
    //$db_pass['password'], stripslashes() just incase:

    $db_pass['password'] = stripslashes($db_pass['password']);
    $_SESSION['password'] = stripslashes($_SESSION['password']);



    //compare:



    if($_SESSION['password'] == $db_pass['password']) {
    // valid password for username
    $logged_in = 1; // they have correct info
    // in session variables.
    } else {
    $logged_in = 0;
    unset($_SESSION['username']);
    unset($_SESSION['password']);
    // kill incorrect session variables.
    }
    }


    // clean up
    unset($db_pass['password']);

    $_SESSION['username'] = stripslashes($_SESSION['username']);

    ?>
    [/code:1:241548b715]

    alvast bedankt allemaal.

Beantwoord deze vraag

Dit is een gearchiveerde pagina. Antwoorden is niet meer mogelijk.