PHP vyplnanie databazy

doubleR · Napísal **doubleR**: 12.10.2014 0:20

Ahojte mam problem (nepochopitelny pre mna) pri zapisovani do databazy. moj kod je nasledovny:

Kód:

$prom1 = $_GET["prom1"];
$prom2 = $_GET["prom2"];
$prom3 = $_GET["prom3"];
$prom4 = $_GET["prom4"];
$prom5 = $_GET["prom5"];
$prom6 = $_GET["prom6"];

echo "Vyplnil jste hodnoty: ".$prom1." A ".$prom2." A ".$prom3." A ".$prom4." A ".$prom5." A ".$prom6;

$con=mysqli_connect("localhost","MENO","HESLO","DATABAZA");

if (mysqli_connect_errno()) {
     echo "Failed to connect to MySQL: " . mysqli_connect_error();
}else{
   echo "Pripojil sa ";
}

//tato cast nefunguje
mysqli_query($con,"INSERT INTO SPORTOVCI1 (name, surname, birthDay, birthPlace, birthCountry) VALUES (".$prom1.",".$prom2.",".$prom3.",".$prom4.",".$prom5.");");

//tato zakomentovana cast funguje
//mysqli_query($con,"INSERT INTO SPORTOVCI1 (name, surname, birthDay, birthPlace, birthCountry) VALUES ('xxx','xxx','xxx','xxx','xxx');");

neviem co s tym ten insert kde su same X ide..ale ten nad nim nic do databazy nezapise..pritom v tych premennych hodnotu su lebo ich vypisujem.

JanoF · Napísal **JanoF**: 12.10.2014 0:27

no vidis to, ked zakomentovana funguje, tak by si to tak aj mal spravit

cize

Kód:

mysqli_query($con,"INSERT INTO SPORTOVCI1 (name, surname, birthDay, birthPlace, birthCountry) VALUES ('$prom1','$prom2','$prom3','$prom4','$prom5')");

a $_GET si nezabudni tiez osetrit

doubleR · Napísal autor témy **doubleR**: 12.10.2014 0:34

jejda vidim to..dik moc..asi uz dlho sedim za PC

dik moc : P

PHP vyplnanie databazy

Podobné témy