raha1234567
چهارشنبه 12 آذر 1393, 22:32 عصر
سلام دویتان میشه بگید این کد insert چرا مقدار هام رو وارد نمیکنه؟؟
<?php
if (isset($_POST["job type"],$_POST["tel"],$_POST["address"],$_POST["mname"],$_POST["phonem"],$_POST["other"]))
{
$sn="localhost";
$user="root";
$pass="";
$dbn="jobs2";
$con=mysqli_connect($sn,$user,$pass,$dbn);
if (mysqli_connect_errno())
{
echo "خطا در برقرار ارتباط " . mysqli_connect_error();
}
mysqli_set_charset( $con, 'utf8' );
/* $sql="SELECT * FROM `register` WHERE `phonem` LIKE '".$_POST["phonem"]."'";
$result=mysqli_query($con,$sql);
$record= mysqli_fetch_assoc($result);
if (empty($record))
{*/
$ins="INSERT INTO `jobs2`.`register` (`id`, `job type`, `tel`, `address`, `mname`, `phonem`, `other`)
VALUES (NULL,'". $_POST["job type"]."','".$_POST["tel"]."','".$_POST["address"]."','".$_POST["mname"]."',
'".$_POST["phonem"]."','".$_POST["other"]."'";
$a=mysqli_query($con,$ins);
if ($a==1)
{
echo "success";
}
else
{
echo "repetitive";
}
}
?>
<?php
if (isset($_POST["job type"],$_POST["tel"],$_POST["address"],$_POST["mname"],$_POST["phonem"],$_POST["other"]))
{
$sn="localhost";
$user="root";
$pass="";
$dbn="jobs2";
$con=mysqli_connect($sn,$user,$pass,$dbn);
if (mysqli_connect_errno())
{
echo "خطا در برقرار ارتباط " . mysqli_connect_error();
}
mysqli_set_charset( $con, 'utf8' );
/* $sql="SELECT * FROM `register` WHERE `phonem` LIKE '".$_POST["phonem"]."'";
$result=mysqli_query($con,$sql);
$record= mysqli_fetch_assoc($result);
if (empty($record))
{*/
$ins="INSERT INTO `jobs2`.`register` (`id`, `job type`, `tel`, `address`, `mname`, `phonem`, `other`)
VALUES (NULL,'". $_POST["job type"]."','".$_POST["tel"]."','".$_POST["address"]."','".$_POST["mname"]."',
'".$_POST["phonem"]."','".$_POST["other"]."'";
$a=mysqli_query($con,$ins);
if ($a==1)
{
echo "success";
}
else
{
echo "repetitive";
}
}
?>