如何从php中插入mysql中的无限记录?

I have to insert multiple records in mysql from php. How to pass list to mysql table.Please suggest your solution.

$course[0] = 1;
$course[1] = 'test';
$course[2] = 'test1'
$sql = "INSERT INTO temp_course(uniqueId,fullName,shortName) VALUES($course[0],'$course[1]','$course[2]')";

i tried like above. but values not inserted.

Try wrapping the variables with curly brackets like this:

    $course = [];
    $course[0] = 1;
    $course[1] = 'test';
    $course[2] = 'test1';
    $sql = "INSERT INTO temp_course(uniqueId,fullName,shortName) VALUES($course[0],'$course[1]','$course[2]')";

@Gopal you can try with implode() but make sure your array sequence must be same as your table column sequence given by you in query, try like below:

<?php
    $course[0] = 1;
    $course[1] = 'test';
    $course[2] = 'test1';
    $sql = "INSERT INTO temp_course(uniqueId,fullName,shortName) VALUES(".implode(',', $course).")";