Databases
StackOverflow2013
Postsdbo
POAjax database browser page Refresh changes the page instead of refreshing it
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAjax database browser page Refresh changes the page instead of refreshing it
    primarykey
    data
    text
    <p>I am facing a problem with my AJAX and PHP database. I bet many other new Ajax programmers would also be facing this problem. Although I have shortened the code but it is still somehow lengty, so please be patient. I have a button on the homepage index.php which when clicked, loads the Books Management System as it is Ajax database so the Books Management system is loaded on a div('mainDiv') on the same page. The problem is that when Books Management System is open whenever I refresh/reload the page(by clicking browsers Refresh button) it unexpectedly return to the homepage with button. On refresh the page contents should remain the same. But it never happens here. Doing it in Ajax makes it more complicated. Is there any simple/easy Ajax solution to it? Also kindly point out if something in this code is against good programming practises. Here is my code: ** script portion of Database Home page/index.php**</p> <pre><code>&lt;script language="javascript"&gt; function submitData(dataSource,divID,formId) { var PostData;//assuming the form's post data has been already serialized to keep the question simple var dataSource; /*setting up XMLHttpRequestObject*/ var XMLHttpRequestObject = false; if (window.XMLHttpRequest) { XMLHttpRequestObject = new XMLHttpRequest();} else if (window.ActiveXObject) { XMLHttpRequestObject = new ActiveXObject("Microsoft.XMLHTTP");} else if (window.ActiveXObject) { XMLHttpRequestObject = new ActiveXObject("MSXML2.XMLHTTP");} else { alert ("XMLHttpRequestObject can not be created");} /*processing sending of the form's post data*/ if(XMLHttpRequestObject) { var obj = document.getElementById(divID); XMLHttpRequestObject.open("POST", dataSource); XMLHttpRequestObject.setRequestHeader('Content-Type','application/x-www-form-urlencoded'); XMLHttpRequestObject.onreadystatechange = function() { if (XMLHttpRequestObject.readyState == 4 &amp;&amp; XMLHttpRequestObject.status == 200) { obj.innerHTML = XMLHttpRequestObject.responseText; } } XMLHttpRequestObject.send(PostData); } } &lt;/script&gt; </code></pre> <p><strong>Body portion of Database Homepage/index.php:</strong> </p> <pre><code>&lt;h2&gt; Ajax Books Database &lt;/h2&gt; &lt;div id="mainDiv"&gt; &lt;form id="books-management-sys-targeting-form"&gt; &lt;input type="hidden" name="open-bms" value="open-jms" /&gt; &lt;input type="button" onclick="submitData('phpcontroller.php','mainDiv','books-management-sys-targeting-form')" value="Open Books Management System" /&gt; &lt;/form&gt; &lt;/div&gt; </code></pre> <p><strong>When the Button on above home page is Clicked The PHP controller executes this code:</strong></p> <pre><code>/*Opening Books Management System*/ if(isset($_REQUEST['open-bms'])) { include 'books-management-system.html.php'; } </code></pre> <p><strong>Here is the books-management-system.html.php code:</strong></p> <pre><code>//manage books categories link &lt;form id="to-manage-book-categories-form"&gt; &lt;input type="hidden" name="manage-book-categories" value="manage-book-categories" /&gt; &lt;a href="#" onclick="submitData('phpcontroller.php','mainDiv','to-manage-book-categories-form','personalform.txt')" &gt;Manage Books Categories&lt;/a&gt; &lt;/form&gt; . . //other tasks related to managing books . . </code></pre> <p>What changes I have to make in this code so as when I refresh it, it should display the same presently opened page/contents,not the main page. Is there an easy way to do it in Ajax? Please Help!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USNaeem Ul Wahhab
    1. USNaeem Ul Wahhab
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAjax database browser page Refresh changes the page instead of refreshing it
      1. USNaeem Ul Wahhab
      1. VTFavorite
    2. VO
      singulars
      1. POAjax database browser page Refresh changes the page instead of refreshing it
      1. USNaeem Ul Wahhab
      1. VTFavorite
    3. VO
      singulars
      1. POAjax database browser page Refresh changes the page instead of refreshing it
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWow, I'd strongly recommend looking into a javascript framework like jQuery or Mootools instead of writing all the XmlHttpRequestObject code yourself. SUCH a time saver just in that area alone!
      singulars
      1. POAjax database browser page Refresh changes the page instead of refreshing it
      1. USdavidethell
    2. CO@davidethell you are right. But I would not recommend it for beginners. New coders should first master all the techniques their self before using ready made frameworks.
      singulars
      1. POAjax database browser page Refresh changes the page instead of refreshing it
      1. USNaeem Ul Wahhab
    3. CO@TheNobleCoder, fair enough.
      singulars
      1. POAjax database browser page Refresh changes the page instead of refreshing it
      1. USdavidethell
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload