通过php将一个值（你没有输入但是被回显）插入数据库？

Question

I am inserting a car mileage and car color into a database, on the same page I am displaying that cars ID and the cars owner.

So I have two input fields where the user types the mileage and color and beneath that I am just displaying that cars ID and the cars owner.

The insert works fine, I can insert the mileage and color but it leaves two columns where the cars ID and cars owner (which are displayed on the page where I enter mileage/color) should be...

Does anyone know of a way to put them into the DB too as im not actually typing them, simply echoing them there. Code is shown below, thanks.

    Mileage:<input type="text" name="mileage"><br />
    Color:<input type="text" name="Color"><br />
    carID:<?php echo $cID; ?>
    carOwner: <?php echo $cOwner; ?>

The insert page is just a simple sql statement which only has the mileage/color values . I have tried adding carID and carOwner as extras but it throws errors.......any ideas?

Answer 1

Crude but easiest method and will match the style of the other data:

Show the carID and carOwner but prevent them from being edited:

Mileage:<input type="text" name="mileage"><br />
Color:<input type="text" name="Color"><br />
carID:<input type="text" name="cID" value="<?php echo $cID; ?>" readonly="readonly"><br />
carOwner:<input type="text" name="cOwner" value="<?php echo $cOwner; ?>" readonly="readonly"><br />

Forgot to add, the data will be posted just the same as "mileage" or "Color" for you to process however you like.