Greetings,
I am having two php pages. 1) filesearch.php 2)filedelete.php
filesearch.php is attached.
<!--filedelete.php contains the following -->
<?php
$link = mysqli_connect("localhost","root","");
mysqli_select_db($link,"stores_bgts");
$id = $_GET['id'];
$q = "DELETE FROM `filetrack` WHERE id = $id";
mysqli_query($link,$q);
header('location:filesearch.php');
?>
In filesearch.php, I had 3 buttons, one is search and the other two are delete and update. while clicking search button, somehow with an input attribute I manage to display input values after search button click. Whereas, clicking on any of the delete, update refreshing the input values. I just want to display the remaining records searched after deleting the opted record. But the delete query executing and redirecting to filesearch.php and there all records searched are refreshed. Kindly guide me to fix this issue. Thanks in advance.
Attached File(s)
filesearch.php ( 3.52k )
Number of downloads: 806
I MOVE THIS TO THE SERVER-SIDE SCRIPTING FORUM.
I 'think' you want to display the original search results after clicking on delete or update button instead of doing a new search, which is what is happening now.
Do I understand correctly?
Greetings.
in detail,
my filesearch.php has 3 buttons.
1. search
2. delete
3. update
the following portion, retaining the input values even after displaying the search items after pressing the search button
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
$frmdate=$_POST['frmdate'];
$todate=$_POST['todate'];
?>
</select>
<input type="text" id="myDatepicker" placeholder="Click to pick from date" name = "frmdate" autocomplete="off" value="<?php if(isset($frmdate)) {echo $frmdate;}?>"/> <input type="text" id="myDatepicker2" placeholder="Click to pick to date" name = "todate" autocomplete="off" value="<?php if(isset($todate)) {echo $todate;}?>"/> <br>
<br><input name="search" class="btn btn-primary" type="submit" value="SEARCH"/></center>
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
after clicking either delete / update buttons, the code is executing but all the content on the screen disappearing. Kindly guide me in this regard to overcome the issue.
Sorry for the delay, I've been out all day. I'll have to look over your code to be sure. It sounds like after you click on the update or delete button, and the code runs, then you are taken back to the main page, in this case the search page. Now the search page comes up blank but you want the original search done again. Is this correct?
If I'm understanding correctly then why not just pass 'frmdate' and '$todate' in the URL. Then rewrite your search code to check for the $_GET values. If found do the search and show the results. If not found then display the empty search page.
Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)