Php MySQL database help

programming web dev
1

I would like to create 3 dbs connected by foreign keys and have the end user input the data from one form
Can anyone please help?

The dbs are client, work, and accessories

Client

<?php $month = date('m'); $day = date('d'); $year = date('Y'); $today = $year . '-' . $month . '-' . $day; ?> Select Options Option one Option two Option three Option four 
<h1>Work</h1>
<label>
	<input type="checkbox" name="work" value="one">One<br />
	<input type="checkbox" name="work" value="two">Two<br />
	<input type="checkbox" name="work" value="three">Three<br />
	<input type="checkbox" name="work" value="four">Four<br />
</label>

<h1>Accessories</h1>
<table class="table table-bordered">
<thead>
    <tr>
        <th></th>
        <th>Product Name</th>
        <th>Price</th>
        <th>Quantity</th>
    </tr>
</thead>
<tbody>
    <tr>
        <td><input type="checkbox" name="prodid[]" value="Car"></td>
        <td>Accessory One
            <input type="hidden" name="prodname[]" value="Car">
        </td>
        <td><input type="number" name="prod_price[]" class="form-control"></td>
        <td><input type="number" name="prod_qty[]" class="form-control"></td>
    </tr>
    <tr>
        <td><input type="checkbox" name="prodid[]" value="Bike"></td>
        <td>Accessory Two
            <input type="hidden" name="prodname[]" value="Bike">
        </td>
        <td><input type="number" name="prod_price[]" class="form-control"></td>
        <td><input type="number" name="prod_qty[]" class="form-control"></td>
    </tr>
    <tr>
        <td><input type="checkbox" name="prodid[]" value="Accessories"></td>
        <td>Accessory Three
            <input type="hidden" name="prodname[]" value="Accessories">
        </td>
        <td><input type="number" name="prod_price[]" class="form-control"></td>
        <td><input type="number" name="prod_qty[]" class="form-control"></td>
    </tr>
</tbody>
2

Unfortunately my PHP/MySQL knowledge has deteriorated over the years. The forums are more front-end focused these days, so you may have better luck posting someplace like StackOverflow instead for this topic :slight_smile: