Userbase

Code: Selecteer alles

<?
$username=$_REQUEST["username"];
$pass=$_REQUEST["pass"];
$myconnection=mysql_connect(localhost,"mijn gebruikersnaam","mijn pass");
mysql_select_db("jeroentjevj_photoshop") or die( "Unable to select database");
$query = "SELECT * FROM `gebruikers` WHERE `username`='$username' AND `wachtwoord`='$pass'";
$result=mysql_query($query);
$time=mysql_result($result,0,"tijd")+0.083333333333333333333333333333333;
echo "$time";

////////////////////tot hier werkt alles prima

mysql_close($myconnection);
$myconnection=mysql_connect(localhost,"mijn gebruikersnaam","mijn pass");
mysql_select_db("jeroentjevj_photoshop") or die( "Unable to select database");
$TESTquery = "UPDATE FROM `gebruikers` SET `tijd` = $time WHERE `username`='$pass' AND `wachtwoord`='$pass'" or die("failed to update");
$result=mysql_query($TESTquery);
?>

Code: Selecteer alles

$TESTquery = "UPDATE `gebruikers` SET `tijd` = $time WHERE `username`='$pass' AND `wachtwoord`='$pass'" or die("failed to update"); 

Code: Selecteer alles

$TESTquery = "UPDATE `gebruikers` SET `tijd` = `tijd`+0.083333333333333333333333333333333 WHERE `username`='$pass' AND `wachtwoord`='$pass'" or die("failed to update"); 

Code: Selecteer alles

$TESTquery = "UPDATE `gebruikers` SET `tijd` = `tijd`+0.083333333333333333333333333333333 WHERE `username`='$pass' AND `wachtwoord`='[b]$pass[/b]'" or die("failed to update"); 

Code: Selecteer alles

$TESTquery = "UPDATE `gebruikers` SET `tijd` = `tijd`+0.083333333333333333333333333333333 WHERE `username`='$pass' AND `wachtwoord`='[b]$username[/b]" or die("failed to update"); 

Code: Selecteer alles

MDB2 Description

PEAR MDB2 is a merge of the PEAR DB and Metabase php database abstraction layers.

It provides a common API for all support RDBMS. The main difference to most other database abstraction packages is that MDB2 goes much further to ensure portability. Among other things MDB2 features:

    *

      An OO-style query API
    *

      A DSN (data source name) or array format for specifying database servers
    *

      Datatype abstraction and on demand datatype conversion
    *

      Portable error codes
    *

      Sequential and non sequential row fetching as well as bulk fetching
    *

      Ability to make buffered and unbuffered queries
    *

      Ordered array and associative array for the fetched rows
    *

      Prepare/execute (bind) emulation
    *

      Sequence emulation
    *

      Replace emulation
    *

      Limited Subselect emulation
    *

      Row limit support
    *

      Transactions support
    *

      Large Object support
    *

      Index/Unique support
    *

      Module Framework to load advanced functionality on demand
    *

      Table information interface
    *

      RDBMS management methods (creating, dropping, altering)
    *

      Full integration into the PEAR Framework
    *

      PHPDoc API documentation 

Currently supported RDBMS:

    *

      MySQL
    *

      MySQLi (PHP5 only)
    *

      PostgreSQL
    *

      Oracle
    *

      Frontbase (unmaintained)
    *

      Querysim
    *

      Interbase/Firebird (PHP5 only)
    *

      MSSQL
    *

      SQLite