php - Websql 数据库将数据插入一个表而不是另一个表？

Question

你好 friend ，我面临一个奇怪的问题。我开发 PHP 桌面应用程序，

我正在使用 websql 数据库。当我将数据提交到用户表中时

数据提交成功。但是当我提交到另一个表时数据却没有

提交的表结构是相同的。我不知道该怎么做？

请帮忙。这是我的代码...

<?php

session_start();
//$WindowUser = getenv('username');
//$myPDO = new PDO("sqlite:C:/Users/".$WindowUser."/Desktop/barber_shop/webcache/databases/http_127.0.0.1_51915/2");
include("../sqlitePhpDatabase/sqlitePhpDatabase.php");   
$store_name = $_POST['store_name'];
$street = $_POST['street'];
$status = $_POST['status'];
$location_id = $_POST['location_id'];

 $sth = $myPDO->exec("INSERT INTO bs_stores(store_name,street, status,location_id)VALUES('store_name','$street','$status','$location_id')");
//$sth = $myPDO->exec("INSERT INTO bs_locations(city)VALUES('rere')");
if(isset($sth) && !empty($sth))
{
    echo "done";    
}
else
{
    echo "data is not submiting";   
}   ?>

Answer 1

尝试使用此代码复制所有数据:-

INSERT INTO tab1 SELECT * FROM tab2;

或者复制所选数据:-

INSERT INTO tab1
SELECT col1,
       col2,
       col3,
       NULL
  FROM tab2