Databases
StackOverflow2013
Postsdbo
POUsing ajax with a while statement and DB
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing ajax with a while statement and DB
    primarykey
    data
    text
    <p>I have a question about using ajax.I want to delete something of my screen (to be clear, some articles) I'm generating content (the articles) on the screen with this code:</p> <pre><code>while($test = $allArticles-&gt;fetch_assoc()) { echo "&lt;div class='metfoto'&gt;"; echo "&lt;h1 name='tt' class='titelopmaak'&gt;".$test['titel'] . "&lt;br /&gt;&lt;/h1&gt;"; echo "&lt;p class='artikelopmaak'&gt;" . $test['article'] . "&lt;/p&gt;"; echo "&lt;form method='post' action=''&gt;"; echo "&lt;input type='submit' class='delete' name='verwijder' value='verwijder'&gt;"; echo "&lt;/form&gt;"; //echo "&lt;h1&gt;".$test['id']."&lt;/h1&gt;"; echo "&lt;/div&gt;"; } </code></pre> <p>This all is working very well without ajax. But I want to make this(the delete with the button) happen without a page refresh. When i for example check the content of $test['id'], i receive one number. <strong>My problem with the code below is that when i want to put the title into variabel (var titel) for ajax, it loads all the titels from my page.</strong> </p> <pre><code> &lt;script type="text/javascript"&gt; $(document).ready(function(){ $(".delete").click(function(){ var titel = $(".titelopmaak").text(); var artikel = $(".artikelopmaak").text(); $.ajax({ type: "POST", url: "assets/ajax/deleteArticle.php", data: { titelA:titel }, }).done(function( msg ) { if(msg.status != "error") { if(msg.status == "success") { $(".titelopmaak").fadeOut(); } else { } } }); return false; }) }); &lt;/script&gt; </code></pre> <p><strong>EDIT</strong></p> <p><strong>I hope i explained my question in a better way now</strong></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USNiels
    1. USNiels
    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. POUsing ajax with a while statement and DB
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POUsing ajax with a while statement and DB
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POUsing ajax with a while statement and DB
      1. This table or related slice is empty.
      1. VTDownMod
    1. COTo summarize your question: *"I have a question about using ajax, please read all my code and then tell me what I am doing wrong."* - please improve your style of asking a question, what specifically do you want to know?
      singulars
      1. POUsing ajax with a while statement and DB
      1. UShakre
    2. CO@Hakre, i'm really sorry, i understand it is difficult for you to understand what i mean without knowing the story. See my edit please.
      singulars
      1. POUsing ajax with a while statement and DB
      1. USNiels
    3. COknowing the story is almost irrelevant @NielsJansen. you need to put some effort into simlifying your problem to a concise issue instead of making it a wall of code that you're expecting others to happily read to try and find a question in it. At best you have several questions that are related - and they should be asked individually.
      singulars
      1. POUsing ajax with a while statement and DB
      1. USAD7six
 

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