Pārbauda vai šāds e-pasts eksistē un neļauj tādu izmantot (ja eksistē)

[yeahz]

Kā pareizi uzrakstīt šo kodu, lai tas strādātu kā tam pienākas, es mēģināju šādi:

 

		$jau_aiznemts = mysql_query("SELECT email FROM users");
	if($_POST['email'] != $jau_aiznemts)
		{
			$email_update = quote_smart(htmlspecialchars($_POST['email']));
			mysql_query("UPDATE users SET email=$email_update WHERE id=$id");
			$ok_email = "<h2 class='profils_labots'>Profils labots!</h2>";
		}
		else
		{
			$aiznemts_email = "<h2 class='profils_labots_nav'>Šāds e-pasts jau ir aizņemts!</h2>";
		}

[andrisp]

$sql = "SELECT COUNT(*) FROM users WHERE email = '".mysql_real_escape($_POST['email'])"'";
list($email_exists) = mysql_fetch_row(mysql_query($sql));
if ($email_exists) {
} else {
}

[yeahz]

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\AppServ\www\profile_email.php on line 10

 

10 līnija

 

$sql = "SELECT COUNT(*) FROM users WHERE email = '".mysql_real_escape($_POST['email'])"'";

Edited October 28, 2008 by zekils

[anonīms]

$sql = "SELECT COUNT(*) FROM users WHERE email = '".mysql_real_escape($_POST['email'])."'";

[yeahz]

tagad vēlviens, bet vai tā tas maz var būt?

 

Fatal error: Call to undefined function mysql_real_escape() in C:\AppServ\www\profile_email.php on line 10

[anonīms]

Laikam ir

$sql = "SELECT COUNT(*) FROM users WHERE email = '".mysql_real_escape_string($_POST['email'])."'";

Edited October 28, 2008 by anonīms

[mounkuls]

funkcija tāda nav standartā ja nav pašrakstīta.

Un tikai.

[andrisp]

Nu taču typo tas bija.

[yeahz]

iet, paldies.