too long

Question

Only editor can post into database but the price could'nt Post into database..

So, how can i make query let say 1st Row in form has Field 1 = Fullname, Field 2 = Age.. and i can add new row again with the same field and submit all information to array into database

<?php
    session_start();
    include "_config/config.php";
    //include "header.php";


    if (isset($_POST["editor"])) //&& ($_POST["price"]) && is_array($_POST["price"]) && count($_POST["price"]) > 0) 
    { 
    foreach($_POST["editor"] as $editor)
       { 
           // echo htmlspecialchars($editor, ENT_QUOTES); 
           mysql_connect($server, $db_user, $db_pass)  or die ("Database CONNECT Error (line 62)"); 
           mysql_db_query($database, "INSERT INTO arrayins VALUES   ('','$editor','$price')");

       echo "Data Successfully Added";
            echo '<br />'; 
        } 
    }
    ?>

Answer 1

You can first determine the number of rows posted, and then loop over the row index and get the appropriate values:

$num_rows = is_array($_POST["editor"]) ? count($_POST["editor"]) : 0;

for ($i = 0; $i < $num_rows; $i++) {
    $editor = $_POST["editor"][$i];
    $price = $_POST["price"][$i];

    // your SQL code here using $editor and $price
}