the page won't show inserted data, after refresh it become doubled

Level 6

show your code view controller

1 like

Level 1

@LoverToHelp how?

1 like

Lara_Love

Level 6

@JohnCharves code place between ``` like

$data = [
        "id"         => [
            1,
            2,
        ],
        "columnName" => [
            "supplier",
            "product",
        ],
        "status"     => [
            "1",
            "0",
        ],
    ];

    $list = [];
    foreach ($data['id'] as $index => $key) {
        $list[$key]['columnName'] = $data['columnName'][$index];
        $list[$key]['status'] = $data['status'][$index];
    }

     dd($list);
//Results in
{
   "1":{
      "columnName":"supplier",
      "status":"1"
   },
   "2":{
      "columnName":"product",
      "status":"0"
   }
}

1 like

Level 1

@LoverToHelp ok i edited it

1 like

Level 22

@johncharves I think you should put PHP insert code above html. Run Insert code first and then retrieve data.

1 like

Level 1

@AungHtetPaing__ not working tho

1 like

Level 22

@JohnCharves how is it not working? Is it still doesn't show data after inserted? Or is it inserting double when refresh?

1 like

Level 1

@AungHtetPaing__ it doesn't recognize "echo"

1 like

Level 22

@JohnCharves Come on How it is not recognize "echo"? Syntax error? which 'echo' doesn't work. You can do it without 'echo' like this

<?php 
		if ($result['status'] == 0) 
		{
?>
				<span class='badge badge-warning'>Pending</span>
							 			
<?php
	    }
				else
	   {
?>
				<span class='badge badge-success'>Approved</span>
<?php
		}
		$cnt++;	
?>

And did your previous error solve?

1 like

Level 1

@AungHtetPaing__ no man, I tried, for now I just guide my user to do log out and log in again if their applies doesn't show. I guide them to not refresh also, cause it will be doubled the request

1 like

Best Answer

Level 22

@JohnCharves The data doesn't show after insert may be because of insert code is below all other html. Double inserting maybe because you are writing insert code and retrieve code in same page and refreshing run the insert again after pass the if condition. So you need to make sure insert code is only run after form submit or make a separate file. That is all I can guess.

<?php
if ($_POST['vehicletype'] || $_POST['vehiclepolicenumber'])){
		$email = $_SESSION['email'];
		$moveindate = $_REQUEST['moveindate'];
		$itemlistamount = $_REQUEST['itemlistamount'];
		$vehicletype = $_REQUEST['vehicletype'];
		$vehiclepolicenumber = $_REQUEST['vehiclepolicenumber'];
		//.....
}
?>

//.....

<form action="currentfile.php" method="post">
						<div class="form-group">
							<label class="form-control-label">Move In Items Date* / Items Construction Date** :<p style="color: red;">*only monday-saturday (08.30-17.00)<br>**only monday-friday (08.30-17.00)</p></label>
							<input type="date" name="moveindate" class="form-control"/>
						</div>
						<div class="form-group">
							<label>Item Lists / Amount</label><br>
							<textarea name="itemlistamount" placeholder="tv 2&#10;refrigerator 1" style="width: 100%;"></textarea>
						</div>
						<div class="form-group">
							<label>Vehicle Type</label>
							<input type="text" name="vehicletype" class="form-control"/>
						</div>
						<div class="form-group">
							<label>Vehicle Police Number</label>
							<input type="text" name="vehiclepolicenumber" class="form-control"/>
						</div>
				</div>
				<div class="modal-footer">
					By clicking apply you are agree to all terms and condition mentioned above &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
					<button class="btn btn-danger" style="border-radius:0%;" data-dismiss="modal">Close</button>
					<input type="hidden" name="status" value="0">
					<input type="submit" class="btn btn-success" style="border-radius:0%;" name="apply"  value="Apply">
				</div>
					</form>

//...
?>

1 like

Level 1

@AungHtetPaing__ thank you for ur help

1 like

Sinnbeck

Level 102

Either have a separate file for submitting data or a separate route (if you wrote a router). And then redirect after saving the data.

If this is for a real world application and not just to learn, I suggest using a framework like Laravel

1 like