PHP Null τιμές

[mixalis8]

Loipon exo mia forma oi opoia stelnei kapoia stoixeia se mia basi dedomenon...

 

paradeigma

exo ena paidio id (automato noumero) NOT NULL

ena paidio onoma (varchar) NULL

kai allo ena epitheto NULL

 

poia tha einai i sql etsi oste na balei NULL otan den tou doso tipota??

 

exo kanei

 

onoma = NULL;

$query = "INSERT INTO pinaka (onoma,epitheto) VALUES ('$onoma','$epithero')";

$result = pg_query($query);

 

alla mou bazei isagogika sto paidio onoma anti gia NULL

[isim]

Πολυ απλά θα; βάλεις null στην μεταβλητη που θες να εχει null πχ

 

INSERT INTO pinaka (onoma,epitheto) VALUES (null,'$epithero')";

[mixalis8]

afto to ksero.. to zitima einai oti ekeino to null prepei na einai metabliti... den tha einai panta null... an den dosis se kapoia forma stoixeio tote mono tha ginete null.....

[ODEN]

Dokimase kati tetoio

 

if (isset($onoma)) {

$query = "INSERT INTO pinaka (onoma,epitheto) VALUES (NULL,'$epithero')";

} else {

$query = "INSERT INTO pinaka (onoma,epitheto) VALUES ('$onoma','$epithero')";

}

$result = pg_query($query);

 

an kai me $onoma = NULL; tha eprepe na douleuei...

[mixalis8]

afto to pragma thelo na apofigo.....

rotisa enan kathigiti mou kai mou eipe kati gia prepering statments......

 

to $onoma = NULL mou eipe oti den leitourgei...... epeidi sto VALUES prepei na mpoun eisagogika gia string eno sto null den xreiazontai....

[ODEN]

den uparxei logos na to apofugeis.

outos h allos me ton idio tropo tha to ekanes kai an mporouses na dwseis se mia metavliti NULL statment.

 

dld auto to pragma einai to idio me auto pou parethesa parapanw:

 

 

if (!isset($onoma)) {

$onoma = NULL;

}

$query = "INSERT INTO pinaka (onoma,epitheto) VALUES ('$onoma','$epithero')";

$result = pg_query($query);