<?php
$pattern = "#^[a-z0-9_\.-]+@[a-z0-9_-]+\.([a-z0-9]{1,6}\.)?[a-z]{2,6}$#i";
$firstn = mysql_real_escape_string(trim($_POST['firstn']));
$lastn = mysql_real_escape_string(trim($_POST['lastn']));
$email = mysql_real_escape_string(trim($_POST['email']));
$country = mysql_real_escape_string(trim($_POST['country']));
$link = mysql_connect("localhost", "root", "") or die("No connect to Server");
mysql_query("SET NAMES utf8", $link) or die("Cant set charset");
mysql_select_db("tech") or die("No DATABASE SELECTED");
$query = "SELECT email FROM jos_clients WHERE email = '$email' LIMIT 1";
$res = mysql_query($query, $link) or die(mysql_error());
if(mysql_num_rows($res) > 0){
$query = "UPDATE jos_clients
SET firstname='$firstn', lastname='$lastn', country='$country'
WHERE email= '$email'
";
$result = mysql_query($query, $link);
if(mysql_affected_rows() == 1){
echo 'Your E-mail is already registered';
}else{
echo 'Your E-mail is already registered, but not updated' . $query;
}
}else{
$query = "INSERT INTO jos_clients (
firstname,
lastname,
email,
country
)
VALUES (
'$firstn',
'$lastn',
'$email',
'$country'
)";
$result = mysql_query($query, $link) or die(mysql_error());
if (!$result)
echo "ERROR DATABASE";
else
echo 'Thank you very much for the registration';
}
mysql_close($link);
exit;
?>
Как только переношу на хостинг - строчку вставляет, но данные в поля не записывает. Ошибку не выдает
