Implementation method of adding data in batches and updating data in batches in php, adding data in php

Implementation method of adding data in batches and updating data in batches in php, adding data in php_PHP tutorial

WBOY

Release： 2016-07-13 10:11:45

Original

987 people have browsed it

How to implement batch adding data and batch updating data in php, adding data in php

The example in this article describes the implementation method of batch adding data and batch updating data in PHP. Share it with everyone for your reference. The specific analysis is as follows:

If you want to save data in batches in PHP, we only need to use the insert into statement of SQL to save the data in batches. If you want to update the data, you can use update set to complete the update. The operation methods are very simple. Here are two examples. .

Batch data entry

Design method: Submit multiple form records at the same time, set the same text field name for each record, then in the form processing page, read and extract the data submitted by the form through a for loop, and finally convert the data in the form of data Add items to the database one by one.

Among them, apply a count() function to get the number of elements in the array. int count(mixed var);

Form submission page, the code is as follows:

Copy code The code is as follows:

Database connection page, the code is as follows:

Copy code The code is as follows:

$id=mysql_connect("localhost","root","password") or die('connection failed'.mysql_error());
if(mysql_select_db('mydatabase',$id))
echo "";
else
echo('select db failed:'.mysql_error());
?>

Form processing page, the code is as follows:

Copy code The code is as follows:

if($submit==true){
for($i=0;$i $path=$_POST["sp_name"][$i];
          $path1=$_POST["sp_number"][$i];
         $path2=$_POST["price"][$i];
         $path3=$_POST["counts"][$i];
          $path4=$_POST["address"][$i];
$query=mysql_query("insert into tb_products(sp_name,sp_number,price,counts,address,data) values('$path','$path1','$path2','$path3','$path4',' $data');}
If($query==true){
             echo "Submission successful";
else
echo "Submission failed";}
}
?>

Update data in batches

Mainly implement batch updates of data through the while, list(), and each() functions. The list() function is used to assign values to multiple variables at one time. The code is as follows:

Copy code The code is as follows:

表单处理页,代码如下:

复制代码代码如下:

if($submit=="激活"){
    while(list($name,$value)=each($_POST)){
        $result=mysql_query("update tb_user set operation='激活' where id='".$name."'");
    if($result==true){
        echo "<script> alert('激活成功');window.location.href='index.php';</script>";}}

if($submit2=="冻结"){
    while(list($name,$value)=each($_POST)){
        $result=mysql_query("update tb_user set operation='冻结' where id='".$name."'");
    if($result==true){
        echo "<script> alert('冻结成功');window.location.href='index.php';</script>";}}
}
?>

总结:心细的朋友会发现两个例子都有几个共同点,一个是表单from的表单名是以counts[]数组形式了,而在php处理接受页面都会使用for 或while来实现遍历了,下面我就简单的给大家分析这两个例子.

counts[]:这个在表单中是代表数组,如果你有10个表单那么我们name=counts[] 意思他们内个都是一样数组,知道这个是数组了就知道下面知道为什么会使用遍历了.

for或while:因为表单过来的是数组我们就可以遍历数组然后对数据进行保存了,如下代码:

while(list($name,$value)=each($_POST)){ 或

for($i=0;$i

希望本文所述对大家的php程序设计有所帮助。