创建新对象php并插入mysql

idfiyjo8  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(139)

目标是:

A POST request to this script should create a new company object and thus 
    a new row in the company table and associated company address table.

目前,我有插入工作正常与以下:

$randomname="1";
$randomdescription="Bill is going to work at this company";
$randomad="123 Main Street";
$randomad2="N/A";
$randomcity="Cincinnati";
$randomstate="Ohio";
$randomzip="45205";
$completedesc=$randomname." ". $randomdescription." ".$randomad." ". $randomad2." ".$randomcity." ".$randomstate." ".$randomzip;
try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "INSERT INTO company (name, description)
    VALUES ('$randomname', '$completedesc')";
    // use exec() because no results are returned
    $conn->exec($sql);
   $data= "New record created successfully";
   $data = json_encode($data, JSON_PRETTY_PRINT);
   echo $data;
    }
catch(PDOException $e)
    {
     $data= "company error". $sql . "<br>" . $e->getMessage();
   $data = json_encode($data, JSON_PRETTY_PRINT);
   echo $data;
    }
try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "INSERT INTO company_address (company_id, address,address_2,city,state,zip)
    VALUES ('$randomname','$randomad','$randomad2','$randomcity','$randomstate','$randomzip')";
    // use exec() because no results are returned
    $conn->exec($sql);
   $data= "New record created successfully into company address";
   $data = json_encode($data, JSON_PRETTY_PRINT);
   echo $data;
    }
catch(PDOException $e)
    {
   $data= "company address error". $sql . "<br>" . $e->getMessage();;
   $data = json_encode($data, JSON_PRETTY_PRINT);
   echo $data;
    }

我最纠结的问题是“创建一个新的公司对象”。现在我不相信我的代码正在使用一个对象。有没有一个简单的方法,使一个对象,所以我可以执行插入。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题