Code:
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 'LIMIT 1' at line 1
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 'LIMIT 1' at line 1
a kod stranice:
Code:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$con = mysql_connect('mysql', "nikolate_milos", '********');
if (!$con)
{
DIE('could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db ("nikolate_db1", $con);
if (!$db_selected)
{
die ('can not use' . "nikolate_db1" . ';' . mysql_error());
}
echo 'uspesno ste se registrovali';
$value = $_POST['ime'];
$value1 = $_POST['ime_o'];
$value2 = $_POST['mesto_datum'];
$value3 = $_POST['zvanje'];
$value4 = $_POST['zanimanje'];
$value5 = $_POST['ul_br_me'];
$value6 = $_POST['pb_o'];
$value7 = $_POST['drzava'];
$value8 = $_POST['tel_fax'];
$value9 = $_POST['mobilni'];
$value10 = $_POST['email'];
$value11 = $_POST['sajt'];
$value12 = $_POST['facebook'];
$value13 = $_POST['skype'];
$value14 = $_POST['talenat'];
$value15 = $_POST['clanarina'];
$value16 = $_POST['donacije'];
$value17 = $_POST['predlozi'];
$sql = "insert into registar (ime, ime_o, mesto_datum, zvanje, zanimanje, ul_br_me, pb_o, drzava, tel_fax, mobilni, email, sajt, facebook, skype, talenat, clanarina, donacije, predlozi) VALUES('$value', '$value1', '$value2', '$value3', '$value4', '$value5', '$value6', '$value7', '$value8', '$value9', '$value10', '$value11', '$value12', '$value13', '$value14', '$value15', '$value16', '$value17')";
?>
<?php
if (!mysql_query($sql))
{
die ('Error' . mysql_error());
}
mysql_select_db ("nikolate_db1", $con);
$id = !empty($_GET['id']) ? intval($_GET['id']) : 0;
$rnd = !empty($_GET['rnd']) ? mysql_real_escape_string($_GET['rnd']) : '';
$result = mysql_query("SELECT * FROM registar WHERE id=$id AND rnd=$rnd LIMIT 1") or die(mysql_error());
if (empty($result)) { echo "Greska!"; exit; }
$row = mysql_fetch_assoc($result);
$row_e = array_map('htmlspecialchars', $row);
echo "{$rows['ime']} , {$rows['ime_o']}, {$rows['mesto_datum']}, {$rows['zvanje']}, {$rows['zanimanje']}, {$rows['ul_br_me']}, {$rows['pb_o']}, {$rows['drzava']}, {$rows['tel_fax']}, {$rows['mobilni']}, {$rows['email']}, {$rows['sajt']}, {$rows['facebook']}, {$rows['skype']}, {$rows['talenat']}, {$rows['clanarina']}, {$rows['donacije']}, {$rows['predlozi']}";
?>
<?php
$to = $info['email'];
$subject = "VAŠI PODACI: ".$info['ime'];
$message = 'Ime i prezime/First and last name: '.$info['ime'].'
Očevo ime/Father name: '.$info['ime_0'].'
Datum i mesto rođenja/date and place of birth: '.$info['mesto_datum'].'
Zvanje/title: '.$info['zvanje'].'
Zanimanje/profession: '.$info['zanimanje'].'
Ulica, broj i mesto stanovanja/street and city of resident: '.$info['ul_br_me'].'
Poštanski broj i opština/postal code and state: '.$info['pb_o'].'
Država/country: '.$info['drzava'].'
Tel./ fax: '.$info['tel_fax'].'
Mobilni/mobile: '.$info['mobilni'].'
e-mail: '.$info['email'].'
Sajt/site: '.$info['sajt'].'
Facebook: '.$info['facebook'].'
Skype: '.$info['skype'].'
Talenat/tallent: '.$info['talenat'].'
Članarina učlanjenja/membershipe price: '.$info['clanarina'].'
Donacije/donations: '.$info['donacije'].'
Predlozi za saradnju/proposals for cooperation: '.$info['predlozi'].'
Datum/date: '.$today = date("dmY").'';
$headers = "From: [email protected]\r\n" .
'X-Mailer: PHP/' . phpversion() . "\r\n" .
"MIME-Version: 1.0\r\n" .
"Content-Type: text/plain; charset=utf-8\r\n" .
"Content-Transfer-Encoding: 8bit\r\n\r\n";
mail($to, $subject, $message, $headers);
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$con = mysql_connect('mysql', "nikolate_milos", '********');
if (!$con)
{
DIE('could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db ("nikolate_db1", $con);
if (!$db_selected)
{
die ('can not use' . "nikolate_db1" . ';' . mysql_error());
}
echo 'uspesno ste se registrovali';
$value = $_POST['ime'];
$value1 = $_POST['ime_o'];
$value2 = $_POST['mesto_datum'];
$value3 = $_POST['zvanje'];
$value4 = $_POST['zanimanje'];
$value5 = $_POST['ul_br_me'];
$value6 = $_POST['pb_o'];
$value7 = $_POST['drzava'];
$value8 = $_POST['tel_fax'];
$value9 = $_POST['mobilni'];
$value10 = $_POST['email'];
$value11 = $_POST['sajt'];
$value12 = $_POST['facebook'];
$value13 = $_POST['skype'];
$value14 = $_POST['talenat'];
$value15 = $_POST['clanarina'];
$value16 = $_POST['donacije'];
$value17 = $_POST['predlozi'];
$sql = "insert into registar (ime, ime_o, mesto_datum, zvanje, zanimanje, ul_br_me, pb_o, drzava, tel_fax, mobilni, email, sajt, facebook, skype, talenat, clanarina, donacije, predlozi) VALUES('$value', '$value1', '$value2', '$value3', '$value4', '$value5', '$value6', '$value7', '$value8', '$value9', '$value10', '$value11', '$value12', '$value13', '$value14', '$value15', '$value16', '$value17')";
?>
<?php
if (!mysql_query($sql))
{
die ('Error' . mysql_error());
}
mysql_select_db ("nikolate_db1", $con);
$id = !empty($_GET['id']) ? intval($_GET['id']) : 0;
$rnd = !empty($_GET['rnd']) ? mysql_real_escape_string($_GET['rnd']) : '';
$result = mysql_query("SELECT * FROM registar WHERE id=$id AND rnd=$rnd LIMIT 1") or die(mysql_error());
if (empty($result)) { echo "Greska!"; exit; }
$row = mysql_fetch_assoc($result);
$row_e = array_map('htmlspecialchars', $row);
echo "{$rows['ime']} , {$rows['ime_o']}, {$rows['mesto_datum']}, {$rows['zvanje']}, {$rows['zanimanje']}, {$rows['ul_br_me']}, {$rows['pb_o']}, {$rows['drzava']}, {$rows['tel_fax']}, {$rows['mobilni']}, {$rows['email']}, {$rows['sajt']}, {$rows['facebook']}, {$rows['skype']}, {$rows['talenat']}, {$rows['clanarina']}, {$rows['donacije']}, {$rows['predlozi']}";
?>
<?php
$to = $info['email'];
$subject = "VAŠI PODACI: ".$info['ime'];
$message = 'Ime i prezime/First and last name: '.$info['ime'].'
Očevo ime/Father name: '.$info['ime_0'].'
Datum i mesto rođenja/date and place of birth: '.$info['mesto_datum'].'
Zvanje/title: '.$info['zvanje'].'
Zanimanje/profession: '.$info['zanimanje'].'
Ulica, broj i mesto stanovanja/street and city of resident: '.$info['ul_br_me'].'
Poštanski broj i opština/postal code and state: '.$info['pb_o'].'
Država/country: '.$info['drzava'].'
Tel./ fax: '.$info['tel_fax'].'
Mobilni/mobile: '.$info['mobilni'].'
e-mail: '.$info['email'].'
Sajt/site: '.$info['sajt'].'
Facebook: '.$info['facebook'].'
Skype: '.$info['skype'].'
Talenat/tallent: '.$info['talenat'].'
Članarina učlanjenja/membershipe price: '.$info['clanarina'].'
Donacije/donations: '.$info['donacije'].'
Predlozi za saradnju/proposals for cooperation: '.$info['predlozi'].'
Datum/date: '.$today = date("dmY").'';
$headers = "From: [email protected]\r\n" .
'X-Mailer: PHP/' . phpversion() . "\r\n" .
"MIME-Version: 1.0\r\n" .
"Content-Type: text/plain; charset=utf-8\r\n" .
"Content-Transfer-Encoding: 8bit\r\n\r\n";
mail($to, $subject, $message, $headers);
?>
mysql verzija: 5.0.89-community
da li mozete da mi pomognete gde je greska?