Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = ("select * from inventory");
- $sqlQuery = $db->query($sql) or die($db->error);
- $sqlQuery->num_rows;
- while($sqlFetch = $sqlQuery->fetch_object()){
- echo "
- <div class='modal fade' id='{$sqlFetch->id}' tabindex='-1' role='dialog' aria-labelledby='editInvLabel'>
- <div class='modal-dialog' role='document'>
- <div class='modal-content'>
- <div class='modal-header'>
- <button type='button' class='close' data-dismiss='modal' aria-label='Close'><span aria-hidden='true'>×</span></button>
- <h4 class='modal-title' id='editInvLabel'>Edit</h4>
- </div>
- <form method='post' role='form'>
- <div class='modal-body'>
- <div class='form-group'>
- <label for='InputEditName'>Name</label>
- <input type='text' class='form-control' id='InputEditName' placeholder='Name of the item' value='{$sqlFetch->name}' name='InputEditName'>
- </div>
- <div class='form-group'>
- <label for='InputEditType'>Type</label>
- <input type='text' class='form-control' id='InputEditType' placeholder='Type of item' value='{$sqlFetch->type}' name='InputEditType'>
- </div>
- <div class='form-group'>
- <label for='InputEditStock'>Stock</label>
- <input type='text' class='form-control' id='InputEditStock' placeholder='Amount in stock' value='{$sqlFetch->stock}' name='InputEditStock'>
- </div>
- <div class='form-group'>
- <label for='InputEditPrice'>Price</label>
- <input type='text' class='form-control' id='InputEditPrice' placeholder='Price per item' value='{$sqlFetch->price}' name='InputEditPrice'>
- </div>
- <div class='form-group'>
- <label for='InputEditSets'>Sets</label>
- <input type='text' class='form-control' id='InputEditSets' placeholder='Example Prime A, B, C or D for sorting' value='{$sqlFetch->sets}' name='InputEditSets'>
- <span id='helpBlock' class='help-block'>
- A is for parent blueprints<br>
- B is for Neuroptics<br>
- C is for Chassis<br>
- D is for Systems
- </span>
- </div>
- </div>
- <div class='modal-footer'>
- <button type='button' class='btn btn-default' data-dismiss='modal'>Close</button>
- <button type='submit' class='btn btn-primary' name='SubmitEditForm'>Save changes</button>
- </div>
- </form>
- </div>
- </div>
- </div>
- ";
- if(isset($_POST['SubmitEditForm'])){
- $name = $db->real_escape_string($_POST['InputEditName']);
- $type = $db->real_escape_string($_POST['InputEditType']);
- $stock = $db->real_escape_string($_POST['InputEditStock']);
- $price = $db->real_escape_string($_POST['InputEditPrice']);
- $sets = $db->real_escape_string($_POST['InputEditSets']);
- $sql = "update inventory set name = '{$name}', type = '{$type}', stock = '{$stock}', price = '{$price}', sets = '{$sets}'";
- $sql .= " where id = {$id}";
- $db->query($sql) or die($db->error);
- header('location:index.php?page=inventory');
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement