如何使用php在单个列中逐个插入arraylist


how to insert arraylist in single coloumn one by one using php

你好,先生,我通过url将数组列表从android发送到php。所有数组列表都插入到单个列中的一行。我想插入一列(菜单名)到多行

          EG:
      i pass array list[x,y,z.........] android to php
        mysql 
       menuname
        x
        y
        z(i want like this)
  i try this code
   <?php
   $arr[]=$_POST['menuname'];
   mysql_connect("localhost","root","mobixmysql");
   mysql_select_db("test");
   foreach($arr as $value){
   $value;
   mysql_query("INSERT INTO test (menuname) VALUES ('" . 
    mysql_real_escape_string($value) . "')")or
   die('unable'.mysql_error());
   echo "inserted";
   }
   ?>

我尝试上面的代码,它将数据库插入一行的menuname列中。我想在一列中添加多行

我假设$_POST['menuname']不是数组;

<?php
   $arr=explode(',',preg_replace('/^.*'[(.*)'].*$/','$1',$_POST['menuname']));
   mysql_connect("localhost","root","mobixmysql");
   mysql_select_db("test");
   foreach($arr as $value){
   mysql_query("INSERT INTO test (menuname) VALUES ('" . 
    mysql_real_escape_string($value) . "')")or
   die('unable'.mysql_error());
   echo "inserted";
   }
  ?>