在PHP中使用LOOP在SQL中插入数据 [英] Insert data in SQL using for LOOP in PHP
本文介绍了在PHP中使用LOOP在SQL中插入数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有2个文件`index.php`和`main.php`，这是代码。
index.php
< html >
< head < span class =code-keyword>>
< title > 将Google工作表同步到SQL < / title >
< meta charset = utf-8 / >
< meta 名称 = viewport content = width = device-width，initial-scale = 1.0 >
< script src =' https://cdnjs.cloudflare.com/ajax/ libs / tabletop.js / 1.5.1 / tabletop.min.js' > < / script >
< script src = js /jquery-3.2.1.min.js\"> < / script >
< / head >
< body >
< 按钮 < span class =code-attribute> id = myBtn > 同步数据< / button >
< script >
var x = document .getElementById（ myBtn）;
x.addEventListener（ 点击，init）;
var publicSpreadsheetUrl = ' https：// docs.google.com/spreadsheets/d/1Djso6FE61pXP1VDfyYC8_k_wnWt456hveIr-RDUW7sk/pubhtml?gid=0&single=true';
function init（）{
Tabletop.init（{key：publicSpreadsheetUrl，
callback：showInfo，
simpleSheet： true }）}
function showInfo（data，tabletop ）{
for （ var i in 数据）{
var trans_no = data [i]; // 从表中获取e行
var transno = trans_no.transno
var transdate = trans_no.transdate
var dropno = trans_no.date
var cusname = trans_no.customername
var shipto = trans_no.shipto
var active = trans_no.active
// alert（transno + transdate + dropno + cusname + shipto + active）;
// window.location.href =main.php？transno =+ transno;
}
}
< / < span class =code-leadattribute> script >
< / body >
< / html >
这里是main.php
<？ php
include（' config.php中）;
include（' adodb / adodb.inc.php'）;
$ db = ADONewConnection（$ dbdriver）;
$ db-> Connect（$ dsn，$ username，$ password）;
$ transno = $ _GET [' transno'];
$ sqlSync = ' INSERT INTO TBL_TDev（ TransNo）VALUES（'。$ transno。' ）';
$ rsSync = $ db->执行（$ sqlSync）;
？>
点击我的按钮从谷歌表获取数据并在循环期间将其传递给变量，这是其中的一部分。
for（var i in data ）{
var trans_no = data [i]; //从表中获取e行
var transno = trans_no.transno
var transdate = trans_no.transdate
var dropno = trans_no.date
var cusname = trans_no.customername
var shipto = trans_no.shipto
var active = trans_no.active
// alert（transno + transdate + dropno + cusname + shipto + active）;
window.location.href =main.php？transno =+ transno;
}
}
现在发生的事情是数据以href传递并转到我的`main .php`将其保存在sql中。
我的问题是如何使用同一页面保存它？并节省了吗？我的意思是对于循环中生成的每个数据，我将它保存在sql中。会发生什么是我只能保存1个数据。
我尝试过：
我试图将jQuery用于PHP，但不知道如何
解决方案
db = ADONewConnection（
dbdriver）;
DB->连接（
I have 2 files `index.php` and `main.php` and this are the codes.
index.php
<html>
<head>
<title>Test Sync Google Sheet to SQL</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script src='https://cdnjs.cloudflare.com/ajax/libs/tabletop.js/1.5.1/tabletop.min.js'></script>
<script src="js/jquery-3.2.1.min.js"></script>
</head>
<body>
<button id="myBtn">Sync Data</button>
<script>
var x = document.getElementById("myBtn");
x.addEventListener("click", init);
var publicSpreadsheetUrl = 'https://docs.google.com/spreadsheets/d/1Djso6FE61pXP1VDfyYC8_k_wnWt456hveIr-RDUW7sk/pubhtml?gid=0&single=true';
function init() {
Tabletop.init( { key: publicSpreadsheetUrl,
callback: showInfo,
simpleSheet: true } )}
function showInfo(data, tabletop) {
for (var i in data){
var trans_no = data[i]; //getting e row from table
var transno = trans_no.transno
var transdate = trans_no.transdate
var dropno = trans_no.date
var cusname = trans_no.customername
var shipto = trans_no.shipto
var active = trans_no.active
//alert(transno + transdate + dropno + cusname + shipto + active);
// window.location.href = "main.php?transno=" + transno;
}
}
</script>
</body>
</html>
and here is main.php
<?php
include('config.php');
include('adodb/adodb.inc.php');
$db = ADONewConnection($dbdriver);
$db->Connect($dsn, $username, $password);
$transno = $_GET['transno'];
$sqlSync = 'INSERT INTO TBL_TDev (TransNo) VALUES ('.$transno.')';
$rsSync = $db->Execute($sqlSync);
?>
by clicking the button i am getting data from google sheet and pass it in variable during loop and this is the part of that.
for (var i in data){
var trans_no = data[i]; //getting e row from table
var transno = trans_no.transno
var transdate = trans_no.transdate
var dropno = trans_no.date
var cusname = trans_no.customername
var shipto = trans_no.shipto
var active = trans_no.active
//alert(transno + transdate + dropno + cusname + shipto + active);
window.location.href = "main.php?transno=" + transno;
}
}
what happens now is that the data is passed in href and go to my `main.php` to save it in sql.
My question is how can i save it using the same page? and do the saving? I mean for every data generated in the loop i will save it in sql. what happens is i can only save 1 data.
What I have tried:
I tried to use jQuery to PHP but dont know how
解决方案
db = ADONewConnection(
dbdriver);
db->Connect(
这篇关于在PHP中使用LOOP在SQL中插入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
