Databases
StackOverflow2013
Postsdbo
POWorking with PHP and JQuery
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWorking with PHP and JQuery
    primarykey
    data
    text
    <p>I thought I should ask this before moving forward with my scripting project and later on realizing that I might be doing something wrong. Might as well save my own time in the first place by checking if what I'm doing is indeed correct.</p> <p>I'm pretty new to PHP and JQuery and still getting the hang of them both. I recently came across a problem in which I wanted to run some PHP code after executing a certain function using JQuery, so after doing some reading online I got the idea to create a PHP file which does just what I want to do and POST to it from my JQuery function with the needed variables. That way I achieve my server-side and client-side goals on the same time. However!</p> <p>It doesn't look right to me. At all. I find myself having at least ten include files for one simple page. Those files get included in my HTML code when the form loads, and after refreshing a certain DIV with my JQuery function, they get reloaded. That way I can keep my script dynamic, I doubt there's something else I could do in order to keep it that way.</p> <p>However I often need to update stuff after executing a certain JQuery function, hence I call a similar file to the loading one, but this time it's a file which I transfer some parameters to (using the POST method, through JQuery), and execute the desired action in the file itself.</p> <p>Now, after briefly explaining my current situation and method of work, I'd like to know if what I'm doing is correct. In case you're still wondering what the hell I am talking about, I'd like to explain in detail what I mean:</p> <p>Let's say I have my index.php file which prints data from my database and some additional lines as well. Once I click one of the page buttons, I want to update my database according to the form I've got implanted in my page as well, and then reload the DIV which contains that data ONLY. I do not want to reload the entire page.</p> <p>Now if I wanted to do that without JQuery that would have been easy. I would POST the data to the same form and update it if the POST parameters are indeed valid. However, there's no way to refresh that DIV without JQuery, so I came up with something similar to this:</p> <pre><code>$.post("/files/dosomething.php", { taskID: _taskID }, function(){ $("#div_tasks").fadeOut(800, function(){ $('#div_tasks').load('/files//load_div_A.php', function(){ $("#div_tasks").fadeIn(1500); }); }); }); </code></pre> <p>That's what I've been doing in my last week of learning PHP and JQuery. Now before I proceed any further than this, I'd like to know if it is indeed the right way to achieve my goal.</p> <p><strong>// EXAMPLE B:</strong></p> <p>I've got a DIV in my HTML code which prints a table of tasks, for instance. How do I print it? I include a file which echo's the table at the exact point where I want the table to be displayed. Then, in each row, there's a button called 'delete' which removes the selected row from the database. What I do is, using JQuery (due to the fact I want ONLY that DIV to be refreshed), I call another external file calling remove.php and send the index of the task I'd like to remove using POST. The file performs the server-side code and once it's done, I load the updated table into that DIV by calling the file I used to call in the first place from my main page. This time the table will be updated due to the fact it will read the updated data from the database.</p> <p>Is that how I get this done? Is this the right way? It just doesn't seem right to me. I've never been codding that way and it seems a little bit messy.</p> <p>Thanks in advance and sorry for the long ass question.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USTommy Naidich
    1. USTommy Naidich
    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
    1. VO
      singulars
      1. POWorking with PHP and JQuery
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWorking with PHP and JQuery
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWorking with PHP and JQuery
      1. This table or related slice is empty.
      1. VTUpMod
    1. COJust to make sure I've got your question... You've got some server-side code that performs an action, and depending on the response data you want to load some HTML from a different PHP script? You could always just return that data from the first script. I think your question is more about how to structure your project and separate your application logic from the presentation, yes? There are lots of ways to do that, but it's hard to suggest without knowing a bit more about your application.
      singulars
      1. POWorking with PHP and JQuery
      1. USBrad
    2. COIt's not really a scripting question but more a logic one, you've got that right, yes. My main issue is realizing how to get my stuff done the best and right way. I'll try to be more clear on what I'm trying to do, please see my updated question.
      singulars
      1. POWorking with PHP and JQuery
      1. USTommy Naidich
 

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