将数据从多个文本框插入单列

Question

enter image description herei want to insert multiple text box value in to a single column in a table at a time

it should b like there should be name and infront of name there are text boxes to enter age of the students so when we submit then the age entered infront of the student name it will get stored in the table with student names and ages. (multiple students data feeding at a time)

Answer 1

Hi Try this change table name and column name according to yours. Also i have query all data of table this will update all fields age if already age exist and you fill again in form. So either apply where condition in your query so that it filter only name which does not have price or add value field in form which display age if exist in database.(This is according to code you provided in comment)

<?php
$conn = mysqli_connect($mysql_hostname, $mysql_user, $mysql_password,$mysql_database) or die("Could not connect database");
$result = mysqli_query($conn,"select * from user");
if(isset($_POST['submit'])){    
    $sql = "UPDATE user SET age = (CASE name ";
        foreach($_POST['age'] as $key=>$value){
        $sql = "UPDATE user SET age = '$value' where name = '$key'";
        mysqli_query($conn,$sql);
    }
    $success = "updated successfully";  
}
if(isset($success) && !empty($success)){    
    echo '<h3>'.$success.'</h3>';
}
echo '<form method="post">';
echo '<table>';
while($row = mysqli_fetch_assoc($result)){?>
    <tr>
    <td><input type="text" value="<?php echo $row['name']; ?>" name="name" readonly="true"></td>
           <td><input type="number" name="age[<?php echo $row['name']; ?>]" placeholder='enter age'></td>
        </tr>       

<?php } ?>
<tr><td colspan="2">
 <input type="submit"   name="submit" value="Save"></td></tr>

 </table>
</form>