[SQL][PHP] Problem z zapytaniem do bazy Opcje

[Miszazdw]

[PHP] pobierz, plaintext 
$query = 'INSERT INTO USERS (USERNAME, PASSWORD, ' .
'EMAIL_ADDR, IMIE, NAZWISKO, PESEL, TEL_DOM, TEL_KOM, ' .
'REGON, NIP, ULICA, NR_DOMU, KOD_POCZTOWY, MIASTO, NAZWA_FIRMY' .
'IS_ACTIVE) '.
'VALUES (mysql_real_escape_string($this->username, $GLOBALS[\'DB\']), '.
'mysql_real_escape_string($this->password, $GLOBALS[\'DB\']), '.
'mysql_real_escape_string($this->emailAddr, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->imie, $GLOBALS[\'DB\']), '.
'mysql_real_escape_string($this->nazwisko, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->pesel, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->tel_dom, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->tel_kom, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->regon, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->nip, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->ulica, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->nr_domu, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->kod_pocztowy, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->miasto, $GLOBALS[\'DB\']),'.
'mysql_real_escape_string($this->nazwa_firmy, $GLOBALS[\'DB\']),'.
'$this->isActive)';
[PHP] pobierz, plaintext 

tak wyglada zapytanie

Kod

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>username, $GLOBALS['DB']), mysql_real_escape_string($this->password, $GLOBALS['' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>username, $GLOBALS['DB']), mysql_real_escape_string($this->password, $GLOBALS['' at line 1

a taki mam blad.

Oczekuję pomocy.

Pozdrawiam.

Ten post edytował Miszazdw 10.08.2009, 20:06:24

[jmail]

masz - a tak na przyszłość dobrze poczytać o bazie danych zanim się za nią weźmiesz.

[PHP] pobierz, plaintext 
 
$query = 'INSERT INTO 
            USERS (
                USERNAME
                , PASSWORD
                , EMAIL_ADDR
                , IMIE
                , NAZWISKO
                , PESEL
                , TEL_DOM
                , TEL_KOM
                , ULICA
                , NR_DOMU
                , KOD_POCZTOWY
                , MIASTO
                , IS_ACTIVE
            ) 
        VALUES  
            (
                \''.mysql_real_escape_string($this->username, $GLOBALS['DB']).'\'
                ,\''.mysql_real_escape_string($this->password, $GLOBALS['DB']).'\'
                ,\''.mysql_real_escape_string($this->emailAddr, $GLOBALS['DB']).'\'
                ,\''.mysql_real_escape_string($this->imie, $GLOBALS['DB']).'\'
                ,\''.mysql_real_escape_string($this->nazwisko, $GLOBALS['DB']).'\'
                ,\''.mysql_real_escape_string($this->pesel, $GLOBALS['DB']).'\'
                ,\''.mysql_real_escape_string($this->tel_dom, $GLOBALS['DB']).'\'
                ,\''.mysql_real_escape_string($this->tel_kom, $GLOBALS['DB']).'\'
                ,\''.mysql_real_escape_string($this->ulica, $GLOBALS['DB']).'\'
                ,\''.mysql_real_escape_string($this->nr_domu, $GLOBALS['DB']).'\'
                ,\''.mysql_real_escape_string($this->kod_pocztowy, $GLOBALS['DB']).'\'
                ,\''.mysql_real_escape_string($this->miasto, $GLOBALS['DB']).'\'
                ,\''..$this->isActive.'\'
            )';
 
[PHP] pobierz, plaintext