I need some help with this php code, please.
Posted: Sun Sep 29, 2013 1:43 pm
<?php
$user="root";
$password="";
$database="base";
$host="localhost";
$table="com";
mysql_connect($host, $user, $password) or die("error");
mysql_select_db($database) or die("error");
$name = $_POST['name'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$coment= $_POST['coment'];
$error = '';
if(empty($name) || empty($lastname) || empty($email) || empty($coment))
{
$error .= 'error. ';
}
if(!preg_match("/^[a-zA-A]+$/i", $name))
{
$error .= 'Error ';
}
if(!preg_match("/^[a-zA-A]+$/i", $lastname))
{
$error .= 'Error ';
}
if(!preg_match("/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/i", $email))
{
$error .= 'errorl. ';
}
if(!preg_match("/^[a-zA-z0-9.,?!]+$/i", $comment))
{
$error .= 'Error ';
}
if($error == '')
{
$result = "INSERT INTO com (name, lastname, email, coment) VALUES('$name', '$lastname', '$email','$coment')";
echo "<script type='text/javascript'>alert('Thanks.'); window.close();</script>";}
else{
echo"<script type='text/javascript'>alert ('$error'); window.close(); </script>";}
Errors seems to be working its just it won't insert data in table in mysql database....
Thank you so much if you could help me.And yes I am beginner, a desperate beginner ...
$user="root";
$password="";
$database="base";
$host="localhost";
$table="com";
mysql_connect($host, $user, $password) or die("error");
mysql_select_db($database) or die("error");
$name = $_POST['name'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$coment= $_POST['coment'];
$error = '';
if(empty($name) || empty($lastname) || empty($email) || empty($coment))
{
$error .= 'error. ';
}
if(!preg_match("/^[a-zA-A]+$/i", $name))
{
$error .= 'Error ';
}
if(!preg_match("/^[a-zA-A]+$/i", $lastname))
{
$error .= 'Error ';
}
if(!preg_match("/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/i", $email))
{
$error .= 'errorl. ';
}
if(!preg_match("/^[a-zA-z0-9.,?!]+$/i", $comment))
{
$error .= 'Error ';
}
if($error == '')
{
$result = "INSERT INTO com (name, lastname, email, coment) VALUES('$name', '$lastname', '$email','$coment')";
echo "<script type='text/javascript'>alert('Thanks.'); window.close();</script>";}
else{
echo"<script type='text/javascript'>alert ('$error'); window.close(); </script>";}
Errors seems to be working its just it won't insert data in table in mysql database....
Thank you so much if you could help me.And yes I am beginner, a desperate beginner ...