Save multiple value in database, use row in PHP

What you ask for is not recommended for security reasons. It's one of the biggest no-nos to trust GET contents and put it straight into an SQL query.

But.

Of course you can foreach the variable $_GET like this:

$x="";
foreach($_GET as $key=>$val) {
    $x.=" $key = '$val', ";
}
$sql = "insert into myTable set $x";

This is just the principle of it. You should ALWAYS check for the field names and values to avoid injection attacks. So a better approach would be like:

$isValid = array("name"=>1,"score"=>1,"status"=>1);
$x="";
foreach($_GET as $key=>$val) {
    if(!$isValid[$key]) continue; // skip unknown fields!
    $val = stripslashes($val); // remove magic quote junk
    $val = mysql_real_escape_string($val); // protect mysql from attacks
    $x.=" $key = '$val', "; // build the query
}
$sql = "insert into myTable set $x";

UPDATE

If you get all the values in one string like "aaa|bbb|ccc", you can use explode() to parse them into one array. But then you rely on the order of fields which is not a good practice. I'd recommend to always prefer "field1=aaa&field2=bbb" style.

Hope this helps. Think about the risks and find your own way.

You said 40 row. You have to remember that the limitation of length of an URL. So the suitable way is to use POST method through a HTML form. Taking care in multible fields naming by adding [] to the field name:

<form method="post" action="some.php">
<input type="text" name="name[]" />
<input type="text" name="score[]" />
...
</form>

and from your PHP

for ($i = 0; $i < count($_POST['name']); $i++){
$name = $_POST['name'][$i];
$score = $_POST['score'][$i];
$status = $_POST['status'][$i];
$sql="INSERT INTO user (name, score, status)
        VALUES
        ('$name','$score','$status')";
        mysqli_query($con,$sql); 
}

Notice: This answer is about the concept of inserting multiple records. It does not meant by the security of receiving data.